Voucher/ASN Lookup Columns
Prism enables users to customize grid layouts in many program areas. Among the areas where grids can be customized is Vouchers and ASN Vouchers. 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 Labels | Type(length) | Description |
|---|---|---|
| Active | NUMBER(1) | Active status |
| Al Extract Date | DATE | Accounting Link extract date. |
| Al Post Date | DATE | Accounting Link post date. |
| Approv Date | DATE | Approval date. |
| Approv Notes | STRING(255) | Approval notes. |
| Approv Status | NUMBER(5) | Approval status. |
| Archived | NUMBER(1) | Archived status. |
| Arrived Date | DATE | Date the merchandise arrived. |
| Asn No | STRING(20) | ASN number. |
| Associate | STRING(30) | Associate on the document. |
| Audited | NUMBER(1) | Audited status. |
| Cancel Dt | DATE | Cancel date. |
| Carrier Id | Number(10) | Identifies the carrier used to transport the item. |
| Class | STRING(20) | Class name. |
| Cms | NUMBER(1) | 0 = Not posted to RIL, 1 = Posted to RIL |
| Cms Post Date | DATE | Date the document was posted to RIL. |
| Contract Date | DATE | Contract date. |
| Controller | NUMBER(5) | Controller of the installation where the document was created. |
| Cost Handling Code | NUMBER(5) | Indicates the type of cost handling used (e.g. average, overwrite, leave). |
| Created By | STRING(16,4) | Employee who created the voucher. |
| Created Dt | TIMESTAMP(0) WITH TIME ZONE | Date the voucher was created. |
| Cust Fld | STRING(47) | Field used with customizations. |
| Disc Amt | NUMBER(16,4) | Discount amount. |
| Disc Perc | NUMBER(16,4) | Discount percentage. |
| Disc Type | NUMBER(1) | 0 = Percentage, 1 = Amount |
| Doc Ref No | NUMBER(10) | Number of the PO or other document referenced on the voucher. |
| Held | NUMBER(1) | Held status. 0 = not held, 1 = held |
| Modified By | STRING(30) | Employee who last modified the voucher.. |
| Modified By Employee Id | NUMBER(10) | Identifies the employee who last modified the voucher. |
| Modified Date | TIMESTAMP(0) WITH TIME ZONE | Date the voucher was last modified. |
| No of Pkgs | NUMBER(3) | Number of packages on the voucher. |
| Note | STRING(255) | Note field. |
| Order Dt | DATE | Order date. |
| Orig Controller | NUMBER(5) | Controller of installation where the voucher was originally created. |
| Orig Station | NUMBER(5) | Station where the voucher was originally created. |
| Payee Code | STRING(6) | Payee code. By default, same as Vendor Code. |
| Pending Override | NUMBER(1) | Pending Override flag. |
| Pkg No | STRING(30) | Package number. |
| PO Number | STRING(20) | Purchase order number. |
| Post Date | DATE | Post date. |
| Proc Status | NUMBER(10) | Processing status. |
| Purch Clear Amt | NUMBER(16,4) | The amount posted to purchase clearing account. |
| Rate | NUMBER(20,8) | Tax rate used on the document. |
| Resolv Status | NUMBER(1) | Resolve Status. |
| Review Date | DATE | Review date. |
| Review Note | STRING(30) | Review note text. |
| Sbsno | NUMBER(5) | Subsidiary number. |
| Shipment No | STRING(16) | Shipment number. |
| Slip Flag | NUMBER(1) | 0 = Slip not generated from this voucher, 1 = Slip generated from this voucher. |
| Station | NUMBER(5) | Station number. |
| Status | NUMBER(10) | Document status. 0 = None, 1 = Changed, 2 = Cancelled, 3 = Normal, 4 = Completed. |
| Store No | NUMBER(5) | Store number. |
| Tax Amt Excl | NUMBER(17,5) | The tax amount recorded but not included in the voucher total. This amount does not affect the cost of goods received. |
| Tax Amt Incl | NUMBER(17,5) | The tax amount to be added to the subtotal when calculating the total. This amount does not affect the cost of goods received unless you spread the tax amount over all items received. |
| Tax Area | STRING(11) | Tax area used on the document. |
| Tax Area 2 | STRING(11) | Second tax area (used in multi-tax environments). |
| Tax Excl Type | NUMBER(1) | 0 = Pctg 1 = Amount |
| Tax Incl Type | NUMBER(1) | 0 = Pctg 1 = Amount |
| Tax Perc Excl | NUMBER(17,5) | The tax percentage recorded but not included in the voucher subtotal. The percentage will be applied to the subtotal minus any discount |
| Tax Perc Incl | NUMBER(17,5) |
The tax percentage applied to the subtotal. The percentage will be applied to the subtotal minus any discount. |
| TO No | STRING(8) | Transfer order number. |
| Tracking No | STRING(40) | Tracking number assigned by the carrier. |
| Trans Reason Id | NUMBER(10) | Identifies the transfer reason used on the document. |
| Type | NUMBER(1) | Voucher Type: 0 = Regular, 1 = Return |
| Update Price Flag | NUMBER(1) | 0 = Price not updated, 1 = Price updated. |
| Use VAT | NUMBER(1) | Use VAT status. 0 = VAT not used, 1 = VAT used. |
| Vend Acct No | STRING(20) | Vendor account number. |
| Vend Id | NUMBER(10) | Identifies the vendor. |
| Vendor Code | STRING(6) | Three- to six-character code that identifies the vendor. |
| Vendor Invoice No | NUMBER(10) | Vendor invoice number. |
| Vendor Name | STRING(25) | Name of the vendor's company. |
| Verified | NUMBER(1) | Verified status. |
| Voucher No | NUMBER(10) | Voucher number. |
| Vou Subtotal | NUMBER(16,4) | Voucher subtotal. |
| Vou Total | NUMBER(16,4) | Voucher total. |
| Workstation | CHAR(1) | Workstation number. |
| Ws Seq No | NUMBER(10) | Workstation sequence number. |