AR_DOC_TRANSFER_CUSTOMER_EXT
This is a temporary table which is used internally by Oracle. The AR_DOC_TRANSFER_CUSTOMER_EXT table stores the extended attributes used for the xml invoicing service and data will be purged periodically.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: ar_doc_transfer_customer_ext
Primary Key
| Name | Columns |
|---|---|
|
AR_DOC_TRANSFER_CUST_EXT_PK |
ACCOUNT_ID, SHIP_TO_PARTY_ID, ACCOUNT_SITE_USE_ID, PARTY_SITE_USE_ID, CONTACT_ID, REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNT_ID | NUMBER | 18 | Yes | Bill to or paying customer identifier. | |
| SHIP_TO_PARTY_ID | NUMBER | 18 | Yes | Identifier for ship to customer. | |
| ACCOUNT_SITE_USE_ID | NUMBER | 18 | Yes | Bill to or paying customer site use identifier. | |
| PARTY_SITE_USE_ID | NUMBER | 18 | Yes | Ship to customer site use identifier. | |
| CONTACT_ID | NUMBER | 18 | Yes | Bill to or ship to customer contact identifier. | |
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| PARTY_NAME | VARCHAR2 | 360 | Name of the bill to, ship to, or paying customer party. | ||
| ACCOUNT_NUMBER | VARCHAR2 | 30 | Unique identification number for the bill to, ship to, or paying customer party. | ||
| SITE_USE_CODE | VARCHAR2 | 30 | Business purpose assigned to customer site account, such as Bill-To, Market, and Statements for bill to, paying customer, or assigned to party site for ship to customer. | ||
| LOCATION | VARCHAR2 | 150 | Bill to or paying customer site use identifier or ship to party site number. | ||
| ADDRESS_LINE1 | VARCHAR2 | 240 | Address line 1 for the bill to, ship to, or paying customer. | ||
| ADDRESS_LINE2 | VARCHAR2 | 240 | Address line 2 for the bill to, ship to, or paying customer. | ||
| ADDRESS_LINE3 | VARCHAR2 | 240 | Address line 3 for the bill to, ship to, or paying customer. | ||
| ADDRESS_LINE4 | VARCHAR2 | 240 | Address line 4 for the bill to, ship to, or paying customer. | ||
| ADDRESS | VARCHAR2 | 960 | Address for the bill to, ship to, or paying customer. | ||
| CITY | VARCHAR2 | 60 | City for the bill to, ship to, or paying customer. | ||
| COUNTY | VARCHAR2 | 60 | County for the bill to, ship to, or paying customer. | ||
| STATE | VARCHAR2 | 60 | State for the bill to, ship to, or paying customer. | ||
| PROVINCE | VARCHAR2 | 60 | Province for the bill to, ship to, or paying customer. | ||
| POSTAL_CODE | VARCHAR2 | 60 | Postal Code for the bill to, ship to or paying customer. | ||
| TERRITORY_SHORT_NAME | VARCHAR2 | 80 | Territory short name for the bill to, ship to, or paying customer. | ||
| COMPLETE_ADDRESS | VARCHAR2 | 1340 | Complete address for the bill to, ship to, or paying customer. | ||
| NAME | VARCHAR2 | 320 | Contact party name for the bill to, ship to, or paying customer. | ||
| EMAIL_ADDRESS | VARCHAR2 | 320 | Email address for the bill to, ship to, or paying customer. | ||
| PRIMARY_PHONE_COUNTRY_CODE | VARCHAR2 | 10 | International country code for a telephone number for the bill to, ship to, or paying customer. | ||
| PRIMARY_PHONE_AREA_CODE | VARCHAR2 | 20 | Area code within a country code for the bill to, ship to, or paying customer. | ||
| PRIMARY_PHONE_NUMBER | VARCHAR2 | 40 | A telephone number in local format for the bill to, ship to, or paying customer. The number should not include country code, area code, or extension. | ||
| PRIMARY_PHONE_EXTENSION | VARCHAR2 | 20 | Additional number addressed after initial connection to an internal telephone system for the bill to, ship to, or paying customer. | ||
| ACCOUNT_SITE_LANGUAGE | VARCHAR2 | 4 | Operating Language for bill to, paying account sites, or ship to party site. | ||
| PARTY_ID | NUMBER | 18 | Party identifier for the bill to, ship to, and paying customer. | ||
| TAXPAYER_ID_NUMBER | VARCHAR2 | 20 | Taxpayer identification number, the unique identifier of person or organization. This value can be either social security number or income taxpayer identifier in US and either fiscal code or NIF in Europe. | ||
| TRADE_PARTNER_CODE | VARCHAR2 | 80 | Identifies the customer associated with a trading partner in a business-to-business relationship. | ||
| SITE_NUMBER | VARCHAR2 | 30 | Party site number for the bill to, ship to, or paying customer. | ||
| COUNTRY_CODE | VARCHAR2 | 2 | Country code from the TERRITORY_CODE column in the FND_TERRITORY table. | ||
| CUSTOMER_TAX_REG_NUMBER | VARCHAR2 | 50 | Tax registration number for the bill to, ship to, or paying customer. | ||
| TAX_REGIME_NAME | VARCHAR2 | 30 | Tax regime code for the bill to, ship to, or paying customer. | ||
| ACCT_SITE_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Customer Account Site Descriptive Flexfield: structure definition of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE_NUMBER1 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER2 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER3 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER4 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER5 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER6 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER7 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER8 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER9 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER10 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER11 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_NUMBER12 | NUMBER | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE1 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE2 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE3 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE4 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE5 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE6 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE7 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE8 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE9 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE10 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE11 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE_DATE12 | DATE | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| ACCT_SITE_ATTRIBUTE1 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE2 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE3 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE4 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE5 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE6 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE7 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE8 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE9 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE10 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE11 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE12 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE13 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE14 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE15 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE16 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE17 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE18 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE19 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE20 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE21 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE22 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE23 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE24 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE25 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE26 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE27 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE28 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE29 | VARCHAR2 | 150 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_ATTRIBUTE30 | VARCHAR2 | 255 | Customer Account Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| TRANSLATED_CUSTOMER_NAME | VARCHAR2 | 360 | Customer name in the language used at the account site for the bill to, ship to, or paying customer. | ||
| PROF_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Customer Profile Class Descriptive Flexfield: structure definition of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE1 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE2 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE3 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE4 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE5 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE6 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE7 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE8 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE9 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE10 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE11 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE12 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE13 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE14 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_ATTRIBUTE15 | VARCHAR2 | 150 | Customer Profile Class Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Customer Profile Class Global Descriptive Flexfield: structure definition of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PROF_GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_DATE1 | DATE | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_DATE2 | DATE | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_DATE3 | DATE | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_DATE4 | DATE | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PROF_GLOBAL_ATTRIBUTE_DATE5 | DATE | Customer Profile Class Global Descriptive Flexfield: segment of the global descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Party Site Descriptive Flexfield: structure definition of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE_NUMBER1 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER2 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER3 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER4 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER5 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER6 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER7 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER8 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER9 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER10 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER11 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_NUMBER12 | NUMBER | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE1 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE2 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE3 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE4 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE5 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE6 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE7 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE8 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE9 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE10 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE11 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE_DATE12 | DATE | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | |||
| PARTY_SITE_ATTRIBUTE1 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE2 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE3 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE4 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE5 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE6 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE7 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE8 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE9 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE10 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE11 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE12 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE13 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE14 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE15 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE16 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE17 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE18 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE19 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE20 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE21 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE22 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE23 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE24 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE25 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE26 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE27 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE28 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE29 | VARCHAR2 | 150 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| PARTY_SITE_ATTRIBUTE30 | VARCHAR2 | 255 | Party Site Descriptive Flexfield: segment of the user descriptive flexfield for the bill to, ship to, and paying customer. | ||
| ACCT_SITE_CONTACT_NAME | VARCHAR2 | 360 | Account site primary contact party name for the paying customer. | ||
| ACCT_SITE_PHONE_COUNTRY_CODE | VARCHAR2 | 10 | Account site primary international country code for a telephone number for the paying customer. | ||
| ACCT_SITE_PHONE_AREACODE | VARCHAR2 | 20 | Account site primary area code within a country code for the paying customer. | ||
| ACCT_SITE_PHONE_NUMBER | VARCHAR2 | 40 | Account site primary telephone number in local format for the paying customer. This number should not include country code, area code, or extension. | ||
| ACCT_SITE_PHONE_EXTENSION | VARCHAR2 | 20 | Account site primary additional number addressed after initial connection to an internal telephone system for the paying customer. | ||
| ACCT_SITE_EMAIL_ADDRESS | VARCHAR2 | 320 | Account site primary email address for the bill to, ship to, or paying customer. | ||
| CONCATENATED_SITE_PURPOSE | VARCHAR2 | 2000 | Aggregated business purpose assigned to the customer site account, such as Bill-To, Market, and Statements for the bill to, ship to or paying customer. | ||
| PARTY_SITE_ID | NUMBER | 18 | Party site identifier for the bill to, ship to, and paying customer. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_DOC_TRANSFER_CUST_EXT_U1 | Unique | Default | ACCOUNT_ID, SHIP_TO_PARTY_ID, ACCOUNT_SITE_USE_ID, PARTY_SITE_USE_ID, CONTACT_ID, REQUEST_ID |