VIEW: AR.RA_CUSTOMERS_INTERFACE_ALL#

Source

View Text - Preformatted

select ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_CUSTOMER_REF, SITE_USE_CODE SITE_USE_CODE, ORIG_SYSTEM_ADDRESS_REF ORIG_SYSTEM_ADDRESS_REF, INTERFACE_STATUS INTERFACE_STATUS, REQUEST_ID REQUEST_ID, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG, VALIDATED_FLAG VALIDATED_FLAG, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, CUSTOMER_STATUS CUSTOMER_STATUS, CUSTOMER_TYPE CUSTOMER_TYPE, ORIG_SYSTEM_PARENT_REF ORIG_SYSTEM_PARENT_REF, PRIMARY_SITE_USE_FLAG PRIMARY_SITE_USE_FLAG, LOCATION LOCATION, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, CITY CITY, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, POSTAL_CODE POSTAL_CODE, COUNTRY COUNTRY, CUSTOMER_ATTRIBUTE_CATEGORY CUSTOMER_ATTRIBUTE_CATEGORY, CUSTOMER_ATTRIBUTE1 CUSTOMER_ATTRIBUTE1, CUSTOMER_ATTRIBUTE2 CUSTOMER_ATTRIBUTE2, CUSTOMER_ATTRIBUTE3 CUSTOMER_ATTRIBUTE3, CUSTOMER_ATTRIBUTE4 CUSTOMER_ATTRIBUTE4, CUSTOMER_ATTRIBUTE5 CUSTOMER_ATTRIBUTE5, CUSTOMER_ATTRIBUTE6 CUSTOMER_ATTRIBUTE6, CUSTOMER_ATTRIBUTE7 CUSTOMER_ATTRIBUTE7, CUSTOMER_ATTRIBUTE8 CUSTOMER_ATTRIBUTE8, CUSTOMER_ATTRIBUTE9 CUSTOMER_ATTRIBUTE9, ADDRESS_ATTRIBUTE_CATEGORY ADDRESS_ATTRIBUTE_CATEGORY, ADDRESS_ATTRIBUTE1 ADDRESS_ATTRIBUTE1, ADDRESS_ATTRIBUTE2 ADDRESS_ATTRIBUTE2, ADDRESS_ATTRIBUTE3 ADDRESS_ATTRIBUTE3, ADDRESS_ATTRIBUTE4 ADDRESS_ATTRIBUTE4, ADDRESS_ATTRIBUTE5 ADDRESS_ATTRIBUTE5, ADDRESS_ATTRIBUTE6 ADDRESS_ATTRIBUTE6, ADDRESS_ATTRIBUTE7 ADDRESS_ATTRIBUTE7, ADDRESS_ATTRIBUTE8 ADDRESS_ATTRIBUTE8, ADDRESS_ATTRIBUTE9 ADDRESS_ATTRIBUTE9, SITE_USE_ATTRIBUTE_CATEGORY SITE_USE_ATTRIBUTE_CATEGORY, SITE_USE_ATTRIBUTE1 SITE_USE_ATTRIBUTE1, SITE_USE_ATTRIBUTE2 SITE_USE_ATTRIBUTE2, SITE_USE_ATTRIBUTE3 SITE_USE_ATTRIBUTE3, SITE_USE_ATTRIBUTE4 SITE_USE_ATTRIBUTE4, SITE_USE_ATTRIBUTE5 SITE_USE_ATTRIBUTE5, SITE_USE_ATTRIBUTE6 SITE_USE_ATTRIBUTE6, SITE_USE_ATTRIBUTE7 SITE_USE_ATTRIBUTE7, SITE_USE_ATTRIBUTE8 SITE_USE_ATTRIBUTE8, SITE_USE_ATTRIBUTE9 SITE_USE_ATTRIBUTE9, ADDRESS_KEY ADDRESS_KEY, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE, CUSTOMER_KEY CUSTOMER_KEY, CUST_TAX_CODE CUST_TAX_CODE, CUST_TAX_EXEMPT_NUM CUST_TAX_EXEMPT_NUM, CUST_TAX_REFERENCE CUST_TAX_REFERENCE, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, LOCATION_CCID LOCATION_CCID, CUST_SHIP_VIA_CODE CUST_SHIP_VIA_CODE, SITE_USE_TAX_CODE SITE_USE_TAX_CODE, SITE_USE_TAX_EXEMPT_NUM SITE_USE_TAX_EXEMPT_NUM, SITE_USE_TAX_REFERENCE SITE_USE_TAX_REFERENCE, WARNING_TEXT WARNING_TEXT, CUSTOMER_ATTRIBUTE10 CUSTOMER_ATTRIBUTE10, CUSTOMER_ATTRIBUTE11 CUSTOMER_ATTRIBUTE11, CUSTOMER_ATTRIBUTE12 CUSTOMER_ATTRIBUTE12, CUSTOMER_ATTRIBUTE13 CUSTOMER_ATTRIBUTE13, CUSTOMER_ATTRIBUTE14 CUSTOMER_ATTRIBUTE14, CUSTOMER_ATTRIBUTE15 CUSTOMER_ATTRIBUTE15, ADDRESS_ATTRIBUTE10 ADDRESS_ATTRIBUTE10, ADDRESS_ATTRIBUTE11 ADDRESS_ATTRIBUTE11, ADDRESS_ATTRIBUTE12 ADDRESS_ATTRIBUTE12, ADDRESS_ATTRIBUTE13 ADDRESS_ATTRIBUTE13, ADDRESS_ATTRIBUTE14 ADDRESS_ATTRIBUTE14, ADDRESS_ATTRIBUTE15 ADDRESS_ATTRIBUTE15, SITE_USE_ATTRIBUTE10 SITE_USE_ATTRIBUTE10, SITE_USE_ATTRIBUTE11 SITE_USE_ATTRIBUTE11, SITE_USE_ATTRIBUTE12 SITE_USE_ATTRIBUTE12, SITE_USE_ATTRIBUTE13 SITE_USE_ATTRIBUTE13, SITE_USE_ATTRIBUTE14 SITE_USE_ATTRIBUTE14, SITE_USE_ATTRIBUTE15 SITE_USE_ATTRIBUTE15, SITE_USE_ATTRIBUTE16 SITE_USE_ATTRIBUTE16, SITE_USE_ATTRIBUTE17 SITE_USE_ATTRIBUTE17, SITE_USE_ATTRIBUTE18 SITE_USE_ATTRIBUTE18, SITE_USE_ATTRIBUTE19 SITE_USE_ATTRIBUTE19, SITE_USE_ATTRIBUTE20 SITE_USE_ATTRIBUTE20, SITE_USE_ATTRIBUTE21 SITE_USE_ATTRIBUTE21, SITE_USE_ATTRIBUTE22 SITE_USE_ATTRIBUTE22, SITE_USE_ATTRIBUTE23 SITE_USE_ATTRIBUTE23, SITE_USE_ATTRIBUTE24 SITE_USE_ATTRIBUTE24, SITE_USE_ATTRIBUTE25 SITE_USE_ATTRIBUTE25, SITE_SHIP_VIA_CODE SITE_SHIP_VIA_CODE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MESSAGE_TEXT MESSAGE_TEXT, BILL_TO_ORIG_ADDRESS_REF BILL_TO_ORIG_ADDRESS_REF, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE, LANGUAGE LANGUAGE, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, URL URL, ORG_ID ORG_ID, CUSTOMER_PROSPECT_CODE CUSTOMER_PROSPECT_CODE, CUSTOMER_NAME_PHONETIC CUSTOMER_NAME_PHONETIC, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC, TRANSLATED_CUSTOMER_NAME TRANSLATED_CUSTOMER_NAME, TERRITORY TERRITORY, GL_ID_REC GL_ID_REC, GL_ID_REV GL_ID_REV, GL_ID_TAX GL_ID_TAX, GL_ID_FREIGHT GL_ID_FREIGHT, GL_ID_CLEARING GL_ID_CLEARING, GL_ID_UNBILLED GL_ID_UNBILLED, GL_ID_UNEARNED GL_ID_UNEARNED, PERSON_FLAG PERSON_FLAG, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, GDF_ADDRESS_ATTR_CAT GDF_ADDRESS_ATTR_CAT, GDF_ADDRESS_ATTRIBUTE1 GDF_ADDRESS_ATTRIBUTE1, GDF_ADDRESS_ATTRIBUTE2 GDF_ADDRESS_ATTRIBUTE2, GDF_ADDRESS_ATTRIBUTE3 GDF_ADDRESS_ATTRIBUTE3, GDF_ADDRESS_ATTRIBUTE4 GDF_ADDRESS_ATTRIBUTE4, GDF_ADDRESS_ATTRIBUTE5 GDF_ADDRESS_ATTRIBUTE5, GDF_ADDRESS_ATTRIBUTE6 GDF_ADDRESS_ATTRIBUTE6, GDF_ADDRESS_ATTRIBUTE7 GDF_ADDRESS_ATTRIBUTE7, GDF_ADDRESS_ATTRIBUTE8 GDF_ADDRESS_ATTRIBUTE8, GDF_ADDRESS_ATTRIBUTE9 GDF_ADDRESS_ATTRIBUTE9, GDF_ADDRESS_ATTRIBUTE10 GDF_ADDRESS_ATTRIBUTE10, GDF_ADDRESS_ATTRIBUTE11 GDF_ADDRESS_ATTRIBUTE11, GDF_ADDRESS_ATTRIBUTE12 GDF_ADDRESS_ATTRIBUTE12, GDF_ADDRESS_ATTRIBUTE13 GDF_ADDRESS_ATTRIBUTE13, GDF_ADDRESS_ATTRIBUTE14 GDF_ADDRESS_ATTRIBUTE14, GDF_ADDRESS_ATTRIBUTE15 GDF_ADDRESS_ATTRIBUTE15, GDF_ADDRESS_ATTRIBUTE16 GDF_ADDRESS_ATTRIBUTE16, GDF_ADDRESS_ATTRIBUTE17 GDF_ADDRESS_ATTRIBUTE17, GDF_ADDRESS_ATTRIBUTE18 GDF_ADDRESS_ATTRIBUTE18, GDF_ADDRESS_ATTRIBUTE19 GDF_ADDRESS_ATTRIBUTE19, GDF_ADDRESS_ATTRIBUTE20 GDF_ADDRESS_ATTRIBUTE20, GDF_SITE_USE_ATTR_CAT GDF_SITE_USE_ATTR_CAT, GDF_SITE_USE_ATTRIBUTE1 GDF_SITE_USE_ATTRIBUTE1, GDF_SITE_USE_ATTRIBUTE2 GDF_SITE_USE_ATTRIBUTE2, GDF_SITE_USE_ATTRIBUTE3 GDF_SITE_USE_ATTRIBUTE3, GDF_SITE_USE_ATTRIBUTE4 GDF_SITE_USE_ATTRIBUTE4, GDF_SITE_USE_ATTRIBUTE5 GDF_SITE_USE_ATTRIBUTE5, GDF_SITE_USE_ATTRIBUTE6 GDF_SITE_USE_ATTRIBUTE6, GDF_SITE_USE_ATTRIBUTE7 GDF_SITE_USE_ATTRIBUTE7, GDF_SITE_USE_ATTRIBUTE8 GDF_SITE_USE_ATTRIBUTE8, GDF_SITE_USE_ATTRIBUTE9 GDF_SITE_USE_ATTRIBUTE9, GDF_SITE_USE_ATTRIBUTE10 GDF_SITE_USE_ATTRIBUTE10, GDF_SITE_USE_ATTRIBUTE11 GDF_SITE_USE_ATTRIBUTE11, GDF_SITE_USE_ATTRIBUTE12 GDF_SITE_USE_ATTRIBUTE12, GDF_SITE_USE_ATTRIBUTE13 GDF_SITE_USE_ATTRIBUTE13, GDF_SITE_USE_ATTRIBUTE14 GDF_SITE_USE_ATTRIBUTE14, GDF_SITE_USE_ATTRIBUTE15 GDF_SITE_USE_ATTRIBUTE15, GDF_SITE_USE_ATTRIBUTE16 GDF_SITE_USE_ATTRIBUTE16, GDF_SITE_USE_ATTRIBUTE17 GDF_SITE_USE_ATTRIBUTE17, GDF_SITE_USE_ATTRIBUTE18 GDF_SITE_USE_ATTRIBUTE18, GDF_SITE_USE_ATTRIBUTE19 GDF_SITE_USE_ATTRIBUTE19, GDF_SITE_USE_ATTRIBUTE20 GDF_SITE_USE_ATTRIBUTE20, GL_ID_UNPAID_REC GL_ID_UNPAID_REC, GL_ID_REMITTANCE GL_ID_REMITTANCE, GL_ID_FACTOR GL_ID_FACTOR, ORIG_SYSTEM_PARTY_REF ORIG_SYSTEM_PARTY_REF, PARTY_NUMBER PARTY_NUMBER, PARTY_SITE_NUMBER PARTY_SITE_NUMBER, ADDRESS_CATEGORY_CODE ADDRESS_CATEGORY_CODE, ADDRESS_ATTRIBUTE16 ADDRESS_ATTRIBUTE16, ADDRESS_ATTRIBUTE17 ADDRESS_ATTRIBUTE17, ADDRESS_ATTRIBUTE18 ADDRESS_ATTRIBUTE18, ADDRESS_ATTRIBUTE19 ADDRESS_ATTRIBUTE19, ADDRESS_ATTRIBUTE20 ADDRESS_ATTRIBUTE20, CUSTOMER_ATTRIBUTE16 CUSTOMER_ATTRIBUTE16, CUSTOMER_ATTRIBUTE17 CUSTOMER_ATTRIBUTE17, CUSTOMER_ATTRIBUTE18 CUSTOMER_ATTRIBUTE18, CUSTOMER_ATTRIBUTE19 CUSTOMER_ATTRIBUTE19, CUSTOMER_ATTRIBUTE20 CUSTOMER_ATTRIBUTE20, CUST_TAX_HEADER_LEVEL_FLAG CUST_TAX_HEADER_LEVEL_FLAG, CUST_TAX_ROUNDING_CODE CUST_TAX_ROUNDING_CODE, SITE_USE_TAX_HEADER_LEVEL_FLAG SITE_USE_TAX_HEADER_LEVEL_FLAG, SITE_USE_TAX_ROUNDING_CODE SITE_USE_TAX_ROUNDING_CODE, SITE_USE_TAX_CLASSIFICATION SITE_USE_TAX_CLASSIFICATION, FISCAL_CLASS_CATEGORY FISCAL_CLASS_CATEGORY, FISCAL_CLASS_CODE FISCAL_CLASS_CODE, CUST_FEDERAL_ENTITY_TYPE CUST_FEDERAL_ENTITY_TYPE, CUST_TRADING_PARTNER_AGENCY_ID CUST_TRADING_PARTNER_AGENCY_ID, CUST_DUNS_EXTENSION CUST_DUNS_EXTENSION, CUST_ADVANCE_PAYMENT_INDICATOR CUST_ADVANCE_PAYMENT_INDICATOR from "AR"."RA_CUSTOMERS_INTERFACE_ALL"

View Text - HTML Formatted

SELECT ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_CUSTOMER_REF
, SITE_USE_CODE SITE_USE_CODE
, ORIG_SYSTEM_ADDRESS_REF ORIG_SYSTEM_ADDRESS_REF
, INTERFACE_STATUS INTERFACE_STATUS
, REQUEST_ID REQUEST_ID
, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG
, VALIDATED_FLAG VALIDATED_FLAG
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, CUSTOMER_STATUS CUSTOMER_STATUS
, CUSTOMER_TYPE CUSTOMER_TYPE
, ORIG_SYSTEM_PARENT_REF ORIG_SYSTEM_PARENT_REF
, PRIMARY_SITE_USE_FLAG PRIMARY_SITE_USE_FLAG
, LOCATION LOCATION
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, CITY CITY
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, POSTAL_CODE POSTAL_CODE
, COUNTRY COUNTRY
, CUSTOMER_ATTRIBUTE_CATEGORY CUSTOMER_ATTRIBUTE_CATEGORY
, CUSTOMER_ATTRIBUTE1 CUSTOMER_ATTRIBUTE1
, CUSTOMER_ATTRIBUTE2 CUSTOMER_ATTRIBUTE2
, CUSTOMER_ATTRIBUTE3 CUSTOMER_ATTRIBUTE3
, CUSTOMER_ATTRIBUTE4 CUSTOMER_ATTRIBUTE4
, CUSTOMER_ATTRIBUTE5 CUSTOMER_ATTRIBUTE5
, CUSTOMER_ATTRIBUTE6 CUSTOMER_ATTRIBUTE6
, CUSTOMER_ATTRIBUTE7 CUSTOMER_ATTRIBUTE7
, CUSTOMER_ATTRIBUTE8 CUSTOMER_ATTRIBUTE8
, CUSTOMER_ATTRIBUTE9 CUSTOMER_ATTRIBUTE9
, ADDRESS_ATTRIBUTE_CATEGORY ADDRESS_ATTRIBUTE_CATEGORY
, ADDRESS_ATTRIBUTE1 ADDRESS_ATTRIBUTE1
, ADDRESS_ATTRIBUTE2 ADDRESS_ATTRIBUTE2
, ADDRESS_ATTRIBUTE3 ADDRESS_ATTRIBUTE3
, ADDRESS_ATTRIBUTE4 ADDRESS_ATTRIBUTE4
, ADDRESS_ATTRIBUTE5 ADDRESS_ATTRIBUTE5
, ADDRESS_ATTRIBUTE6 ADDRESS_ATTRIBUTE6
, ADDRESS_ATTRIBUTE7 ADDRESS_ATTRIBUTE7
, ADDRESS_ATTRIBUTE8 ADDRESS_ATTRIBUTE8
, ADDRESS_ATTRIBUTE9 ADDRESS_ATTRIBUTE9
, SITE_USE_ATTRIBUTE_CATEGORY SITE_USE_ATTRIBUTE_CATEGORY
, SITE_USE_ATTRIBUTE1 SITE_USE_ATTRIBUTE1
, SITE_USE_ATTRIBUTE2 SITE_USE_ATTRIBUTE2
, SITE_USE_ATTRIBUTE3 SITE_USE_ATTRIBUTE3
, SITE_USE_ATTRIBUTE4 SITE_USE_ATTRIBUTE4
, SITE_USE_ATTRIBUTE5 SITE_USE_ATTRIBUTE5
, SITE_USE_ATTRIBUTE6 SITE_USE_ATTRIBUTE6
, SITE_USE_ATTRIBUTE7 SITE_USE_ATTRIBUTE7
, SITE_USE_ATTRIBUTE8 SITE_USE_ATTRIBUTE8
, SITE_USE_ATTRIBUTE9 SITE_USE_ATTRIBUTE9
, ADDRESS_KEY ADDRESS_KEY
, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE
, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, CUSTOMER_KEY CUSTOMER_KEY
, CUST_TAX_CODE CUST_TAX_CODE
, CUST_TAX_EXEMPT_NUM CUST_TAX_EXEMPT_NUM
, CUST_TAX_REFERENCE CUST_TAX_REFERENCE
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, LOCATION_CCID LOCATION_CCID
, CUST_SHIP_VIA_CODE CUST_SHIP_VIA_CODE
, SITE_USE_TAX_CODE SITE_USE_TAX_CODE
, SITE_USE_TAX_EXEMPT_NUM SITE_USE_TAX_EXEMPT_NUM
, SITE_USE_TAX_REFERENCE SITE_USE_TAX_REFERENCE
, WARNING_TEXT WARNING_TEXT
, CUSTOMER_ATTRIBUTE10 CUSTOMER_ATTRIBUTE10
, CUSTOMER_ATTRIBUTE11 CUSTOMER_ATTRIBUTE11
, CUSTOMER_ATTRIBUTE12 CUSTOMER_ATTRIBUTE12
, CUSTOMER_ATTRIBUTE13 CUSTOMER_ATTRIBUTE13
, CUSTOMER_ATTRIBUTE14 CUSTOMER_ATTRIBUTE14
, CUSTOMER_ATTRIBUTE15 CUSTOMER_ATTRIBUTE15
, ADDRESS_ATTRIBUTE10 ADDRESS_ATTRIBUTE10
, ADDRESS_ATTRIBUTE11 ADDRESS_ATTRIBUTE11
, ADDRESS_ATTRIBUTE12 ADDRESS_ATTRIBUTE12
, ADDRESS_ATTRIBUTE13 ADDRESS_ATTRIBUTE13
, ADDRESS_ATTRIBUTE14 ADDRESS_ATTRIBUTE14
, ADDRESS_ATTRIBUTE15 ADDRESS_ATTRIBUTE15
, SITE_USE_ATTRIBUTE10 SITE_USE_ATTRIBUTE10
, SITE_USE_ATTRIBUTE11 SITE_USE_ATTRIBUTE11
, SITE_USE_ATTRIBUTE12 SITE_USE_ATTRIBUTE12
, SITE_USE_ATTRIBUTE13 SITE_USE_ATTRIBUTE13
, SITE_USE_ATTRIBUTE14 SITE_USE_ATTRIBUTE14
, SITE_USE_ATTRIBUTE15 SITE_USE_ATTRIBUTE15
, SITE_USE_ATTRIBUTE16 SITE_USE_ATTRIBUTE16
, SITE_USE_ATTRIBUTE17 SITE_USE_ATTRIBUTE17
, SITE_USE_ATTRIBUTE18 SITE_USE_ATTRIBUTE18
, SITE_USE_ATTRIBUTE19 SITE_USE_ATTRIBUTE19
, SITE_USE_ATTRIBUTE20 SITE_USE_ATTRIBUTE20
, SITE_USE_ATTRIBUTE21 SITE_USE_ATTRIBUTE21
, SITE_USE_ATTRIBUTE22 SITE_USE_ATTRIBUTE22
, SITE_USE_ATTRIBUTE23 SITE_USE_ATTRIBUTE23
, SITE_USE_ATTRIBUTE24 SITE_USE_ATTRIBUTE24
, SITE_USE_ATTRIBUTE25 SITE_USE_ATTRIBUTE25
, SITE_SHIP_VIA_CODE SITE_SHIP_VIA_CODE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MESSAGE_TEXT MESSAGE_TEXT
, BILL_TO_ORIG_ADDRESS_REF BILL_TO_ORIG_ADDRESS_REF
, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
, LANGUAGE LANGUAGE
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, URL URL
, ORG_ID ORG_ID
, CUSTOMER_PROSPECT_CODE CUSTOMER_PROSPECT_CODE
, CUSTOMER_NAME_PHONETIC CUSTOMER_NAME_PHONETIC
, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC
, TRANSLATED_CUSTOMER_NAME TRANSLATED_CUSTOMER_NAME
, TERRITORY TERRITORY
, GL_ID_REC GL_ID_REC
, GL_ID_REV GL_ID_REV
, GL_ID_TAX GL_ID_TAX
, GL_ID_FREIGHT GL_ID_FREIGHT
, GL_ID_CLEARING GL_ID_CLEARING
, GL_ID_UNBILLED GL_ID_UNBILLED
, GL_ID_UNEARNED GL_ID_UNEARNED
, PERSON_FLAG PERSON_FLAG
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, GDF_ADDRESS_ATTR_CAT GDF_ADDRESS_ATTR_CAT
, GDF_ADDRESS_ATTRIBUTE1 GDF_ADDRESS_ATTRIBUTE1
, GDF_ADDRESS_ATTRIBUTE2 GDF_ADDRESS_ATTRIBUTE2
, GDF_ADDRESS_ATTRIBUTE3 GDF_ADDRESS_ATTRIBUTE3
, GDF_ADDRESS_ATTRIBUTE4 GDF_ADDRESS_ATTRIBUTE4
, GDF_ADDRESS_ATTRIBUTE5 GDF_ADDRESS_ATTRIBUTE5
, GDF_ADDRESS_ATTRIBUTE6 GDF_ADDRESS_ATTRIBUTE6
, GDF_ADDRESS_ATTRIBUTE7 GDF_ADDRESS_ATTRIBUTE7
, GDF_ADDRESS_ATTRIBUTE8 GDF_ADDRESS_ATTRIBUTE8
, GDF_ADDRESS_ATTRIBUTE9 GDF_ADDRESS_ATTRIBUTE9
, GDF_ADDRESS_ATTRIBUTE10 GDF_ADDRESS_ATTRIBUTE10
, GDF_ADDRESS_ATTRIBUTE11 GDF_ADDRESS_ATTRIBUTE11
, GDF_ADDRESS_ATTRIBUTE12 GDF_ADDRESS_ATTRIBUTE12
, GDF_ADDRESS_ATTRIBUTE13 GDF_ADDRESS_ATTRIBUTE13
, GDF_ADDRESS_ATTRIBUTE14 GDF_ADDRESS_ATTRIBUTE14
, GDF_ADDRESS_ATTRIBUTE15 GDF_ADDRESS_ATTRIBUTE15
, GDF_ADDRESS_ATTRIBUTE16 GDF_ADDRESS_ATTRIBUTE16
, GDF_ADDRESS_ATTRIBUTE17 GDF_ADDRESS_ATTRIBUTE17
, GDF_ADDRESS_ATTRIBUTE18 GDF_ADDRESS_ATTRIBUTE18
, GDF_ADDRESS_ATTRIBUTE19 GDF_ADDRESS_ATTRIBUTE19
, GDF_ADDRESS_ATTRIBUTE20 GDF_ADDRESS_ATTRIBUTE20
, GDF_SITE_USE_ATTR_CAT GDF_SITE_USE_ATTR_CAT
, GDF_SITE_USE_ATTRIBUTE1 GDF_SITE_USE_ATTRIBUTE1
, GDF_SITE_USE_ATTRIBUTE2 GDF_SITE_USE_ATTRIBUTE2
, GDF_SITE_USE_ATTRIBUTE3 GDF_SITE_USE_ATTRIBUTE3
, GDF_SITE_USE_ATTRIBUTE4 GDF_SITE_USE_ATTRIBUTE4
, GDF_SITE_USE_ATTRIBUTE5 GDF_SITE_USE_ATTRIBUTE5
, GDF_SITE_USE_ATTRIBUTE6 GDF_SITE_USE_ATTRIBUTE6
, GDF_SITE_USE_ATTRIBUTE7 GDF_SITE_USE_ATTRIBUTE7
, GDF_SITE_USE_ATTRIBUTE8 GDF_SITE_USE_ATTRIBUTE8
, GDF_SITE_USE_ATTRIBUTE9 GDF_SITE_USE_ATTRIBUTE9
, GDF_SITE_USE_ATTRIBUTE10 GDF_SITE_USE_ATTRIBUTE10
, GDF_SITE_USE_ATTRIBUTE11 GDF_SITE_USE_ATTRIBUTE11
, GDF_SITE_USE_ATTRIBUTE12 GDF_SITE_USE_ATTRIBUTE12
, GDF_SITE_USE_ATTRIBUTE13 GDF_SITE_USE_ATTRIBUTE13
, GDF_SITE_USE_ATTRIBUTE14 GDF_SITE_USE_ATTRIBUTE14
, GDF_SITE_USE_ATTRIBUTE15 GDF_SITE_USE_ATTRIBUTE15
, GDF_SITE_USE_ATTRIBUTE16 GDF_SITE_USE_ATTRIBUTE16
, GDF_SITE_USE_ATTRIBUTE17 GDF_SITE_USE_ATTRIBUTE17
, GDF_SITE_USE_ATTRIBUTE18 GDF_SITE_USE_ATTRIBUTE18
, GDF_SITE_USE_ATTRIBUTE19 GDF_SITE_USE_ATTRIBUTE19
, GDF_SITE_USE_ATTRIBUTE20 GDF_SITE_USE_ATTRIBUTE20
, GL_ID_UNPAID_REC GL_ID_UNPAID_REC
, GL_ID_REMITTANCE GL_ID_REMITTANCE
, GL_ID_FACTOR GL_ID_FACTOR
, ORIG_SYSTEM_PARTY_REF ORIG_SYSTEM_PARTY_REF
, PARTY_NUMBER PARTY_NUMBER
, PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, ADDRESS_CATEGORY_CODE ADDRESS_CATEGORY_CODE
, ADDRESS_ATTRIBUTE16 ADDRESS_ATTRIBUTE16
, ADDRESS_ATTRIBUTE17 ADDRESS_ATTRIBUTE17
, ADDRESS_ATTRIBUTE18 ADDRESS_ATTRIBUTE18
, ADDRESS_ATTRIBUTE19 ADDRESS_ATTRIBUTE19
, ADDRESS_ATTRIBUTE20 ADDRESS_ATTRIBUTE20
, CUSTOMER_ATTRIBUTE16 CUSTOMER_ATTRIBUTE16
, CUSTOMER_ATTRIBUTE17 CUSTOMER_ATTRIBUTE17
, CUSTOMER_ATTRIBUTE18 CUSTOMER_ATTRIBUTE18
, CUSTOMER_ATTRIBUTE19 CUSTOMER_ATTRIBUTE19
, CUSTOMER_ATTRIBUTE20 CUSTOMER_ATTRIBUTE20
, CUST_TAX_HEADER_LEVEL_FLAG CUST_TAX_HEADER_LEVEL_FLAG
, CUST_TAX_ROUNDING_CODE CUST_TAX_ROUNDING_CODE
, SITE_USE_TAX_HEADER_LEVEL_FLAG SITE_USE_TAX_HEADER_LEVEL_FLAG
, SITE_USE_TAX_ROUNDING_CODE SITE_USE_TAX_ROUNDING_CODE
, SITE_USE_TAX_CLASSIFICATION SITE_USE_TAX_CLASSIFICATION
, FISCAL_CLASS_CATEGORY FISCAL_CLASS_CATEGORY
, FISCAL_CLASS_CODE FISCAL_CLASS_CODE
, CUST_FEDERAL_ENTITY_TYPE CUST_FEDERAL_ENTITY_TYPE
, CUST_TRADING_PARTNER_AGENCY_ID CUST_TRADING_PARTNER_AGENCY_ID
, CUST_DUNS_EXTENSION CUST_DUNS_EXTENSION
, CUST_ADVANCE_PAYMENT_INDICATOR CUST_ADVANCE_PAYMENT_INDICATOR
FROM "AR"."RA_CUSTOMERS_INTERFACE_ALL"