|
This data object is used to show all GL detail transactions in the Fusion business system.
This information is found within the Accounting General Ledger Transaction program within the Fusion business system.
URL
/frw/GeneralLedgerTrans
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AccountType | This field displays the general ledger account type: assets, liability, capital, other revenue, sales revenue, other expenses, and cost of goods sold. |
| AddUser | This field displays the user name that added the record. |
| Amount | This Field Displays the amount of the general ledger transaction. |
| Branch | This field displays the branch associated with a general ledger transaction. |
| BranchDescription | This field displays the branch description of a given general ledger transaction. |
| CheckNumber | This field displays the check number used in a given transaction. |
| CompanyName | This field displays the company name of an A/P vendor associated with the general ledger transaction. |
| Control | This field displays the control value for a given general ledger transaction. |
| CustomerName | This field displays the A/R customer’s name from the customer record. |
| CustomerNumber | This field displays the identifying number attached to a customer. |
| DaysOld | This field displays the difference between the invoice due date and the current date. |
| Department | This field displays the department associated with a general ledger transaction. |
| DepartmentType | This field displays the pre-defined list that a user must tie deferrment to. |
| FiscalYear | This field displays the fiscal year being observed. |
| GLAccount | This field displays the general ledger account number associated with the general ledger transaction. |
| GLDescription | This field displays the general ledger account description associatd with the general ledger transaction. |
| Journal | This field displays the journal source code for a general ledger transaction. |
| JournalReference | This field displays the reference number attached to a given journal. |
| UpdateUser | This field displays the user name of the individual who made the update. |
| NumericCode | This field displays the department code associated with the general ledger account number. |
| OrderBranch | This field displays the branch in which the transactions originated from. |
| OverridePostingDescription | This field displays the override description for a given transaction. |
| PostDate | This field displays the date on which appreciation was posted for a fixed asset. |
| PostMonth | This field displays the month in which a transaction was posted, in MM format. |
| PostYear | This field displays the year in which a transaction was posted, in YYYY format. |
| PostingDescription | This field displays a posting description for an Accounts Payable invoice. |
| PostingPeriod | This field displays the posting period that was used to depreciate a fixed asset. |
| PostingSequence | This field displays the sequence number attached to a posting. |
| IsReconciled | This field displays whether or not an entry has been reconciled. |
| SourceApplication | This field displays the application used to create the general ledger posting. |
| TransactionDate | This field displays the date on which a transaction was created. |
| TransactionDescription | This field displays the description of a transaction. |
| User | This field displays the user name of the user who posted a transaction. |
| Vendor | This field displays the vendor attached to a given A/P invoice. |
| AccountingTransactionID | This field displays the Internal ID of the GL Transaction |