tables_fields:internal_tables

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tables_fields:internal_tables [2020/01/07 01:05] – ↷ Page moved from tables:internal_tables to tables_fields:internal_tables loutables_fields:internal_tables [2022/03/11 14:44] (current) – [Name store join] Gary Willetts
Line 1: Line 1:
 {{indexmenu_n>40}} {{indexmenu_n>40}}
- +====== 24.04. Internal tables ======
-====== 20.04. Internal tables ====== +
 **These are tables that are used internally that you most likely shouldn't be interested in ** **These are tables that are used internally that you most likely shouldn't be interested in **
 \\ \\
 \\ \\
 ===Internal tables===  ===Internal tables=== 
-   * [[tables:internal_tables#item_store_join]]   +   * [[tables_fields:internal_tables#insuranceProvider]]   
-   * [[tables:internal_tables#name_store_join]] +   * [[tables_fields:internal_tables#item_store_join]]   
-   * [[tables:internal_tables#name_group]] +   * [[tables_fields:internal_tables#nameInsuranceJoin]] 
-   * [[tables:internal_tables#numbers]] +   * [[tables_fields:internal_tables#name_store_join]] 
-   * [[tables:internal_tables#number_re-use]] +   * [[tables_fields:internal_tables#name_group]] 
-   * [[tables:internal_tables#permissions]] +   * [[tables_fields:internal_tables#numbers]] 
-   * [[tables:internal_tables#prefs]] +   * [[tables_fields:internal_tables#number_re-use]] 
-   * [[tables:internal_tables#reports]] +   * [[tables_fields:internal_tables#permissions]] 
-   * [[tables:internal_tables#ship_method]] +   * [[tables_fields:internal_tables#prefs]] 
-   * [[tables:internal_tables#sync_out]] +   * [[tables_fields:internal_tables#reports]] 
-   * [[tables:internal_tables#transaction_category]] +   * [[tables_fields:internal_tables#ship_method]] 
-   * [[tables:internal_tables#transaction_notes]] +   * [[tables_fields:internal_tables#sync_out]] 
-   * [[tables:internal_tables#units]]+   * [[tables_fields:internal_tables#transaction_category]] 
 +   * [[tables_fields:internal_tables#transaction_notes]] 
 +   * [[tables_fields:internal_tables#units]] 
 + 
 +=== 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 28: Line 38:
 | item_ID |  | Text |  |  | | item_ID |  | Text |  |  |
 | inactive | true means item is not visible in this store. False means it is visible | bool |  |  | | 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 === === 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 119: Line 144:
 \\ \\
 \\ \\
-|  //  Previous:  **[[tables:foreign_keys |20.03. Foreign keys]]** | | Next: **[[admin:|21. Technical Administration]]** //  |+|  //  Previous:  **[[tables_fields:foreign_keys]]** | | Next: **[[admin:]]** //  |
  
  
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/01/07 01:05
  • by lou