Adjustment Columns
Prism enables users to customize grid layouts in many program areas. Among the areas where grids can be customized is Adjustments. 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.
Adjustment Memo Items
| Column Label | Type(length) | Desription |
|---|---|---|
| Adj Price with Tax | NUMBER(16,4) | Adjustment price with tax. |
| Adj Price w/o Tax | NUMBER(16,4) | Adjustment price without tax. |
| Adj Value | NUMBER(16,4) | Value after the adjustment. |
| 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 | NUMVER(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. |
| Attr | STRING(8) | Item attribute (e.g. color or a second size). |
| Cost | NUMBER(16,4) | Item cost. |
| Dcs Code | STRING(9) | Three- to nine-character field that identifies the item's department-class-subclass hierarchy. |
| Description 1 - Description 2 | STRING(20) | Item description fields. Desc 1 is the primary item description. |
| Item Note 1 - Item Note 10 | STRING(350) | Item note fields. |
| Orig Cost | NUMBER(16,4) | Original cost before discounts or other changes. |
| Orig Value | NUMBER(16,4) | Original value before the adjustment. |
| Price | NUMBER(16,4) | Item price. |
| Price with Tax | NUMBER(16,4) | Item price with tax. |
| Price w/o Tax | NUMBER(16,4) | Item price without tax. |
| Scan UPC | NUMBER(18) | Scanned UPC. |
| Serial No | Serial number. | |
| Size | STRING(8) | Item size. |
| Sublocmovetype | NUMBER(1) | Sublocation movement type. |
| Tax % | NUMBER(16,4) | Tax percentage. |
| Tax % 2 | NUMBER(16,4) | Tax percentage of a second tax area (multi-tax environment). |
| Udf Val1 - Udf Val4 | STRING(50) | User-defined fields. Taken from item UDF fields in inventory. |
| Upc | NUMBER(18) | Universal product code. |
Adjustment Memo Lookup
| Column Label | Type(length) | Description |
|---|---|---|
| Associate | Associate listed on the memo. | |
| Audited | NUMBER(1) | Audited status. 0 = not audited, 1 = audited. |
| Cms | NUMBER(1) | 0 = not posted to RIL, 1 = posted to RIL |
| Controller | NUMBER(5) | Controller of the installation where the memo was created. |
| Created Date | TIMESTAMP(0) WITH TIME ZONE | Date the memo was created. |
| Creating Doc No | STRING(20) | Memo are sometimes created as a result of updating other documents that contain a change to quantity, cost, or price. This field displays the doc number of the document that, when updated, resulted in the creation of a memo. |
| Doc Ref No | STRING(20) | Doc number of the document referenced on the memo. |
| Memo No | STRING(20) | Memo number. |
| Memo Type | NUMBER(1) | Adjustment Type 0=Qty 1=Price 2=Cost |
| Modified By | STRING(20) | Employee who last modified the memo. |
| Modified Date | TIMESTAMP(0) WITH TIME ZONE | Date the memo was last modified. |
| Note | STRING(255) | Note field. |
| Orig Controller | NUMBER(5) | Controller of the installation where the memo was originally created. |
| Orig Station | STRING(1) | Station where the memo was originally created. |
| Reason | STRING(80) | Memo reason. |
| Season | STRING(30) | Season name. |
| Season Code | STRING(5) | Season Code is a short code that identifies the season. |
| Status | NUMBER(1) | Transaction document status. 0 = None, 1 = Changed, 2 = Cancelled, 3 = Normal, 4 = Completed. |
| Store Code | STRING(10) | Store code. |
| Store Name | STRING(20) | Store name. |
| Source | NUMBER(5) | Memo source. |
| Sublocmovetype | NUMBER(1) | Sublocation movement type. |
| Use VAT | NUMBER(1) | Use VAT status. 0 = VAT not used, 1 = VAT used. |
| Verified | NUMBER(1) | Verified status. 0 = Not verified, 1 = verified. |
| Wsseqno | NUMBER(10) | Workstation sequence number. |