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()