cof_entregaavulsa

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofentregaavulsa R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofentregaavulsa R
ad_table_id numeric 10 √ NULL::numeric
ad_table.ad_table_id adtable_cofentregaavulsa R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofentregaavulsa R
c_location_id numeric 10 √ NULL::numeric
c_location.c_location_id clocation_cofentregaavulsa R
cof_dataentregaavulsa timestamp 29,6 √ null
cof_entregaavulsa_id numeric 10 null
cof_packinglist_line.cof_entregaavulsa_id cofentregaavulsa_cofpackinglistline R
cof_entregaavulsa_uu varchar 36 √ NULL::character varying
cof_peso numeric 0 √ 0
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofentregaavulsa R
documentno varchar 30 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
record_id numeric 10 √ NULL::numeric
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofentregaavulsa R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cofentregaavulsa R
deliveryviarule bpchar 1 √ 'D'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_entregaavulsa_key Primary key Asc cof_entregaavulsa_id
cof_entregaavulsa_uu_idx Must be unique Asc cof_entregaavulsa_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation