[[tables:internal_tables]]

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

Internal Tables

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 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: 2019/09/21 11:43
  • by Lou Lomas