Batches, 28 (ver3.6.1)
This table creates an instance tracking statistics for each "Serve Lunch" session.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
BatchType | 3.6.1 | Varchar(20) | What kind of session was being run. Types are self-explanatory: Lunch, Breakfast, or Deposits. |
Cash | 3.6.1 | Float | How much cash was taken while serving this session. |
Date_Value | 3.6.1 | Date | The date of the transaction session. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
EndTime | 3.6.1 | Number(10,0) | The time the serve session ended. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IPAddress | 3.6.1 | Varchar(20) | The IP address of the machine entering lunch transactions for the server session. |
NumTransactions | 3.6.1 | Number(10,0) | The number of transactions taken while serving this session. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
StartTime | 3.6.1 | Number(10,0) | The time the serve session started. |
UserID | 3.6.1 | Number(10,0) | The user who was logged in taking the lunch transactions for this server session. |