OFITEMORDEMMAOOBRA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
OFMAOOBRA.CODCOLIGADA FKOFITEMORDEMMAOOBRA_OFMAOOBRAR
OFITEMORDEMSERVICO.CODCOLIGADA FKOFITEMORDEMMAOOBRA_OFITEMORDR
IDMOV int 4 null
OFITEMORDEMSERVICO.IDMOV FKOFITEMORDEMMAOOBRA_OFITEMORDR
NSEQITMMOV int 4 null
OFITEMORDEMSERVICO.NSEQITMMOV FKOFITEMORDEMMAOOBRA_OFITEMORDR
CODPESSOA int 4 null
OFMAOOBRA.CODPESSOA FKOFITEMORDEMMAOOBRA_OFMAOOBRAR
EMPENHO RMDVALOR2 17,2 (100)
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)
PKOFITEMORDEMMAOOBRA Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDMOV + NSEQITMMOV + CODPESSOA

Check Constraints

Constraint Name Constraint
CK__OFITEMORD__EMPEN__4C6C248F ([EMPENHO] >= 0)

Relationships

Close relationships within degrees of separation