rendered paste body Table "public.c_order"
Column | Type | Modifiers
------------------------+-----------------------------+------------------------------
c_order_id | numeric(10,0) | not null
ad_client_id | numeric(10,0) | not null
ad_org_id | numeric(10,0) | not null
isactive | character(1) | not null default 'Y'::bpchar
created | timestamp without time zone | not null default now()
createdby | numeric(10,0) | not null
updated | timestamp without time zone | not null default now()
updatedby | numeric(10,0) | not null
issotrx | character(1) | not null default 'Y'::bpchar
documentno | character varying(30) | not null
docstatus | character(2) | not null
docaction | character(2) | not null
processing | character(1) |
processed | character(1) | not null default 'N'::bpchar
c_doctype_id | numeric(10,0) | not null
c_doctypetarget_id | numeric(10,0) | not null
description | character varying(255) |
isapproved | character(1) | default 'Y'::bpchar
iscreditapproved | character(1) | default 'N'::bpchar
isdelivered | character(1) | not null default 'N'::bpchar
isinvoiced | character(1) | not null default 'N'::bpchar
isprinted | character(1) | not null default 'N'::bpchar
istransferred | character(1) | default 'N'::bpchar
isselected | character(1) | not null default 'N'::bpchar
salesrep_id | numeric(10,0) |
dateordered | timestamp without time zone | not null
datepromised | timestamp without time zone |
dateprinted | timestamp without time zone |
dateacct | timestamp without time zone | not null
c_bpartner_id | numeric(10,0) | not null
billto_id | numeric(10,0) |
c_bpartner_location_id | numeric(10,0) | not null
poreference | character varying(20) |
isdiscountprinted | character(1) | not null default 'Y'::bpchar
c_currency_id | numeric(10,0) | not null
paymentrule | character(1) | not null
c_paymentterm_id | numeric(10,0) | not null
invoicerule | character(1) | not null
deliveryrule | character(1) | not null
freightcostrule | character(1) | not null
freightamt | numeric | default 0
deliveryviarule | character(1) | not null
m_shipper_id | numeric(10,0) |
c_charge_id | numeric(10,0) |
chargeamt | numeric | default 0
priorityrule | character(1) | not null
totallines | numeric | not null default 0
grandtotal | numeric | not null default 0
m_warehouse_id | numeric(10,0) | not null
m_pricelist_id | numeric(10,0) | not null
istaxincluded | character(1) | default 'N'::bpchar
c_campaign_id | numeric(10,0) |
c_project_id | numeric(10,0) |
c_activity_id | numeric(10,0) |
posted | character(1) | not null default 'N'::bpchar
sendemail | character(1) | default 'N'::bpchar
ad_user_id | numeric(10,0) |
copyfrom | character(1) |
dropship_bpartner_id | numeric(10,0) |
dropship_location_id | numeric(10,0) |
dropship_user_id | numeric(10,0) |
isselfservice | character(1) | not null default 'N'::bpchar
ad_orgtrx_id | numeric(10,0) |
user1_id | numeric(10,0) |
user2_id | numeric(10,0) |
deliverynotes | character varying(2000) |
c_incoterms_id | numeric(10,0) |
incotermsdescription | character varying(255) |
generatetemplate | character(1) |
delivery_location_id | numeric(10,0) |
copyfrompo | character(1) |
Indexes:
"c_order_key" PRIMARY KEY, btree (c_order_id)
"c_order_bpartner" btree (c_bpartner_id)
"c_order_client_org_date_docno" btree (ad_client_id, ad_org_id, dateordered, documentno)
"c_order_docno" btree (documentno)
"c_order_updated" btree (updated)
Check constraints:
"c_order_isactive_check" CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_isapproved_check" CHECK (isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_iscreditapproved_check" CHECK (iscreditapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_isdelivered_check" CHECK (isdelivered = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_isdiscountprinted_check" CHECK (isdiscountprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_isinvoiced_check" CHECK (isinvoiced = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_isprinted_check" CHECK (isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_isselected_check" CHECK (isselected = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_issotrx_check" CHECK (issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_istaxincluded_check" CHECK (istaxincluded = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_istransferred_check" CHECK (istransferred = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
"c_order_processed_check" CHECK (processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
Foreign-key constraints:
"adclient_corder" FOREIGN KEY (ad_client_id) REFERENCES ad_client(ad_client_id)
"adorg_corder" FOREIGN KEY (ad_org_id) REFERENCES ad_org(ad_org_id)
"adorgtrx_corder" FOREIGN KEY (ad_orgtrx_id) REFERENCES ad_org(ad_org_id)
"aduser_corder" FOREIGN KEY (ad_user_id) REFERENCES ad_user(ad_user_id)
"aduser_sr_corder" FOREIGN KEY (salesrep_id) REFERENCES ad_user(ad_user_id)
"aduserdropship_corder" FOREIGN KEY (dropship_user_id) REFERENCES ad_user(ad_user_id)
"c_doctype_corder" FOREIGN KEY (c_doctype_id) REFERENCES c_doctype(c_doctype_id)
"cactivity_corder" FOREIGN KEY (c_activity_id) REFERENCES c_activity(c_activity_id)
"cbpartner_corder" FOREIGN KEY (c_bpartner_id) REFERENCES c_bpartner(c_bpartner_id)
"cbpartnerdropship_corder" FOREIGN KEY (dropship_bpartner_id) REFERENCES c_bpartner(c_bpartner_id)
"cbpartnerlocation_soheader" FOREIGN KEY (c_bpartner_location_id) REFERENCES c_bpartner_location(c_bpartner_location_id)
"cbplocationbillto_soheader" FOREIGN KEY (billto_id) REFERENCES c_bpartner_location(c_bpartner_location_id)
"cbplocationdropship_corder" FOREIGN KEY (dropship_location_id) REFERENCES c_bpartner_location(c_bpartner_location_id)
"ccampaign_corder" FOREIGN KEY (c_campaign_id) REFERENCES c_campaign(c_campaign_id)
"ccharge_corder" FOREIGN KEY (c_charge_id) REFERENCES c_charge(c_charge_id)
"ccurrency_corder" FOREIGN KEY (c_currency_id) REFERENCES c_currency(c_currency_id)
"cdoctypetarget_corder" FOREIGN KEY (c_doctypetarget_id) REFERENCES c_doctype(c_doctype_id)
"corder_cincotemrs" FOREIGN KEY (c_incoterms_id) REFERENCES c_incoterms(c_incoterms_id)
"cpaymentterm_soheader" FOREIGN KEY (c_paymentterm_id) REFERENCES c_paymentterm(c_paymentterm_id)
"cproject_corder" FOREIGN KEY (c_project_id) REFERENCES c_project(c_project_id)
"mpricelist_soheader" FOREIGN KEY (m_pricelist_id) REFERENCES m_pricelist(m_pricelist_id)
"mshipper_corder" FOREIGN KEY (m_shipper_id) REFERENCES m_shipper(m_shipper_id)
"mwarehouse_corder" FOREIGN KEY (m_warehouse_id) REFERENCES m_warehouse(m_warehouse_id)
Triggers:
c_order_chk_restrinctions_trg BEFORE INSERT OR DELETE OR UPDATE ON c_order FOR EACH ROW EXECUTE PROCEDURE c_order_chk_restrinctions_trg()
c_order_trg AFTER UPDATE ON c_order FOR EACH ROW EXECUTE PROCEDURE c_order_trg()
c_order_trg2 AFTER UPDATE ON c_order FOR EACH ROW EXECUTE PROCEDURE c_order_trg2()