EMODCONPC

431 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODPERLET varchar 6 null
EMODCONCT.CODPERLET FKEMODCONCT_EMODCONPCR
EMODCONTR.CODPERLET FKEMODCONPC_EMODCONTRR
MODELO varchar 10 null
EMODCONCT.MODELO FKEMODCONCT_EMODCONPCR
EMODCONTR.CODMOD FKEMODCONPC_EMODCONTRR
PARCELA int 4 null
EMODCONCT.PARCELA FKEMODCONCT_EMODCONPCR
CODSERV int 4 null
EMODCONCT.SERVICO FKEMODCONCT_EMODCONPCR
ESERVICOS.SERVICO_COD FKEMODCONPC_ESERVICOSR
ACUMCOTAS varchar 1 √ null
VALOR RMDVALOR2 17,2 √ null
MOEDA int 4 √ null
NCOTAS int 4 √ null
DESCONTO RMDVALOR4 17,4 √ null
VRCHEIO RMDVALOR2 17,2 √ null
TIPODESC int 4 √ null
CODFORMA int 4 √ null
CODBOL int 4 √ null
USAVALORFIXO varchar 1 √ 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)
PKEMODCONPC Primary key Asc/Asc/Asc/Asc CODPERLET + MODELO + PARCELA + CODSERV

Relationships

Close relationships within degrees of separation