cof_packinglist_line

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_packinglist_line_id numeric 10 null
cof_rv_detalheslistaembarque.cof_packinglist_line_id Implied Constraint R
cof_packinglist_line_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
cof_packinglist_id numeric 10 √ null
cof_packinglist.cof_packinglist_id cofpackinglist_cofpackinglistl C
m_inout_id numeric 10 √ NULL::numeric
m_inout.m_inout_id minout_cofpackinglistline R
cof_grossweight numeric 0 √ (0)::numeric
cof_deliveryrestriction_id numeric 10 √ NULL::numeric
cof_deliveryrestriction.cof_deliveryrestriction_id cofdeliveryrestriction_cofpack R
cof_deliverydate timestamp 29,6 √ null
cof_deliveryoccurrence_id numeric 10 √ NULL::numeric
cof_deliveryoccurrence.cof_deliveryoccurrence_id cofdeliveryoccurrence_cofpacki R
line numeric 10 null
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofpackinglistline R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cofpackingli R
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_cofpackinglistline R
cof_localseparation_id numeric 10 √ NULL::numeric
cof_localseparation.cof_localseparation_id Implied Constraint R
description varchar 255 √ NULL::character varying
lbr_docfiscal_id numeric 10 √ NULL::numeric
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_cofpackinglistlin N
name varchar 500 NULL::character varying
m_rma_id numeric 10 √ null
m_rma.m_rma_id mrma_cofpackinglistline R
cof_sequenciaentrega numeric 10 √ null
cof_m_shipregion_id numeric 10 √ NULL::numeric
cof_m_shipregion.cof_m_shipregion_id cofmshipregion_cofpackinglistl R
cof_observacoesembarque varchar 255 √ NULL::character varying
cof_dfe_id numeric 10 √ NULL::numeric
cof_dfe.cof_dfe_id cofdfe_cofpackinglistline R
cof_permiteestorno bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_packinglist_line_key Primary key Asc cof_packinglist_line_id
cof_packinglist_line_uu_idx Must be unique Asc cof_packinglist_line_uu

Check Constraints

Constraint Name Constraint
cof_packinglist_line_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_line_cof_permiteestorno_check ((cof_permiteestorno = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation