AR_UPD_CUSTOMERS
AR_UPD_CUSTOMERS contains customer data entered into a simplified customer spreadsheet template for upload.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
AR_UPD_CUSTOMERS_PK |
CUST_UPLOAD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUST_UPLOAD_ID | NUMBER | 18 | Yes | Unique identifier for a customer upload record. | |
| BATCH_ID | NUMBER | 18 | Unique identifier for a customer import batch process. | ||
| ORIG_SOURCE_SYSTEM | VARCHAR2 | 30 | Yes | Source system required for importing customer, customer account, address, and address purpose. | |
| ORIG_SOURCE_SYSTEM_NAME | VARCHAR2 | 80 | Name of the source system used to load data into the TCA registry. | ||
| PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Yes | Original system reference for the customer party. | |
| PARTY_T_ID | NUMBER | 18 | Reference to the unique identifier of the HZ_IMP_PARTIES_T interface table. | ||
| LOCATION_T_ID | NUMBER | 18 | Reference to the unique identifier of the HZ_IMP_LOCATIONS_T interface table. | ||
| PARTYSITE_T_ID | NUMBER | 18 | Reference to the unique identifier of the HZ_IMP_PARTYSITES_T interface table. | ||
| PARTYSITEUSE_T_ID | NUMBER | 18 | Reference to the unique identifier of the HZ_IMP_PARTYSITEUSES_T interface table. | ||
| ACCOUNT_T_ID | NUMBER | 18 | Reference to the unique identifier of the HZ_IMP_ACCOUNTS_T interface table. | ||
| ACCTSITE_T_ID | NUMBER | 18 | Reference to the unique identifier of the HZ_IMP_ACCTSITES_T interface table. | ||
| ACCTSITEUSE_T_ID | NUMBER | 18 | Reference to the unique identifier of the HZ_IMP_ACCTSITEUSES_T interface table. | ||
| PARTY_INT_STATUS | VARCHAR2 | 30 | Status of the data in the HZ_IMP_PARTIES_T interface table. | ||
| LOC_INT_STATUS | VARCHAR2 | 30 | Status of the data in the HZ_IMP_LOCATIONS_T interface table. | ||
| PARTYSITE_INT_STATUS | VARCHAR2 | 30 | Status of the data in the HZ_IMP_PARTYSITES_T interface table. | ||
| PTYSITEUSE_INT_STATUS | VARCHAR2 | 30 | Status of the data in the HZ_IMP_PARTYSITEUSES_T interface table. | ||
| ACCOUNT_INT_STATUS | VARCHAR2 | 30 | Status of the data in the HZ_IMP_ACCOUNTS_T interface table. | ||
| ACCTSITE_INT_STATUS | VARCHAR2 | 30 | Status of the data in the HZ_IMP_ACCTSITES_T interface table. | ||
| ACCTSITEUSE_INT_STATUS | VARCHAR2 | 30 | Status of the data in the HZ_IMP_ACCTSITEUSES_T interface table. | ||
| PARTY_NAME | VARCHAR2 | 360 | Yes | Name of the customer organization party. | |
| DUNS_NUMBER | VARCHAR2 | 30 | DUNS number in varchar format. Column value is not restricted to the nine digit D-U-N-S number. | ||
| TAXPAYER_ID_NUM | VARCHAR2 | 20 | Taxpayer identification number. | ||
| TAXPAYER_REGISTRATION_NUM | VARCHAR2 | 50 | Registration number of the taxpayer. | ||
| PARTY_NUMBER | VARCHAR2 | 30 | Unique identifier of the customer organization party. | ||
| GSA_INDICATOR_FLAG | VARCHAR2 | 1 | Indicates whether the business is served by the General Services Administration. Valid values are: Null, Y, and N. | ||
| CUST_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Yes | Original System Reference for the customer account. | |
| ACCOUNT_NUMBER | VARCHAR2 | 30 | Number of the customer account. | ||
| ACCOUNT_DESCRIPTION | VARCHAR2 | 240 | User-defined description of the customer account. | ||
| ACCOUNT_TYPE | VARCHAR2 | 30 | Indicates the type of customer account, based on the CUSTOMER_TYPE lookup. For example, I for internal customers, R for revenue generating external customers. | ||
| ACCOUNT_ESTABLISHED_DATE | DATE | Yes | Date when the customer account was originally created. | ||
| CUSTOMER_CLASS | VARCHAR2 | 30 | Identifier of the customer class, based on the CUSTOMER_CLASS lookup. For example, Education for educational customers. | ||
| CUSTOMER_PROFILE_CLASS | VARCHAR2 | 30 | Name of the customer profile class. | ||
| SITE_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original system reference for the party site. | ||
| PARTY_SITE_NAME | VARCHAR2 | 240 | Name of the customer party site. | ||
| PARTY_SITE_NUMBER | VARCHAR2 | 230 | Number of the customer party site. | ||
| CUST_SITE_ORIG_SYS_REF | VARCHAR2 | 240 | Yes | Original system reference for the customer account site. | |
| ACCT_ADDRESS_SET_CODE | VARCHAR2 | 30 | Yes | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional user interfaces. | |
| LOCATION_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original system reference for the party site address. | ||
| ADDRESS_LINE_1 | VARCHAR2 | 240 | Yes | First line of the address for the customer site. | |
| ADDRESS_LINE_2 | VARCHAR2 | 240 | Second line of the address for the customer site. | ||
| MAIL_STOP | VARCHAR2 | 60 | User-defined code to indicate a mail drop point within the customer site address. | ||
| ADDRESS_LINE_3 | VARCHAR2 | 240 | Third line of the address for the customer site. | ||
| ADDRESS_LINE_4 | VARCHAR2 | 240 | Fourth line of the address for the customer site. | ||
| BUILDING | VARCHAR2 | 240 | Name of the building for the customer site address. | ||
| FLOOR_NUMBER | VARCHAR2 | 40 | Number of the floor of the building for the customer site address. | ||
| HOUSE_TYPE | VARCHAR2 | 30 | If required by the country of the customer site address, the type of house described in the address, such as detached, semi-detached, colonial, or bungalow. Values are based on the HZ_HOUSE_TYPE lookup type. | ||
| ADDR_ELEMENT_ATTRIBUTE1 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE2 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE3 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE4 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| ADDR_ELEMENT_ATTRIBUTE5 | VARCHAR2 | 150 | Additional address element to support flexible address format. | ||
| CITY | VARCHAR2 | 60 | City of the address for the customer site. | ||
| STATE | VARCHAR2 | 60 | State of the address for the customer site. | ||
| PROVINCE | VARCHAR2 | 60 | Province of the address for the customer site. | ||
| POSTAL_CODE | VARCHAR2 | 60 | Postal code of the address for the customer site. | ||
| POSTAL_PLUS4_CODE | VARCHAR2 | 10 | Four digit extension to the United States postal code. | ||
| COUNTY | VARCHAR2 | 60 | County of the address for the customer site. | ||
| COUNTRY | VARCHAR2 | 2 | Yes | Country code from the TERRITORY_CODE column in the FND_TERRITORY table. For example, US for United State of America, DE for Germany. | |
| ADDRESS_LINES_PHONETIC | VARCHAR2 | 560 | Phonetic representation of address lines, such as those used in Japan. | ||
| ADDRESS_DESCRIPTION | VARCHAR2 | 1000 | Complete description of the customer site. | ||
| ADDR_SHORT_DESCRIPTION | VARCHAR2 | 240 | Short description of the customer site. | ||
| TIMEZONE_CODE | VARCHAR2 | 50 | Timezone code from the FND_TIMEZONES_B table. | ||
| SALES_TAX_GEOCODE | VARCHAR2 | 30 | US state and local tax jurisdiction code. Use this field to provide either a Vertex GeoCode or Taxware Geocode value for the Point of Order Origin. | ||
| SALES_TAX_INSIDE_CITY_LIMITS | VARCHAR2 | 1 | Indicates whether a location is inside the boundary of a city, based on the associated GeoCode. It is used to calculate state and local taxes in the United States. Values are Y for locations within the city limits, and N for locations outside the city limits. | ||
| IDENTIFYING_ADDRESS_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the customer site address is the identifying address for the customer organization. Valid values are Y and N. | |
| ACCT_SITE_LANGUAGE | VARCHAR2 | 4 | Default language code for the party site. | ||
| TRANSLATED_CUSTOMER_NAME | VARCHAR2 | 360 | Customer name in the language of the site. | ||
| CUST_SITEUSE_ORIG_SYS_REF | VARCHAR2 | 240 | Yes | Original system reference for the customer account site purpose. | |
| SITE_USE_CODE | VARCHAR2 | 30 | Yes | Business purpose assigned to the customer site, such as bill-to, ship-to or sold-to. | |
| SITE_USE_PRIMARY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the business purpose assigned to the customer site is the primary business purpose. Valid values are Y and N. | |
| SITE_LOCATION | VARCHAR2 | 150 | Location of the associated customer site. Value must be unique for accounts in a set. | ||
| BILL_TO_CUST_SITE_REF | VARCHAR2 | 240 | Bill-to site address linked to the ship-to site purpose. | ||
| PAYMENT_METHOD_NAME | VARCHAR2 | 30 | Receipt method name that is associated with the bill-to site. | ||
| PAYMENT_METHOD_PRIMARY_FLAG | VARCHAR2 | 1 | Indicates whether the receipt method assigned to the customer site is the primary receipt method. Valid values are Y and N. | ||
| PAYMENT_METHOD_START_DATE | DATE | Date from which the receipt method assigned to the customer site is valid. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | ||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| UPLOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the parent job that processes this record. | ||
| UPLOAD_STATUS | VARCHAR2 | 30 | Indicates the upload status of this record. | ||
| FILE_RECORD_NUM | NUMBER | 10 | This column is used by the import wizard to relate a record in the interface table to the file row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_UPD_CUSTOMERS_N1 | Non Unique | Default | BATCH_ID, UPLOAD_STATUS, FILE_RECORD_NUM |
| AR_UPD_CUSTOMERS_N2 | Non Unique | Default | LOAD_REQUEST_ID |
| AR_UPD_CUSTOMERS_U1 | Unique | Default | CUST_UPLOAD_ID |