AX_JE

Data Dictionary for Journal Entry Table

Original Column Name Expanded Column Name Description
JEID Journal Entry ID Unique identifier for a journal entry in the system.
Amt Amount The monetary amount associated with the journal entry.
Balance Balance The current balance after the journal entry is recorded.
CAID Chart of Accounts ID Identifier for the chart of accounts line item affected by the journal entry.
Date Created Date Created The date when the journal entry was created.
DeptID Department ID Identifier for the department associated with the journal entry.
Details Department Details Detailed information about the department associated with the journal entry.
Desc X Description A description of the journal entry or the transaction detail.
Emp Details Employee Details Information about the employee associated with the journal entry.
GLPeriodID General Ledger Period ID Identifier for the financial period in the General Ledger to which the journal entry relates.
GLPeriod Details General Ledger Period Details Description of the financial period in the General Ledger associated with the journal entry.
GLType Details General Ledger Type Details Description and details pertaining to the type of the General Ledger.
Is Reverse Trans Is Reverse Transaction Indicates whether the journal entry corresponds to a reversing transaction.
Item POID Item Purchase Order ID Identifier for the purchase order related to the journal entry item.
JEID_ Ref Journal Entry ID Reference Reference to another journal entry ID that is related to this entry.
Obj Details Object Details Additional information about the object or category affected by the journal entry.
Obj Type Details Object Type Details Details about the type of object affected by the journal entry.
Pay Method Details Payment Method Details Information regarding the payment method used in the transaction.
Recipient Details Recipient Details Information about the recipient involved in the journal entry transaction.
Recipient Type Details Recipient Type Details Specifications about the type of recipient for the journal entry.
Ref No Reference Number A unique number to identify and reference the journal entry.
Ref Text Reference Text Textual reference or notes associated with the journal entry.
Site Details Site Details Information about the site or location related to the journal entry.
Source Details Source Details Information about the source of the journal entry or transaction.
Source Type Details Source Type Details Details on the type of source providing the journal entry information.
Status Status The current status of the journal entry (e.g., posted, pending, reversed).
Trans Type Details Transaction Type Details Details concerning the type of transaction the journal entry represents.
ZUChk Sum ZU Checksum Checksum value used for audit trail verification in the system.
ZUDate ZU Date Date associated with the Zone Update, typically used for audit purposes.
ZULogon His Details ZU Logon History Details Details of the user logon history used for system auditing and tracking.