| id |
integer |
Yes |
Yes |
nextval('cash_outs_id_seq'::regclass) |
Unique identifier |
| till |
character varying(20) |
No |
No |
|
User entered till name or description |
| start_date |
date |
Yes |
No |
|
Start date for reports |
| end_date |
date |
Yes |
No |
|
End date for reports |
| coin_count |
smallint[] |
Yes |
No |
|
Number of coins for each denomination, .01, .05, .10, .25, .50, 1.00, 2.00 |
| coin_total |
numeric(15,2)[] |
Yes |
No |
|
Value of coins for each denomination, .01, .05, .10, .25, .50, 1.00, 2.00 |
| bill_count |
smallint[] |
Yes |
No |
|
Number of bills for each denomination, $1.00, $2.00, $5.00, $10.00, $20.00, $50.00, $100.00 |
| bill_total |
numeric(15,2)[] |
Yes |
No |
|
Value of bills for each denomination, $1.00, $2.00, $5.00, $10.00, $20.00, $50.00, $100.00 |
| other_total |
numeric(15,5) |
Yes |
No |
|
Total value of all other payment methods |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| location |
character varying(24) |
No |
No |
|
Location for this Cash count |