Custom report objects—Inter-entity transactions
Use the custom report writer (available with your Customization Services or Platform Services subscription) to create inter-entity transaction reports using the following report objects. See Custom Report Writer for detailed information on how to create reports.
| Report object | Description | Column names | Related objects |
|---|---|---|---|
|
Inter-entity transactions |
Contains the fields found in the inter-entity transaction. |
See a list of columns
IET account IET account title IET amount IET base currency IET batch number IET batch title IET department IET department title IET entry date IET exchange rate IET exchange rate date IET exchange rate type IET line number IET location IET location name IET memo IET TR type IET txn amount IET Txn currency Record URL |
See a list of related objects
Source GL entry object Department object Created by Department ID Department title Manager Manager record number Modified by Name Parent Parent department record number Record URL Record number Status When created When modified |
|
Source GL Entry |
Use the Source GL Entry object as the secondary data source. |
See a list of columns
Account Account title Adj Amount Base currency Batch number Batch title Billable Billed Class ID Cleared Cleared Date Contract ID Created by Customer ID Department ID Department title Doc Employee ID Entry date Exchange rate Exchange rate date Exchange rate type Is tax Item ID Line number Location ID Location name Memo Modified by Project ID Reconciliation date Record URL Record number State TR type Tax details Time period Txn amount Txn currency User number Vendor ID When created When modified |
See a list of related objects
GL account object Account number Account type Category Class Close into account Close-to account record number Contract Created at: entity ID Created at: entity key Created at: entity name Created by Customer Department Disallow direct posting Employee GL account alternative Item Location M-3 return code Modified by Normal balance Period end closing type Project Record URL Require UDD Status Tax return code Taxable Title Vendor When created When modified GL batch object Accounting sequence number Balance Created at: Entity ID Created at: Entity key Created at: Entity name Created by Description Journal Last modified date and time Modified by Module Posting date Record URL Record number Reference no. Reversed date Scheduled operation key State Transaction number When created When modified Location object Base currency Created by Default country for addresses End date Location ID Manager Modified by Name Parent Record number Start date Status Tax ID When created When modified |
