This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision |
| tables_fields:main_tables [2020/01/07 01:37] – [20.01. Main tables] lou | tables_fields:main_tables [2026/01/06 08:41] (current) – [24.01. Main tables] Raksha Khadka |
|---|
| {{indexmenu_n>10}} | {{indexmenu_n>10}} |
| |
| ====== 20.01. Main tables ====== | ====== 24.01. Main tables ====== |
| |
| ^ Name of table ^ Description of table ^ | ^ Name of table ^ Description of table ^ |
| ^ [[tables_fields:main_tables:transaction|Transactions]] | A transaction record is stored for each invoice | | ^ [[tables_fields:main_tables:transaction|Transactions]] | A transaction record is stored for each invoice | |
| ^ [[tables_fields:main_tables:trans_line|Transaction lines]] | One transaction line record is created for each line on an invoice | | ^ [[tables_fields:main_tables:trans_line|Transaction lines]] | One transaction line record is created for each line on an invoice | |
| | ^ [[tables_fields:main_tables:goods_received|Goods received]] | A record is created for each goods received from a supplier only after purchase order | |
| | ^ [[tables_fields:main_tables:goods_received_lines|Goods received lines]] | Each record is received for one item on goods received from supplier | |
| | ^ [[tables_fields:main_tables:list_master|List master]] | Master list is a standard list of items you would supply to wards, clinics, etc. on a regular basis | |
| | ^ [[tables_fields:main_tables:list_master_item_join|List master item join]] | Each item that added on master list | |
| | ^ [[tables_fields:main_tables:list_master_name_join|List master name join]] | Each customer and store name the master list has been assigned to | |
| \\ | \\ |
| \\ | \\ |
| | // Previous: **[[tables_fields:|20. Data Tables and Fields]]** | | Next: **[[tables_fields:other_tables:|20.02. Other tables]]** // | | | // Previous: **[[tables_fields:]]** | | Next: **[[tables_fields:other_tables:]]** // | |
| |
| ---- struct data ---- | ---- struct data ---- |
| | pagestatus.status : |
| ---- | ---- |
| |