Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXPV1001
Product: Manufacturing (346)
Series:
Display Name: EXP_BillOfMaterials
Physical Name: EXPV1001
Technical Name: EXP_BillOfMaterialsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PPN_I 
PPN String STR30_UC 30 2 BOMCAT_I BOM Cat Integer DDL_BOM_Cat 0 3 BOMTYPE_I BOM Type Integer DDL_BOM_Type 0 4 BOMNAME_I BOM Name String STR15_LBU 15 5 BOM_REVISION_LEVEL BOM Revision Level String STR50 50 6 CPN_I CPN String STR30_Item_Number 30 7 SUBCAT_I Sub Cat Integer DDL_BOM_Cat 0 8 SUBNAME_I Sub Name String STR15_LBU 15 9 QUANTITY_I Quantity Currency DLR12_RBN_UT2 12 10 UOFM U Of M String U_Of_M 8 11 FIXED_QTY_I Fixed Quantity Currency DLR17_QTY_RBS0_UTR 17 12 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 13 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['EXP_BillOfMaterials'].LOCNCODE AS 'EXP_BillOfMaterials-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EXPV1001 AS ['EXP_BillOfMaterials']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['EXP_BillOfMaterials'].LOCNCODE = ['Site Setup'].LOCNCODE14 WCID_I WC ID String STR10_Location_Code 10 15 FLOORSTOCK_I Floor Stock Boolean CB 0 16 BACKFLUSHITEM_I Backflush Item Boolean CB_Backflush Item 0 17 ALTERNATE_I Alternate Boolean CB 0 18 ALTERNATEPARTFOR_I Alternate Part For String STR30_Item_Number 30 19 EFFECTIVEDATE_I Effective Date0 Date DT 8 20 OPTPERCENT_I OPT Percent Long Integer INTXXX.X% 4 21 SCRAPPERCENT_I Scrap Percent Long Integer INTXXX.X% 4 22 EFFECTIVEINDATE_I Effective In Date Date DT 8 23 EFFECTIVEOUTDATE_I Effective Out Date Date DT 8 24 LEADTIMEOFFSET_I Lead Time Offset Currency DLR_10_3 18 25 OFFSET_FROM_I Offset From Integer DDL_Offset_From 0 26 USERDEF1 User Defined 1 String STR20 20 27 USERDEF2 User Defined 2 String STR20 20 28 BOMSINGLELOT_I BOM_Single_Lot Boolean CB 0 29 BOMENGAPPROVAL_I BOM_Eng_Approval Boolean CB 0 30 CHANGEDATE_I Change Date Date DT 8 31 CHANGEBY_I Change By String STR15_User_ID 15 32 ACTUAL_CONSUMED_CHECK_I Actual Consumed Check Boolean CB 0 33 MODIFDT Modified Date Date DT 8 34 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['EXP_BillOfMaterials'].USERID AS 'EXP_BillOfMaterials-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXPV1001 AS ['EXP_BillOfMaterials']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['EXP_BillOfMaterials'].USERID = ['Users Master'].USERID35 BOMSEQ_I BOM Seq Long Integer LINT_10 10