oez_i_order

CREATE TABLE oez_i_order (
    oez_i_order_id varchar(32) NOT NULL,
    ad_client_id varchar(32) NULL,
    ad_org_id varchar(32) NULL,
    isactive bpchar(1) NULL DEFAULT 'Y'::bpchar,
    created timestamp NULL DEFAULT now(),
    createdby varchar(32) NULL,
    updated timestamp NULL DEFAULT now(),
    updatedby varchar(32) NULL,
    i_isimported bpchar(1) NULL DEFAULT 'N'::bpchar,
    i_errormsg varchar(2000) NULL,
    c_order_id varchar(32) NULL,
    c_orderline_id varchar(32) NULL,
    processing bpchar(1) NULL,
    processed bpchar(1) NULL DEFAULT 'N'::bpchar,
    documentno varchar(30) NULL,
    doctypename varchar(60) NULL,
    c_doctype_id varchar(32) NULL,
    dateordered timestamp NULL,
    scheduleddeliverydate timestamp NULL,
    bpartnersearchkey varchar(32) NULL,
    c_bpartner_id varchar(32) NULL,
    warehousesearchkey varchar(32) NULL,
    m_warehouse_id varchar(32) NULL,
    pricelistname varchar(60) NULL,
    m_pricelist_id varchar(32) NULL,
    paymentTermValue varchar(60) NULL,
    c_paymentterm_id varchar(32) NULL,
    paymentmethod varchar(60) NULL,
    fin_paymentmethod_id varchar(32) NULL,
    headerdescription varchar(255) NULL,
    productsearchkey varchar(32) NULL,
    m_product_id varchar(32) NULL,
    orderReference varchar(60) NULL,
    orderqty numeric NULL DEFAULT 0,
    netunitprice numeric NULL DEFAULT 0,
    netlistprice numeric NULL DEFAULT 0,
    taxsearchkey varchar(32) NULL,
    linedescription varchar(255) NULL,
    importOrder bpchar(1) null,
    importProcessComplete bpchar(1) null default 'N'::bpchar,
    CONSTRAINT oez_i_or_i_isimported_check CHECK ((i_isimported = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))),
    CONSTRAINT oez_i_or_isactive_check CHECK ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))),
    CONSTRAINT oez_i_or_isd_chk CHECK ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))),
    CONSTRAINT oez_i_or_client FOREIGN KEY (AD_CLIENT_ID) REFERENCES AD_CLIENT (AD_CLIENT_ID),
    CONSTRAINT oez_i_or_org FOREIGN KEY (ad_org_id) REFERENCES ad_org(ad_org_id),
    CONSTRAINT oez_i_or_key PRIMARY KEY (oez_i_order_id),
    CONSTRAINT oez_i_or_processed_check CHECK ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))),
    CONSTRAINT oez_i_or_b_partner FOREIGN KEY (c_bpartner_id) REFERENCES c_bpartner(c_bpartner_id),
    CONSTRAINT oez_i_or_warehouse FOREIGN KEY (m_warehouse_id) REFERENCES m_warehouse(m_warehouse_id),
    CONSTRAINT oez_i_iv_product FOREIGN KEY (m_product_id) REFERENCES m_product(m_product_id),
    CONSTRAINT oez_i_or_m_pricelist FOREIGN KEY (m_pricelist_id) REFERENCES m_pricelist(m_pricelist_id),
    CONSTRAINT oez_i_or_order FOREIGN KEY (c_order_id) REFERENCES c_order(c_order_id),
    CONSTRAINT oez_i_or_pay_term FOREIGN KEY (c_paymentterm_id) REFERENCES c_paymentterm(c_paymentterm_id),
    CONSTRAINT oez_i_or_pay_meth FOREIGN KEY (fin_paymentmethod_id) REFERENCES fin_paymentmethod(fin_paymentmethod_id)
);