JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9539

IntercompanyAgreements

Represents the intercompany agreement, which defines the attributes, currency settings, organizations, and process controls used when transferring funds between intercompany organizations.

Columns

Name Type Description
AllowInvoicingFlag Bool Indicates whether the intercompany agreement follows the invoicing flow or general ledger flow. This information is derived from the transaction type.
CreatedBy String The user who created the record.
CreationDate Datetime The date and time when the record was created.
CurrencyCode String The code that represents the currency defined in the intercompany agreement. The transaction might be initiated in a different currency but can be converted to the agreement currency if needed.
Description String A brief description of the intercompany agreement.
LastUpdateDate Datetime The date and time when the record was last updated.
LastUpdatedBy String The user who last updated the record.
IntercompanyAgreementId [KEY] Long The unique identifier of the intercompany agreement.
IntercompanyAgreementNumber String The unique number assigned to the intercompany agreement.
ProviderIntercompanyOrgName String The name of the provider intercompany organization.
CurrencyConversionType String The conversion rate type for currency conversion, defined in the intercompany agreement.
TransactionTypeName String The transaction type of the intercompany agreement. All transactions in a intercompany agreement must have the same transaction type.
FirstClearingOrgName String The name of the first clearing organization.
SecondClearingOrgName String The name of the second clearing organization.
SettlementCurrencyBasis String The basis for converting amounts from transaction currency to settlement currency.
Status String The status of the intercompany agreement.
ActivationDate Date The date when the intercompany agreement status is set to active.
ClosureDate Date The date when the intercompany agreement is closed.
ControlAmount Decimal The control amount of the intercompany agreement.
RunningTotalAmount Decimal The running total amount of the valid transfer authorizations created for an intercompany agreement.
NumberOfTransferAuthorizations Int The total number of transfer authorizations created for an intercompany agreement.
ReceiverIntercompanyOrgName String The name of the receiver intercompany organization.
TransferAuthorizationNumber String The unique number assigned to the transfer authorization.
AmountType String The abbreviated name that uniquely identifies the amount type (for example, Principal, Interest, and Expense). These values are used for reporting.
TransactionDate String The transaction date of the intercompany transaction.
TransactionTypeCode String The transaction type of the intercompany agreement. All transactions in a intercompany agreement must have the same transaction type.
SourceDocumentNumber String The document number of the source document.
RunningTotalCurrencyCode String The code that represents the currency of the transfer authorization group.
Finder String The finder column allowing searching with various finder attributes.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539