Purchase Order Columns
Prism enables users to customize grid layouts in many program areas. Among the areas where grids can be customized is Purchase Orders. You can specify the columns displayed in the UI and select columns that can be added on the fly by the user when working in that area. Define grid formats in Admin Console > Preferences & Settings > Grid Formats. You can customize grids for the following areas related to purchase orders:
- Purchase Orders
- Purchase Order Lookup
Purchase Orders
| Column Label | Type(Length) | Description |
|---|---|---|
| Allocation Pattern | NUMBER(10) | Identifies the allocation pattern used on the PO. |
| Alt Alu | NVARCHAR2(20) | Alternate ALU (used for items that can be ordered from multiple vendors). The ALU used by the vendor of this PO. |
| Alt Cost | NUMBER(16,4) | Alternate Cost (used for items that can be ordered from multiple vendors). The Cost used by the vendor of this PO. |
| Alt Upc | NUMBER(18) | Alternate UPC (used for items that can be ordered from multiple vendors). The Alternate UPC used by the vendor of this PO. |
| Alt Vend Code | NVARCHAR2(6) | Alternate Vendor Code (used for items that can be ordered from multiple vendors) |
| ALU | NVARCHAR2(2) | Alternate Lookup. Used as an item identifier and for item lookups. |
| Archived | NUMBER(1) | PO Archived status. |
| Attribute | NVARCHAR2(8) | Attribute of the selected PO item. |
| Created By | NVARCHAR2(30) | Employee who created the PO. |
| Created Date | TIMESTAMP(0) WITH TIME ZONE | Date the PO was created. |
| Currency | NUMBER(5) | If the items are being ordered from a vendor in a foreign country, the Currency field displays the currency assigned in the vendor record. |
| Dcs Code | NVARCHAR2(6) | DCS Code of the selected PO item. |
| Ext Cost | NUMBER(16,4) | Extended Cost of the selected PO item. |
| Ext FC Cost | NUMBER(16,4) | Extended Cost, in the vendor's currency, of the selected PO item. |
| Ext Price | NUMBER(16,4) | Extended Price of the selected PO item. |
| Fc Cost | NUMBER(16,4) | Cost, in the vendor's currency, of the selected PO item. |
| Item Note1 - Item Note10 | NVARCHAR2(350) | Optional item notes |
| Itemsize | NARCHAR2(8) | Item size. |
| ItemUid | NUMBER(5) | Item UID. |
| Modified By | NVARCHAR2(30) | Employee who last modified the PO. |
| Modified Date | TIMESTAMP(0) WITH TIME ZONE | Date the PO was last modified. |
| Order Due Qty | NUMBER(10,3) | The Order Qty minus the Received Quantity. Indicates the quantity yet to be received. |
| Ord Qty | NUMBER(10,3) | Will hold sum of all order quantities for the selected PO item for all stores. |
| PO Cost | NUMBER(16,4) | Cost of the item. By default, the PO Cost is drawn from the current Cost in Inventory for the item. |
| Post Date | DATE | Date the PO was posted to the RIL database. |
| Price | NUMBER(16,4) | Price of the item. By default, the PO Price is drawn from the current Price in Inventory for the item. |
| Receive Qty | NUMBER(10,3) | Will hold sum of all receive quantities for the selected PO item for all stores. |
| Src Sbs No | The subsidiary that was the source for the PO. | |
| Tax Perc | NUMBER(16,4) | Tax percentage applied to the PO. |
| Tax Perc 2 | NUMBER(16,4) | If multiple tax areas are involved, the second tax percentage applied to the PO. |
| Trade Disc % | NUMBER(16,4) | A discount given by a vendor. The Trade Discount % is applied to any new inventory items from that vendor. The Trade Discount % is applied to each applicable item's List Cost to calculate Order Cost. If using trade discounts, Order Cost is automatically used on purchase orders and vouchers, and vouchers are unable to update an item's Order Cost. |
| UDF Value1 - UDF Value4 | NVARCHAR2(50) | User-defined field values. |
| Upc | NUMBER(18) | Universal product code. |
| Vendor Code | NVARCHAR2(6) | Vendor Code. |
| Vendor List Cost | NUMBER(16,4) | Vendor list cost for the item (does not reflect discounts such as trade discounts). |
| Vendor Name | NVARCHAR2(2) | Vendor name. |
Purchase Order Lookup
| Column Label | Type | Description |
|---|---|---|
| Active | NUMBER(1) | Active Status |
| Address1 - Address6 | NVARCHAR2(60) | Address fields. |
| Approved Date | DATE | Date the PO was approved (pending POs) |
| Approved Notes | NVARCHAR2(255) | Notes entered when the PO was approved. |
| Approved Status | NUMBER(5) | Approved status. 0 = not approved, 1 = approved. |
| Archived | NUMBER(5) | Archived status. 0 = not archived, 1 - archived. |
| Associate | NUMBER(5) | Identifies the Associate who created the PO. |
| Bill To Address1 - Bill To Address6 | NVARCHAR2(40) | Address fields of the Bill To store for the PO. |
| Bill To Store Name | NVARCHAR2(40) | Store Name of the Bill To store for the PO. |
| Bill To Store Number | NUMBER(5) | Store Number of the Bill To store for the PO. |
| Bill To Zip | NVARCHAR2(10) | Postal Code of the Bill To store for the PO. |
| Cancel Dt | DATE | Cancel date. |
| CMS | NUMBER(1) | Indicates the PO was posted to the RIL database. 0 = Not posted, 1 = posted. |
| CMS Post Date | DATE | Date the PO was posted to the RIL database. |
| Controller | NUMBER(5) | Controller number. |
| Created By | NVARCHAR2(30) | Employee who created the PO. |
| Created Date | TIMESTAMP(0) WITH TIME ZONE | Date the PO was created. |
| Cust Fld | NVARCHAR2(47) | Custom field (used with customizations). |
| Diagnose | NUMBER(5) | Diagnose status. |
| Disc Amt | NUMBER(16,4) | Discount amount applied to the PO. |
| Disc Perc | NUMBER(10,3) | Discount percentage applied to the PO. |
| Disc Type | NUMBER(1) | 0 = Use Percentage, 1 = Use Amount |
| Doc Ref No | NUMBER(10) | Number of document referenced by this PO. For example, if the PO was generated from an SO, this field will display the SO number. |
| Due Qty | NUMBER(10,3) | Quantity ordered that has yet to be received on vouchers (Order Qty - Received Qty) |
| Edi Date | EDI Date (legacy field) | |
| Employee ID | NUMBER(10) | Identifies the employee who created the PO. |
| From So | NUMBER(1) | From SO status. 0 = Not generated from SO, 1 = Generated from SO |
| Held | NUMBER(1) | Held status. 0 = Not Held, 1 =Held. |
| Instruction1 - Instruction5 | NVARCHAR2(60) | PO Instructions. Special handling or billing instructions. |
| Line Items | NUMBER(5) | Number of line items on the PO. |
| Lst Activity Date | DATE | Date of the last activity against the PO. For example, the last date a voucher referencing the PO was updated. |
| Marked For Address1 - Marked For Address6 | NVARCHAR2(40) | Address fields of the Marked For store. |
| Marked For Store Name | NVARCHAR2(20) | Name of the store where the items on a Marked For PO will be shipped. |
| Marked For Store Number | NUMBER(5) | Number of the store where the items on a Marked For PO will be shipped. |
| Marked For Zip | NVARCHAR2(10) | Postal Code of the store where the items on a Marked For PO will be shipped. |
| Modified By Employee | NVARCHAR | Employee who last modified the PO. |
| Modified Date | TIMESTAMP(0) WITH TIME ZONE | Date the PO was last modified. |
| Note | NVARCHAR2 (255) | Optional note text. |
| Order Qty | NUMBER(10,3) | Total ordered quantity for the whole PO. |
| Orig Qty | NUMBER(10,3) | |
| Orig Controller | NUMBER10) | Original controller. |
| Pending Override | NUMBER(1) | Pending Override status. |
| Pending Po | NUMBER(1) | 0 = Not Pending 1 = Pending |
| PO Number | NUMBER(5) | Sequential number assigned to the PO. |
| PO Term Info | NUMBER(5) | Identifies the term used on the PO. |
| Post Date | DATE | Date the PO was posted to the RIL database. |
| Rate | NUMBER(20,8) | Currency rate used. |
| Rcvd Qty | NUMBER(10,3) | Total received quantity for the whole PO. |
| Reason Name | NVARCHAR2(20) | Reason name. |
| Reason Type | NUMBER(5) | Reason Type. |
| Sbsno | NUMBER(5) | Subsidiary number. |
| Season Code | NUMBER(5) | Season code. |
| Season Name | NVARCHAR2(10) | Season name. |
| Sent Date | DATE | Date the PO was sent by edi. |
| Ship To Address1 - Ship To Address6 | NVARCHAR2(40) | Ship To Address fields. |
| Ship To Store Name | NVARCHAR2(20) | Ship To Store Name. |
| Ship To Store Number | NUMBER(5) | Ship To Store Number. |
| Ship To Zip | NUMBER(10) | ZIP Code of the Ship To store. |
| Shipping Date | DATE | Date the items on the PO were shipped. |
| Station | NVARCHAR2(1) | Station character. The station character is combined with the Store No. to produce a store/station identifier. For example, 001A is for Store 001, station A. |
| Status | NUMBER(5) |
Approval status. |
| Store Address | NVARCHAR2(40) | Store Address Name. |
| Store Name | NVARCHAR | Store Name of the PO Store. |
| Store Number | NUMBER(5) | Store number of the PO Store. |
| Submitted Date | DATE | Date the PO was submitted for approval. |
| Subtotal | NUMBER(16,4) | Will hold sum of all quantities multiplied by cost. |
| Tax Area | NUMBER(5) | Tax area of the PO store. |
| Total | NUMBER(16,4) | PO Subtotal plus all fees. |
| Type | NUMBER(5) |
0 = Drop Ship |
| Unfilled Percentage | NUMBER(16,4) | Percentage of the total ordered quantity that has yet to be received on vouchers. |
| Unverified | NUMBER(1) | Verified status. 0 = Unverified, 1 = Verified |
| Use VAT | NUMBER(1) | Use VAT status. |
| Vendor Code | NVARCHAR2(6) | Vendor Code. |
| Verified | NUMBER(1) | Verified status. 0 = Unverified, 1 = Verified |
| ZIP | NVARCHAR2(15) | ZIP Code of the PO store. |