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 |