DDARF

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GFILIAL.CODCOLIGADA FKDDARF_GFILIALR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKDDARF_GFILIALR
ABRANGENCIA varchar 1 null
ANOBASE smallint 2 null
MESBASE smallint 2 null
VLRACUMULADO RMDVALOR2 17,2 √ null
VLRFATURAMENTO RMDVALOR2 17,2 √ null
ALIQUOTA RMDVALOR4 17,4 √ null
VLRFATACUMULADO RMDVALOR2 17,2 √ null
VALORSIMPLES RMDVALOR2 17,2 √ null
VALORVENDAS RMDVALOR2 17,2 √ null
VALORENTRADAS RMDVALOR2 17,2 √ null
NUMEMPREGADOS int 4 √ 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)
PKDDARF Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + ABRANGENCIA + ANOBASE + MESBASE

Relationships

Close relationships within degrees of separation