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