SZITEMALTOCUSTO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKSZITEMALTOCUSTO_GCOLIGADAR
SEQUENCIAL int 4 null
JUSTIFICATIVA MEMO 2147483647 √ null
DATA DDATETIME 16,3 √ null
ORIGEM char 1 null
CODPACIENTE int 4 √ null
CODATENDIMENTO int 4 √ null
ECNTATENDIM.CODATENDIMENTO Implied ConstraintR
SEQPARCIAL int 4 √ null
IDPRD int 4 √ null
TPRODUTO.IDPRD Implied ConstraintR
CODESPECIFICO varchar 8 √ null
QUANTIDADE RMDVALOR4 17,4 null
VALORUNITARIO RMDVALOR4 17,4 null
VALORTOTAL RMDVALOR2 17,2 null
CODPRESCRICAO int 4 √ null
SEQPRESC int 4 √ null
CODREQUISICAO int 4 √ null
SEQREQ int 4 √ null
SEQDEBITO int 4 √ null
SEQCENTRALAUTORIZACAO 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)
PKSZITEMALTOCUSTO Primary key Asc/Asc CODCOLIGADA + SEQUENCIAL

Relationships

Close relationships within degrees of separation