Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXPV1000
Product: Manufacturing (346)
Series:
Display Name: EXP_SalesOrdersNotLinked
Physical Name: EXPV1000
Technical Name: EXP_SalesOrdersNotLinkedSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SOPNUMBE 
SOP Number String STR20_SOP_Number 17 2 SOPTYPE SOP Type Integer DDL_SOP_Type 0 3 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['EXP_SalesOrdersNotLinked'].ITEMNMBR AS 'EXP_SalesOrdersNotLinked-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
EXPV1000 AS ['EXP_SalesOrdersNotLinked']
INNER JOIN
IV00101 AS ['Item Master']
ON
['EXP_SalesOrdersNotLinked'].ITEMNMBR = ['Item Master'].ITEMNMBR4 UOFM U Of M String U_Of_M 8 5 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 6 QTYBACKO QTY Backordered Currency DLR17_QTY_RBS0_UTR 17 7 ITEMFULFILLMETHOD Item Fulfillment Method Integer Item Fulfillment Method 0 8 ReqShipDate Requested Ship Date Date DT 8 9 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['EXP_SalesOrdersNotLinked'].CUSTNMBR AS 'EXP_SalesOrdersNotLinked-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
EXPV1000 AS ['EXP_SalesOrdersNotLinked']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['EXP_SalesOrdersNotLinked'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR10 ITEMDESC Item Description String STR100 100 11 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['EXP_SalesOrdersNotLinked'].LOCNCODE AS 'EXP_SalesOrdersNotLinked-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EXPV1000 AS ['EXP_SalesOrdersNotLinked']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['EXP_SalesOrdersNotLinked'].LOCNCODE = ['Site Setup'].LOCNCODE12 MAKEBUYCODE_I Make/Buy_Code Integer DDL_Make_Buy_Code 0 13 AVERAGEORDQTY_I Average ORD QTY Currency DLR17_QTY_RBS0_UTR 17 14 ITEMSTATUS_I Item Status Integer DDL_Item_Status 0 15 EFFECTIVEDATE_I Effective Date0 Date DT 8 16 CUSTPRIORITY Customer Priority Integer DDL_CustomerPriority 0 17 CUSTNAME Customer Name String STR64_Customer_Name 64 18 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 19 CMPNTSEQ Component Sequence Long Integer LI_Sequence_Number 10