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 TypeSQL DB LengthKeyable Length
1CPN_I SearchCPNSTR30_Item_NumberString3230
2USERID SearchUser IDSTR15_User_IDString1615
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_RadioGroupGBInteger20
4QUANTITY_I SearchQuantityDLR12_RBN_UT2Currency1012
5BOM_UOFM_RadioGroup SearchBOM_UOFM_RadioGroupGBInteger20
6UOFM SearchU Of MU_Of_MString108
7BOM_IssueFrom_RadioGroup SearchBOM_IssueFrom_RadioGroupGBInteger20
8FROM_SITE_I SearchFrom SiteSTR10_Location_CodeString1210
9BOM_IssueTo_RadioGroup SearchBOM_IssueTo_RadioGroupGBInteger20
10TO_SITE_I SearchTo SiteSTR10_Location_CodeString1210
11BOM_InDate_RadioGroup SearchBOM_InDate_RadioGroupGBInteger20
12EFFECTIVEINDATE_I SearchEffective In DateDTDate48
13BOM_OutDate_RadioGroup SearchBOM_OutDate_RadioGroupGBInteger20
14EFFECTIVEOUTDATE_I SearchEffective Out DateDTDate48
15BOM_Shrinkage_RadioGroup SearchBOM_Shrinkage_RadioGroupGBInteger20
16SHRINKAGEPERCENT_I SearchShrinkage%INTXXX.X%Long Integer44
17BOM_FixedQty_RadioGroup SearchBOM_FixedQty_RadioGroupGBInteger20
18FIXED_QTY_I SearchFixed QuantityDLR17_QTY_RBS0_UTRCurrency1017
19BOM_FixedQtyUofM_RadioGr SearchBOM_FixedQtyUofM_RadioGroupGBInteger20
20U_Of_M_2 SearchU Of M 2U_Of_MString108
21BOM_LeadTime_RadioGroup SearchBOM_LeadTime_RadioGroupGBInteger20
22LEADTIMEOFFSET_I SearchLead Time OffsetDLR_10_3Currency1018
23LEADTIMEOFFSETINC_I SearchLead Time Offset IncDDL_IncrementInteger20
24BOM_OffsetFrom_RadioGrou SearchBOM_OffsetFrom_RadioGroupGBInteger20
25OFFSET_FROM_I SearchOffset FromDDL_Offset_FromInteger20
26BOM_RefDesignators_Radio SearchBOM_RefDesignators_RadioGroupGBInteger20
27BOM_Backflush_RadioGroup SearchBOM_Backflush_RadioGroupGBInteger20
28BACKFLUSHITEM_I SearchBackflush ItemCB_Backflush ItemBoolean20
29BOM_FloorStock_RadioGrou SearchBOM_FloorStock_RadioGroupGBInteger20
30FLOORSTOCK_I SearchFloor StockCBBoolean20
31BOM_Alternate_RadioGroup SearchBOM_Alternate_RadioGroupGBInteger20
32ALTERNATE_I SearchAlternateCBBoolean20
33BOM_SingleLot_RadioGroup SearchBOM_SingleLot_RadioGroupGBInteger20
34BOMSINGLELOT_I SearchBOM_Single_LotCBBoolean20
35BOM_EngApproval_RadioGro SearchBOM_EngApproval_RadioGroupGBInteger20
36BOMENGAPPROVAL_I SearchBOM_Eng_ApprovalCBBoolean20
37BOM_ActConsumed_RadioGro SearchBOM_ActConsumed_RadioGroupGBInteger20
38ACTUAL_CONSUMED_CHECK_I SearchActual Consumed CheckCBBoolean20
39QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency1017
40QTY_In_Variable_U_Of_M SearchQTY In Variable U Of MDLR17_QTY_RBS0_STRCurrency1017
41DEX_ROW_ID Searchintint1010

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 *