DPERIODODIFAL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DPERIODO.CODCOLIGADA FKDPERIODODIFAL_DPERIODOR
IDPER int 4 null
DPERIODO.IDPER FKDPERIODODIFAL_DPERIODOR
CODETD varchar 2 null
GETD.CODETD FKDPERIODODIFAL_GETDR
REMETENTE int 4 null
VLRDEBITODIFAL RMDVALOR4 17,4 √ null
VLROUTROSDEBITOS RMDVALOR4 17,4 √ null
VLRESTORNOCREDITO RMDVALOR4 17,4 √ null
VLRCREDITODIFAL RMDVALOR4 17,4 √ null
VLROUTROSCREDITOS RMDVALOR4 17,4 √ null
VLRESTORNODEBITO RMDVALOR4 17,4 √ null
VLRDEDUCAO RMDVALOR4 17,4 √ null
VLRDEBITOSESPECIAIS RMDVALOR4 17,4 √ null
VLRFECPSAIDA RMDVALOR4 17,4 √ null
VLRFECPENTRADA RMDVALOR4 17,4 √ null
SALDOCREDDEVANT RMDVALOR4 17,4 √ null
SALDODEVANTDEDUCAO RMDVALOR4 17,4 √ null
SALDOCREDORDEVEDOR RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
VLRESTORNOCREDITOFECP RMDVALOR4 17,4 √ null
VLRESTORNODEBITOFECP RMDVALOR4 17,4 √ null
SALDOCREDORANTFCP RMDVALOR4 17,4 √ null
VLROUTROSDEBFCP RMDVALOR4 17,4 √ null
VLROUTROSCREDFCP RMDVALOR4 17,4 √ null
SALDODEVANTDEDUCAOFCP RMDVALOR4 17,4 √ null
VLRDEDUCAOFCP RMDVALOR4 17,4 √ null
VLRDEBITOSESPECIAISFCP RMDVALOR4 17,4 √ null
SALDOCREDORDEVEDORFCP RMDVALOR4 17,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKDPERIODODIFAL Primary key Asc/Asc/Asc CODCOLIGADA + IDPER + CODETD

Relationships

Close relationships within degrees of separation