AR_UPD_REF_ACCOUNTS
AR_UPD_REF_ACCOUNTS contains customer reference account interface 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_REF_ACCOUNTS_PK |
REFACCT_UPLOAD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REFACCT_UPLOAD_ID | NUMBER | 18 | Yes | Unique identifier for a customer upload record. | |
| BATCH_ID | NUMBER | 18 | Unique identifier for a customer import batch process. | ||
| CUST_ORIG_SYSTEM | VARCHAR2 | 30 | Yes | Original system identifier for the customer account. | |
| ORIG_SOURCE_SYSTEM_NAME | VARCHAR2 | 80 | Name of the source system used to load data into the TCA registry. | ||
| CUST_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Yes | Original system reference for the customer account. | |
| CUST_SITE_ORIG_SYS_REF | VARCHAR2 | 240 | Yes | Original system reference for the customer account site. | |
| CUST_SITEUSE_ORIG_SYS_REF | VARCHAR2 | 240 | Yes | Original system reference for the customer account site purpose. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| ACCOUNT_NUMBER | VARCHAR2 | 30 | Number of the customer account. | ||
| PARTY_SITE_NUMBER | VARCHAR2 | 30 | Number of the party site. This number indicates unique reference of the addresses associated to a party. | ||
| LEDGER_ID | NUMBER | 18 | Unique ledger identifier for the reference account. | ||
| REF_ACCOUNT_CCID | NUMBER | 18 | Unique identifier for the reference account. | ||
| SITE_USE_ID | NUMBER | 18 | Unique identifier of the customer address purpose. | ||
| INSERT_UPDATE_FLAG | VARCHAR2 | 1 | Insert update indicator. Valid values are I and U. I means the customer does not exist and that the customer information must be imported for the first time. U means the customer exists and that only specific customer information must be updated. | ||
| ACCOUNT_TYPE | VARCHAR2 | 30 | Yes | Account class for this reference account. | |
| SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created 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_REF_ACCOUNTS_N1 | Non Unique | Default | BATCH_ID, UPLOAD_STATUS, FILE_RECORD_NUM |
| AR_UPD_REF_ACCOUNTS_N2 | Non Unique | Default | LOAD_REQUEST_ID |
| AR_UPD_REF_ACCOUNTS_U1 | Unique | Default | REFACCT_UPLOAD_ID |