Key SQL table names that store data in the application

Below is a glossary of FactoryMaster table names within SQL and what they contain:

SOHEAD - Header information relating to sales orders.
​SODETAIL - Detailed information relating to sales order lines.
​SOCALL - Sales Order call off information
​INVHEAD - Header information for sales invoices.
​INVDET - Detailed information relating to sales invoice lines.
​DELHEAD - Header information for delivery notes.
​DELDET - Detailed information relating to delivery note lines.
​ORDERREF - Information on associated quotes

POHEAD - Header information relating to purchase orders.
​PODETAIL - Detailed information relating to purchase order lines.
​POADV - Header information relating to advice notes.
​POADVICE - Detailed information relating to advice note lines.

STKHEAD - Gives the basic information of a stocked part (Part Number, Stock Type etc.)
​STKDETAIL - Shows stock transactions for stocked parts (Goods In, Sales Order Allocations etc.)
​SCHIST - Shows the standard cost history of an item.
​RMFORM - Raw material forms
​PSRMBAT - Raw material batches
​PSBATCH - Specific information relating to batches of stock (Date Last Used, Quantity Left etc.)

WOHEAD - Header information for Works Orders.
​PROGRESS - Detailed information for Works Orders.
​WOCMPNTS - Component information for Works Orders.
​WOCLOCK - Employee clocking information for Works Orders.
​ASSEMBLY - Assembly information for a parts.
​MANHEAD - Header information for routes.
​MANOPS - Detailed information for routes.
​MANCRG - Manufacturing charges
​PARTROUT - Part numbers and their associated routes.
​RESOURCE - Header information for resources.

SALERET - Customer After sales table
​PPERMIT - Production permit table
​INTERNAL_REJ - Internal Rejects
​SUPRETRN - Supplier Rejects

EMPLOYEE - Employee header information
​SHIFTS - Types of shifts set up in the system
​EMPSHFTS - Shifts allocated to an employee

CRMMEMO - user information that created the CRM communication
​
If none of the above tables apply, please raise a new case online and reference the title of this article.