[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RA_CUSTOMERS_INTERFACE_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | AR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORIG_SYSTEM_CUSTOMER_REF | VARCHAR2 | (240) | Yes | |
| SITE_USE_CODE | VARCHAR2 | (30) | ||
| ORIG_SYSTEM_ADDRESS_REF | VARCHAR2 | (240) | ||
| INTERFACE_STATUS | VARCHAR2 | (240) | ||
| REQUEST_ID | NUMBER | (15) | ||
| INSERT_UPDATE_FLAG | VARCHAR2 | (1) | Yes | |
| VALIDATED_FLAG | VARCHAR2 | (1) | ||
| CUSTOMER_NAME | VARCHAR2 | (360) | Yes | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
| CUSTOMER_STATUS | VARCHAR2 | (1) | ||
| CUSTOMER_TYPE | VARCHAR2 | (25) | ||
| ORIG_SYSTEM_PARENT_REF | VARCHAR2 | (240) | ||
| PRIMARY_SITE_USE_FLAG | VARCHAR2 | (1) | ||
| LOCATION | VARCHAR2 | (40) | ||
| ADDRESS1 | VARCHAR2 | (240) | ||
| ADDRESS2 | VARCHAR2 | (240) | ||
| ADDRESS3 | VARCHAR2 | (240) | ||
| ADDRESS4 | VARCHAR2 | (240) | ||
| CITY | VARCHAR2 | (60) | ||
| STATE | VARCHAR2 | (60) | ||
| PROVINCE | VARCHAR2 | (60) | ||
| COUNTY | VARCHAR2 | (60) | ||
| POSTAL_CODE | VARCHAR2 | (60) | ||
| COUNTRY | VARCHAR2 | (60) | ||
| CUSTOMER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| CUSTOMER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ADDRESS_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| SITE_USE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ADDRESS_KEY | VARCHAR2 | (50) | ||
| CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | ||
| CUSTOMER_CLASS_CODE | VARCHAR2 | (30) | ||
| CUSTOMER_KEY | VARCHAR2 | (50) | ||
| CUST_TAX_CODE | VARCHAR2 | (50) | ||
| CUST_TAX_EXEMPT_NUM | VARCHAR2 | (30) | ||
| CUST_TAX_REFERENCE | VARCHAR2 | (50) | ||
| DEMAND_CLASS_CODE | VARCHAR2 | (30) | ||
| LOCATION_CCID | NUMBER | (15) | ||
| CUST_SHIP_VIA_CODE | VARCHAR2 | (30) | ||
| SITE_USE_TAX_CODE | VARCHAR2 | (50) | ||
| SITE_USE_TAX_EXEMPT_NUM | VARCHAR2 | (30) | ||
| SITE_USE_TAX_REFERENCE | VARCHAR2 | (50) | ||
| WARNING_TEXT | VARCHAR2 | (240) | ||
| CUSTOMER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE21 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE22 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE23 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE24 | VARCHAR2 | (150) | ||
| SITE_USE_ATTRIBUTE25 | VARCHAR2 | (150) | ||
| SITE_SHIP_VIA_CODE | VARCHAR2 | (30) | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| MESSAGE_TEXT | VARCHAR2 | (240) | ||
| BILL_TO_ORIG_ADDRESS_REF | VARCHAR2 | (240) | ||
| JGZZ_FISCAL_CODE | VARCHAR2 | (20) | ||
| LANGUAGE | VARCHAR2 | (30) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| URL | VARCHAR2 | (240) | ||
| ORG_ID | NUMBER | (15) | ||
| CUSTOMER_PROSPECT_CODE | VARCHAR2 | (30) | ||
| CUSTOMER_NAME_PHONETIC | VARCHAR2 | (320) | ||
| ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | ||
| TRANSLATED_CUSTOMER_NAME | VARCHAR2 | (50) | ||
| TERRITORY | VARCHAR2 | (30) | ||
| GL_ID_REC | NUMBER | (15) | ||
| GL_ID_REV | NUMBER | (15) | ||
| GL_ID_TAX | NUMBER | (15) | ||
| GL_ID_FREIGHT | NUMBER | (15) | ||
| GL_ID_CLEARING | NUMBER | (15) | ||
| GL_ID_UNBILLED | NUMBER | (15) | ||
| GL_ID_UNEARNED | NUMBER | (15) | ||
| PERSON_FLAG | VARCHAR2 | (1) | ||
| PERSON_FIRST_NAME | VARCHAR2 | (150) | ||
| PERSON_LAST_NAME | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTR_CAT | VARCHAR2 | (30) | ||
| GDF_ADDRESS_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| GDF_ADDRESS_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTR_CAT | VARCHAR2 | (30) | ||
| GDF_SITE_USE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| GDF_SITE_USE_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| GL_ID_UNPAID_REC | NUMBER | (15) | ||
| GL_ID_REMITTANCE | NUMBER | (15) | ||
| GL_ID_FACTOR | NUMBER | (15) | ||
| ORIG_SYSTEM_PARTY_REF | VARCHAR2 | (240) | ||
| PARTY_NUMBER | VARCHAR2 | (30) | ||
| PARTY_SITE_NUMBER | VARCHAR2 | (30) | ||
| ADDRESS_CATEGORY_CODE | VARCHAR2 | (30) | ||
| ADDRESS_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ADDRESS_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| CUSTOMER_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| CUST_TAX_HEADER_LEVEL_FLAG | VARCHAR2 | (1) | ||
| CUST_TAX_ROUNDING_CODE | VARCHAR2 | (30) | ||
| SITE_USE_TAX_HEADER_LEVEL_FLAG | VARCHAR2 | (1) | ||
| SITE_USE_TAX_ROUNDING_CODE | VARCHAR2 | (30) | ||
| SITE_USE_TAX_CLASSIFICATION | VARCHAR2 | (30) | ||
| FISCAL_CLASS_CATEGORY | VARCHAR2 | (30) | ||
| FISCAL_CLASS_CODE | VARCHAR2 | (30) | ||
| CUST_FEDERAL_ENTITY_TYPE | VARCHAR2 | (30) | ||
| CUST_TRADING_PARTNER_AGENCY_ID | VARCHAR2 | (3) | ||
| CUST_DUNS_EXTENSION | VARCHAR2 | (4) | ||
| CUST_ADVANCE_PAYMENT_INDICATOR | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ORIG_SYSTEM_CUSTOMER_REF
, SITE_USE_CODE
, ORIG_SYSTEM_ADDRESS_REF
, INTERFACE_STATUS
, REQUEST_ID
, INSERT_UPDATE_FLAG
, VALIDATED_FLAG
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_STATUS
, CUSTOMER_TYPE
, ORIG_SYSTEM_PARENT_REF
, PRIMARY_SITE_USE_FLAG
, LOCATION
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, STATE
, PROVINCE
, COUNTY
, POSTAL_CODE
, COUNTRY
, CUSTOMER_ATTRIBUTE_CATEGORY
, CUSTOMER_ATTRIBUTE1
, CUSTOMER_ATTRIBUTE2
, CUSTOMER_ATTRIBUTE3
, CUSTOMER_ATTRIBUTE4
, CUSTOMER_ATTRIBUTE5
, CUSTOMER_ATTRIBUTE6
, CUSTOMER_ATTRIBUTE7
, CUSTOMER_ATTRIBUTE8
, CUSTOMER_ATTRIBUTE9
, ADDRESS_ATTRIBUTE_CATEGORY
, ADDRESS_ATTRIBUTE1
, ADDRESS_ATTRIBUTE2
, ADDRESS_ATTRIBUTE3
, ADDRESS_ATTRIBUTE4
, ADDRESS_ATTRIBUTE5
, ADDRESS_ATTRIBUTE6
, ADDRESS_ATTRIBUTE7
, ADDRESS_ATTRIBUTE8
, ADDRESS_ATTRIBUTE9
, SITE_USE_ATTRIBUTE_CATEGORY
, SITE_USE_ATTRIBUTE1
, SITE_USE_ATTRIBUTE2
, SITE_USE_ATTRIBUTE3
, SITE_USE_ATTRIBUTE4
, SITE_USE_ATTRIBUTE5
, SITE_USE_ATTRIBUTE6
, SITE_USE_ATTRIBUTE7
, SITE_USE_ATTRIBUTE8
, SITE_USE_ATTRIBUTE9
, ADDRESS_KEY
, CUSTOMER_CATEGORY_CODE
, CUSTOMER_CLASS_CODE
, CUSTOMER_KEY
, CUST_TAX_CODE
, CUST_TAX_EXEMPT_NUM
, CUST_TAX_REFERENCE
, DEMAND_CLASS_CODE
, LOCATION_CCID
, CUST_SHIP_VIA_CODE
, SITE_USE_TAX_CODE
, SITE_USE_TAX_EXEMPT_NUM
, SITE_USE_TAX_REFERENCE
, WARNING_TEXT
, CUSTOMER_ATTRIBUTE10
, CUSTOMER_ATTRIBUTE11
, CUSTOMER_ATTRIBUTE12
, CUSTOMER_ATTRIBUTE13
, CUSTOMER_ATTRIBUTE14
, CUSTOMER_ATTRIBUTE15
, ADDRESS_ATTRIBUTE10
, ADDRESS_ATTRIBUTE11
, ADDRESS_ATTRIBUTE12
, ADDRESS_ATTRIBUTE13
, ADDRESS_ATTRIBUTE14
, ADDRESS_ATTRIBUTE15
, SITE_USE_ATTRIBUTE10
, SITE_USE_ATTRIBUTE11
, SITE_USE_ATTRIBUTE12
, SITE_USE_ATTRIBUTE13
, SITE_USE_ATTRIBUTE14
, SITE_USE_ATTRIBUTE15
, SITE_USE_ATTRIBUTE16
, SITE_USE_ATTRIBUTE17
, SITE_USE_ATTRIBUTE18
, SITE_USE_ATTRIBUTE19
, SITE_USE_ATTRIBUTE20
, SITE_USE_ATTRIBUTE21
, SITE_USE_ATTRIBUTE22
, SITE_USE_ATTRIBUTE23
, SITE_USE_ATTRIBUTE24
, SITE_USE_ATTRIBUTE25
, SITE_SHIP_VIA_CODE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, MESSAGE_TEXT
, BILL_TO_ORIG_ADDRESS_REF
, JGZZ_FISCAL_CODE
, LANGUAGE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, URL
, ORG_ID
, CUSTOMER_PROSPECT_CODE
, CUSTOMER_NAME_PHONETIC
, ADDRESS_LINES_PHONETIC
, TRANSLATED_CUSTOMER_NAME
, TERRITORY
, GL_ID_REC
, GL_ID_REV
, GL_ID_TAX
, GL_ID_FREIGHT
, GL_ID_CLEARING
, GL_ID_UNBILLED
, GL_ID_UNEARNED
, PERSON_FLAG
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, GDF_ADDRESS_ATTR_CAT
, GDF_ADDRESS_ATTRIBUTE1
, GDF_ADDRESS_ATTRIBUTE2
, GDF_ADDRESS_ATTRIBUTE3
, GDF_ADDRESS_ATTRIBUTE4
, GDF_ADDRESS_ATTRIBUTE5
, GDF_ADDRESS_ATTRIBUTE6
, GDF_ADDRESS_ATTRIBUTE7
, GDF_ADDRESS_ATTRIBUTE8
, GDF_ADDRESS_ATTRIBUTE9
, GDF_ADDRESS_ATTRIBUTE10
, GDF_ADDRESS_ATTRIBUTE11
, GDF_ADDRESS_ATTRIBUTE12
, GDF_ADDRESS_ATTRIBUTE13
, GDF_ADDRESS_ATTRIBUTE14
, GDF_ADDRESS_ATTRIBUTE15
, GDF_ADDRESS_ATTRIBUTE16
, GDF_ADDRESS_ATTRIBUTE17
, GDF_ADDRESS_ATTRIBUTE18
, GDF_ADDRESS_ATTRIBUTE19
, GDF_ADDRESS_ATTRIBUTE20
, GDF_SITE_USE_ATTR_CAT
, GDF_SITE_USE_ATTRIBUTE1
, GDF_SITE_USE_ATTRIBUTE2
, GDF_SITE_USE_ATTRIBUTE3
, GDF_SITE_USE_ATTRIBUTE4
, GDF_SITE_USE_ATTRIBUTE5
, GDF_SITE_USE_ATTRIBUTE6
, GDF_SITE_USE_ATTRIBUTE7
, GDF_SITE_USE_ATTRIBUTE8
, GDF_SITE_USE_ATTRIBUTE9
, GDF_SITE_USE_ATTRIBUTE10
, GDF_SITE_USE_ATTRIBUTE11
, GDF_SITE_USE_ATTRIBUTE12
, GDF_SITE_USE_ATTRIBUTE13
, GDF_SITE_USE_ATTRIBUTE14
, GDF_SITE_USE_ATTRIBUTE15
, GDF_SITE_USE_ATTRIBUTE16
, GDF_SITE_USE_ATTRIBUTE17
, GDF_SITE_USE_ATTRIBUTE18
, GDF_SITE_USE_ATTRIBUTE19
, GDF_SITE_USE_ATTRIBUTE20
, GL_ID_UNPAID_REC
, GL_ID_REMITTANCE
, GL_ID_FACTOR
, ORIG_SYSTEM_PARTY_REF
, PARTY_NUMBER
, PARTY_SITE_NUMBER
, ADDRESS_CATEGORY_CODE
, ADDRESS_ATTRIBUTE16
, ADDRESS_ATTRIBUTE17
, ADDRESS_ATTRIBUTE18
, ADDRESS_ATTRIBUTE19
, ADDRESS_ATTRIBUTE20
, CUSTOMER_ATTRIBUTE16
, CUSTOMER_ATTRIBUTE17
, CUSTOMER_ATTRIBUTE18
, CUSTOMER_ATTRIBUTE19
, CUSTOMER_ATTRIBUTE20
, CUST_TAX_HEADER_LEVEL_FLAG
, CUST_TAX_ROUNDING_CODE
, SITE_USE_TAX_HEADER_LEVEL_FLAG
, SITE_USE_TAX_ROUNDING_CODE
, SITE_USE_TAX_CLASSIFICATION
, FISCAL_CLASS_CATEGORY
, FISCAL_CLASS_CODE
, CUST_FEDERAL_ENTITY_TYPE
, CUST_TRADING_PARTNER_AGENCY_ID
, CUST_DUNS_EXTENSION
, CUST_ADVANCE_PAYMENT_INDICATOR
FROM AR.RA_CUSTOMERS_INTERFACE_ALL#;
AR
RA_CUSTOMERS_INTERFACE_ALL
APPS
JL_BR_AR_BEF_DEL_CUST_INT
RA_CUSTOMERS_INTERFACE
RA_CUSTOMERS_INTERFACE_ALL
|
|
|
|