Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BM010117
Product: Manufacturing (346)
Series:
Display Name: BOM_Mass_Changes_Line_Defaults
Physical Name: BM010117
Technical Name: BOM_Mass_Changes_Line_DefaultsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CPN_I 
CPN String STR30_Item_Number 30 2 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['BOM_Mass_Changes_Line_Defaults'].USERID AS 'BOM_Mass_Changes_Line_Defaults-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
BM010117 AS ['BOM_Mass_Changes_Line_Defaults']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['BOM_Mass_Changes_Line_Defaults'].USERID = ['Users Master'].USERID3 BOM_Quantity_RadioGroup BOM_Quantity_RadioGroup Integer GB 0 4 QUANTITY_I Quantity Currency DLR12_RBN_UT2 12 5 BOM_UOFM_RadioGroup BOM_UOFM_RadioGroup Integer GB 0 6 UOFM U Of M String U_Of_M 8 7 BOM_IssueFrom_RadioGroup BOM_IssueFrom_RadioGroup Integer GB 0 8 FROM_SITE_I From Site String STR10_Location_Code 10 9 BOM_IssueTo_RadioGroup BOM_IssueTo_RadioGroup Integer GB 0 10 TO_SITE_I To Site String STR10_Location_Code 10 11 BOM_InDate_RadioGroup BOM_InDate_RadioGroup Integer GB 0 12 EFFECTIVEINDATE_I Effective In Date Date DT 8 13 BOM_OutDate_RadioGroup BOM_OutDate_RadioGroup Integer GB 0 14 EFFECTIVEOUTDATE_I Effective Out Date Date DT 8 15 BOM_Shrinkage_RadioGroup BOM_Shrinkage_RadioGroup Integer GB 0 16 SHRINKAGEPERCENT_I Shrinkage% Long Integer INTXXX.X% 4 17 BOM_FixedQty_RadioGroup BOM_FixedQty_RadioGroup Integer GB 0 18 FIXED_QTY_I Fixed Quantity Currency DLR17_QTY_RBS0_UTR 17 19 BOM_FixedQtyUofM_RadioGr BOM_FixedQtyUofM_RadioGroup Integer GB 0 20 U_Of_M_2 U Of M 2 String U_Of_M 8 21 BOM_LeadTime_RadioGroup BOM_LeadTime_RadioGroup Integer GB 0 22 LEADTIMEOFFSET_I Lead Time Offset Currency DLR_10_3 18 23 LEADTIMEOFFSETINC_I Lead Time Offset Inc Integer DDL_Increment 0 24 BOM_OffsetFrom_RadioGrou BOM_OffsetFrom_RadioGroup Integer GB 0 25 OFFSET_FROM_I Offset From Integer DDL_Offset_From 0 26 BOM_RefDesignators_Radio BOM_RefDesignators_RadioGroup Integer GB 0 27 BOM_Backflush_RadioGroup BOM_Backflush_RadioGroup Integer GB 0 28 BACKFLUSHITEM_I Backflush Item Boolean CB_Backflush Item 0 29 BOM_FloorStock_RadioGrou BOM_FloorStock_RadioGroup Integer GB 0 30 FLOORSTOCK_I Floor Stock Boolean CB 0 31 BOM_Alternate_RadioGroup BOM_Alternate_RadioGroup Integer GB 0 32 ALTERNATE_I Alternate Boolean CB 0 33 BOM_SingleLot_RadioGroup BOM_SingleLot_RadioGroup Integer GB 0 34 BOMSINGLELOT_I BOM_Single_Lot Boolean CB 0 35 BOM_EngApproval_RadioGro BOM_EngApproval_RadioGroup Integer GB 0 36 BOMENGAPPROVAL_I BOM_Eng_Approval Boolean CB 0 37 BOM_ActConsumed_RadioGro BOM_ActConsumed_RadioGroup Integer GB 0 38 ACTUAL_CONSUMED_CHECK_I Actual Consumed Check Boolean CB 0 39 QTYBSUOM QTY In Base U Of M Currency DLR17_QTY_RBS0_STR 17 40 QTY_In_Variable_U_Of_M QTY In Variable U Of M Currency DLR17_QTY_RBS0_STR 17