DCOMPTRBFED

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCOMPTRBFEDGUIADEB.CODCOLIGADA FKDCOMTFEDGUIADEB_DCOMPTRBFEDR
DGUIAPERIODO.CODCOLIGADA FKDCOMPTRBFED_DGUIAPERIODOR
DTRIBUTO.CODCOLIGADA FKDCOMPTRBFED_DTRIBUTOR
IDCOMPTRBFED int 4 null
DCOMPTRBFEDGUIADEB.IDCOMPTRBFED FKDCOMTFEDGUIADEB_DCOMPTRBFEDR
NUMEROPEDIDO varchar 50 √ null
DTTRANSMISSAO datetime 16,3 √ null
CODTRB varchar 10 null
DTRIBUTO.CODTRB FKDCOMPTRBFED_DTRIBUTOR
DESCPEDIDO varchar 255 √ null
TIPOCREDITO int 4 null
FORMAPEDIDO int 4 null
VLRORIGINAL RMDVALOR4 17,4 √ null
VLRCREDITO RMDVALOR4 17,4 √ null
TXSELIC RMDVALOR4 17,4 √ null
VLRATUALIZADO RMDVALOR4 17,4 √ null
VLRCOMPENSADO RMDVALOR4 17,4 √ null
VLRJUROSCOMP RMDVALOR4 17,4 √ null
SALDOCREDITO RMDVALOR4 17,4 √ null
IDGUIA int 4 √ null
DGUIAPERIODO.IDGUIA FKDCOMPTRBFED_DGUIAPERIODOR
PERIODO DDATETIME 16,3 √ null
CNPJ varchar 20 √ null
CODRECEITA varchar 10 √ null
FIRRF.CODRECEITA Implied ConstraintR
DATAVENC DDATETIME 16,3 √ null
DATAGNR DDATETIME 16,3 √ null
NUMEROGNR varchar 20 √ null
VALORGNR RMDVALOR4 17,4 √ null
VALORMULTA RMDVALOR4 17,4 √ null
VALORJUROS RMDVALOR4 17,4 √ null
VALORPAGO RMDVALOR4 17,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)
PKDCOMPTRBFED Primary key Asc/Asc CODCOLIGADA + IDCOMPTRBFED

Relationships

Close relationships within degrees of separation