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 |