CLCMOLDE_TEMP

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CODIGO varchar 10 null
CODESTRUTURA varchar 10 null
CODFILIAL smallint 2 √ null
DATA datetime 16,3 √ null
DEBITO DCODCONTA 40 √ null
CREDITO DCODCONTA 40 √ null
PARTIDA DCODCONTA 40 √ null
VALOR RMDVALOR2 17,2 √ null
CODHISTP varchar 10 √ null
COMPLEMENTO varchar 250 √ null
VALOR2 RMDVALOR4 17,4 √ null
CODCOLDEBITO DCODCOLIGADA 2 null
CODCOLCREDITO DCODCOLIGADA 2 null
CODCOLPARTIDA DCODCOLIGADA 2 null
CODCCUSTO varchar 25 √ null
CODDEPARTAMENTO varchar 25 √ null
DOCUMENTO varchar 20 √ null
VARFILIAL varchar 10 √ null
VARDATA varchar 10 √ null
VARDEBITO varchar 10 √ null
VARCREDITO varchar 10 √ null
VARPARTIDA varchar 10 √ null
VARVALOR varchar 10 √ null
VARHISTP varchar 10 √ null
VARCOMPLEMENTO varchar 10 √ null
VARVALOR2 varchar 10 √ null
VARCCUSTO varchar 10 √ null
VARDEPTO varchar 10 √ null
VARDOCUMENTO varchar 10 √ null
DATA2 datetime 16,3 √ null
VARDATA2 varchar 10 √ null
EXPRESSAO varchar 100 √ null
EXPRESSAO2 varchar 100 √ null
CODDIARIO varchar 5 √ null
VARCODDIARIO varchar 10 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKLCMOLDE Primary key Asc/Asc/Asc CODCOLIGADA + CODESTRUTURA + CODIGO

Diagram producer might be missing

No diagrams were produced please see application output for any errors