External Cash Transactions
The External Cash Transactions view object contains information related to external cash transactions such as bank account name, transaction type, reconciliation reference, cleared date, cash account combinations, and so on.
Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.ExternalTransactionExtractPVO
Primary Keys : ExternalTransactionsExternalTransactionId
Initial Extract Date : ExternalTransactionsCreationDate
Incremental Extract Date : ExternalTransactionsLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ExternalTransactionsAccountingFlag | The option that indicates whether the accounting event is raised when the external transaction is reconciled. A list of accepted values is defined in the lookup type YES_NO. |
| ExternalTransactionsAmount | The transaction amount of the external transaction. |
| ExternalTransactionsAssetCcid | The cash general ledger account combination of the external transaction. This is a foreign key to the GL_CODE_COMBINATIONS table. |
| ExternalTransactionsAttribute1 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute10 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute11 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute12 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute13 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute14 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute15 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute2 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute3 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute4 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute5 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute6 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute7 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute8 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttribute9 | A segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeCategory | The descriptive flexfield context name for the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeDate1 | A date segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeDate2 | A date segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeDate3 | A date segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeDate4 | A date segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeDate5 | A date segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeNumber1 | A number segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeNumber2 | A number segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeNumber3 | A number segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeNumber4 | A number segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsAttributeNumber5 | A number segment of the External Cash Transactions descriptive flexfield. |
| ExternalTransactionsBankAccountId | The unique identifier of the bank account associated to the external transaction. This is a foreign key to the CE_BANK_ACCOUNTS table. |
| ExternalTransactionsBusinessUnitId | The identifier of the business unit associated to the external transaction. This is a foreign key to the FUN_ALL_BUSINESS_UNITS_V view. |
| ExternalTransactionsClearedDate | The date when the external transaction is cleared. |
| ExternalTransactionsCreatedBy | The user who created the external transaction. |
| ExternalTransactionsCreationDate | The date and time when the external transaction was created. |
| ExternalTransactionsCurrencyCode | The currency of the external transaction. This is a foreign key to the FND_CURRENCIES table. |
| ExternalTransactionsDescription | The description of the external transaction. |
| ExternalTransactionsExternalTransactionId | The unique identifier of the external transaction. This is the primary key of the External Cash Transactions view object. |
| ExternalTransactionsLastUpdateDate | The date and time when the external transaction was last updated. |
| ExternalTransactionsLastUpdateLogin | The session login associated with the user who last updated the external transaction. |
| ExternalTransactionsLastUpdatedBy | The user who last updated the external transaction. |
| ExternalTransactionsLegalEntityId | The identifier of the legal entity associated to the external transaction. This is a foreign key to the XLE_ENTITY_PROFILES table. |
| ExternalTransactionsObjectVersionNumber | The number of times the external transaction row has been updated. |
| ExternalTransactionsOffsetCcid | The offset general ledger account combination of the external transaction. This is a foreign key to the GL_CODE_COMBINATIONS table. |
| ExternalTransactionsReconHistoryId | The unique identifier of the last reconciliation performed for the external transaction. This is a foreign key to the CE_RECON_HISTORY table. |
| ExternalTransactionsReferenceText | The reconciliation reference of the external transaction. |
| ExternalTransactionsSource | The source of the external transaction. A list of accepted values is defined in the lookup type CE_EXT_TRANSACTION_SOURCE. |
| ExternalTransactionsStatementLineId | The bank statement line identifier from which the external transaction is created. It is updated when the transaction source is STMT. This is a foreign key to the CE_STATEMENT_LINES table. |
| ExternalTransactionsStatus | The status of the external transaction. A list of accepted values is defined in the lookup type CE_EXT_STATUS. |
| ExternalTransactionsTransactionDate | The date when the external transaction is created. |
| ExternalTransactionsTransactionId | The sequence number transaction identifier of the external transaction. |
| ExternalTransactionsTransactionType | The transaction type of the external transaction. Examples include Bank adjustment, Fee, Check, Electronic funds transfer, Interest, Zero balancing, Lockbox, Miscellaneous, and Automated clearing house. A list of accepted values is defined in the lookup type CE_TRX_TYPE. |
| ExternalTransactionsValueDate | The actual value date of the external transaction. |