Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
tables:main_tables:name [2019/09/04 15:42] – lou | tables_fields:main_tables:name [2023/01/20 11:21] – Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Name ====== | ====== Name ====== | ||
- | + | [[..:|Back to list of main tables]] | |
- | [[tables: | + | |
<WRAP center round info 60%> | <WRAP center round info 60%> | ||
Line 50: | Line 49: | ||
| group_ID | | group_ID | ||
| hold | If true, you can't issue or receive items to/from this name | Boolean | | | | hold | If true, you can't issue or receive items to/from this name | Boolean | | | ||
+ | | is_deleted | ||
| last | Patients only: patient' | | last | Patients only: patient' | ||
| latitude | | latitude | ||
Line 65: | Line 65: | ||
| occupation_ID | | occupation_ID | ||
| ordering_method | The type of customer stock history this customer uses: im=imprest, sh=stock history | Alpha | | | | ordering_method | The type of customer stock history this customer uses: im=imprest, sh=stock history | Alpha | | | ||
- | | overpayment | + | | overpayment |
| PATIENT_PHOTO | | PATIENT_PHOTO | ||
| phone | Name's phone number | Alpha | | phone | Name's phone number | Alpha | ||
Line 88: | Line 88: | ||
| supplier | | supplier | ||
| title | Patients only: patient' | | title | Patients only: patient' | ||
- | | **type** (v3.5 on) |“store” - a name associated with a mSupply virtual store\\ | + | | **type** (v3.5 on) |“store” - a name associated with an mSupply virtual store\\ |
| url | Web page of this name. Includes " | | url | Web page of this name. Includes " | ||
| web_id | | web_id | ||
| ZIP | Postal address postcode | Longint | | | | ZIP | Postal address postcode | Longint | | | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||