oez_i_bpartner

CREATE TABLE public.oez_i_bpartner (
    oez_i_bpartner_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,
    value varchar(40) NULL,
    "name" varchar(60) NULL,
    name2 varchar(60) NULL,
    description varchar(255) NULL,
    groupvalue varchar(40) NULL,
    c_bp_group_id varchar(32) NULL,
    c_bpartner_location_id varchar(32) NULL,
    address1 varchar(60) NULL,
    address2 varchar(60) NULL,
    postal varchar(10) NULL,
    postal_add varchar(10) NULL ,
    city varchar(60) NULL,
    c_region_id varchar(32) NULL,
    regionname varchar(60) NULL,
    c_country_id varchar(32) NULL,
    countrycode varchar(2) NULL,
    phone varchar(40) NULL,
    phone2 varchar(40) NULL,
    fax varchar(40) NULL,
    email varchar(40) NULL,
    processing bpchar(1) NULL,
    processed bpchar(1) NULL DEFAULT 'N'::bpchar,
    i_erorrmsg varchar(2000) NULL,
    i_isimported bpchar(1) NULL DEFAULT 'N'::bpchar,
    em_oez_iscustomer bpchar(1) NULL,
    em_oez_isemployee bpchar(1) NULL,
    em_oez_isvendor bpchar(1) NULL,
    bank_name varchar(50) NULL,
    accountno varchar(100) NULL,
    em_a_name varchar(60) NULL,
    c_bp_bankaccount_id varchar(32) NOT NULL,
    CONSTRAINT oez_i_bp_isactive_check CHECK ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))),
    CONSTRAINT oez_i_bp_key PRIMARY KEY (oez_i_bpartner_id),
    CONSTRAINT oez_i_bp_processed_chk CHECK ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))),
    CONSTRAINT oez_i_bp_ad_client FOREIGN KEY (ad_client_id) REFERENCES ad_client(ad_client_id),
    CONSTRAINT oez_i_bp_ad_org FOREIGN KEY (ad_org_id) REFERENCES ad_org(ad_org_id),
    CONSTRAINT oez_i_bp_c_bp_group FOREIGN KEY (c_bp_group_id) REFERENCES c_bp_group(c_bp_group_id),
    CONSTRAINT oez_i_bp_c_bankAcount FOREIGN KEY (c_bp_bankaccount_id) REFERENCES c_bp_bankaccount(c_bp_bankaccount_id)
    CONSTRAINT oez_i_bp_c_region FOREIGN KEY (c_region_id) REFERENCES c_region(c_region_id),
);