TMDFEINFPAGAMENTOFRETE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TMDFECOMPPGTOFRETE.CODCOLIGADA FKTMDFECOMPPGTOFRETE_TMDFEINFR
TMDFEINFPGTOAPRAZO.CODCOLIGADA FKTMDFEINFPGTOAPRAZO_TMDFEINFR
TCTEMOV.CODCOLIGADA FKTMDFEINFPAGAMENTOFRETE_TCTER
IDCTE int 4 null
TMDFECOMPPGTOFRETE.IDCTE FKTMDFECOMPPGTOFRETE_TMDFEINFR
TMDFEINFPGTOAPRAZO.IDCTE FKTMDFEINFPGTOAPRAZO_TMDFEINFR
TCTEMOV.IDCTE FKTMDFEINFPAGAMENTOFRETE_TCTER
NSEQPGTOFRETE int 4 null
TMDFECOMPPGTOFRETE.NSEQPGTOFRETE FKTMDFECOMPPGTOFRETE_TMDFEINFR
TMDFEINFPGTOAPRAZO.NSEQPGTOFRETE FKTMDFEINFPGTOAPRAZO_TMDFEINFR
NOMERESPONSAVELPGTO varchar 60 √ null
IDENTIFICADORRESPPGTO varchar 20 null
VALORCONTRATO RMDVALOR4 17,4 null
INDICADORFORMAPGTO int 4 null
CODBANCO varchar 5 √ null
CODAGENCIA varchar 10 √ null
NUMCNPJINSTITUICAOPGTOFRETE varchar 14 √ null
TIPORESPPGTO varchar 1 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CHAVEPIX varchar 60 √ null
INDALTODESEMP smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKTMDFEINFPAGAMENTOFRETE Primary key Asc/Asc/Asc CODCOLIGADA + IDCTE + NSEQPGTOFRETE

Relationships

Close relationships within degrees of separation