[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_BANK_ACCOUNTS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_BANK_ACCOUNTS_ALL
|
| Subobject Name: | |
| Status: | VALID |
AP_BANK_ACCOUNTS_ALL contains information about your bank accounts. You need one row for each bank account you define. Each bank account must be affiliated with one bank branch. When you initiate an automatic payment batch, enter a manual check, or create a Quick payment,
you can select a bank account that you define in this table.
This table corresponds to the Bank Accounts window.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_BANK_ACCOUNTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BANK_ACCOUNT_ID
|
| AP_BANK_ACCOUNTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
BANK_ACCOUNT_NUM
BANK_ACCOUNT_ID
|
| AP_BANK_ACCOUNTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BANK_BRANCH_ID
|
| AP_BANK_ACCOUNTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BANK_ACCOUNT_NAME
ACCOUNT_TYPE
|
| AP_BANK_ACCOUNTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACCOUNT_TYPE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BANK_ACCOUNT_ID | NUMBER | (15) | Yes | Bank account identifier |
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | Yes | Bank account name |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | VARCHAR2 | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Yes | Bank account number |
| BANK_BRANCH_ID | NUMBER | (15) | Yes | Bank branch identifier |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identifier |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| CONTACT_FIRST_NAME | VARCHAR2 | (15) | First name of bank contact person | |
| CONTACT_MIDDLE_NAME | VARCHAR2 | (15) | Middle name of bank contact person | |
| CONTACT_LAST_NAME | VARCHAR2 | (20) | Last name of bank contact person | |
| CONTACT_PREFIX | VARCHAR2 | (5) | Prefix of bank contact person (Ms., Mr., Mrs., Miss, etc.) | |
| CONTACT_TITLE | VARCHAR2 | (30) | Title of bank contact person | |
| CONTACT_AREA_CODE | VARCHAR2 | (10) | Area code for phone number of bank contact person | |
| CONTACT_PHONE | VARCHAR2 | (15) | Phone number of bank contact person | |
| MAX_CHECK_AMOUNT | NUMBER | Default maximum payment amount allowed for bank account in a payment batch | ||
| MIN_CHECK_AMOUNT | NUMBER | Default minimum payment amount allowed for bank account in a payment batch | ||
| ONE_SIGNATURE_MAX_FLAG | VARCHAR2 | (1) | No longer used | |
| INACTIVE_DATE | DATE | Inactive date | ||
| AVG_FLOAT_DAYS | NUMBER | (15) | No longer used | |
| ASSET_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for cash account associated with bank account | |
| GAIN_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for account to which you post realized exchange rate gains | |
| LOSS_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for account to which you post realized exchange rate losses | |
| BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | Bank account type code | |
| VALIDATION_NUMBER | NUMBER | (5) | No longer used | |
| MAX_OUTLAY | NUMBER | Maximum payment batch outlay for bank account | ||
| MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | Yes | Multiple currency bank account indicator (Y or N) |
| ACCOUNT_TYPE | VARCHAR2 | (25) | Yes | Bank account type code. Possible values are: INTERNAL or SUPPLIER for banks defined for Oracle Payables, INTERNAL or EXTERNAL for banks defined for Oracle Receivables and PAYROLL for banks defined for Payroll |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| POOLED_FLAG | VARCHAR2 | (1) | Pooled or non-pooled account indicator | |
| ZERO_AMOUNTS_ALLOWED | VARCHAR2 | (1) | Indicator for allowing or disallowing zero amount payments for bank account | |
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| RECEIPT_MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | Supports integration with Oracle Cash Management | |
| CHECK_DIGITS | VARCHAR2 | (30) | Holds any check digits that result from bank account number validation in FBS | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| CASH_CLEARING_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Cash Clearing Account | |
| BANK_CHARGES_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Bank Charges Account | |
| BANK_ERRORS_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Bank Errors Account | |
| EARNED_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Earned Account | |
| UNEARNED_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Unearned Account | |
| ON_ACCOUNT_CCID | NUMBER | (15) | Accounting Flexfield identifier for the On Account Account | |
| UNAPPLIED_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Unapplied Account | |
| UNIDENTIFIED_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Unidentified Account | |
| FACTOR_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Factor Account | |
| RECEIPT_CLEARING_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Receipt Confirmation Account | |
| REMITTANCE_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Remittance Account | |
| SHORT_TERM_DEPOSIT_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Short Term Deposit Account | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| BANK_ACCOUNT_NAME_ALT | VARCHAR2 | (320) | Alternate bank account name | |
| ACCOUNT_HOLDER_NAME | VARCHAR2 | (240) | Account holder name | |
| ACCOUNT_HOLDER_NAME_ALT | VARCHAR2 | (150) | Alternate account holder name | |
| EFT_REQUESTER_ID | VARCHAR2 | (25) | EFT requester identifier | |
| EFT_USER_NUMBER | VARCHAR2 | (30) | The number that identifies you as a user of electronic funds transfer services to your bank or clearing organization | |
| PAYROLL_BANK_ACCOUNT_ID | NUMBER | (9) | Bank account identifier for payroll bank accounts | |
| FUTURE_DATED_PAYMENT_CCID | NUMBER | (15) | Accounting Flexfield identifier for the future dated payment account | |
| EDISC_RECEIVABLES_TRX_ID | NUMBER | (15) | Earned Discounts Activity | |
| UNEDISC_RECEIVABLES_TRX_ID | NUMBER | (15) | Unearned Discounts Activity | |
| BR_REMITTANCE_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Bills Receivable Remittance account | |
| BR_FACTOR_CCID | NUMBER | (15) | Accounting Flexfield identifier for the Bills Receivable Factoring account | |
| BR_STD_RECEIVABLES_TRX_ID | NUMBER | (15) | Receivables activity identifier used for short term debt definition for transaction type of Bills Receivable Remittance | |
| ALLOW_MULTI_ASSIGNMENTS_FLAG | VARCHAR2 | (1) | Allows a bank to be assigned to more than one supplier | |
| AGENCY_LOCATION_CODE | VARCHAR2 | (30) | Agency Location code assigned by US Treasury | |
| IBAN_NUMBER | VARCHAR2 | (40) | International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN. |
Cut, paste (and edit) the following text to query this object:
SELECT BANK_ACCOUNT_ID
, BANK_ACCOUNT_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, BANK_ACCOUNT_NUM
, BANK_BRANCH_ID
, SET_OF_BOOKS_ID
, CURRENCY_CODE
, DESCRIPTION
, CONTACT_FIRST_NAME
, CONTACT_MIDDLE_NAME
, CONTACT_LAST_NAME
, CONTACT_PREFIX
, CONTACT_TITLE
, CONTACT_AREA_CODE
, CONTACT_PHONE
, MAX_CHECK_AMOUNT
, MIN_CHECK_AMOUNT
, ONE_SIGNATURE_MAX_FLAG
, INACTIVE_DATE
, AVG_FLOAT_DAYS
, ASSET_CODE_COMBINATION_ID
, GAIN_CODE_COMBINATION_ID
, LOSS_CODE_COMBINATION_ID
, BANK_ACCOUNT_TYPE
, VALIDATION_NUMBER
, MAX_OUTLAY
, MULTI_CURRENCY_FLAG
, ACCOUNT_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, POOLED_FLAG
, ZERO_AMOUNTS_ALLOWED
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RECEIPT_MULTI_CURRENCY_FLAG
, CHECK_DIGITS
, ORG_ID
, CASH_CLEARING_CCID
, BANK_CHARGES_CCID
, BANK_ERRORS_CCID
, EARNED_CCID
, UNEARNED_CCID
, ON_ACCOUNT_CCID
, UNAPPLIED_CCID
, UNIDENTIFIED_CCID
, FACTOR_CCID
, RECEIPT_CLEARING_CCID
, REMITTANCE_CCID
, SHORT_TERM_DEPOSIT_CCID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, BANK_ACCOUNT_NAME_ALT
, ACCOUNT_HOLDER_NAME
, ACCOUNT_HOLDER_NAME_ALT
, EFT_REQUESTER_ID
, EFT_USER_NUMBER
, PAYROLL_BANK_ACCOUNT_ID
, FUTURE_DATED_PAYMENT_CCID
, EDISC_RECEIVABLES_TRX_ID
, UNEDISC_RECEIVABLES_TRX_ID
, BR_REMITTANCE_CCID
, BR_FACTOR_CCID
, BR_STD_RECEIVABLES_TRX_ID
, ALLOW_MULTI_ASSIGNMENTS_FLAG
, AGENCY_LOCATION_CODE
, IBAN_NUMBER
FROM AP.AP_BANK_ACCOUNTS_ALL;
AP.AP_BANK_ACCOUNTS_ALL does not reference any database object
AP.AP_BANK_ACCOUNTS_ALL is referenced by following:
APPS
AP_BANK_ACCOUNTS
AP_BANK_ACCOUNTS_ALL
|
|
|
|