External Cash Transactions

The Oracle Fusion Cash Management transactions related to cash activity that was not recorded within the application. For example, transactions created from bank statement lines for bank charges.

QName: {http://xmlns.oracle.com/apps/financials/cashManagement/cashTransactions/service/}ExternalTransactionsVOSDO

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Handled by

External Cash Transaction

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountingFlag

boolean

Indicates if accounting should be enabled for the external transaction.

Amount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The transaction amount of the external transaction.

AssetCcid

long

The Asset GL Account ID of the external transaction.

Attribute1

string

The descriptive flexfield attribute of the external transaction.

Attribute10

string

The descriptive flexfield attribute of the external transaction.

Attribute11

string

The descriptive flexfield attribute of the external transaction.

Attribute12

string

The descriptive flexfield attribute of the external transaction.

Attribute13

string

The descriptive flexfield attribute of the external transaction.

Attribute14

string

The descriptive flexfield attribute of the external transaction.

Attribute15

string

The descriptive flexfield attribute of the external transaction.

Attribute2

string

The descriptive flexfield attribute of the external transaction.

Attribute3

string

The descriptive flexfield attribute of the external transaction.

Attribute4

string

The descriptive flexfield attribute of the external transaction.

Attribute5

string

The descriptive flexfield attribute of the external transaction.

Attribute6

string

The descriptive flexfield attribute of the external transaction.

Attribute7

string

The descriptive flexfield attribute of the external transaction.

Attribute8

string

The descriptive flexfield attribute of the external transaction.

Attribute9

string

The descriptive flexfield attribute of the external transaction.

AttributeCategory

string

The descriptive flexfield attribute category of the external transaction.

AttributeDate1

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flex field attribute

AttributeDate2

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flex field attribute

AttributeDate3

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flex field attribute

AttributeDate4

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flex field attribute

AttributeDate5

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flex field attribute

AttributeNumber1

decimal

Descriptive flex field attribute

AttributeNumber2

decimal

Descriptive flex field attribute

AttributeNumber3

decimal

Descriptive flex field attribute

AttributeNumber4

decimal

Descriptive flex field attribute

AttributeNumber5

decimal

Descriptive flex field attribute

BankAccountId

long

The bank account ID of the external transaction.

BusinessUnitId

long

The business unit ID of the external transaction.

ClearedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The transaction cleared date of the external transaction.

CurrencyCode

string

The currency code of the transaction amount entered for the external transaction.

Description

string

The transaction description of the external transaction.

ExternalTransactionId

long

The unique primary key for the external transaction generated by the application.
  • Primary Key

LegalEntityId

long

The legal entity ID of the external transaction.

ObjectVersionNumber

int

The attribute tracking the number of updates to the record which is automatically updated.

OffsetCcid

long

The Offset GL Account ID of the external transaction.

ReconHistoryId

long

The transaction reconciliation history ID of the external transaction.

ReferenceText

string

The transaction reference of the external transaction.

Source

string

he transaction source of the external transaction. Valid values are Imported, Manual, Bank Statement, and Ad Hoc Payments.

StatementLineId

long

The bank statement line ID that generated the external transaction.

Status

string

The external transaction status. Valid values are Reconciled, Unreconciled, and Voided.

TransactionDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The transaction date of the external transaction.

TransactionId

long

The sequential number of the external transaction.

TransactionType

string

The transaction type of the external transaction. Valid values are Fee, Check, Interest, and Electronic Funds Transfer (EFT).

ValueDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The value date of the external transaction.