EHI Export Data Dictionary

AX_GLSBAT

Expanded Names and Descriptions for General Ledger Sub-Batch Table

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

Column	Expanded name	Description
`GLSBATID`	General Ledger Sub-Batch ID	Unique identifier for a sub-batch within the general ledger.
`Amt`	Amount	Total financial value handled in the sub-batch.
`Balance`	Balance	Current outstanding balance after transactions in the sub-batch.
`CAID`	Cash Account ID	Identifier for the cash account involved in the sub-batch.
`CAGrpID`	Cash Account Group ID	Identifier for the group of cash accounts the transaction belongs to.
`DeptID`	Department ID	Identifier for the department responsible for the sub-batch.
`DescX`	Description	Detailed narrative explaining the purpose or contents of the sub-batch.
`DtClr`	Date Cleared	Date when the sub-batch was finalized and cleared.
`DtPost`	Date Posted	Date when the sub-batch was officially posted to the general ledger.
`DtTrans`	Date Transaction	Date when the actual transactions within the sub-batch occurred.
`EmpID`	Employee ID	Identifier for the employee related to the transactions in the sub-batch.
`GLID`	General Ledger ID	Identifier for a specific entry within the general ledger.
`GLSBATID_Ref`	General Ledger Sub-Batch ID Reference	Referential ID linking the sub-batch to other related records or entries.
`IsCleared`	Is Cleared	Indicator specifying whether the sub-batch has been cleared (true/false).
`IsPrint`	Is Printed	Indicator showing if the sub-batch records have been physically printed (true/false).
`IsVoided`	Is Voided	Indicator of whether the sub-batch has been voided or invalidated (true/false).
`ItemPOID`	Item Purchase Order ID	Identifier of the purchase order related to the transaction items.
`PayMethodID`	Payment Method ID	Identifier for the payment method used in the transactions.
`RecptID`	Recipient ID	Identifier for the recipient of funds or transactions.
`RecptTypeID`	Recipient Type ID	Identifier for the type or category of the transaction recipient.
`RefNo`	Reference Number	Unique reference number for identifying the sub-batch.
`RefText`	Reference Text	Additional text providing context or details related to the reference number.
`SiteID`	Site ID	Identifier for the physical or logical site related to the transaction.
`TransTypeID`	Transaction Type ID	Identifier defining the type of transaction within the sub-batch.
`ZUChkSum`	ZU Check Sum	Checksum value used for data integrity verification in audit logs.
`ZUDate`	ZU Date	Date and time when an entry was used or modified for audit purposes.
`ZULogonHisID`	ZU Logon History ID	Identifier for a specific user logon event for auditing.