cof_itemsubstituto

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_itemsubstituto_id numeric 10 null
cof_itemsubstituto_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_cofitemsubstituto R
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_cofitemsubstituto R
qty numeric 0 √ null
priceentered numeric 0 √ null
cof_faturado bpchar 1 √ 'N'::bpchar
priceactual numeric 0 √ null
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_cofitemsubstituto R
linenetamt numeric 0 √ null
lineno numeric 10 √ NULL::numeric
cof_qtdnf numeric 0 √ null
cof_gerarnf bpchar 1 √ 'N'::bpchar
cof_qtdis numeric 0 √ null
cof_tratamentopedido_id numeric 10 √ NULL::numeric
cof_tratamentopedido.cof_tratamentopedido_id coftratamentopedido_cofitemsub R
isvalid bpchar 1 √ NULL::bpchar
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_cofitemsubstituto N
m_inoutline_id numeric 10 √ NULL::numeric
m_inoutline.m_inoutline_id minoutline_cofitemsubstituto R

Indexes

Constraint Name Type Sort Column(s)
cof_itemsubstituto_key Primary key Asc cof_itemsubstituto_id
cof_itemsubstituto_uu_idx Must be unique Asc cof_itemsubstituto_uu

Check Constraints

Constraint Name Constraint
cof_itemsubstituto_isvalid_check ((isvalid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_itemsubstituto_cof_faturado_check ((cof_faturado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_itemsubstituto_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_itemsubstituto_cof_gerarnf_check ((cof_gerarnf = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation