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: 3rd Party

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 SearchCPNSTR30_Item_NumberString30
2USERID SearchUser IDSTR15_User_IDString15
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_RadioGroupGBInteger0
4QUANTITY_I SearchQuantityDLR12_RBN_UT2Currency12
5BOM_UOFM_RadioGroup SearchBOM_UOFM_RadioGroupGBInteger0
6UOFM SearchU Of MU_Of_MString8
7BOM_IssueFrom_RadioGroup SearchBOM_IssueFrom_RadioGroupGBInteger0
8FROM_SITE_I SearchFrom SiteSTR10_Location_CodeString10
9BOM_IssueTo_RadioGroup SearchBOM_IssueTo_RadioGroupGBInteger0
10TO_SITE_I SearchTo SiteSTR10_Location_CodeString10
11BOM_InDate_RadioGroup SearchBOM_InDate_RadioGroupGBInteger0
12EFFECTIVEINDATE_I SearchEffective In DateDTDate8
13BOM_OutDate_RadioGroup SearchBOM_OutDate_RadioGroupGBInteger0
14EFFECTIVEOUTDATE_I SearchEffective Out DateDTDate8
15BOM_Shrinkage_RadioGroup SearchBOM_Shrinkage_RadioGroupGBInteger0
16SHRINKAGEPERCENT_I SearchShrinkage%INTXXX.X%Long Integer4
17BOM_FixedQty_RadioGroup SearchBOM_FixedQty_RadioGroupGBInteger0
18FIXED_QTY_I SearchFixed QuantityDLR17_QTY_RBS0_UTRCurrency17
19BOM_FixedQtyUofM_RadioGr SearchBOM_FixedQtyUofM_RadioGroupGBInteger0
20U_Of_M_2 SearchU Of M 2U_Of_MString8
21BOM_LeadTime_RadioGroup SearchBOM_LeadTime_RadioGroupGBInteger0
22LEADTIMEOFFSET_I SearchLead Time OffsetDLR_10_3Currency18
23LEADTIMEOFFSETINC_I SearchLead Time Offset IncDDL_IncrementInteger0
24BOM_OffsetFrom_RadioGrou SearchBOM_OffsetFrom_RadioGroupGBInteger0
25OFFSET_FROM_I SearchOffset FromDDL_Offset_FromInteger0
26BOM_RefDesignators_Radio SearchBOM_RefDesignators_RadioGroupGBInteger0
27BOM_Backflush_RadioGroup SearchBOM_Backflush_RadioGroupGBInteger0
28BACKFLUSHITEM_I SearchBackflush ItemCB_Backflush ItemBoolean0
29BOM_FloorStock_RadioGrou SearchBOM_FloorStock_RadioGroupGBInteger0
30FLOORSTOCK_I SearchFloor StockCBBoolean0
31BOM_Alternate_RadioGroup SearchBOM_Alternate_RadioGroupGBInteger0
32ALTERNATE_I SearchAlternateCBBoolean0
33BOM_SingleLot_RadioGroup SearchBOM_SingleLot_RadioGroupGBInteger0
34BOMSINGLELOT_I SearchBOM_Single_LotCBBoolean0
35BOM_EngApproval_RadioGro SearchBOM_EngApproval_RadioGroupGBInteger0
36BOMENGAPPROVAL_I SearchBOM_Eng_ApprovalCBBoolean0
37BOM_ActConsumed_RadioGro SearchBOM_ActConsumed_RadioGroupGBInteger0
38ACTUAL_CONSUMED_CHECK_I SearchActual Consumed CheckCBBoolean0
39QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency17
40QTY_In_Variable_U_Of_M SearchQTY In Variable U Of MDLR17_QTY_RBS0_STRCurrency17
41DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyBOM_Mass_Changes_Line_Defaults (BM010117)

Leave a Reply

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