IntercompanyTransactionSourceDocuments
Returns the source documents underlying intercompany transactions, including document, supplier, and transfer authorization details, in Oracle Financials.
Columns
| Name | Type | SupportedFinders | Description |
| CreatedBy | String | The user who created the source document. | |
| CreationDate | Datetime | The date and time when the source document was created. | |
| DocumentAmount | Decimal | Transaction amount for the source document. | |
| DocumentCurrencyCode | String | The currency code for the source document. | |
| DocumentDate | Date | Document date for the source document. | |
| DocumentDescription | String | A brief description about the source document. | |
| DocumentDistributionNumber | Long | Distribution number of the source document. | |
| DocumentLegalEntityId | Long | The unique identifier of the legal entity associated with the source document. | |
| DocumentLineNumber | Long | Document line number of the source document. | |
| DocumentNumber | String | Document number of the source document. | |
| DocumentFirstReferenceId | Long | First reference identifier of the source document. | |
| ErrorMessage | String | Intercompany transaction processing error details. | |
| IntercompanyTrxSourceDocumentId [KEY] | Long | PrimaryKey | The unique identifier of the intercompany transaction source document. |
| IntercompanyTrxSourceNumber | Long | The unique number assigned to intercompany transaction source document. | |
| LastUpdateDate | Datetime | The date when the intercompany transaction source document was last updated. | |
| LastUpdatedBy | String | The user who last updated the intercompany transaction source document. | |
| ProcessingStatusCode | String | Processing status code of the intercompany transaction source document. | |
| TransferAuthorizationGroupId | Long | The unique identifier of the transfer authorization group. | |
| TransferAuthorizationAmount | Decimal | Transaction amount for the transfer authorization. | |
| TransferAuthorizationDescription | String | A brief description about the transfer authorization. | |
| TransferAuthorizationNumber | String | The unique number of the transfer authorization. | |
| TransferAuthorizationReference | String | Reference number for the transfer authorization. | |
| TransferAuthorizationTrxDate | Date | Transaction date for the transfer authorization. | |
| DocumentChartOfAccount | Long | Chart of account of the intercompany transaction source document. | |
| TrxProviderAccountDistribution | String | Provider account code combination of the intercompany transaction. | |
| DocumentAccountDistribution | String | Account code combination for the source document. | |
| SupplierNumber | String | The unique supplier number of the source document. | |
| SupplierName | String | The supplier name on the source document. | |
| SupplierSite | String | The supplier location on the source document. | |
| ApprovalRequiredFlag | Bool | Indicates whether the intercompany transaction approval is required. | |
| IntercompanyAgreementNumber | String | Agreement number associated with the source document. | |
| BusinessUnit | String | Business unit for the source document. | |
| ProviderIntercompanyOrgName | String | Provider organization of the intercompany transaction. | |
| ReceiverIntercompanyOrgName | String | Receiver or beneficiary organization of the intercompany transaction. | |
| LegalEntity | String | Name of the legal entity associated with the intercompany transaction source document. | |
| DocumentAmountType | String | Amount type for the source document. | |
| LedgerName | String | Name of the ledger associated with the intercompany transaction source document. | |
| TransferAuthorizationStatus | String | The current status of the transfer authorization associated with the intercompany transaction source document. | |
| DocumentAction | String | Action type of the source document. Valid values are New Transaction and Reversal Transaction. | |
| DocumentType | String | Document type of the source document. | |
| SourceApplication | String | Source application where the source document is originated from. | |
| TransferAuthorizationAmountType | String | Amount type for the transfer authorization. | |
| ProcessingStatus | String | Processing status of the intercompany transaction. | |
| Notes | String | A brief note or description that's added to the transfer authorization. | |
| DocumentAccountedAmount | Decimal | Amount of the source document in ledger currency. | |
| DocumentAccountedCurrencyCode | String | Currency code of the ledger associated with the source document. | |
| StandardCreditMemoFlag | Bool | Indicates whether intercompany reversals create standard credit memos. | |
| Finder | String | A named finder reference used to filter or locate specific intercompany transaction source documents when querying. |