[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_CASHFLOWS |
|---|---|
| Object Type: | TABLE |
| Owner: | CE |
| FND Design Data: |  CE.CE_CASHFLOWS
|
| Subobject Name: | |
| Status: | VALID |
Table for storing Cashflows
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CE_CASHFLOWS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CASHFLOW_ID
CASHFLOW_STATUS_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CASHFLOW_ID | NUMBER | (15) | Yes | Unique cashflow reference number created by the system |
| CASHFLOW_LEDGER_ID | NUMBER | Yes | Ledger ID of cashflow | |
| CASHFLOW_LEGAL_ENTITY_ID | NUMBER | (15) | Yes | Legal Entity identifier of cashflow owner |
| CASHFLOW_BANK_ACCOUNT_ID | NUMBER | (15) | Yes | Identifier of the bank account that owns the cashflow. Links to the internal bank accounts table |
| CASHFLOW_DIRECTION | VARCHAR2 | (30) | Yes | Values Include: PAYMENT and RECEIPT (Payment and Receipt) |
| CASHFLOW_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Payment Currency Code |
| CASHFLOW_DATE | DATE | Yes | Cashflow date | |
| CASHFLOW_AMOUNT | NUMBER | Yes | Cashflow amount in cashflow trx currency | |
| BASE_AMOUNT | NUMBER | Yes | Cashflow Amount in functional currency | |
| DESCRIPTION | VARCHAR2 | (255) | Free text description | |
| CASHFLOW_EXCHANGE_RATE | NUMBER | Cashflow exchange rate | ||
| CASHFLOW_EXCHANGE_DATE | DATE | Cashflow exchange date | ||
| CASHFLOW_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Cashflow exchange rate type | |
| TRXN_REFERENCE_NUMBER | NUMBER | (15) | Payment transaction identifier | |
| BANK_TRXN_NUMBER | VARCHAR2 | (100) | Bank Transaction Number to be used in reconciliation match | |
| SOURCE_TRXN_TYPE | VARCHAR2 | (30) | Yes | Source Transaction Type |
| SOURCE_TRXN_SUBTYPE_CODE_ID | VARCHAR2 | (30) | Transaction sub-type code identifier | |
| STATEMENT_LINE_ID | NUMBER | (15) | Statement Line ID required for reconciliation of JEC and ZBA flows | |
| ACTUAL_VALUE_DATE | DATE | The actual value date on which the cashflow is settled by the bank. Populated upon clearing or reconciliation. | ||
| COUNTERPARTY_PARTY_ID | NUMBER | (15) | TCA HZ identifier of counterparty | |
| COUNTERPARTY_BANK_ACCOUNT_ID | NUMBER | (15) | Identifier of the counter party''s bank account.Links to the internal and external bank accounts table | |
| OFFSET_CCID | NUMBER | (15) | CCID of non-cash GL account used in seeded accounting definition for clearing event | |
| CASHFLOW_STATUS_CODE | VARCHAR2 | (30) | Yes | Value include Created, Cleared, Reconciled, Canceled |
| CLEARED_DATE | DATE | Date on which the cashflow was cleared by the bank | ||
| CLEARED_AMOUNT | NUMBER | Cash flow amount (in bank account currency) as returned from the bank upon clearing or reconciliation | ||
| CLEARED_EXCHANGE_RATE | NUMBER | Exchange rate used to calculate cleared base amount(functional currency) from cleared amount (bank account currency) | ||
| CLEARED_EXCHANGE_DATE | DATE | Exchange date used to calculate cleared base amount (functional currency) from cleared amount (bank account currency). | ||
| CLEARED_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type used to calculate cleared base amount (functional currency) from cleared amount (bank account currency) | |
| CLEARING_CHARGES_AMOUNT | NUMBER | Charges amount in bank account currency as returned from bank upon clearing or reconciliation | ||
| CLEARING_ERROR_AMOUNT | NUMBER | Clearing error amount in bank account currency as returned from bank upon clearing or reconciliation | ||
| CLEARED_BY_FLAG | VARCHAR2 | (1) | Flag to include whether cashflow is cleared by Manual Clearing or Reconciliation Values : M, R | |
| REFERENCE_TEXT | VARCHAR2 | (80) | Reference Text | |
| BANK_ACCOUNT_TEXT | VARCHAR2 | (30) | Bank Account Text | |
| CUSTOMER_TEXT | VARCHAR2 | (80) | Customer Text | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CASHFLOW_ID
, CASHFLOW_LEDGER_ID
, CASHFLOW_LEGAL_ENTITY_ID
, CASHFLOW_BANK_ACCOUNT_ID
, CASHFLOW_DIRECTION
, CASHFLOW_CURRENCY_CODE
, CASHFLOW_DATE
, CASHFLOW_AMOUNT
, BASE_AMOUNT
, DESCRIPTION
, CASHFLOW_EXCHANGE_RATE
, CASHFLOW_EXCHANGE_DATE
, CASHFLOW_EXCHANGE_RATE_TYPE
, TRXN_REFERENCE_NUMBER
, BANK_TRXN_NUMBER
, SOURCE_TRXN_TYPE
, SOURCE_TRXN_SUBTYPE_CODE_ID
, STATEMENT_LINE_ID
, ACTUAL_VALUE_DATE
, COUNTERPARTY_PARTY_ID
, COUNTERPARTY_BANK_ACCOUNT_ID
, OFFSET_CCID
, CASHFLOW_STATUS_CODE
, CLEARED_DATE
, CLEARED_AMOUNT
, CLEARED_EXCHANGE_RATE
, CLEARED_EXCHANGE_DATE
, CLEARED_EXCHANGE_RATE_TYPE
, CLEARING_CHARGES_AMOUNT
, CLEARING_ERROR_AMOUNT
, CLEARED_BY_FLAG
, REFERENCE_TEXT
, BANK_ACCOUNT_TEXT
, CUSTOMER_TEXT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM CE.CE_CASHFLOWS;
CE.CE_CASHFLOWS does not reference any database object
CE.CE_CASHFLOWS is referenced by following:
APPS
CE_CASHFLOWS
|
|
|
|