Table 20-19 Cash Management Records Export Format
Field | Field Type | Description |
---|---|---|
Record Type |
Varchar (255) |
String must contain CASH. |
Revenue Center Number |
Numeric (10) |
Local revenue center number. |
CM Item Number |
Numeric (10) |
Local cash management item number. |
CM Item Name |
Varchar (255) |
Local cash management item name. |
Receptacle Type |
Numeric (10) |
0: Till 1: Safe 2: Deposit |
Receptacle Number |
Numeric (10) |
Local receptacle number. |
Receptacle Name |
Varchar (255) |
Local receptacle name. |
Starting Amount |
Numeric (12,2) |
Starting bank amount in the Till. |
Trans Amount |
Numeric (12,2) |
Total Point-of-Sale transactions for the Till. |
OverShort Amount |
Numeric (12,2) |
Total amount over or short for the Till. |
Deposit Amount |
Numeric (12,2) |
Total amount withdrawn (negative) or deposited (positive) for the Till. |
Trans Datetime |
YYYYMMDDHHMMSS |
Date and time of the transaction. |
Trans Employee |
Numeric (10) |
Point-of-Sale reference number of the employee that processed the transaction. |
Reference Info |
Varchar (255) |
Reference recorded for the transaction. |
Related Topics
Parent topic: Standard Export