CashTransaction
The cash transaction provides the details of the external transactions related to cash activity that isn't recorded within the application, such as bank charges or interest transactions created from bank statement lines, bank account balance adjustments, bank statement reconciliation differences, transactions imported from third-party systems and so on.
Business Views
** Available for extracting data- cashTransactionsExtract**
The cash transaction provides the details of the external transactions related to cash activity that isn't recorded within the application, such as bank charges or interest transactions created from bank statement lines, bank account balance adjustments, bank statement reconciliation differences, transactions imported from third-party systems and so on.
Label, Plural Label
Cash Transactions, Cash Transactions
Data Source
Read-optimized data store
Fields
- accountingEnabledFlag (boolean)
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.
Label
Account transaction
Properties
- not nullable
- amount (big-decimal)
The transaction amount of the external transaction.
Label
Amount
Properties
- not nullable
- clearedDate (date)
The date when the external transaction is cleared.
Label
Clearing Date
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- description (string)
The description of the external transaction.
Label
Description
- id (int64)
The unique identifier of the external transaction. This is the primary key of the External Cash Transactions view object.
Label
External cash transaction identifier
Properties
- searchable
- sortable
- not nullable
- reconciliationReferenceText (string)
External transaction reconciliation reference.
Label
Reference
- status (enumeration: CashTransactionStatus)
The status of the external transaction. A list of accepted values is defined in the lookup type CE_EXT_STATUS.
Label
Status
Type
-
Module: oraErpCoreCashEntries
-
Enumeration Type: CashTransactionStatus
Valid Values
- REC
- UNR
- VOID
-
- timeCreated (date-time)
The date and time when the record was created.
Label
Time Created
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated
Properties
- searchable
- not nullable
- transactionDate (date)
The date when the external transaction is created.
Label
Date
Properties
- not nullable
- transactionNumber (int64)
The sequence number transaction identifier of the external transaction.
Label
Transaction Number
Properties
- not nullable
- transactionSource (enumeration: CashTransactionSource)
The source of the external transaction. A list of accepted values is defined in the lookup type CE_EXT_TRANSACTION_SOURCE.
Label
Origin
Type
-
Module: oraErpCoreCashEntries
-
Enumeration Type: CashTransactionSource
Properties
- not nullable
Valid Values
- IMPORTED
- MANUAL
- ORA_AHP
- ORA_BAT
- RECON_DIFF
- RECON_REVERSAL
- STMT
-
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- valueDate (date)
The actual value date of the external transaction.
Label
Value Date
Reference Object
- bankAccount (BankAccount)
The bank account provides the details of the internal bank accounts of a company that are used to receive payments and disburse funds. It contains legal entity-level bank account information. Each bank account must be affiliated with one bank branch.
Business Object
BankAccountFields
- id (int64)
Unique identifier for the bank account.
Label
Bank Account ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- bankAccountStatementLine (BankAccountStatementLine)
The bank account statement lines contain information related to bank statement lines, such as line number, booking date, transaction code, transaction type, reconciliation reference, transaction amount, transaction identification information, and so on. It includes reconciled and unreconciled bank statements lines.
Business Object
BankAccountStatementLineFields
- id (int64)
The unique identifier of the bank statement line. This is the primary key of the Bank Statement Lines view object.
Label
Statement Line Identifier
Properties
- searchable
- sortable
- not nullable
- id (int64)
- businessUnit (BusinessUnit)
A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- cashAccount (GeneralLedgerAccount)
Cash general ledger account to be used when the external transaction is accounted.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- currency (Currency)
A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- legalEntity (LegalEntity)
A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.
Business Object
LegalEntityFields
- legalEntityId (int64)
The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.
Label
Legal Entity ID
Properties
- searchable
- sortable
- not nullable
- legalEntityId (int64)
- offsetAccount (GeneralLedgerAccount)
Offset general ledger account to be used when the external transaction is accounted.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- reconciliationGroup (BankReconciliationGroup)
A bank reconciliation group contains the grouping, status, and details of reconciliation actions performed on a bank account, including information about the reconciliation matching and tolerance rules used, and whether the reconciliation was performed automatically. Each reconciliation group helps track which transactions and transaction sources were reconciled over time and supports the review of reconciliation history.
Business Object
BankReconciliationGroupFields
- id (int64)
Identifier of the bank reconciliation group.
Label
Bank Reconciliation Group ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- transactionType (ERPLookupCode)
Transaction type of the external cash transactions. Valid values include Fee, Check, and Interest.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- accountingEnabledFlag (boolean)