AR_UPD_BANK_ACCOUNTS
AR_UPD_BANK_ACCOUNTS contains customer bank 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_BANK_ACCOUNTS_PK |
BANKACCT_UPLOAD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BANKACCT_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 | Original system reference for the customer account site. | ||
| 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. | ||
| COUNTRY | VARCHAR2 | 2 | Yes | Country code from the TERRITORY_CODE column in the FND_TERRITORY table. For example, US for United State of America or DE for Germany. | |
| BANK_NAME | VARCHAR2 | 60 | Yes | Name of the customer bank. The combination of BANK_NAME and BRANCH_NAME must be unique. Do not use if the bank account already exists. | |
| BANK_NUMBER | VARCHAR2 | 30 | Bank number associated with the customer bank account. Must be unique. Do not use if the bank account already exists. | ||
| BANK_ACCOUNT_NUMBER | VARCHAR2 | 30 | Yes | Name of the bank where the account for the customer was opened. | |
| BANK_ACCOUNT_NAME | VARCHAR2 | 80 | Yes | Customer bank account name. This is a mandatory field. Use the Manage Bank Accounts task to identify valid values. | |
| BANK_ACCOUNT_PRIMARY_INDICATOR | VARCHAR2 | 1 | Yes | Indicates whether this is the primary bank account for the customer. Valid values are Y and N. | |
| BANK_ACCOUNT_FROM_DATE | DATE | Activation date of the customer bank account. The customer can be assigned to more than one bank account as long as there is no overlapping date range. | |||
| BANK_ACCOUNT_CURRENCY | VARCHAR2 | 15 | Currency of the customer bank account. Use the Manage Currencies task to identify valid values. Use the three character ISO code, such as USD for the US dollar. | ||
| BANK_ACCOUNT_DESCRIPTION | VARCHAR2 | 240 | Description of the customer bank account. | ||
| BANK_ACCOUNT_CHECK_DIGITS | VARCHAR2 | 30 | One or more digits used to validate a bank account number. This is a free text field that is not validated. | ||
| BRANCH_NAME | VARCHAR2 | 60 | Name of the bank branch of the customer bank. The combination of BANK_NAME and BRANCH_NAME must be unique. Do not use if the bank account already exists. Mandatory if bank account is not defined. | ||
| BRANCH_NUMBER | VARCHAR2 | 25 | Branch number or branch routing number associated with the customer bank account. Must be unique. Do not use if the bank account already exists. | ||
| BANK_BRANCH_EFT_USER_NUMBER | VARCHAR2 | 30 | Electronic fund transfer user number of the customer bank branch. This is a free text field that is not validated. | ||
| 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. | ||
| 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_BANK_ACCOUNTS_N1 | Non Unique | Default | BATCH_ID, UPLOAD_STATUS, FILE_RECORD_NUM |
| AR_UPD_BANK_ACCOUNTS_N2 | Non Unique | Default | LOAD_REQUEST_ID |
| AR_UPD_BANK_ACCOUNTS_U1 | Unique | Default | BANKACCT_UPLOAD_ID |