[[tables_fields:internal_tables]]

21.04. Internal tables

These are tables that are used internally that you most likely shouldn't be interested in

Internal tables

Insurance provider

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

Item store join

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

Name insurance join

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

Name store join

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

Name group

Field name Description Type Length Ind
id Text
name Alpha 40

Name note

Field name Description Type Length Ind
note_type Alpha 3
entry_date Date
note Text
name_key Alpha 8
id Text

Numbers

Stores serial numbers such as invoice numbers

Field name Description Type Length Ind
name Text
value Long

Number re-use

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

Permissions

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

Preferences

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

Reports

Field name Description Type Length Ind
report_name Alpha 80
report_blob BLOB
owner_ID Text
id Text
last_updated Date

Ship method

Field name Description Type Length Ind
id Text
method Alpha 80

Sync out

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

Transaction category

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

Transaction notes

Field name Description Type Length Ind
id Text
note Text

Units

Field name Description Type Length Ind
id Text
units Alpha 60
comment Text



  • Last modified: 2020/03/16 10:09
  • by Gary Willetts