[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_UPGA_BANK_ACCOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | CE |
| FND Design Data: |  CE.CE_UPGA_BANK_ACCOUNTS
|
| Subobject Name: | |
| Status: | VALID |
This table is an audit table of CE_UPG_BANK_ACCOUNTS. This table
stores new CE bank account information for bank upgrade purpose
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CE_BANK_ACCOUNT_ID | NUMBER | (15) | CE bank account identifier | |
| CE_UPGRADE_ID | NUMBER | (15) | Yes | CE upgrade identifier |
| PARENT_UPGRADE_ID | NUMBER | (15) | Yes | Parent CE upgrade identifier |
| UPGRADE_STATUS | VARCHAR2 | (30) | Bank upgrade status. Possible values are SUCCESS, PROCESSED, UNPROCESSED, and INVALID | |
| PRIMARY_ACCT_FLAG | VARCHAR2 | (1) | Flag to indicate if this record is the primary record of the bank account group | |
| SECONDARY_ACCT_FLAG | VARCHAR2 | (1) | Flag to indicate if this record is the secondary record of the bank account group | |
| GROUP_ID | NUMBER | (15) | Bank account group identifier | |
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | Bank account name | |
| CREATED_BY_MODULE | VARCHAR2 | (150) | Created by module | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| 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 | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Bank account number | |
| BRANCH_PARTY_ID | NUMBER | (15) | Bank party identifier | |
| BANK_PARTY_ID | NUMBER | (15) | Bank branch party identifier | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descripitive flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descripitive 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_NAME | VARCHAR2 | (80) | Account holder name | |
| ACCOUNT_HOLDER_NAME_ALT | VARCHAR2 | (80) | Alternate account holder name | |
| 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_NUM | VARCHAR2 | (50) | IBAN number | |
| SHORT_ACCOUNT_NAME | VARCHAR2 | (30) | No longer used | |
| ACCOUNT_OWNER_PARTY_ID | NUMBER | (15) | Bank account owner party identifier in TCA | |
| ACCOUNT_OWNER_ORG_ID | NUMBER | (15) | Bank account owner organization identifier in HR | |
| ACCOUNT_CLASSIFICATION | VARCHAR2 | (30) | 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 is allowed | |
| PAY_USE_ALLOWED_FLAG | VARCHAR2 | (1) | Flag to indicate if the account use for PAY 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_FLAG | VARCHAR2 | (1) | Indicator for allowing or disallowing zero amount | |
| MAX_OUTLAY | NUMBER | (15) | Maximum payment batch | |
| MAX_CHECK_AMOUNT | NUMBER | (15) | Default maximum payment amount allowed for bank account in a payment batch | |
| MIN_CHECK_AMOUNT | NUMBER | (15) | Default minimum payment amount allowed for bank account in a payment batch | |
| AP_AMOUNT_TOLERANCE | NUMBER | (15) | Tolerance amount limit to be used for AP transactions during automatic reconciliation | |
| AP_PERCENT_TOLERANCE | NUMBER | (15) | Tolerance percent to be used for AP transactions during automatic reconciliation | |
| AR_AMOUNT_TOLERANCE | NUMBER | (15) | Tolerance amount limit to be used for AR transactions during automatic reconciliation | |
| AR_PERCENT_TOLERANCE | NUMBER | (15) | Tolerance percent to be used for AR transactions during automatic reconciliation | |
| XTR_AMOUNT_TOLERANCE | NUMBER | (15) | Tolerance amount limit to be used for XTR transactions during automatic reconciliation | |
| XTR_PERCENT_TOLERANCE | NUMBER | (15) | Tolerance percent to be used for XTR transactions during automatic reconciliation | |
| PAY_AMOUNT_TOLERANCE | NUMBER | (15) | Tolerance amount limit to be used for PAY transactions during automatic reconciliation | |
| PAY_PERCENT_TOLERANCE | NUMBER | (15) | Tolerance percent to be used for PAY 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 | ||
| YEAR_CALC_TYPE | VARCHAR2 | (15) | Day count basis which defines the way in which interest accrues over time | |
| INTEREST_CALCULATION_BASIS | VARCHAR2 | (4) | Interest calculation basis (STEP or FLAT) | |
| DAY_COUNT_TYPE_FLAG | VARCHAR2 | (1) | Interest includes | |
| ROUNDING_TYPE_FLAG | VARCHAR2 | (1) | Interest rounding | |
| CASHFLOW_DISPLAY_ORDER | NUMBER | (15) | Cashflow display order | |
| TARGET_BALANCE | NUMBER | (15) | Target bank account balance | |
| EFT_USER_NUM | VARCHAR2 | (30) | EFT user number | |
| BANK_CODE | VARCHAR2 | (30) | Bank code | |
| COMM_AGREEMENT_IDENTIFIER | NUMBER | (15) | Communication agreement identifier | |
| LEGAL_ACCOUNT_NAME | VARCHAR2 | (240) | Legal account name |
Cut, paste (and edit) the following text to query this object:
SELECT CE_BANK_ACCOUNT_ID
, CE_UPGRADE_ID
, PARENT_UPGRADE_ID
, UPGRADE_STATUS
, PRIMARY_ACCT_FLAG
, SECONDARY_ACCT_FLAG
, GROUP_ID
, BANK_ACCOUNT_NAME
, CREATED_BY_MODULE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, BANK_ACCOUNT_NUM
, BRANCH_PARTY_ID
, BANK_PARTY_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_NAME
, ACCOUNT_HOLDER_NAME_ALT
, EFT_REQUESTER_IDENTIFIER
, SECONDARY_ACCOUNT_REFERENCE
, ACCOUNT_SUFFIX
, DESCRIPTION_CODE1
, DESCRIPTION_CODE2
, IBAN_NUM
, 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_FLAG
, MAX_OUTLAY
, MAX_CHECK_AMOUNT
, MIN_CHECK_AMOUNT
, AP_AMOUNT_TOLERANCE
, AP_PERCENT_TOLERANCE
, AR_AMOUNT_TOLERANCE
, AR_PERCENT_TOLERANCE
, XTR_AMOUNT_TOLERANCE
, XTR_PERCENT_TOLERANCE
, PAY_AMOUNT_TOLERANCE
, PAY_PERCENT_TOLERANCE
, BANK_ACCOUNT_TYPE
, AGENCY_LOCATION_CODE
, START_DATE
, END_DATE
, YEAR_CALC_TYPE
, INTEREST_CALCULATION_BASIS
, DAY_COUNT_TYPE_FLAG
, ROUNDING_TYPE_FLAG
, CASHFLOW_DISPLAY_ORDER
, TARGET_BALANCE
, EFT_USER_NUM
, BANK_CODE
, COMM_AGREEMENT_IDENTIFIER
, LEGAL_ACCOUNT_NAME
FROM CE.CE_UPGA_BANK_ACCOUNTS;
CE.CE_UPGA_BANK_ACCOUNTS does not reference any database object
CE.CE_UPGA_BANK_ACCOUNTS is referenced by following:
CE
CE_UPGA_BANK_ACCOUNTS#
|
|
|
|