Bill Of Material Line File (BM010115)

azurecurveProductsManufacturing (346)3rd PartyBill Of Material Line File (BM010115)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BM010115

Product: Manufacturing (346)
Series:

Display Name: Bill Of Material Line File
Physical Name: BM010115
Technical Name: BOM_Line

Group Display Name: Manufacturing BOM
Group Technical Name: Manufacturing BOM

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PPN_I SearchPPNStringSTR30_UC30
2CPN_I SearchCPNStringSTR30_Item_Number30
3BOMCAT_I SearchBOM CatIntegerDDL_BOM_Cat0
4BOMNAME_I SearchBOM NameStringSTR15_LBU15
5BOMTYPE_I SearchBOM TypeIntegerDDL_BOM_Type0
6BOMSEQ_I SearchBOM SeqLong IntegerLINT_1010
7POSITION_NUMBER SearchPosition NumberIntegerINT4_RB_U04
8SUBCAT_I SearchSub CatIntegerDDL_BOM_Cat0
9SUBNAME_I SearchSub NameStringSTR15_LBU15
10SUB_REV_LEVEL_SEQ_I SearchSub Revision Level SequenceLong IntegerLINT_1010
11QUANTITY_I SearchQuantityCurrencyDLR12_RBN_UT212
12OPTPERCENT_I SearchOPT PercentLong IntegerINTXXX.X%4
13SCRAPPERCENT_I SearchScrap PercentLong IntegerINTXXX.X%4
14FLOORSTOCK_I SearchFloor StockBooleanCB0
15EFFECTIVEINDATE_I SearchEffective In DateDateDT8
16EFFECTIVEOUTDATE_I SearchEffective Out DateDateDT8
17ALTERNATE_I SearchAlternateBooleanCB0
18ALTERNATEPARTFOR_I SearchAlternate Part ForStringSTR30_Item_Number30
19ALT_FOR_BOM_SEQ_I SearchAlt For BOM SeqLong IntegerLINT_1010
20LEADTIMEOFFSET_I SearchLead Time OffsetCurrencyDLR_10_318
21LEADTIMEOFFSETINC_I SearchLead Time Offset IncIntegerDDL_Increment0
22BOMUSERDEF1_I SearchBOM User Def1StringSTR3030
23BOMUSERDEF2_I SearchBOM User Def2StringSTR_3030
24BOMSINGLELOT_I SearchBOM_Single_LotBooleanCB0
25BOMENGAPPROVAL_I SearchBOM_Eng_ApprovalBooleanCB0
26WCID_I SearchWC IDStringSTR10_Location_Code10
27LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Bill Of Material Line File'].LOCNCODE AS 'Bill Of Material Line File-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       BM010115 AS ['Bill Of Material Line File']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Bill Of Material Line File'].LOCNCODE = ['Site Setup'].LOCNCODE
28BACKFLUSHITEM_I SearchBackflush ItemBooleanCB_Backflush Item0
29CHANGEDATE_I SearchChange DateDateDT8
30USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Bill Of Material Line File'].USERID AS 'Bill Of Material Line File-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       BM010115 AS ['Bill Of Material Line File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Bill Of Material Line File'].USERID = ['Users Master'].USERID
31OPTIONED_ITEM_I SearchOptioned ItemBooleanCB0
32ACTUAL_CONSUMED_CHECK_I SearchActual Consumed CheckBooleanCB0
33FIXED_QTY_I SearchFixed QuantityCurrencyDLR17_QTY_RBS0_UTR17
34UOFM SearchU Of MStringU_Of_M8
35U_Of_M_2 SearchU Of M 2StringU_Of_M8
36QTYBSUOM SearchQTY In Base U Of MCurrencyDLR17_QTY_RBS0_STR17
37OFFSET_FROM_I SearchOffset FromIntegerDDL_Offset_From0
38MFGNOTEINDEX_I SearchMFG Note IndexCurrencyDLR1414
39MFGNOTEINDEX2_I SearchMFG Note Index2CurrencyDLR1414
azurecurveProductsManufacturing (346)3rd PartyBill Of Material Line File (BM010115)

Leave a Reply

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