| Valudater Front End and Control Project |
| Database Table and Field Definitions |
| RecordType Table | ; RecordType Table Definition |
| RecordTypeID | ; ID Number for internal Database use only |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| ItemName | ; Short Description of this Item |
| Description | ; Description of this Item |
| Transaction Table | ; Transaction Tracking |
| TransactionID | ; ID Number for internal Database use only |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| MachineID | ; Serial Number of Licenced Operating Software |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| RecordTypeID | ; Type associated with this Item |
| ; Index: - Ascending - Allow Duplicates |
| ; Relation: One To Many - Update on RecordType.RecordTypeID |
| ClientID | ; Client to whom this Record Applies |
| ; Index: - Ascending - Allow Duplicates |
| ; Relation: None on Clients.ClientID |
| DateTime | ; Date the Record was initially entered |
| ; Index: - Ascending - Allow Duplicates |
| Amount | ; Amount connected to this Record |
| Deposit | ; Attributes associated with this Item |
| Printed | ; Attributes associated with this Item |
| BackedUp | ; Attributes associated with this Item |
| Journelled | ; Attributes associated with this Item |
| Form Table | ; Form Resource Table |
| FormID | ; ID Number for internal Database use only |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| ItemName | ; Name Detail |
| Description | ; Description of this Item |
| Language Table | ; Language Table |
| LanguageID | ; ID Number for internal Database use only |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| ItemName | ; Name Detail |
| Label Table | ; Label Resource Table |
| FormID | ; ID Number for internal Database use only |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| ; Relation: One To Many - Delete on Form.FormID |
| LanguageID | ; ID Number for internal Database use only |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| ; Relation: One To Many - Delete on Language.LanguageID |
| Number | ; Sequence Number |
| ; Index: - Ascending - Primary - No Duplicates - Required |
| Value | ; Text Value of this item |
| 12 February, 2000 - Rev. 1 | Page 6 of 5 |
Back to TOP
Back to Previous PAGE
Back to Project Page