DROP SYNONYM XXCUS.XXAVX_CUSTOMERS_STG;
DROP TABLE XXCUS.XXAVX_CUSTOMERS_STG;
CREATE TABLE xxcus.XXAVX_CUSTOMERS_STG
(
ORGANIZATION_NAME VARCHAR2(240)
,PARTY_NUMBER VARCHAR2(240)
,ORIG_SYSTEM_REFERENCE VARCHAR2(240)
,ACCOUNT_NUMBER VARCHAR2(240)
,ACCOUNT_NAME VARCHAR2(240)
,CREATED_BY_MODULE VARCHAR2(240)
,DUNNING_LETTERS_FLAG VARCHAR2(240)
,DUNNING_LETTERS_SET_ID VARCHAR2(240)
,ORIG_SYSTEM_ADDRESS_REF VARCHAR2(240)
,COUNTRY VARCHAR2(2)
,STATE VARCHAR2(240)
,PROVINCE VARCHAR2(240)
,ADDRESS1 VARCHAR2(240)
,ADDRESS2 VARCHAR2(240)
,ADDRESS3 VARCHAR2(240)
,ADDRESS4 VARCHAR2(240)
,CITY VARCHAR2(240)
,POSTAL_CODE VARCHAR2(240)
,ADDRESSEE VARCHAR2(240)
,IDENTIFYING_ADDRESS_FLAG VARCHAR2(240)
,LANGUAGE VARCHAR2(240)
,SITE_USE_CODE VARCHAR2(240)
,PERSON_FLAG VARCHAR2(240)
,FIRST_NAME VARCHAR2(240)
,LAST_NAME VARCHAR2(240)
,ORG_CONTACT_PRE_NAME_ADJUNT VARCHAR2(240)
,ORG_CONTACT_FIRST_NAME VARCHAR2(240)
,ORG_CONTACT_LAST_NAME VARCHAR2(240)
,ORG_CONTACT_DEPARTMENT_CODE VARCHAR2(240)
,ORG_CONTACT_JOB_TITLE VARCHAR2(240)
,ORGCONTACT_DECISIONMAKERFLAG VARCHAR2(240)
,ORG_CONTACT_JOB_TITLE_CODE VARCHAR2(240)
,ORG_CONTACT_ROLE_TYPE VARCHAR2(240)
,ORG_CONTACT_PHONE_NUMBER VARCHAR2(240)
,ORG_CONTACT_PHONE_LINE_TYPE VARCHAR2(240)
,SITE_CONTACT_PRE_NAME_ADJUNT VARCHAR2(240)
,SITE_CONTACT_FIRST_NAME VARCHAR2(240)
,SITE_CONTACT_LAST_NAME VARCHAR2(240)
,SITE_CONTACT_DEPARTMENT_CODE VARCHAR2(240)
,SITE_CONTACT_JOB_TITLE VARCHAR2(240)
,SITECONTACT_DECISIONMAKERFLAG VARCHAR2(240)
,SITE_CONTACT_JOB_TITLE_CODE VARCHAR2(240)
,SITE_CONTACT_ROLE_TYPE VARCHAR2(240)
,SITECONTACT_PHONE_COUNTRY_CODE VARCHAR2(240)
,SITE_CONTACT_PHONE_AREA_CODE VARCHAR2(240)
,SITE_CONTACT_PHONE_NUMBER VARCHAR2(240)
,SITE_CONTACT_PHONE_EXTENSION VARCHAR2(240)
,SITE_CONTACT_PHONE_LINE_TYPE VARCHAR2(240)
,CUSTOMER_PROFILE_CLASS VARCHAR2(240)
,PRIMARY_SALES_PERSON_NUMBER VARCHAR2(240)
,PAYMENT_TERM_ID VARCHAR2(25)
,PROFILE_CREDIT_CHECKING_FLAG VARCHAR2(240)
,PROFILE_INTEREST_CHARGES_FLAG VARCHAR2(240)
,PROFILE_OVERALL_CREDIT_LIMIT VARCHAR2(240)
,DUNS_NUMBER VARCHAR2(240)
,ACCOUNT_ROLE_TYPE VARCHAR2(240)
,CREDITPROFILE_ATTRIBCATEGORY VARCHAR2(30)
,CREDIT_PROFILE_ATTRIBUTE_1 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_2 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_3 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_4 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_5 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_6 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_7 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_8 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_9 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_10 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_11 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_12 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_13 VARCHAR2(150)
,CREDIT_PROFILE_ATTRIBUTE_14 VARCHAR2(150)
,PROFILEAMNTS_ATTRIBCATEGORY VARCHAR2(30)
,PROFILE_AMOUNTS_ATTRIBUTE_1 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_2 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_3 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_4 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_5 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_6 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_7 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_8 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_9 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_10 VARCHAR2(150)
,PROFILE_AMOUNTS_ATTRIBUTE_11 VARCHAR2(150)
,SITE_USE_ATTRIBUTESCATEGORY VARCHAR2(30)
,SITE_USE_ATTRIBUTE_1 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_2 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_3 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_4 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_5 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_6 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_7 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_8 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_9 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_10 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_11 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_12 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_13 VARCHAR2(150)
,SITE_USE_ATTRIBUTE_14 VARCHAR2(150)
,STANDARD_TERMS VARCHAR2(240)
,COLLECTOR_ID VARCHAR2(240)
,RISK_CODE VARCHAR2(240)
,CURRENCY_CODE VARCHAR2(15)
,CREDIT_CLASSIFICATION VARCHAR2(240)
,LOCATION NUMBER
,BILL_TO_SITE_USE_ID NUMBER
,EMAIL_ADDRESS VARCHAR2(240)
,DISCOUNT_GRACE_DAYS VARCHAR2(240)
,DELIVERY_METHOD_INVOICE VARCHAR2(240)
,E_MAIL_ID VARCHAR2(240)
,FAX_PHONE_COUNTRY VARCHAR2(240)
,FAX_PHONE_AREA VARCHAR2(240)
,FAX_PHONE_NUMBER VARCHAR2(240)
,FAX_PHONE_EXTENSION VARCHAR2(240)
,CONTACT_INFORMATION_CATEGORY VARCHAR2(240)
,CONTACTINFORMATION_ATTRIBUTE1 VARCHAR2(240)
,STATUS_FLAG VARCHAR2(2) DEFAULT 'N'
,ERROR_MSG VARCHAR2(4000)
);
CREATE OR REPLACE SYNONYM XXAVX_CUSTOMERS_STG
FOR xxcus.XXAVX_CUSTOMERS_STG ;