TRELSLD

1401 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDPRD int 4 null
SALDO int 4 null
SEQUENCIAL int 4 null
CODFILIAL int 4 null
CODLOC varchar 15 null
CODCOLIGADA DCODCOLIGADA 2 null
IDMOV int 4 null
NSEQITMMOV int 4 null
DATAMOVIMENTO datetime 16,3 √ null
SALDOANTERIOR RMDVALOR4 17,4 √ null
CUSTOMEDANTERIOR RMDVALOR4 17,4 √ null
TOTALANTERIOR RMDVALOR4 17,4 √ null
QTDECOMSINAL RMDVALOR4 17,4 √ null
VALORFINCOMSINAL RMDVALOR4 17,4 √ null
QTDEENTRADA RMDVALOR4 17,4 √ null
CUSTOUNITARIO RMDVALOR4 17,4 √ null
TOTALENTRADA RMDVALOR4 17,4 √ null
QTDESAIDA RMDVALOR4 17,4 √ null
CUSTOMEDITEM RMDVALOR4 17,4 √ null
TOTALSAIDA RMDVALOR4 17,4 √ null
SALDOMOV RMDVALOR4 17,4 √ null
CUSTOMEDMOV RMDVALOR4 17,4 √ null
TOTALMOV RMDVALOR4 17,4 √ null
ULTIMOCUSTOUNITARIO RMDVALOR4 17,4 √ null
CUSTOREPOSICAOA RMDVALOR4 17,4 √ null
CUSTOREPOSICAOB RMDVALOR4 17,4 √ null
SEQUENCIALFILIAL int 4 √ null
SALDOFILIALANT RMDVALOR4 17,4 √ null
TOTALFILIALANT RMDVALOR4 17,4 √ null
CUSTOMEDFILIALANT RMDVALOR4 17,4 √ null
CUSTOMEDFILIAL RMDVALOR4 17,4 √ null
SALDOFILIAL RMDVALOR4 17,4 √ null
TOTALFILIAL RMDVALOR4 17,4 √ null
DATAULTCUSTOUNITARIO datetime 16,3 √ null
VALORFINCOMSINALFILIAL RMDVALOR4 17,4 √ null
CUSTOUNITARIOFILIAL RMDVALOR4 17,4 √ null
TOTALENTRADAFILIAL RMDVALOR4 17,4 √ null
CUSTOMEDITEMFILIAL RMDVALOR4 17,4 √ null
TOTALSAIDAFILIAL RMDVALOR4 17,4 √ null
CODUNDCONTROLE varchar 5 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TOTALMOVAJUSTADOITEM RMDVALOR4 17,4 √ null
TOTALFILIALAJUSTADOIR RMDVALOR4 17,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTRELSLD Primary key Asc/Asc/Asc/Asc/Asc/Asc IDPRD + SALDO + CODFILIAL + CODLOC + SEQUENCIAL + CODCOLIGADA
IDXTRELSLDDATAMOVIMENTO Performance Asc/Asc/Asc CODCOLIGADA + IDPRD + DATAMOVIMENTO
IDXTRELSLDDATAMOVIMENTO2 Performance Asc/Asc/Asc/Asc CODCOLIGADA + IDPRD + DATAMOVIMENTO + SALDO
TXTRELSLD Performance Asc/Asc IDMOV + CODCOLIGADA

Diagram producer might be missing

No diagrams were produced please see application output for any errors