DLDCNF

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DLAFAGRUPHISTORICO.CODCOLIGADA FKDLDCNF_DLAFAGRUPHISTORICOR
DLDC.CODCOLIGADA FKDLDCNF_DLDCR
FTDO.CODCOLIGADA FKDLDCNF_FTDOR
DLAFAGRUP.CODCOLIGADA FKDLDCNF_DLAFAGRUPR
IDLDC int 4 null
DLDC.IDLDC FKDLDCNF_DLDCR
IDLDCNF int 4 null
IDLAF int 4 √ null
OBSERVACAO varchar 80 √ null
CODTDO varchar 10 √ null
FTDO.CODTDO FKDLDCNF_FTDOR
DOCINI varchar 15 √ null
SERIEDOC varchar 20 √ null
SUBSERIE varchar 20 √ null
CNPJCPFCEI varchar 20 √ null
UF varchar 2 √ null
GETD.CODETD FKDLDCNF_GETDR
INSCRESTADUAL varchar 20 √ null
VALORTOTAL RMDVALOR2 17,2 √ null
DATAEMISSAO datetime 16,3 √ null
MOTIVO varchar 10 √ null
DATAVISTO datetime 16,3 √ null
PRODUTORRURAL smallint 2 √ (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDLAFAGRUP int 4 √ null
DLAFAGRUP.IDLAFAGRUP FKDLDCNF_DLAFAGRUPR
IDLAFAGRUPHIST int 4 √ null
DLAFAGRUPHISTORICO.IDLAFAGRUP FKDLDCNF_DLAFAGRUPHISTORICOR

Indexes

Constraint Name Type Sort Column(s)
PKDLDCNF Primary key Asc/Asc IDLDCNF + CODCOLIGADA

Relationships

Close relationships within degrees of separation