EHI Export Data Dictionary

AX_ItemPR

Data fields for the AX_ItemPR table explained in detail

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

Column	Expanded name	Description
`ItemPRID`	Item Purchase Request ID	A unique identifier for the item purchase request within the system.
`ApprovedUserID`	Approved User ID	The ID of the user who approved the purchase request.
`CreatedUserID`	Created User ID	The ID of the user who created the purchase request.
`DateApproved`	Date Approved	The date when the purchase request was approved.
`DateCreated`	Date Created	The date when the purchase request was created.
`DateNeeded`	Date Needed	The date when the items requested are needed by.
`ItemPRNo`	Item Purchase Request Number	The number assigned to the item purchase request for tracking and reference purposes.
`NoteAC`	Note Audit Comment	A field for additional notes or audit comments regarding the purchase request.
`PRApprovalTaskID`	Purchase Request Approval Task ID	A unique identifier for the task associated with the approval process of the purchase request.
`PRLocID`	Purchase Request Location ID	The ID that identifies the location associated with the purchase request.
`RecptID`	Recipient ID	The identification number of the recipient for the purchase request.
`RecptTypeID`	Recipient Type ID	An identifier for the type of recipient that the purchase request is intended for.
`SiteID`	Site ID	The identifier for the site where the purchase request originated or is to be delivered to.
`VendorID`	Vendor ID	The identifier for the vendor from whom the items are being requested.
`ZUChkSum`	ZU Check Sum	An audit log field used for data integrity checks, representing a checksum value for the record.
`ZUDate`	ZU Date	The date on which this record was last audited or used in an audit log.
`ZULogonHisID`	ZU Logon History ID	A reference to the user logon history ID used for auditing purposes.