Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
tables_fields:internal_tables [2020/02/19 23:14] – Add nameInsuranceJoin table will | tables_fields:internal_tables [2022/03/11 14:44] (current) – [Name store join] Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{indexmenu_n> | {{indexmenu_n> | ||
- | + | ====== | |
- | ====== | + | |
**These are tables that are used internally that you most likely shouldn' | **These are tables that are used internally that you most likely shouldn' | ||
\\ | \\ | ||
\\ | \\ | ||
===Internal tables=== | ===Internal tables=== | ||
+ | * [[tables_fields: | ||
* [[tables_fields: | * [[tables_fields: | ||
* [[tables_fields: | * [[tables_fields: | ||
Line 21: | Line 20: | ||
* [[tables_fields: | * [[tables_fields: | ||
* [[tables_fields: | * [[tables_fields: | ||
+ | |||
+ | === 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 === | === Item store join === | ||
+ | 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 ^ | ^ 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||||| | | Note that records are created for each item- there should always be one record for each item in each store||||| | ||
Line 44: | Line 53: | ||
=== Name store join === | === Name store join === | ||
+ | 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 ^ | ^ 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||||| | | Note that records are only created as needed- that is a missing record implies the name is invisible for that store||||| | ||
Line 133: | Line 144: | ||
\\ | \\ | ||
\\ | \\ | ||
- | | // Previous: | + | | // Previous: |
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||