EHI Export Data Dictionary

AX_GL

General Ledger Transaction Details

27 columns Original: AX_GL Data Dictionary.html Checked Nov 11, 2026, 7:22 PM CST

Column	Expanded name	Description
`GLID`	General Ledger ID	The unique identifier for a General Ledger entry.
`Amt`	Amount	The monetary value associated with the transaction.
`Balance`	Balance	The current balance after the transaction has been recorded.
`CAID`	Current Account ID	Identifier of the current account affected by the transaction.
`CAEntID`	Current Account Entry Details	Details pertaining to the entry in the current account associated with the transaction.
`CAGrpID`	Current Account Group Details	Group classification details of the current account.
`DeptID`	Department Details	Identifying information about the department responsible for or involved in the transaction.
`DescX`	Description X	A description or narrative explaining the nature of the item or entry.
`DtPost`	Date Posted	The date on which the transaction was recorded in the General Ledger.
`DtTrans`	Date Transacted	The date the transaction took place or was initiated.
`GLID_Ref`	General Ledger ID Reference	Reference to a General Ledger ID that is related to this transaction for cross-referencing purposes.
`GLPeriodID`	General Ledger Period Details	Details regarding the fiscal period of the General Ledger entry.
`GLTypeID`	General Ledger Type Details	Categorization details of the General Ledger entry based on the type of transaction.
`IsReverseTrans`	Is Reverse Transaction	Indicates whether the transaction reverses a previously posted transaction.
`IsVoided`	Is Voided	Indicates if the transaction has been voided and should not be considered in current financial calculations.
`ItemPOID`	Item Purchase Order ID	Identifier of the purchase order for the item involved in the transaction.
`PayMethodID`	Payment Method Details	Details about the method of payment used for the transaction.
`RecptID`	Recipient Details	Information about the recipient of goods or services related to the transaction.
`RecptTypeID`	Recipient Type Details	Classification of the recipient as per the predefined recipient types.
`RefText`	Reference Text	Textual reference information that provides additional context for the transaction.
`SiteID`	Site Details	Information specifying the location or site where the transaction is relevant or was recorded.
`SourceID`	Source Details	Details about the origin of the transaction, such as the initiating department or external entity.
`SourceTypeID`	Source Type Details	Classification information about the source of the transaction.
`TransTypeID`	Transaction Type Details	Information describing the nature of the transaction, categorized by predefined transaction types.
`ZUChkSum`	ZU Check Sum	An audit trail checksum value used for data integrity verification in transaction logs.
`ZUDate`	ZU Date	The date associated with the audit log entry used for tracking changes and updates.
`ZULogonHisID`	ZU Logon History Details	Details related to a user's logon session that is captured as part of the system's security and audit logs.