CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

IntercompanyAgreementstransferAuthorizationGroupstransferAuthorizationstransactions

The transactions represents intercompany transaction information that's generated from a transfer authorization.

Columns

Name Type Description
IntercompanyAgreementsIntercompanyAgreementId [KEY] Long The unique identifier of the intercompany agreement.
TransferAuthorizationGroupsTransferAuthorizationGroupId [KEY] Long The unique identifier of the transfer authorization group.
TransferAuthorizationsTransferAuthorizationId [KEY] Long The unique identifier of the transfer authorization.
ApInvoiceId Long The unique identifier of the payables invoice.
ArCustomerTrxId Long The unique identifier of the receivables invoice.
ArInvoiceNumber String The unique number assigned to the supplier invoice.
CreatedBy String The user who created the record.
CreationDate Datetime The date and time when the record was created.
Description String A brief description of the intercompany transaction.
SettlementAmount Decimal Settlement amount calculated in settlement currency which is received by the receiver organization
SettlementCurrencyCode String The code representing the currency in which the transaction amount is received by the receiver.
ErrorReason String Lists transaction error reason details.
ExchangeRate Decimal The conversion rate used to convert the transaction currency to the ledger currency of the receiving organization.
ExchangeRateDate Date The date as of which a conversion rate is used to convert the transaction currency to the ledger currency of the receiving organization.
IntercompanyTrxNumber String Intercompany transaction number generated based on the intercompany organization short codes.
LastUpdateDate Datetime The date and time when the record was created.
LastUpdatedBy String The user who last updated the record.
ProviderJeHeaderId Long The unique identifier of the provider ledger journal.
ReceiverJeHeaderId Long The unique identifier of the receiver ledger journal.
RejectReason String Reason for rejection of the intercompany transaction.
TransactionAmount Decimal Transaction amount of the intercompany transaction.
TransactionCurrencyCode String The code representing the currency in which the transaction is initiated.
TransactionDate Date Transaction date of the intercompany transaction.
TrxId [KEY] Long The unique identifier of the intercompany transaction.
TrxNumber Decimal Transaction number of the intercompany transaction.
ProviderIntercompanyOrgName String Initiator of the intercompany transaction.
ReceiverIntercompanyOrgName String Receiver of the intercompany transaction.
UserConversionType String The currency conversion type to convert the transaction currency to the ledger currency of the receiving organization.
SettlementCurrencyBasis String Basis for currency conversion from transaction currency to settlement currency that's defined for the intercompany agreement.
TransactionStatus String Status of the intercompany transaction.
CustomerAccountName String Customer account name of the transaction recipient.
SupplierName String Supplier name of the transaction initiator.
CustomerAccountSite String The site code of the customer account site. The code representing the bill-to customer site assigned to the transaction.
SupplierSite String The site code of the supplier site. The code representing the ship-to customer site assigned to the transaction.
RouteType String Route type of the intercompany multitier transaction.
ApInvoiceNumber String The unique number assigned to the customer invoice.
ProviderGLJournalName String Journal entry header name of the provider.
ReceiverGLJournalName String Journal entry header name of the receiver.
ProviderJeBatchId Long The unique identifier of the provider ledger journal batch.
ReceiverJeBatchId Long The unique identifier of the receiver ledger journal batch.
ReceivablesTrxClass String The class type of the receivables transaction.
Finder String The finder column allowing searching with various finder attributes.
IntercompanyAgreementId Long The unique identifier of the intercompany agreement.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454