CE_BANK_ACCOUNT_CASH_CCIDS
This table stores the cash account flexfield identifiers for bank accounts that use multiple cash accounts for bank statement reconciliation. The cash account combinations are used to retrieve eligible journal lines for reconciliation, and the general ledger book balance to be displayed in the Cash to GL Reconciliation report.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CE_BANK_ACCOUNT_CASH_CCIDS_PK |
BANK_ACCOUNT_ID, CASH_CCID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
BANK_ACCOUNT_ID | NUMBER | 18 | Yes | Bank account identifier. Foreign key to CE_BANK_ACCOUNTS | |
CASH_CCID | NUMBER | 18 | Yes | Accounting flexfield identifier for the cash account. Foreign key to GL_CODE_COMBINATIONS | |
CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Key flexfield structure instance identifier. | |
LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier for the bank account. Foreign key to GL_LEDGERS | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CE_BANK_ACCOUNT_CASH_CCIDS | ce_bank_accounts | BANK_ACCOUNT_ID |
CE_BANK_ACCOUNT_CASH_CCIDS | gl_code_combinations | CASH_CCID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CE_BANK_ACCOUNT_CASH_CCIDS_N1 | Non Unique | Default | CASH_CCID |
CE_BANK_ACCOUNT_CASH_CCIDS_U1 | Unique | Default | BANK_ACCOUNT_ID, CASH_CCID |