SZ0PROTOCOLODETALHE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CDCOLIGADA DCODCOLIGADA 2 null
SZ0PROTOCOLO.CDCOLIGADA FKSZ0PROTOCOLODET_SZ0PROTOCOLOR
SZ0ESTOQUE.CDCOLIGADA FKSZ0PROTOCOLODETALHE_SZ0ESTOQR
SZ0INSUMO.CDCOLIGADA FKSZ0PROTOCOLODETALHE_SZ0INSUMR
CDFILIAL smallint 2 null
SZ0ESTOQUE.CDFILIAL FKSZ0PROTOCOLODETALHE_SZ0ESTOQR
SZ0INSUMO.CDFILIAL FKSZ0PROTOCOLODETALHE_SZ0INSUMR
SZ0PROTOCOLO.CDFILIAL FKSZ0PROTOCOLODET_SZ0PROTOCOLOR
CDPROTOCOLO numeric 12 null
SZ0PROTOCOLO.CDPROTOCOLO FKSZ0PROTOCOLODET_SZ0PROTOCOLOR
CDGRUPOINSUMO varchar 50 null
SZ0INSUMO.CDGRUPOINSUMO FKSZ0PROTOCOLODETALHE_SZ0INSUMR
CDINSUMO varchar 50 null
SZ0INSUMO.CDINSUMO FKSZ0PROTOCOLODETALHE_SZ0INSUMR
CDESTOQUE varchar 50 null
SZ0ESTOQUE.CDESTOQUE FKSZ0PROTOCOLODETALHE_SZ0ESTOQR
QTAMOSTRA numeric 16,2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CDTABELAINSUMO varchar 50 null
SZ0INSUMO.CDTABELAINSUMO FKSZ0PROTOCOLODETALHE_SZ0INSUMR

Indexes

Constraint Name Type Sort Column(s)
PKSZ0PROTOCOLODETALHE Primary key Asc/Asc/Asc/Asc/Asc/Asc CDCOLIGADA + CDFILIAL + CDPROTOCOLO + CDGRUPOINSUMO + CDINSUMO + CDESTOQUE

Relationships

Close relationships within degrees of separation