Voucher/ASN - PO Items Columns
Prism enables users to customize grid layouts in many program areas. Among the areas where grids can be customized is the item grid that is used on POs, Vouchers and ASNs. 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.
| Column Label | Type(length) | Description |
|---|---|---|
| Allocation pattern | N/A | Allocation pattern used on the PO. |
| Alt Alu | STRING(20) | Alternate Lookup (ALU) value assigned to the item by the alternate vendor. Alternate vendor fields are used when an item can be ordered from multiple vendors. Each vendor has its own "alternate" values for Vendor Code, Cost and UPC/ALU). |
| Alt Cost | NUMBER(16,4) | Cost assigned to the item by the alternate vendor. Alternate vendor fields are used when an item can be ordered from multiple vendors. Each vendor has its own "alternate" values for Vendor Code, Cost and UPC/ALU). |
| Alt Upc | NUMBER(18) | UPC assigned to the item by the alternate vendor. Alternate vendor fields are used when an item can be ordered from multiple vendors. Each vendor has its own "alternate" values for Vendor Code, Cost and UPC/ALU). |
| Alt Vend Code | STRING(6) | Vendor Code assigned to the item by the alternate vendor. Alternate vendor fields are used when an item can be ordered from multiple vendors. Each vendor has its own "alternate" values for Vendor Code, Cost and UPC/ALU). |
| ALU | STRING(20) | Alternate Lookup |
| Archived | NUMBER(1) | Archived status. 0 = not archived, 1 = archived |
| Attribute | STRING(8) | Item attribute (e.g. color or a second size) |
| Created By | STRING(30) | Employee who created the document. |
| Created Date | TIMESTAMP(0) WITH TIME ZONE | Date the document was created. |
| Currency | NUMBER(5) | If a currency is assigned to the vendor, it will be listed in the Currency field. |
| Dcs Code | STRING(9) | DCS Code. |
| Description1 - Description2 | STRING(20) | Item description fields. Desc 1 is the primary item description field. |
| Ext Cost | NUMBER(16,4) | Extended cost for the item on the document. Doc Qty x Cost. |
| Ext FC Cost | NUMBER(16,4) | Extended cost for the item on the document in the vendor's currency. |
| Ext Price | NUMBER(16,4) | Extended price. |
| Fc Cost | NUMBER(16,4) | Item cost in the vendor's currency. |
| Item Note 1 - Item Note 10 | STRING(350) | Optional item note fields. Each field can hold 350 characters. |
| Item Pos | NUMBER(5) | The item's position in the item list. |
| Itemsize | STRING(8) | Item size. |
| Itemuid | NUMBER(19) | Identifies the item. |
| Modified By | STRING(30) | Employee who last modified the document. |
| Modified Date | TIMESTAMP(0) WITH TIME ZONE | Date and time of the last change to the document. |
| Order Due Qty | NUMBER(10,3) | Of the quantity ordered, the remaining number yet to be received. |
| Ord Qty | NUMBER(10,3) | Order quantity |
| PO Cost | NUMBER(16,4) | Item cost on the PO. |
| Post Date | DATE | Date the document was posted to RIL. |
| Price | NUMBER(16,4) | Item price (taken from Inventory Price). |
| Receive Qty | NUMBER(10,3) | Quantity received on voucher. |
| Src Sbs No | NUMBER(5) | Source subsidiary number. |
| Tax Perc | NUMBER(16,4) | Tax percentage. |
| Tax Perc 2 | NUMBER(16,4) | Tax percentage for Tax Area 2 (when using multi-tax) |
| Trade Disc % | NUMBER(16,4) | The cost of the item as charged by the vendor. If you are using Trade Discounts, then the Trade Discount % is applied to each applicable item's Vendor 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 Value 1 - Udf Value 4 | STRING(50) | User-defined fields for the item, taken from the item's inventory record. |
| Upc | NUMBER(18) | Universal product code. |
| Vendor Code | STRING(6) | A three- to six-character code that identifies the vendor for the item. |
| Vendor List Cost | NUMBER(16,4) | The list cost as charged by the vendor. If you are using Trade Discounts, then the Trade Discount % is applied to each applicable item's Vendor List Cost to calculate Order Cost. If using Trade Discounts, Order Cost is automatically used on purchase orders and vouchers, and when working with the voucher users are unable to update an item's Order Cost. |