Table arcasys.posper_cashregister
Defines a cashregister period

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 255
posper_payment.cashregister_id FK_payment_register R
posper_ticket.parent_id FKA0D585C237714FBD C
version int 10 Used for optimistic locking
dateOpen datetime 19 Start of register period.
Must always be equal to the end of the previous period.
dateClose datetime 19  √  null End of register period.
host varchar 255 Host name. Each host has it't own sequence.
serialnr int unsigned 10  √  null Gapless number for register periods by host.
cashCarryForward double 22  √  0 The amount remaining in the drawer as change for the next period.
The amount is added for the next cash count.
cashDifference double 22  √  0 Counted amount minus expected amount.
countCloseCash smallint 5  √  null
countCurrentCash smallint 5  √  null
countOpenDrawer smallint 5  √  null
countPayments smallint 5  √  null
countReprints smallint 5  √  null
cashInSafe varchar 50  √  null

Table contained 2 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY

Close relationships  within of separation: