Dynamics AX 2012 SQL Reporting Query Generator: Sales Lines, Enums and Table Numbers

SELECT st.SALESID,
       st.CUSTACCOUNT,
       dpt.NAME AS CUSTOMERNAME,
       sl.LINENUM,
       sl.ITEMID,
       sl.SALESQTY,
       sl.REMAINSALESPHYSICAL,
       sl.SHIPPINGDATEREQUESTED,
       CASE sl.SALESSTATUS
            WHEN 1 THEN 'Open order'
            WHEN 2 THEN 'Delivered'
            WHEN 3 THEN 'Invoiced'
            WHEN 4 THEN 'Canceled'
            ELSE 'None'
       END AS SALESSTATUSLABEL
FROM SALESTABLE st
JOIN SALESLINE sl
  ON sl.SALESID = st.SALESID
 AND sl.DATAAREAID = st.DATAAREAID
 AND sl.PARTITION = st.PARTITION
LEFT JOIN CUSTTABLE ct
  ON ct.ACCOUNTNUM = st.CUSTACCOUNT
 AND ct.DATAAREAID = st.DATAAREAID
 AND ct.PARTITION = st.PARTITION
LEFT JOIN DIRPARTYTABLE dpt
  ON dpt.RECID = ct.PARTY
 AND dpt.PARTITION = ct.PARTITION
WHERE st.DATAAREAID = 'usmf'
  AND st.PARTITION = 5637144576
  AND st.CREATEDDATETIME >= '2026-01-01'
  AND sl.SALESSTATUS = 1
ORDER BY st.SALESID, sl.LINENUM;

-- FIELDID = 0 rows describe the table itself
SELECT TABLEID, NAME, SQLNAME
FROM SQLDICTIONARY
WHERE FIELDID = 0
  AND NAME LIKE 'SALES%'
ORDER BY NAME;

-- fields of one table (FIELDID <> 0)
SELECT TABLEID, FIELDID, NAME, SQLNAME
FROM SQLDICTIONARY
WHERE TABLEID = 366
  AND FIELDID <> 0
ORDER BY FIELDID;