GLDetail, 25 (ver3.6.1)
This table stores lunch transactions information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ALaCarte | 3.6.1 | Float | How much the user spent on A La Cart items. |
Batch | 3.6.1 | Number(10,0) | The group for which this transaction was taken. Indexed. |
Cash | 3.6.1 | Float | The amount of cash taken for the transaction. |
Credit | 3.6.1 | Float | Credit transaction. Amount needed to be added. |
Date_Value | 3.6.1 | Date | The Date this record was created. Indexed. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Debit | 3.6.1 | Float | Debit transaction. Amount needed to be subtracted. |
Description | 3.6.1 | Varchar(80) | The description for this transaction. |
EnteredBy | 3.6.1 | Number(10,0) | The userID associated with the record. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
MealPrice | 3.6.1 | Float | The price for the meal. |
NetEffect | 3.6.1 | Float | The change in total outcome: Credit - Debit. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Time | 3.6.1 | Number(10,0) | The time the record was created. |
TransType | 3.6.1 | Varchar(20) | The type of transaction D=Deposit, ML=Meal Lunch, MB=Meal Breakfast, A=A La Carte. Indexed. |