# QAD EE Key Fields Reference > Source: https://netray.co/tools/qad-ee-key-fields-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Searchable list of the QAD Enterprise Edition fields report writers use most, by table, with type, meaning and the menu program that maintains them. ## Category other-erp ## Erp QAD ## Audience - QAD developer - QAD administrator - Report writer ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Field **Key:** field **Type:** text #### Typical screen label **Key:** label **Type:** text #### Type **Key:** type **Type:** text #### Meaning **Key:** meaning **Type:** text #### Maintained in **Key:** maintained **Type:** text **Rows:** #### Domain **Table:** pt_mstr **Field:** pt_domain **Type:** character **Meaning:** Domain code; part of every key in EE **Maintained:** Set by the session domain #### Item Number **Table:** pt_mstr **Field:** pt_part **Type:** character **Meaning:** Item number, primary key with pt_domain **Maintained:** 1.4.1 Item Master Maintenance #### Description **Table:** pt_mstr **Field:** pt_desc1 **Type:** character **Meaning:** Item description line 1 **Maintained:** 1.4.1 Item Master Maintenance #### Description (line 2) **Table:** pt_mstr **Field:** pt_desc2 **Type:** character **Meaning:** Item description line 2 **Maintained:** 1.4.1 Item Master Maintenance #### UM **Table:** pt_mstr **Field:** pt_um **Type:** character **Meaning:** Stocking unit of measure **Maintained:** 1.4.1 Item Master Maintenance #### Prod Line **Table:** pt_mstr **Field:** pt_prod_line **Type:** character **Meaning:** Product line; drives GL accounts **Maintained:** 1.4.1 Item Master Maintenance #### Item Type **Table:** pt_mstr **Field:** pt_part_type **Type:** character **Meaning:** User-defined item type for selection and reporting **Maintained:** 1.4.1 Item Master Maintenance #### Status **Table:** pt_mstr **Field:** pt_status **Type:** character **Meaning:** Item status code; restricts transactions via status code rules **Maintained:** 1.4.1 Item Master Maintenance #### Group **Table:** pt_mstr **Field:** pt_group **Type:** character **Meaning:** Item group for selection and reporting **Maintained:** 1.4.1 Item Master Maintenance #### Pur/Mfg **Table:** pt_mstr **Field:** pt_pm_code **Type:** character **Meaning:** Purchased or manufactured code used by planning **Maintained:** 1.4.7 Item Planning Maintenance #### ABC Class **Table:** pt_mstr **Field:** pt_abc **Type:** character **Meaning:** ABC class for cycle counting **Maintained:** 1.4.5 Item Inventory Data Maintenance #### Order Policy **Table:** pt_mstr **Field:** pt_ord_pol **Type:** character **Meaning:** MRP order policy such as POQ, LFL, FOQ, OTO **Maintained:** 1.4.7 Item Planning Maintenance #### Buyer/Planner **Table:** pt_mstr **Field:** pt_buyer **Type:** character **Meaning:** Buyer or planner code **Maintained:** 1.4.7 Item Planning Maintenance #### Supplier **Table:** pt_mstr **Field:** pt_vend **Type:** character **Meaning:** Default supplier **Maintained:** 1.4.7 Item Planning Maintenance #### Site **Table:** pt_mstr **Field:** pt_site **Type:** character **Meaning:** Default site **Maintained:** 1.4.5 Item Inventory Data Maintenance #### Location **Table:** pt_mstr **Field:** pt_loc **Type:** character **Meaning:** Default stocking location **Maintained:** 1.4.5 Item Inventory Data Maintenance #### Lot/Serial Control **Table:** pt_mstr **Field:** pt_lot_ser **Type:** character **Meaning:** Blank = none, L = lot, S = serial **Maintained:** 1.4.5 Item Inventory Data Maintenance #### Added **Table:** pt_mstr **Field:** pt_added **Type:** date **Meaning:** Date the item was created **Maintained:** Set on creation #### Domain **Table:** so_mstr **Field:** so_domain **Type:** character **Meaning:** Domain code **Maintained:** Set by the session domain #### Order **Table:** so_mstr **Field:** so_nbr **Type:** character **Meaning:** Sales order number, key with so_domain **Maintained:** 7.1.1 Sales Order Maintenance #### Sold-To **Table:** so_mstr **Field:** so_cust **Type:** character **Meaning:** Sold-to customer **Maintained:** 7.1.1 Sales Order Maintenance #### Bill-To **Table:** so_mstr **Field:** so_bill **Type:** character **Meaning:** Bill-to address code **Maintained:** 7.1.1 Sales Order Maintenance #### Ship-To **Table:** so_mstr **Field:** so_ship **Type:** character **Meaning:** Ship-to address code **Maintained:** 7.1.1 Sales Order Maintenance #### Order Date **Table:** so_mstr **Field:** so_ord_date **Type:** date **Meaning:** Order date **Maintained:** 7.1.1 Sales Order Maintenance #### Due Date **Table:** so_mstr **Field:** so_due_date **Type:** date **Meaning:** Header due date, default for lines **Maintained:** 7.1.1 Sales Order Maintenance #### Purchase Order **Table:** so_mstr **Field:** so_po **Type:** character **Meaning:** Customer's PO reference **Maintained:** 7.1.1 Sales Order Maintenance #### Currency **Table:** so_mstr **Field:** so_curr **Type:** character **Meaning:** Order currency **Maintained:** 7.1.1 Sales Order Maintenance #### Action Status **Table:** so_mstr **Field:** so_stat **Type:** character **Meaning:** Order action status; blank is normal, non-blank values such as hold stop shipping **Maintained:** 7.1.1 Sales Order Maintenance #### Site **Table:** so_mstr **Field:** so_site **Type:** character **Meaning:** Header site, default for lines **Maintained:** 7.1.1 Sales Order Maintenance #### Ship Via **Table:** so_mstr **Field:** so_shipvia **Type:** character **Meaning:** Carrier or shipping method **Maintained:** 7.1.1 Sales Order Maintenance #### Domain **Table:** sod_det **Field:** sod_domain **Type:** character **Meaning:** Domain code **Maintained:** Set by the session domain #### Order **Table:** sod_det **Field:** sod_nbr **Type:** character **Meaning:** Sales order number; joins to so_nbr **Maintained:** 7.1.1 Sales Order Maintenance #### Line **Table:** sod_det **Field:** sod_line **Type:** integer **Meaning:** Line number **Maintained:** 7.1.1 Sales Order Maintenance #### Item Number **Table:** sod_det **Field:** sod_part **Type:** character **Meaning:** Item ordered; joins to pt_part **Maintained:** 7.1.1 Sales Order Maintenance #### Quantity Ordered **Table:** sod_det **Field:** sod_qty_ord **Type:** decimal **Meaning:** Quantity ordered in line UM **Maintained:** 7.1.1 Sales Order Maintenance #### Quantity Shipped **Table:** sod_det **Field:** sod_qty_ship **Type:** decimal **Meaning:** Cumulative quantity shipped **Maintained:** Updated by shipment transactions (7.9.15 Sales Order Shipments) #### Quantity to Invoice **Table:** sod_det **Field:** sod_qty_inv **Type:** decimal **Meaning:** Shipped quantity not yet invoiced **Maintained:** Updated by shipment and invoice post #### Net Price **Table:** sod_det **Field:** sod_price **Type:** decimal **Meaning:** Net unit price **Maintained:** 7.1.1 Sales Order Maintenance #### Due Date **Table:** sod_det **Field:** sod_due_date **Type:** date **Meaning:** Line due date **Maintained:** 7.1.1 Sales Order Maintenance #### Site **Table:** sod_det **Field:** sod_site **Type:** character **Meaning:** Shipping site for the line **Maintained:** 7.1.1 Sales Order Maintenance #### UM **Table:** sod_det **Field:** sod_um **Type:** character **Meaning:** Line unit of measure **Maintained:** 7.1.1 Sales Order Maintenance #### Domain **Table:** wo_mstr **Field:** wo_domain **Type:** character **Meaning:** Domain code **Maintained:** Set by the session domain #### Work Order **Table:** wo_mstr **Field:** wo_nbr **Type:** character **Meaning:** Work order number **Maintained:** 16.1 Work Order Maintenance #### ID **Table:** wo_mstr **Field:** wo_lot **Type:** character **Meaning:** Work order ID; unique key **Maintained:** Assigned by the system #### Item Number **Table:** wo_mstr **Field:** wo_part **Type:** character **Meaning:** Item being made **Maintained:** 16.1 Work Order Maintenance #### Quantity Ordered **Table:** wo_mstr **Field:** wo_qty_ord **Type:** decimal **Meaning:** Quantity to build **Maintained:** 16.1 Work Order Maintenance #### Quantity Completed **Table:** wo_mstr **Field:** wo_qty_comp **Type:** decimal **Meaning:** Cumulative quantity completed **Maintained:** Updated by receipts and backflush #### Status **Table:** wo_mstr **Field:** wo_status **Type:** character **Meaning:** P planned, F firm planned, B batch, E exploded, A allocated, R released, C closed **Maintained:** 16.1 Work Order Maintenance #### Due Date **Table:** wo_mstr **Field:** wo_due_date **Type:** date **Meaning:** Work order due date **Maintained:** 16.1 Work Order Maintenance #### Order **Table:** po_mstr **Field:** po_nbr **Type:** character **Meaning:** Purchase order number **Maintained:** 5.7 Purchase Order Maintenance #### Supplier **Table:** po_mstr **Field:** po_vend **Type:** character **Meaning:** Supplier code **Maintained:** 5.7 Purchase Order Maintenance #### Order Date **Table:** po_mstr **Field:** po_ord_date **Type:** date **Meaning:** PO order date **Maintained:** 5.7 Purchase Order Maintenance #### Order **Table:** pod_det **Field:** pod_nbr **Type:** character **Meaning:** PO number; joins to po_nbr **Maintained:** 5.7 Purchase Order Maintenance #### Line **Table:** pod_det **Field:** pod_line **Type:** integer **Meaning:** PO line number **Maintained:** 5.7 Purchase Order Maintenance #### Item Number **Table:** pod_det **Field:** pod_part **Type:** character **Meaning:** Item on the PO line **Maintained:** 5.7 Purchase Order Maintenance #### Quantity Ordered **Table:** pod_det **Field:** pod_qty_ord **Type:** decimal **Meaning:** Quantity ordered **Maintained:** 5.7 Purchase Order Maintenance #### Quantity Received **Table:** pod_det **Field:** pod_qty_rcvd **Type:** decimal **Meaning:** Cumulative quantity received **Maintained:** Updated by PO receipts #### Site **Table:** ld_det **Field:** ld_site **Type:** character **Meaning:** Site of the inventory balance **Maintained:** Inventory transactions #### Location **Table:** ld_det **Field:** ld_loc **Type:** character **Meaning:** Location of the balance **Maintained:** Inventory transactions #### Item Number **Table:** ld_det **Field:** ld_part **Type:** character **Meaning:** Item **Maintained:** Inventory transactions #### Lot/Serial **Table:** ld_det **Field:** ld_lot **Type:** character **Meaning:** Lot or serial number **Maintained:** Inventory transactions #### Quantity On Hand **Table:** ld_det **Field:** ld_qty_oh **Type:** decimal **Meaning:** On-hand quantity for site, location, lot and reference **Maintained:** Inventory transactions **Notes:** Scope: QAD Enterprise Edition (eB2.1 through the 2017 releases) on Progress OpenEdge. Labels vary by version and language; confirm in your Data Dictionary. In EE every table carries a *_domain field (po_domain, pod_domain, ld_domain as well) and every query should filter on it. ## Content **Intro:** This reference lists the QAD Enterprise Edition fields that report writers and 4GL developers use most, at column level, for pt_mstr, so_mstr, sod_det, wo_mstr, po_mstr, pod_det and ld_det. It covers QAD EE from eB2.1, where domains were introduced, through the 2017 releases on Progress OpenEdge. **Sections:** #### How to use it **Body:** Search for a table prefix (sod_), a field name or a screen label such as Order Policy. The type column tells you how to compare and format the value in 4GL or SQL, and the maintained in column tells you which menu program to open when you need to see the value on screen. Use the table alongside the table-level QAD core tables reference when you are working out joins: header to detail on domain and order number, detail to item on domain and part. **Bullets:** - so_mstr to sod_det: so_domain = sod_domain and so_nbr = sod_nbr. - sod_det to pt_mstr: sod_domain = pt_domain and sod_part = pt_part. - po_mstr to pod_det: po_domain = pod_domain and po_nbr = pod_nbr. #### Where this lives in QAD **Body:** Field definitions sit in the Progress Data Dictionary of the QAD database, which you can open from the Progress Data Administration or Data Dictionary tools with the qaddb connected. In the character UI, Ctrl-F on a field shows its table and field name, which is the fastest way to map a screen label to a column. QAD's Database Definitions guides for each release list tables and fields, and are worth keeping for the version you run. #### Worked example: open sales order balance **Body:** To list open quantities per line, join the header and detail on domain and order, and subtract shipped from ordered. In Progress 4GL: FOR EACH so_mstr NO-LOCK WHERE so_domain = global_domain, EACH sod_det NO-LOCK WHERE sod_domain = so_domain AND sod_nbr = so_nbr AND sod_qty_ord - sod_qty_ship > 0: DISPLAY so_nbr so_cust sod_line sod_part sod_qty_ord - sod_qty_ship LABEL "Open". END. Add sod_due_date to sort by due date. For value, multiply the open quantity by sod_price, remembering it is in the order currency so_curr. #### Gotchas **Body:** Forgetting the domain filter is the classic EE mistake: queries run slowly on full index scans and can mix data from several domains. MFG/PRO eB2 and QAD Standard Edition databases have no domain fields, so drop the domain filter there. sod_qty_ord can be negative on return lines, so filter on sign if you only want shipments. wo_status values drive what a work order can do; closed orders (C) are often excluded from reports. Labels change with language and release, so trust field names, not labels. **Cta:** If you want planners to ask QAD about open orders, work orders and stock in plain English on your own servers, we can set that up over these same tables. **Faq:** #### Where can I see QAD tables and fields? **Answer:** Open the Progress Data Dictionary against the QAD database to browse tables, fields, types and indexes, or use the QAD Database Definitions guide for your release. In the character UI, pressing Ctrl-F on a field shows the table and field behind it. This reference covers the fields most reports need. #### What does wo_status mean in QAD? **Answer:** wo_status holds the work order status: P planned, F firm planned, B batch, E exploded, A allocated, R released and C closed. Status controls which transactions are allowed, for example issues and receipts against released orders. Many reports exclude C and focus on F, A and R orders. #### Why do my QAD EE queries need the domain field? **Answer:** In QAD Enterprise Edition every business table includes a domain field, and it is the first component of most indexes. Filtering on pt_domain, so_domain and so on lets Progress use the indexes and stops data from other domains appearing in results. Set it from global_domain in 4GL or a parameter in SQL. #### How do I get on-hand quantity in QAD? **Answer:** Sum ld_det.ld_qty_oh for the item, filtered by domain and optionally by site and location. ld_det holds one record per site, location, item, lot and reference. in_mstr also carries summary quantities per item and site, but ld_det is the detail behind it and the one to use when lot or location matters. ## Search terms qad tables and fields, qad pt_mstr fields, qad so_mstr sod_det, qad wo_mstr fields, qad ld_det, qad standard reports, qad report, how to use qad --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json