XCONTRATO

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NUM_CONT int 4 null
XDOCUMENTO.NUMCONT FKXDOCUMENTO_XCONTRATOR
XVENDA.NUM_CONT FKXVENDA_XCONTRATOR
COD_SIT_CONT int 4 null
XSITUACAOCONTRATO.COD_SIT_CONT FKXCONTRATO_XSITUACAOCONTRATOR
COD_MODEL_CONTR int 4 √ null
XMODELOCONTRATO.COD_MODEL_CONTR FKXCONTRATO_XMODELOCONTRATOR
DAT_EMISS datetime 16,3 √ null
SALDO_DEV RMDVALOR4 17,4 √ null
DAT_BASE_SALDO_DEV datetime 16,3 √ null
COD_SIT_OPRL char 1 √ null
COD_PESS_ULT_MNT varchar 20 √ null
DAT_ULT_MNT datetime 16,3 √ null
CONTRATO varchar 25 √ null
TAXA_OCUP RMDVALOR4 17,4 √ null
DATAPREVENTREGA datetime 16,3 √ null
CODCOLIGADA DCODCOLIGADANULL 2 √ 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)
PKXCONTRATO Primary key Asc NUM_CONT

Relationships

Close relationships within degrees of separation