[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_BANK_ACCTS_SEARCH_GT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CE_BANK_ACCTS_SEARCH_GT_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BANK_ACCOUNT_ID | NUMBER | (15) | Yes | Bank Account Identifier |
| BANK_ACCOUNT_NAME | VARCHAR2 | (100) | Yes | Bank Account Name |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Bank Account Number | |
| BANK_BRANCH_ID | NUMBER | (15) | Yes | Bank Branch Identifier |
| BANK_ID | NUMBER | (15) | Bank Identifier | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield Structure Defining Column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
| REQUEST_ID | NUMBER | (15) | Concurrent Who Column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Who Column | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Who Column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who Column | ||
| CHECK_DIGITS | VARCHAR2 | (30) | Holds any check digits that result from bank account number validation in FBS | |
| BANK_ACCOUNT_NAME_ALT | VARCHAR2 | (320) | Alternate Bank Account Name | |
| ACCOUNT_HOLDER_ID | NUMBER | (15) | Account Holder Identifier | |
| EFT_REQUESTER_IDENTIFIER | VARCHAR2 | (25) | EFT Requester Identifier | |
| SECONDARY_ACCOUNT_REFERENCE | VARCHAR2 | (30) | Account Number Reference, Such As Building Society Roll Number | |
| ACCOUNT_SUFFIX | VARCHAR2 | (30) | Account Suffix | |
| DESCRIPTION_CODE1 | VARCHAR2 | (60) | Description Code 1 | |
| DESCRIPTION_CODE2 | VARCHAR2 | (60) | Description Code 2 | |
| IBAN_NUMBER | VARCHAR2 | (50) | IBAN Number | |
| SHORT_ACCOUNT_NAME | VARCHAR2 | (30) | Short Account Name | |
| ACCOUNT_OWNER_PARTY_ID | NUMBER | (15) | Yes | Bank Account Owner Party_Id in TCA |
| ACCOUNT_OWNER_ORG_ID | NUMBER | (15) | Yes | Bank Account Owner Org_Id in HR |
| ACCOUNT_CLASSIFICATION | VARCHAR2 | (30) | Yes | Account Classification (INTERNAL, EXTERNAL) |
| AP_USE_ALLOWED_FLAG | VARCHAR2 | (1) | Flag to indicate if the account use for AP is allowed | |
| AR_USE_ALLOWED_FLAG | VARCHAR2 | (1) | Flag to indicate if the account use for AR is allowed | |
| XTR_USE_ALLOWED_FLAG | VARCHAR2 | (1) | Flag to indicate if the account use for XTR(Treasury) is allowed | |
| PAY_USE_ALLOWED_FLAG | VARCHAR2 | (1) | Flag to indicate if the account use for Payroll is allowed | |
| MULTI_CURRENCY_ALLOWED_FLAG | VARCHAR2 | (1) | Flag to indicate if the multiple currency is allowed | |
| PAYMENT_MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | Flag to indicate if the payment multiple currency is enabled | |
| RECEIPT_MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | Flag to indicate if the receipt multiple currency is enabled | |
| ZERO_AMOUNT_ALLOWED | VARCHAR2 | (1) | Indicator for allowing or disallowing zero amount | |
| MAX_OUTLAY | NUMBER | (15) | Maximum payment batch | |
| 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 | ||
| AP_AMOUNT_TOLERANCE | NUMBER | Tolerance amount limit to be used for AP payments during automatic reconciliation | ||
| AR_AMOUNT_TOLERANCE | NUMBER | Tolerance amount limit to be used for AR receipts during automatic reconciliation | ||
| XTR_AMOUNT_TOLERANCE | NUMBER | Tolerance amount limit to be used for XTR transactions during automatic reconciliation | ||
| PAY_AMOUNT_TOLERANCE | NUMBER | Tolerance amount limit to be used for Payroll transactions during automatic reconciliation | ||
| AP_PERCENT_TOLERANCE | NUMBER | Tolerance percent to be used for AP payments during automatic reconciliation | ||
| AR_PERCENT_TOLERANCE | NUMBER | Tolerance percent to be used for AR receipts during automatic reconciliation | ||
| XTR_PERCENT_TOLERANCE | NUMBER | Tolerance percent to be used for XTR transactions during automatic reconciliation | ||
| PAY_PERCENT_TOLERANCE | NUMBER | Tolerance percent to be used for Payroll transactions during automatic reconciliation | ||
| BANK_ACCOUNT_TYPE | VARCHAR2 | (25) | Bank account type code (sub account type) | |
| AGENCY_LOCATION_CODE | VARCHAR2 | (30) | Agency Location Code used by federal agencies | |
| START_DATE | DATE | Start Date | ||
| END_DATE | DATE | End Date | ||
| ACCOUNT_HOLDER_NAME_ALT | VARCHAR2 | (150) | Account holder alternate name | |
| CASHFLOW_DISPLAY_ORDER | NUMBER | (15) | Cashflow display order | |
| ACCOUNT_HOLDER_NAME | VARCHAR2 | (240) | Account holder name | |
| MASKED_ACCOUNT_NUM | VARCHAR2 | (100) | MASKED_ACCOUNT_NUM | |
| MASKED_IBAN | VARCHAR2 | (50) | MASKED_IBAN | |
| POOLED_FLAG | VARCHAR2 | (1) | POOLED_FLAG | |
| MIN_TARGET_BALANCE | NUMBER | MIN_TARGET_BALANCE | ||
| MAX_TARGET_BALANCE | NUMBER | MAX_TARGET_BALANCE | ||
| EFT_USER_NUM | VARCHAR2 | (30) | EFT_USER_NUM | |
| INTEREST_SCHEDULE_ID | NUMBER | (15) | Interest schedule identifier | |
| ASSET_CODE_COMBINATION_ID | NUMBER | (15) | Asset code combination id | |
| NETTING_ACCT_FLAG | VARCHAR2 | (1) | Netting Bank Account Indicator | |
| CASH_CLEARING_CCID | NUMBER | (15) | Cash clearing ccid | |
| BANK_ACCOUNT_NUM_ELECTRONIC | VARCHAR2 | (100) | Bank account number in electronic transmission format. | |
| STMT_LINE_FLOAT_HANDLING_FLAG | VARCHAR2 | (1) | Flag to indicate how to handle statement lines with effective date being later than today; Lookup type: FLOAT_HANDLING E for error or I for ignore. | |
| AUTORECON_AP_MATCHING_ORDER | VARCHAR2 | (10) | Order of matching statement lines to AP transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX | |
| AUTORECON_AR_MATCHING_ORDER | VARCHAR2 | (10) | Order of matching statement lines to AR transactions, by transactions first or by batch first, lookup type BATCH_OR_TRX | |
| RECON_FOREIGN_BANK_XRATE_TYPE | VARCHAR2 | (30) | Exchange rate type defaulted for foreign currency bank. | |
| RECON_FOR_BANK_XRATE_DATE_TYPE | VARCHAR2 | (10) | Exchange rate date defaulted for foreign currency bank, lookup type EXCHANGE_RATE_DATE_TYPE | |
| RECON_ENABLE_OI_FLAG | VARCHAR2 | (1) | Flag to indicate whether to allow reconciliation of statement lines to open interface transactions, Y or N | |
| RECON_OI_FLOAT_STATUS | VARCHAR2 | (30) | Code to specify the float status for open interface transactions | |
| RECON_OI_CLEARED_STATUS | VARCHAR2 | (30) | Code to specify cleared status for open interface transactions | |
| RECON_OI_MATCHING_CODE | VARCHAR2 | (10) | Open interface transactions matching code, T for matching by transaction number, D for matching by date and amount. Lookup type: OI_MATCHING_CRITERIA | |
| RECON_OI_AMOUNT_TOLERANCE | NUMBER | Tolerance amount limit to be used during the automatic reconciliation for open interface transactions | ||
| RECON_OI_PERCENT_TOLERANCE | NUMBER | Tolerance percent to be used during the automatic reconciliation for open interface transactions | ||
| MANUAL_RECON_AMOUNT_TOLERANCE | NUMBER | Tolerance amount limit to be used during manual reconciliation | ||
| MANUAL_RECON_PERCENT_TOLERANCE | NUMBER | Tolerance percent to be used during manual reconciliation | ||
| RECON_AP_FOREIGN_DIFF_HANDLING | VARCHAR2 | (30) | Code to indicate how to handle amount differences for AP payments due to currency exchange rate changes during the automatic reconciliation process, G for treating them as currency gain or loss, C for handling them as errors or charges, N for no action. Lookup type: FX_TOL_DIFFERENCES | |
| RECON_AR_FOREIGN_DIFF_HANDLING | VARCHAR2 | (30) | Code to indicate how to handle amount differences for AR receipts due to currency exchange rate changes during the automatic reconciliation process, G for treating them as currency gain or loss, C for handling them as errors or charges, N for no action. Lookup type: FX_TOL_DIFFERENCES | |
| RECON_CE_FOREIGN_DIFF_HANDLING | VARCHAR2 | (30) | Code to indicate how to handle amount differences for CE cashflows due to currency exchange rate changes during the automatic reconciliation process, CH for handling them as charges, E for handling them as errors, FX for handling them as foreign charges. Lookup type: CE_FX_TOL_DIFFERENCES | |
| RECON_AP_TOLERANCE_DIFF_ACCT | VARCHAR2 | (30) | Code to indicate how to handle any amount differences between statement line and AP transaction during the automatic reconciliation process, lookup type TOLERANCE_DIFFERENCES | |
| RECON_CE_TOLERANCE_DIFF_ACCT | VARCHAR2 | (30) | Code to indicate how to handle any amount differences between statement line and CE transaction during the automatic reconciliation process, lookup type TOLERANCE_DIFFERENCES | |
| XTR_BANK_ACCOUNT_REFERENCE | VARCHAR2 | (20) | xtr bank account reference |
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
, BANK_ID
, CURRENCY_CODE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CHECK_DIGITS
, BANK_ACCOUNT_NAME_ALT
, ACCOUNT_HOLDER_ID
, EFT_REQUESTER_IDENTIFIER
, SECONDARY_ACCOUNT_REFERENCE
, ACCOUNT_SUFFIX
, DESCRIPTION_CODE1
, DESCRIPTION_CODE2
, IBAN_NUMBER
, SHORT_ACCOUNT_NAME
, ACCOUNT_OWNER_PARTY_ID
, ACCOUNT_OWNER_ORG_ID
, ACCOUNT_CLASSIFICATION
, AP_USE_ALLOWED_FLAG
, AR_USE_ALLOWED_FLAG
, XTR_USE_ALLOWED_FLAG
, PAY_USE_ALLOWED_FLAG
, MULTI_CURRENCY_ALLOWED_FLAG
, PAYMENT_MULTI_CURRENCY_FLAG
, RECEIPT_MULTI_CURRENCY_FLAG
, ZERO_AMOUNT_ALLOWED
, MAX_OUTLAY
, MAX_CHECK_AMOUNT
, MIN_CHECK_AMOUNT
, AP_AMOUNT_TOLERANCE
, AR_AMOUNT_TOLERANCE
, XTR_AMOUNT_TOLERANCE
, PAY_AMOUNT_TOLERANCE
, AP_PERCENT_TOLERANCE
, AR_PERCENT_TOLERANCE
, XTR_PERCENT_TOLERANCE
, PAY_PERCENT_TOLERANCE
, BANK_ACCOUNT_TYPE
, AGENCY_LOCATION_CODE
, START_DATE
, END_DATE
, ACCOUNT_HOLDER_NAME_ALT
, CASHFLOW_DISPLAY_ORDER
, ACCOUNT_HOLDER_NAME
, MASKED_ACCOUNT_NUM
, MASKED_IBAN
, POOLED_FLAG
, MIN_TARGET_BALANCE
, MAX_TARGET_BALANCE
, EFT_USER_NUM
, INTEREST_SCHEDULE_ID
, ASSET_CODE_COMBINATION_ID
, NETTING_ACCT_FLAG
, CASH_CLEARING_CCID
, BANK_ACCOUNT_NUM_ELECTRONIC
, STMT_LINE_FLOAT_HANDLING_FLAG
, AUTORECON_AP_MATCHING_ORDER
, AUTORECON_AR_MATCHING_ORDER
, RECON_FOREIGN_BANK_XRATE_TYPE
, RECON_FOR_BANK_XRATE_DATE_TYPE
, RECON_ENABLE_OI_FLAG
, RECON_OI_FLOAT_STATUS
, RECON_OI_CLEARED_STATUS
, RECON_OI_MATCHING_CODE
, RECON_OI_AMOUNT_TOLERANCE
, RECON_OI_PERCENT_TOLERANCE
, MANUAL_RECON_AMOUNT_TOLERANCE
, MANUAL_RECON_PERCENT_TOLERANCE
, RECON_AP_FOREIGN_DIFF_HANDLING
, RECON_AR_FOREIGN_DIFF_HANDLING
, RECON_CE_FOREIGN_DIFF_HANDLING
, RECON_AP_TOLERANCE_DIFF_ACCT
, RECON_CE_TOLERANCE_DIFF_ACCT
, XTR_BANK_ACCOUNT_REFERENCE
FROM APPS.CE_BANK_ACCTS_SEARCH_GT_V;
APPS
CE_BANK_ACCOUNTS
CE_BANK_ACCT_USES_ALL
CE_SECURITY_PROFILES_GT
APPS.CE_BANK_ACCTS_SEARCH_GT_V is not referenced by any database object
|
|
|
|