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 |