Vendor Invoice Columns
Prism enables users to customize grid layouts in many program areas. Among the areas where grids can be customized is Vendor Invoices. 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 |
|---|---|---|
| Active | NUMBER(1) | Active status. |
| Created By | STRING(30) | Employee who created the vendor invoice. |
| Created Datetime | TIMESTAMP(0) WITH TIME ZONE | Date and time the vendor invoice was created. |
| Employee | STRING(30) | Employee who created the vendor invoice. |
| Invoice Date | DATE | Date the vendor invoice was created. |
| Invoice Number | STRING(20) | Vendor invoice number. |
| Modified By | STRING(30) | Employee who last modified the vendor invoice. |
| Modified Datetime | TIMESTAMP(0) WITH TIME ZONE | Date and time the vendor invoice was last changed. |
| Notes | STRING(384) | Optional note text. |
| PO Number | STRING(20) | Purchase number (if the voucher for the vendor invoice referenced a PO). |
| Post Date | DATE | Date and time the row was created/last modified in this system. May not be the same as the Created Datetime and Modified Datetime. |
| Sbs No | NUMBER(5) | Subsidiary number. |
| Vendor Code | STRING(6) | Three- to six-character code that identifies the vendor. |
| Voucher Total | NUMBER(16,4) | Total of vouchers for this vendor invoice. |