JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

CashExternalTransactions

CashExternalTransactions

Columns

Name Type Description
AccountingFlag Bool The option that indicates whether the accounting event is raised when the external transaction is reconciled.
Amount String The transaction amount of the external transaction.
ClearedDate Date The date when the external transaction is cleared.
CreatedBy String The user who created the external transaction.
CreationDate Datetime The date and time when the external transaction was created.
CurrencyCode String The currency code of the external transaction.
Description String The description of the external transaction.
ExternalTransactionId [KEY] String The unique identifier of the external transaction.
LastUpdateDate Datetime The date and time when the external transaction was last updated.
LastUpdateLogin String The session login associated with the user who last updated the external transaction.
LastUpdatedBy String The user who last updated the external transaction.
ReferenceText String The reconciliation reference of the external transaction.
Source String The source of the external transaction. The default value is Imported.
Status String The status of the external transaction. The default value is UNR for Unreconciled. Unreconciled external transactions can be rendered as void by updating this attribute to VOID.
TransactionDate Date The date when the external transaction is created.
TransactionId String The sequence number transaction identifier of the external transaction.
TransactionType String 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.
ValueDate Date The actual value date of the external transaction.
AssetAccountCombination String The cash general ledger account code combination of the external transaction.
OffsetAccountCombination String The offset general ledger account code combination of the external transaction.
BusinessUnitName String The name of the business unit associated to the external transaction.
LegalEntityName String The name of the legal entity associated to the external transaction.
BankAccountName String The name of the bank account associated to the external transaction.
BankConversionRate String The accounting conversion rate used to convert the external transaction amount from the bank account currency to the ledger currency.
BankConversionRateType String The accounting conversion rate type used to convert the external transaction amount from the bank account currency to the ledger currency.
TransferId String The unique identifier of the bank account transfer or the ad hoc payment that created the external transaction.
AccntServicerReference String The reference number assigned by the account servicing institution for the underlying payment, receipt, external transaction, or payroll payment.
AddendaTxt String Additional information about the entry details.
CheckNumber String The check number of the underlying transaction.
ClearingSystemReference String The unique identifier assigned by the clearing system to a payment instruction.
CustomerReference String The customer reference used by BAI format.
EndToEndId String The unique identification assigned by the initiating party to the transaction. It is passed on unchanged throughout the entire end to end chain.
InstructionIdentification String The unique identification which is a point to point reference used between the instructing party and the instructed party to refer to an individual instruction. It is assigned by the instructing party to the instructed party and can be included in several messages related to the instruction.
ReconReference String The reference to the underlying transaction information.
StructuredPaymentReference String The structured payment reference or receipt reference on the bank statement line.
BankTransactionId String Unique identifier of the bank transaction on the statement line.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462