i_order

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_order_id numeric 10 null
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
ad_org.ad_org_id adorg_iorder N
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_iorder N
isactive bpchar 1 √ 'Y'::bpchar
created timestamp 29,6 statement_timestamp()
createdby numeric 10 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 √ null
i_isimported bpchar 1 'N'::bpchar
i_errormsg varchar 2000 √ null
processing bpchar 1 √ null
processed bpchar 1 √ 'N'::bpchar
salesrep_id numeric 10 √ null
ad_user.ad_user_id adusersalesrep_iorder N
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id mwarehouse_iorder N
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id mpricelist_iorder N
c_currency_id numeric 10 √ null
c_currency.c_currency_id ccurrency_iorder N
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id mshipper_iorder N
issotrx bpchar 1 √ 'Y'::bpchar
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_iorder N
bpartnervalue varchar 40 √ null
name varchar 60 √ null
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbolocation_iorder N
billto_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbpartnerlocbillto_iorder N
c_location_id numeric 10 √ null
c_location.c_location_id clocation_iorder N
address1 varchar 60 √ null
address2 varchar 60 √ null
postal varchar 10 √ null
city varchar 60 √ null
c_region_id numeric 10 √ null
c_region.c_region_id cregion_iorder N
regionname varchar 60 √ null
c_country_id numeric 10 √ null
c_country.c_country_id ccountry_iorder N
countrycode bpchar 2 √ null
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_iorder N
contactname varchar 60 √ null
email varchar 60 √ null
phone varchar 40 √ null
c_project_id numeric 10 √ null
c_project.c_project_id cproject_iorder N
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_iorder N
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_iorder N
doctypename varchar 60 √ null
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cpaymentterm_iorder N
paymenttermvalue varchar 40 √ null
c_order_id numeric 10 √ null
c_order.c_order_id corder_iorder N
documentno varchar 30 √ null
dateordered timestamp 29,6 √ null
dateacct timestamp 29,6 √ null
description varchar 255 √ null
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_iorder N
productvalue varchar 40 √ null
upc varchar 30 √ null
sku varchar 30 √ null
c_tax_id numeric 10 √ null
c_tax.c_tax_id ctax_iorder N
taxindicator varchar 10 √ null
taxamt numeric 0 √ 0
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_iorder N
linedescription varchar 255 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id cuom_iorder N
qtyordered numeric 0 √ 0
priceactual numeric 0 √ 0
freightamt numeric 0 √ 0
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_iorder N
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_iorder R
chargename varchar 60 √ null
c_ordersource_id numeric 10 √ NULL::numeric
c_ordersource.c_ordersource_id cordersource_iorder R
c_ordersourcevalue varchar 40 √ NULL::character varying
deliveryrule bpchar 1 √ NULL::bpchar
i_order_uu varchar 36 √ NULL::character varying
cof_attributesetinstancevalue varchar 2000 √ NULL::character varying
lbr_transactiontype varchar 3 √ null
warehousevalue varchar 40 √ NULL::character varying
cof_pricelistname varchar 60 √ NULL::character varying
cof_taxname varchar 60 √ NULL::character varying
cof_cfopvalue varchar 60 √ NULL::character varying
cof_transactiontypevalue varchar 22 √ NULL::character varying
lbr_cfop_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id lbrcfop_iorder R

Indexes

Constraint Name Type Sort Column(s)
i_order_pkey Primary key Asc i_order_id
i_order_uu_idx Must be unique Asc i_order_uu

Check Constraints

Constraint Name Constraint
i_order_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_order_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_order_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation