Disbursement Lookup Columns
Prism enables users to customize grid layouts in many program areas. Among the areas where grids can be customized is Disbursements. 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. 0 = inactive, 1 = active. |
| Cashier | STRING(20) | Cashier name. |
| Closed By | STRING(20) | Employee who closed the drawer or did the cash drop. |
| Controller Number | NUMBER(5) | User-defined database number |
| Created By | STRING(30) | Employee who created the disbursement. |
| Created Date | TIMESTAMP(0) WITH TIME ZONE | Date and time the disbursement was created. |
| Disbursement Number | NUMBER(5) | Sequential document number. |
| Drawer Number | NUMBER(5) | The number of the drawer involved in the disbursement. |
| Modified By | STRING(30) | Employee who last modified the disbursement record. |
| Modified Datetime | TIMESTAMP(0) WITH TIME ZONE | Date and time the disbursement record was last modified. |
| Notes | STRING(255) | Optional notes. |
| Post Date | DATE | Date the disbursement record was posted to the RIL database. |
| Reason Code | STRING(10) | Reason for the disbursement. |
| Reference Event | NUMBER(19) | Event that this event is paired with, eg. an open event and a close event. |
| Status | NUMBER(1) | 1 = changed 2 = cancelled 3 = normal |
| Store Name | STRING(40) | Name of the store where the disbursement was created. |
| Store Number | NUMBER(5) | Store number. |
| Till Name | STRING(40) | Name of the till involved in the disbursement. |
| Total | NUMBER(16,4) | The total amount of the disbursement. |
| Type | NUMBER(5) | The type of disbursement: Cash Drop, Paid In, Paid Out, or Misc. |
| Workstation Name | STRING(20) | Name of the workstation where the disbursement was created. |
| Workstation Number | NUMBER(5) | Workstation number. |