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 [2022/03/11 13:17] – [Item store join] Gary Willetts | tables_fields:internal_tables [2022/03/11 14:44] (current) – [Name store join] Gary Willetts | ||
|---|---|---|---|
| Line 30: | Line 30: | ||
| === Item store join === | === Item store join === | ||
| - | Contains item related values  | + | Contains item related values  | 
| ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | ^ Field name ^ Description ^ Type ^ Length ^ Ind ^ | ||
| Line 53: | 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||||| | ||