Supplier Interface Staging table

Staging table structure of supplier Interface-----

create table xx_ap_suppliers_stg --ap_suppliers_int
(
vendor_full_name varchar2(240) not null --VENDOR_NAME
,vendor_code varchar2(30) not null --SEGMENT1
,alt_vendor_name varchar2(320) --VENDOR_NAME_ALT
,active_vendor_since date --START_DATE_ACTIVE
,inactive_date date --END_DATE_ACTIVE
,vendor_type varchar2(30) --VENDOR_TYPE_LOOKUP_CODE
,domestic_or_international varchar2(25) --STANDARD_INDUSTRY_CLASS
,customer_num varchar2(25) --CUSTOMER_NUM
,parent_vendor_code varchar2(30) --
,small_scale_industry varchar2(1) --SMALL_BUSINESS_FLAG
,industry varchar2(25) --ORGANIZATION_TYPE_LOOKUP_CODE
,min_order_amount number --MIN_ORDER_AMOUNT
,inspection_reqd_flag varchar2(1) --INSPECTION_REQUIRED_FLAG
,receipt_reqd_flag varchar2(1) --RECEIPT_REQUIRED_FLAG
,qty_receipt_tolerance number --QTY_RCV_TOLERANCE
,days_early_receipt_allwd number --DAYS_EARLY_RECEIPT_ALLOWED
,days_late_receipt_allwd number --DAYS_LATE_RECEIPT_ALLOWED
,substitute_receipt_allwd varchar2(1) --ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,unordered_receipts_allowed varchar2(1) --ALLOW_UNORDERED_RECEIPTS_FLAG
,request_id number(15)
,status varchar2(15)
,reject_code varchar2(1000)
);

create table xx_ap_supplier_sites_stg --ap_supplier_sites_int
(
vendor_code varchar2(30) not null --for reference to supplier
,vendor_site_code varchar2(15) not null --VENDOR_SITE_CODE
,vendor_site_code_alt varchar2(320) --VENDOR_SITE_CODE_ALT
,operating_unit varchar2(30) not null --ORG_ID
,inactive_date date --INACTIVE_DATE
,purchasing_site_flag varchar2(1) --PURCHASING_SITE_FLAG
,rfq_only_site_flag varchar2(1) --RFQ_ONLY_SITE_FLAG
,pay_site_flag varchar2(1) --PAY_SITE_FLAG
,address_line1 varchar2(240) --ADDRESS_LINE1
,address_line2 varchar2(240) --ADDRESS_LINE2
,address_line3 varchar2(240) --ADDRESS_LINE3
,address_line4 varchar2(240) --ADDRESS_LINE4
,city varchar2(25) --CITY
,district varchar2(150) --PROVINCE
,state varchar2(150) --STATE
,pin varchar2(20) --ZIP
,country varchar2(25) --COUNTRY
,landmark varchar2(560) --ADDRESS_LINES_ALT
,area_code varchar2(10) --AREA_CODE
,phone varchar2(15) --PHONE
,fax varchar2(15) --FAX
,vendor_internet_site varchar2(2000) --EMAIL_ADDRESS
,freight_terms varchar2(25) --FREIGHT_TERMS_LOOKUP_CODE
,payment_terms varchar2(50) --TERMS_NAME
,terms_date_basis varchar2(25) --TERMS_DATE_BASIS
,pay_date_basis varchar2(25) --PAY_DATE_BASIS_LOOKUP_CODE
,pay_group varchar2(25) --PAY_GROUP_LOOKUP_CODE
,payment_priority number --PAYMENT_PRIORITY
,invioce_currency varchar2(15) --INVOICE_CURRENCY_CODE
,payment_currency varchar2(15) --PAYMENT_CURRENCY_CODE
,invoice_amount_limit number --INVOICE_AMOUNT_LIMIT
,vat_code varchar2(20) --VAT_CODE
,preferred_payment_method varchar2(25) --PAYMENT_METHOD_LOOKUP_CODE
,vendor_bank_name varchar2(50) --
,bank_acct_number varchar2(50) --
,hold_unmatched_invoices varchar2(1) --HOLD_UNMATCHED_INVOICES_FLAG
,vat_regd_num varchar2(20) --VAT_REGISTRATION_NUM
,bank_charge_bearer varchar2(1) --BANK_CHARGE_BEARER
,l_segment1 varchar2(10)
,l_segment2 varchar2(10)
,l_segment3 varchar2(10)
,l_segment4 varchar2(10)
,l_segment5 varchar2(10)
,l_segment6 varchar2(10)
,l_segment7 varchar2(10)
,l_segment8 varchar2(10)
,p_segment1 varchar2(10)
,p_segment2 varchar2(10)
,p_segment3 varchar2(10)
,p_segment4 varchar2(10)
,p_segment5 varchar2(10)
,p_segment6 varchar2(10)
,p_segment7 varchar2(10)
,p_segment8 varchar2(10)
,request_id number(15)
,status varchar2(15)
,reject_code varchar2(1000)
);

create table xx_ap_sup_site_contacts_stg --ap_sup_site_contact_int
(
vendor_code varchar2(30) not null --reference to supplier
,vendor_site_code varchar2(15) not null --reference to site code
,prefix varchar2(5) --PREFIX
,first_name varchar2(15) --FIRST_NAME
,middle_name varchar2(15) --MIDDLE_NAME
,last_name varchar2(20) --LAST_NAME
,designation varchar2(30) --TITLE
,department varchar2(230) --DEPARTMENT
,email varchar2(2000) --EMAIL_ADDRESS
,area_code varchar2(10) --AREA_CODE
,phone varchar2(15) --PHONE
,alt_phone varchar2(15) --ALT_PHONE
,fax varchar2(15) --FAX
,inactive_date date --INACTIVE_DATE
,request_id number(15)
,status varchar2(15)
,reject_code varchar2(1000)
);