RA_CUSTOMER_BANKS_INT_ALL
This is part of customer import program. This is the open interface table for the Customer bank accounts while importing customers
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUST_ORIG_SYSTEM | VARCHAR2 | 240 | Yes | Original source system of customer data. Use the Manage Source Systems task to identify valid values. Examples: Siebel, Dun and Bradstreet. | |
| CUST_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Yes | Uniquely identifies customer in original source system. Must be unique if INSERT_UPDATE_FLAG is I. Must be an existing value if INSERT_UPDATE_FLAG is U. | |
| CUST_SITE_ORIG_SYSTEM | VARCHAR2 | 240 | Unique customer site identifier in original source system. Use the Manage Source Systems task to identify valid values. Examples: Siebel, Dun and Bradstreet. | ||
| CUST_SITE_ORIG_SYS_REF | VARCHAR2 | 240 | Uniquely identifies customer site in original source system. Must be unique if INSERT_UPDATE_FLAG is I. Must be an existing value if INSERT_UPDATE_FLAG is U. | ||
| BATCH_ID | NUMBER | 18 | Yes | Unique batch identifier. | |
| INTERFACE_STATUS | VARCHAR2 | 240 | Oracle internal use only. Interface status. | ||
| VALIDATED_FLAG | VARCHAR2 | 1 | Oracle internal use only. Validated indicator. | ||
| BANK_ACCOUNT_NAME | VARCHAR2 | 80 | Yes | Bank account name. This is a mandatory field. Use the Manage Bank Accounts task to identify valid values. | |
| PRIMARY_FLAG | VARCHAR2 | 1 | Yes | Primary bank account indicator. Valid values: Y, N. | |
| START_DATE | DATE | Yes | Bank account active date. Customers can be assigned to multiple bank accounts as long as there is no overlapping date range. Date format: YYYY/MM/DD. | ||
| END_DATE | DATE | Date upto which an account is active. Customers can be assigned to multiple bank accounts as long as there is no overlapping date range. Date format: YYYY/MM/DD. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| BANK_ACCOUNT_NUM | VARCHAR2 | 30 | Customer bank account number. Free text field. Not validated. | ||
| BANK_ACCOUNT_CURRENCY_CODE | VARCHAR2 | 15 | Bank account currency. Use the Manage Currencies task to identify valid values. Use the three character ISO code. Example: US Dollars is USD. | ||
| BANK_ACCOUNT_INACTIVE_DATE | DATE | Date on which the account will become inactive. | |||
| BANK_ACCOUNT_DESCRIPTION | VARCHAR2 | 240 | Bank account description. Free text field. Not validated. | ||
| BANK_NAME | VARCHAR2 | 60 | Bank name. The combination of BANK_NAME and BANK_BRANCH_NAME must be unique. Do not use if the bank account already exists. | ||
| BANK_BRANCH_NAME | VARCHAR2 | 60 | Bank branch name. The combination of BANK_NAME and BANK_BRANCH_NAME must be unique. Do not use if the bank account already exists. Mandatory if bank account is not defined. | ||
| BANK_NUM | VARCHAR2 | 25 | Branch number associated with the bank account. Must be unique. Do not use if the bank account already exists. | ||
| BANK_BRANCH_DESCRIPTION | VARCHAR2 | 240 | Bank branch description. Free text field. Not validated. | ||
| BANK_BRANCH_ADDRESS1 | VARCHAR2 | 35 | Bank branch address line 1. Free text field. Not validated. | ||
| BANK_BRANCH_ADDRESS2 | VARCHAR2 | 35 | Bank branch address line 2. Free text field. Not validated. | ||
| BANK_BRANCH_ADDRESS3 | VARCHAR2 | 35 | Bank branch address line 3. Free text field. Not validated. | ||
| BANK_BRANCH_CITY | VARCHAR2 | 25 | Bank branch city. Free text field. Not validated. | ||
| BANK_BRANCH_STATE | VARCHAR2 | 25 | Bank branch state. Free text field. Not validated. | ||
| BANK_BRANCH_ZIP | VARCHAR2 | 20 | Bank branch zip code. Free text field. Not validated. | ||
| BANK_BRANCH_PROVINCE | VARCHAR2 | 25 | Bank branch province. Free text field. Not validated. | ||
| BANK_BRANCH_COUNTRY | VARCHAR2 | 25 | Bank branch country. Use the Manage Territories task to identify valid values. | ||
| BANK_BRANCH_AREA_CODE | VARCHAR2 | 10 | Bank branch area code. Free text field. Not validated. | ||
| BANK_BRANCH_PHONE | VARCHAR2 | 15 | Bank branch phone number. Free text field. Not validated. | ||
| BANK_ACCOUNT_ATT_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Bank account descriptive flexfield category. | ||
| BANK_ACCOUNT_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_ACCOUNT_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Bank account descriptive flexfield column. | ||
| BANK_BRANCH_ATT_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Bank branch descriptive flexfield category. | ||
| BANK_BRANCH_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| BANK_BRANCH_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Bank branch descriptive flexfield column. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| BANK_NUMBER | VARCHAR2 | 30 | Stores bank number and branch number of the associated bank. Must be unique. Leave blank if the bank account already exists. | ||
| BANK_BRANCH_ADDRESS4 | VARCHAR2 | 35 | Bank branch address line 4. | ||
| BANK_BRANCH_COUNTY | VARCHAR2 | 25 | Bank branch county. Free text field. Not validated. | ||
| BANK_BRANCH_EFT_USER_NUMBER | VARCHAR2 | 30 | Branch electronic fund transfer user number. Free text field. Not validated. | ||
| BANK_ACCOUNT_CHECK_DIGITS | VARCHAR2 | 30 | Bank account check digit. Free text field. Not validated. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Oracle internal use only. Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| ORG_ID | NUMBER | 18 | Yes | Identifier of the business unit associated with the row. Use the Set Id for the reference data set shared across business units where this receipt method is used in the receipts. | |
| BANK_HOME_COUNTRY | VARCHAR2 | 2 | Bank home country. Use the Manage Territories task to identify valid values. | ||
| EFT_SWIFT_CODE | VARCHAR2 | 30 | Branch identification code | ||
| PRIMARY_ACCT_OWNER_FLAG | VARCHAR2 | 1 | Indicates if the customer is the primary owner of the bank account. | ||
| BANK_ACCOUNT_TYPE | VARCHAR2 | 25 | Type of customer bank account like Saving, Checking, etc. | ||
| IBAN | VARCHAR2 | 50 | International bank account number used as a global bank account identifier | ||
| FOREIGN_PAYMENT_USE_FLAG | VARCHAR2 | 1 | Indicates if the bank account supports international payments | ||
| ACCOUNT_SUFFIX | VARCHAR2 | 30 | Bank account suffix | ||
| AGENCY_LOCATION_CODE | VARCHAR2 | 30 | Bank account agency location code | ||
| BANK_ACCOUNT_NAME_ALT | VARCHAR2 | 320 | Alternate name of the bank account | ||
| COUNTRY_CODE | VARCHAR2 | 2 | Bank account country code | ||
| LOCALINSTR | VARCHAR2 | 35 | Local instrument code as defined in the ISO20022 external code list. Values come from lookup IBY_LOCAL_INSTRUMENT | ||
| SERVICE_LEVEL | VARCHAR2 | 35 | Service level code as defined in the ISO20022 external code list. Values come from lookup IBY_SERVICE_LEVEL | ||
| PURPOSE_CODE | VARCHAR2 | 30 | Payment purpose code as defined in the ISO20022 external code list. Values come from lookup IBY_PURPOSE_CODE. | ||
| BANK_CHARGE_BEARER_CODE | VARCHAR2 | 30 | Party that is responsible for paying regular or express bank charges, such as Payee or Payer. Values come from lookup IBY_BANK_CHARGE_BEARER | ||
| DEBIT_ADVICE_DELIVERY_METHOD | VARCHAR2 | 30 | Delivery option for receiving debit advice | ||
| DEBIT_ADVICE_EMAIL | VARCHAR2 | 155 | Email address for receiving debit advice | ||
| DEBIT_ADVICE_FAX | VARCHAR2 | 100 | Fax number for receiving debit advice | ||
| 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. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the Customer Import job that created the row. | ||
| 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 |
|---|---|---|---|
| RA_CUST_BANKS_INTERFACE_N1 | Non Unique | Default | CUST_ORIG_SYSTEM, CUST_ORIG_SYSTEM_REFERENCE |
| RA_CUST_BANKS_INTERFACE_N2 | Non Unique | Default | CUST_SITE_ORIG_SYSTEM, CUST_SITE_ORIG_SYS_REF |
| RA_CUST_BANKS_INTERFACE_N3 | Non Unique | Default | BANK_ACCOUNT_NAME |
| RA_CUST_BANKS_INTERFACE_N4 | Non Unique | Default | BANK_NAME, BANK_BRANCH_NAME |
| RA_CUST_BANKS_INTERFACE_N5 | Non Unique | Default | BANK_NUMBER, BANK_NUM |
| RA_CUST_BANKS_INTERFACE_N6 | Non Unique | Default | BANK_ACCOUNT_NUM, BANK_NAME, BANK_BRANCH_NAME |
| RA_CUST_BANKS_INTERFACE_N7 | Non Unique | Default | BATCH_ID, INTERFACE_STATUS, FILE_RECORD_NUM |