DPERIODORESSARCIMENTOICMSST

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DPERIODO.CODCOLIGADA FKDPERIODO_RESSARCIMENTOICMSSTR
DITEM.CODCOLIGADA FKDITEM_RESSARCIMENTOICMSSTR
DITEMHISTORICO.CODCOLIGADA FKDITEMHI_RESSARCIMENTOICMSSTR
GFILIAL.CODCOLIGADA FKGFILIAL_RESSARCIMENTOICMSSTR
IDRESSARCIMENTO int 4 null
IDPER int 4 null
DPERIODO.IDPER FKDPERIODO_RESSARCIMENTOICMSSTR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKGFILIAL_RESSARCIMENTOICMSSTR
IDPRD int 4 null
TPRODUTO.IDPRD Implied ConstraintR
IDLAF int 4 √ null
DITEM.IDLAF FKDITEM_RESSARCIMENTOICMSSTR
NUMITEM int 4 √ null
DITEM.NUMITEM FKDITEM_RESSARCIMENTOICMSSTR
IDLAFHIST int 4 √ null
DITEMHISTORICO.IDLAF FKDITEMHI_RESSARCIMENTOICMSSTR
NUMITEMHIST int 4 √ null
DITEMHISTORICO.NUMITEM FKDITEMHI_RESSARCIMENTOICMSSTR
QUANTIDADE RMDVALOR4 17,4 √ null
VLRUNSUPORTADO RMDVALOR4 17,4 √ null
VLRUNCONFRONTO RMDVALOR4 17,4 √ null
VLRTOTSUPORTADO RMDVALOR4 17,4 √ null
VLRTOTCONFRONTO RMDVALOR4 17,4 √ null
VLRRESSARCIMENTOAPURADO RMDVALOR4 17,4 √ null
TIPO varchar 1 √ null
ENQUADRAMENTOLEGAL int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

Constraint Name Type Sort Column(s)
PKDPERIODORESSARCIMENTOICMSST Primary key Asc/Asc CODCOLIGADA + IDRESSARCIMENTO

Relationships

Close relationships within degrees of separation