BOM_Mass_Changes_Line_Defaults (BM010117)

azurecurveProductsManufacturing (346)3rd PartyBOM_Mass_Changes_Line_Defaults (BM010117)

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_Defaults

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CPN_I SearchCPNStringSTR30_Item_Number30
2USERID SearchUser IDStringSTR15_User_ID15
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'].USERID
3BOM_Quantity_RadioGroup SearchBOM_Quantity_RadioGroupIntegerGB0
4QUANTITY_I SearchQuantityCurrencyDLR12_RBN_UT212
5BOM_UOFM_RadioGroup SearchBOM_UOFM_RadioGroupIntegerGB0
6UOFM SearchU Of MStringU_Of_M8
7BOM_IssueFrom_RadioGroup SearchBOM_IssueFrom_RadioGroupIntegerGB0
8FROM_SITE_I SearchFrom SiteStringSTR10_Location_Code10
9BOM_IssueTo_RadioGroup SearchBOM_IssueTo_RadioGroupIntegerGB0
10TO_SITE_I SearchTo SiteStringSTR10_Location_Code10
11BOM_InDate_RadioGroup SearchBOM_InDate_RadioGroupIntegerGB0
12EFFECTIVEINDATE_I SearchEffective In DateDateDT8
13BOM_OutDate_RadioGroup SearchBOM_OutDate_RadioGroupIntegerGB0
14EFFECTIVEOUTDATE_I SearchEffective Out DateDateDT8
15BOM_Shrinkage_RadioGroup SearchBOM_Shrinkage_RadioGroupIntegerGB0
16SHRINKAGEPERCENT_I SearchShrinkage%Long IntegerINTXXX.X%4
17BOM_FixedQty_RadioGroup SearchBOM_FixedQty_RadioGroupIntegerGB0
18FIXED_QTY_I SearchFixed QuantityCurrencyDLR17_QTY_RBS0_UTR17
19BOM_FixedQtyUofM_RadioGr SearchBOM_FixedQtyUofM_RadioGroupIntegerGB0
20U_Of_M_2 SearchU Of M 2StringU_Of_M8
21BOM_LeadTime_RadioGroup SearchBOM_LeadTime_RadioGroupIntegerGB0
22LEADTIMEOFFSET_I SearchLead Time OffsetCurrencyDLR_10_318
23LEADTIMEOFFSETINC_I SearchLead Time Offset IncIntegerDDL_Increment0
24BOM_OffsetFrom_RadioGrou SearchBOM_OffsetFrom_RadioGroupIntegerGB0
25OFFSET_FROM_I SearchOffset FromIntegerDDL_Offset_From0
26BOM_RefDesignators_Radio SearchBOM_RefDesignators_RadioGroupIntegerGB0
27BOM_Backflush_RadioGroup SearchBOM_Backflush_RadioGroupIntegerGB0
28BACKFLUSHITEM_I SearchBackflush ItemBooleanCB_Backflush Item0
29BOM_FloorStock_RadioGrou SearchBOM_FloorStock_RadioGroupIntegerGB0
30FLOORSTOCK_I SearchFloor StockBooleanCB0
31BOM_Alternate_RadioGroup SearchBOM_Alternate_RadioGroupIntegerGB0
32ALTERNATE_I SearchAlternateBooleanCB0
33BOM_SingleLot_RadioGroup SearchBOM_SingleLot_RadioGroupIntegerGB0
34BOMSINGLELOT_I SearchBOM_Single_LotBooleanCB0
35BOM_EngApproval_RadioGro SearchBOM_EngApproval_RadioGroupIntegerGB0
36BOMENGAPPROVAL_I SearchBOM_Eng_ApprovalBooleanCB0
37BOM_ActConsumed_RadioGro SearchBOM_ActConsumed_RadioGroupIntegerGB0
38ACTUAL_CONSUMED_CHECK_I SearchActual Consumed CheckBooleanCB0
39QTYBSUOM SearchQTY In Base U Of MCurrencyDLR17_QTY_RBS0_STR17
40QTY_In_Variable_U_Of_M SearchQTY In Variable U Of MCurrencyDLR17_QTY_RBS0_STR17
azurecurveProductsManufacturing (346)3rd PartyBOM_Mass_Changes_Line_Defaults (BM010117)

Leave a Reply

Your email address will not be published. Required fields are marked *