POTRANS

The POTRANS dimension table lists all of the attributes for a purchase request in Axiom Capital Tracking.

The following table lists all of the options available in this dimension table:

NOTE: Some dimension tables are shared across multiple Axiom products. As a result, some of the columns listed in the following table may not display, depending on the Axiom products in which your organization is licensed.

Column	Description
POTRANS	The unique Identity number assigned to each purchase requisition.
Description	The purchase request description.
CAPREQ	The unique identity number for the capital project assigned to each purchase requisition.
PurchReqID	The unique purchase request identification number linked to the ProjectID.
GLPERIOD	The GLPERIOD assigned to the purchase request.
Creator	The username for purchase request creator.
Status	The approval status for the purchase request.
StatusComment	The approval status comments for the purchase request.
ApprovalDate	The approval date for the purchase request.
PO	The PO number assigned for the purchase request.
Vendor	The vendor selected for the purchase request from the Vendor picklist.
RequestNotes	The purchase request notes (same as Description).
DeliverTo	The Deliver To location selected for the purchase request from the Deliver To picklist.
ReqDate	The creation date for the purchase request.
NeedDate	The need-by date for the purchase request.
AttachNotes	The attachment notes for the purchase request.
SentStatus	The sent status for the purchase request. Designates if the purchase request has been sent to the purchasing system when using the integration.
POPicklist01 - POPicklist10	The Picklist01-10 selected for the purchase request from the Picklist01-10 picklists.
POTextField01 - POTextField10	The purchase request header text entries for the TextField01-10 fields.
PR_PM_Routing01 - PR_PM_Routing30	Used for the Manual Process Flow Assignment utility.
Archive	Designates if the purchase request is set as Archived in Axiom Capital Tracking.
ImportRebuild	Designates if the purchase request should be rebuilt if the data was imported into the system from an external data source.
ShowOnListCT	Designates if the purchase request is shown in the workflow and the Open Purchase Request window.