This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |
| tables_fields:main_tables [2021/10/08 11:08] – Gary Willetts | tables_fields:main_tables [2026/01/06 08:41] (current) – [24.01. Main tables] Raksha Khadka |
|---|
| ^ [[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 | |
| \\ | \\ |
| \\ | \\ |