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 |