These are tables that are used internally that you most likely shouldn't be interested in
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| ID | Alpha | |||
| providerName | The insurance provider name. | Text | ||
| comment | Text | |||
| prescriptionValidityDays | The number of days that can expire from when a prescription is created and when it is paid for. | Long Integer | ||
| isActive | If false, no policies associated with this insurance provider can be used to pay for any new or outstanding prescriptions. | Boolean |
Contains item related values that differ across stores. Most notably, defines whether an item is visible in a particular store.
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| Note that records are created for each item- there should always be one record for each item in each store | ||||
| id | Text | |||
| store_ID | Text | |||
| item_ID | Text | |||
| inactive | true means item is not visible in this store. False means it is visible | bool | ||
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| ID | Alpha | |||
| insuranceProviderID | Alpha | |||
| nameID | Alpha | |||
| isActive | If false, insurance policy cannot be used to pay for any outstanding or new prescriptions. | |||
| policyNumberFamily | Alpha | |||
| policyNumberPerson | Alpha | |||
| discountRate | The percent of the prescription cost that is payable by this policy. | Real | ||
| expiryDate | The date after which this policy will be inactive. | Date | ||
| policyNumberFull | The full policy number (family policy number + personal policy number) | Alpha | ||
| enteredByID | The ID of the user who created this policy | Alpha |
Contains name (customer, supplier, manufacturer etc.) related values that differ across stores. Most notably, defines whether a name is visible in a particular store.
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| Note that records are only created as needed- that is a missing record implies the name is invisible for that store | ||||
| id | Text | |||
| store_ID | Text | |||
| name_ID | Text | |||
| inactive | true means name is not visible in this store. False means it is visible | bool | ||
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| id | Text | |||
| name | Alpha | 40 |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| note_type | Alpha | 3 | ||
| entry_date | Date | |||
| note | Text | |||
| name_key | Alpha | 8 | ||
| id | Text |
Stores serial numbers such as invoice numbers
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| name | Text | |||
| value | Long |
Stores serial numbers such as invoice numbers
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| name | Stores deleted serial numbers for reuse- not relevant to users | Text | ||
| number_to_use | Long |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| item_dept_id | Text | |||
| name_group_id | Stores which name groups have permission to be supplied which item departments | Text |
The data for each preference is in binary format. You're not interested.
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| item | Internally used: storing preferences of text type(Now deprecated in favour of pref blob) | Alpha | 20 | |
| value | Alpha | 60 |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| report_name | Alpha | 80 | ||
| report_blob | BLOB | |||
| owner_ID | Text | |||
| id | Text | |||
| last_updated | Date |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| id | Text | |||
| method | Alpha | 80 |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| id | Text | |||
| type | I=insert, U=update, D=delete, M=merge, T=transfer | Alpha | 2 | |
| record_id | ID of the record to be synced | Text | ||
| to_from_id | sync site ID to send the record | Long | ||
| store_id | if store-specific data, the store ID for the record. For example a remote sync site might have multiple stores. If this sync_out record if for a transact record, the Store_ID that it's for. Can be blank | Text | ||
| record_data | (deprecated) | BLOB | ||
| table_num | Internal table number of the record | Long | ||
| sequence | Integer for correct sync ordering | Long | ||
| table_id_num | Internal field number for the ID field of the record's table | Long | ||
| merge_ID_to_keep | ID of record being kept in merge | Text | ||
| merge_ID_to_delete | ID of record being deleted in merge | Text |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| id | Text | |||
| category | Alpha | 80 | ||
| type | “ci” for customer invoices “pi” for prescriptions “cc” for customer credits “si” for supplier invoices “sc” for supplier credits “sr for repacks “bu” for builds “in” for inventory adjustments | Alpha | 3 |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| id | Text | |||
| note | Text |
| Field name | Description | Type | Length | Ind |
|---|---|---|---|---|
| id | Text | |||
| units | Alpha | 60 | ||
| comment | Text |
| Previous: 24.03. Foreign keys | | Next: 25. Technical Administration |