IBY_TEMP_EXT_BANK_ACCTS
IBY_TEMP_EXT_BANK_ACCTS defines the temporary records for external bank accounts.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
IBY_TEMP_EXT_BANK_ACCTS_PK |
TEMP_EXT_BANK_ACCT_ID, FEEDER_IMPORT_BATCH_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TEMP_EXT_BANK_ACCT_ID | NUMBER | 18 | Yes | Oracle internal use only. Populated by Oracle. | |
EXT_BANK_ACCOUNT_ID | NUMBER | 18 | Bank account identifier. Use the Manage Bank Accounts task to identify valid values. | ||
PAYMENT_FLOW | VARCHAR2 | 30 | Yes | Specifies funds capture or disbursement flow. Use the Manage Lookup Types task, lookup type IBY_PAYMENT_FLOW to identify valid values. | |
COUNTRY_CODE | VARCHAR2 | 2 | Yes | Country code where the bank is located. Use the two character ISO code. Example: United States is US. | |
BRANCH_ID | NUMBER | 18 | Identifies bank branch. Used if BANK_ID is populated. Use the Manage Bank Branches task to identify valid values. | ||
BANK_ID | NUMBER | 18 | Identifies branch''s bank. Mandatory if Allow International Payments, FOREIGN_PAYMENT_USE_FLAG is Y. Use the Manage Bank Accounts task to identify valid values. | ||
BANK_NAME | VARCHAR2 | 360 | Bank name. Must be unique based on the country code. | ||
BANK_NUMBER | VARCHAR2 | 30 | Bank number. The combination of bank number, branch number, and country code must be unique for each bank. | ||
BANK_NAME_ALT | VARCHAR2 | 360 | Alternative bank name. Free text field. Not validated. | ||
BANK_INSTITUTION_TYPE | VARCHAR2 | 80 | Bank institution type. Valid values: BANK, CLEARINGHOUSE. | ||
BANK_ADDRESS_ID | NUMBER | 18 | Oracle internal use only. | ||
BRANCH_NUMBER | VARCHAR2 | 30 | Branch number assigned by banking authority. For US banks, use the nine-digit transit routing number. The number must be unique for the bank. | ||
BRANCH_TYPE | VARCHAR2 | 30 | Branch type. Valid values: BANK_BRANCH, CLEARINGHOUSE_BRANCH. | ||
BRANCH_NAME | VARCHAR2 | 360 | Branch name. Free text field. Not validated. | ||
BRANCH_NAME_ALT | VARCHAR2 | 360 | Alternative branch name. Free text field. Not validated. | ||
BIC | VARCHAR2 | 30 | Bank Identifier Code (BIC) for the payee bank branch. First four letters are institution or bank code. Position four through six are country code. Positions six through eight are location code. Last three characters are optional: bank code. | ||
RFC_IDENTIFIER | VARCHAR2 | 30 | Branch Regional Finance Center. Applicable to US banks only. Use the Manage Cash Management Lookups task, lookup type RFC_IDENTIFIER to identify valid values. | ||
BANK_CODE | VARCHAR2 | 100 | Short code for the bank. Varies based upon country of bank branch. Use the Manage Cash Management Lookups task, lookup type BANK_CODE to identify valid values by country. | ||
BRANCH_ADDRESS_ID | NUMBER | 18 | Branch location. Oracle internal use only. Foreign key to HZ_IMP_LOCATIONS_T.LOCATION_T_ID. | ||
ACCOUNT_OWNER_PARTY_ID | NUMBER | 18 | Oracle internal use only. Owner party Identifier. | ||
OWNER_PRIMARY_FLAG | VARCHAR2 | 1 | Primary flag for the owner. Use: Y. Valid values: Y, N. | ||
BANK_ACCOUNT_NAME | VARCHAR2 | 80 | Bank account name. Free text field. Not validated. | ||
BANK_ACCOUNT_NUM | VARCHAR2 | 100 | Account number. The combination of bank account number, branch number, country code, and currency must be unique for each bank. | ||
CURRENCY_CODE | VARCHAR2 | 15 | Currency code. Use the Manage Currencies task to find valid values. Use the three character ISO currency code. Example: US Dollars is USD. Leave this field blank if the bank account accepts payments in multiple currencies. | ||
IBAN | VARCHAR2 | 50 | International Bank Account Number (IBAN) for the payee bank account. First two positions are letters. Third and fourth positions are numbers. Mod 97 rule is used for IBAN check digit. | ||
CHECK_DIGITS | VARCHAR2 | 30 | Check digits to validate bank account number. | ||
BANK_ACCOUNT_NAME_ALT | VARCHAR2 | 320 | Alternate account name. Free text field. Not validated. | ||
BANK_ACCOUNT_TYPE | VARCHAR2 | 25 | Bank account type. Valid values: SAVINGS, CHECKING, OTHER. Use the Manage Standard Lookups task, lookup IBY_BANKACCT_TYPES to identify valid values. | ||
ACCOUNT_SUFFIX | VARCHAR2 | 30 | Account suffix. New Zealand banks only: combination of bank account number, currency, and account suffix must be unique within a bank. | ||
DESCRIPTION | VARCHAR2 | 240 | Description. Free text field. Not validated. | ||
AGENCY_LOCATION_CODE | VARCHAR2 | 30 | Agency location code assigned by the treasury financial management service of the company. Free text field. Not validated. | ||
PAYMENT_FACTOR_FLAG | VARCHAR2 | 1 | Indicates whether this is a payment factor bank account. Valid values: Y, N. | ||
FOREIGN_PAYMENT_USE_FLAG | VARCHAR2 | 1 | Indicates whether foreign payments are permitted: when the bank branch country of payer bank account differs from payee bank account country. Valid values: Y, N. | ||
EXCHANGE_RATE_AGREEMENT_NUM | VARCHAR2 | 80 | Exchange rate agreement number. Free text field. Not validated. | ||
EXCHANGE_RATE_AGREEMENT_TYPE | VARCHAR2 | 80 | Exchange rate agreement type. Use the Manage Standard Lookups task, lookup type IBY_XCHG_RATE_AGREEMENT to identify valid values. | ||
EXCHANGE_RATE | NUMBER | Exchange rate per agreement between supplier and its bank account. Used to convert payment currency to bank account currency. | |||
HEDGING_CONTRACT_REFERENCE | VARCHAR2 | 20 | Hedging contract reference. Free text field. Not validated. | ||
SECONDARY_ACCOUNT_REFERENCE | VARCHAR2 | 30 | Additional account number reference. Example: Building Society Roll Number. Free text field. Not validated. | ||
START_DATE | DATE | Date when the bank account becomes active. Date format: YYYY/MM/DD. Must be earlier than END_DATE. | |||
END_DATE | DATE | Date when the bank account becomes inactive. Date format: YYYY/MM/DD. Must be later than START_DATE. | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Context code for External Bank Accounts descriptive flexfield. Use the Manage Payment System Connectivity Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE15 for the segment values. | ||
NOTE | VARCHAR2 | 240 | Note. Free text field. | ||
NOTE_ALT | VARCHAR2 | 240 | Alternative note. Free text field. Not validated. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for External Bank Accounts descriptive flexfield. | ||
STATUS | VARCHAR2 | 30 | Yes | Status of the bank account approval process. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: user who last updated the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: user who created the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: request ID of the job that created or last updated the row. | ||
PROGRAM_APPLICATION_ID | NUMBER | 18 | Oracle internal use only. Who column. | ||
PROGRAM_ID | NUMBER | 18 | Oracle internal use only. Who column. | ||
PROGRAM_UPDATE_DATE | DATE | Oracle internal use only. Who column. | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
CALLING_APP_UNIQUE_REF1 | VARCHAR2 | 100 | Oracle internal use only. First unique identifier of the owner in the source product. | ||
CALLING_APP_UNIQUE_REF2 | VARCHAR2 | 100 | Oracle internal use only. Second unique identifier of the owner in the source product | ||
EXT_PAYEE_ID | NUMBER | 18 | Oracle internal use only. Payee to whom the bank account must be assigned. Not used for Oracle Cloud implementations. | ||
FEEDER_IMPORT_BATCH_ID | NUMBER | 18 | Yes | Batch identifier. Must be unique. | |
ORIG_SYSTEM | VARCHAR2 | 80 | Original system for the bank account. Not used for Oracle Cloud implementations. Free text field. Not validated. | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original system reference for the bank account. Not used for Oracle Cloud implementations. Free text field. Not validated. | ||
BANK_MRG_TGT_OSR | VARCHAR2 | 240 | Oracle internal use only. Stores the original source reference of the bank merge target interface record. | ||
BRANCH_MRG_TGT_OSR | VARCHAR2 | 240 | Stores the original source reference of the branch merge target interface record. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: request ID of the loader job that created or last updated the row. | ||
TEMP_EXT_PARTY_ID | NUMBER | 18 | Account owner party identifier. Use either ACCOUNT_OWNER_PARTY_ID or TEMP_EXT_PARTY_ID, but not both. | ||
BANK_ACCOUNT_NUM_ELECTRONIC | VARCHAR2 | 100 | The bank account number used in electronic files, if different from the written form. | ||
BA_NUM_ELEC_SEC_SEGMENT_ID | NUMBER | 18 | Electronically-formatted bank number security segment identifier. | ||
SALT_VERSION | NUMBER | 2 | Denotes the versions of the encryption algorithm used for the bank account number encryption. | ||
ENTERPRISE_ID | NUMBER | 18 | Enterprise identifier to support multi-tenancy. | ||
ENCRYPTED_FLAG | VARCHAR2 | 1 | Yes | Whether the instrument is encrypted. | |
IBAN_SEC_SEGMENT_ID | NUMBER | 18 | Security identifier of IBAN(International Bank Account Number). | ||
IBAN_HASH1 | VARCHAR2 | 64 | Hash value of IBAN(International Bank Account Number). | ||
IBAN_HASH2 | VARCHAR2 | 64 | Salted hash value of IBAN(International Bank Account Number). | ||
MASKED_IBAN | VARCHAR2 | 50 | Masked IBAN value to be used for display purposes. | ||
BANK_ACCOUNT_NUM_HASH1 | VARCHAR2 | 64 | Hash of the bank account number. | ||
BANK_ACCOUNT_NUM_HASH2 | VARCHAR2 | 64 | Hash of the salted bank account number. | ||
MASKED_BANK_ACCOUNT_NUM | VARCHAR2 | 100 | Masked bank account number to be used for display purposes. | ||
BA_MASK_SETTING | VARCHAR2 | 30 | Current bank account masking setting values taken from lookup IBY_INSTRUMENT_MASK_SETTING. | ||
BA_UNMASK_LENGTH | NUMBER | 2 | Number of digits to expose in the external bank account mask. | ||
BA_NUM_SEC_SEGMENT_ID | NUMBER | 18 | Bank account number security identifier. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
IBY_TEMP_EXT_BANK_ACCTS | iby_ext_bank_accounts | EXT_BANK_ACCOUNT_ID |
IBY_TEMP_EXT_BANK_ACCTS | hz_parties | BRANCH_ID |
IBY_TEMP_EXT_BANK_ACCTS | hz_parties | BANK_ID |
IBY_TEMP_EXT_BANK_ACCTS | hz_parties | ACCOUNT_OWNER_PARTY_ID |
IBY_TEMP_EXT_BANK_ACCTS | iby_external_payees_all | EXT_PAYEE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
IBY_TEMP_EXT_BANK_ACCTS_N1 | Non Unique | Default | EXT_BANK_ACCOUNT_ID |
IBY_TEMP_EXT_BANK_ACCTS_N2 | Non Unique | Default | ACCOUNT_OWNER_PARTY_ID |
IBY_TEMP_EXT_BANK_ACCTS_N3 | Non Unique | Default | BANK_ID, BRANCH_ID |
IBY_TEMP_EXT_BANK_ACCTS_U1 | Unique | Default | TEMP_EXT_BANK_ACCT_ID, FEEDER_IMPORT_BATCH_ID |