Bill Of Materials Log File (BM010300)

azurecurveProductsManufacturing (346)3rd PartyBill Of Materials Log File (BM010300)

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

Product: Manufacturing (346)
Series:

Display Name: Bill Of Materials Log File
Physical Name: BM010300
Technical Name: BOM_Log

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PPN_I SearchPPNStringSTR30_UC30
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Bill Of Materials Log File'].ITEMNMBR AS 'Bill Of Materials Log File-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       BM010300 AS ['Bill Of Materials Log File']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Bill Of Materials Log File'].ITEMNMBR = ['Item Master'].ITEMNMBR
3CHANGENUMBER_I SearchChange NumberIntegerINT54
4DESCRIPTIN50 SearchIC_DescriptionStringSTR5050
5UNIT_I SearchUnitStringSTR10_U10
6ADDCHG_I SearchAdd ChgStringSTR1515
7DATE1 SearchDateDateDT66
8TIME1 SearchTimeTimeTM66
9QUANTITY_I SearchQuantityCurrencyDLR12_RBN_UT212
10OPTPERCENT_I SearchOPT PercentLong IntegerINTXXX.X%4
11SCRAPPERCENT_I SearchScrap PercentLong IntegerINTXXX.X%4
12ALTERNATE_I SearchAlternateBooleanCB0
13ALTERNATEPARTFOR_I SearchAlternate Part ForStringSTR30_Item_Number30
14LEADTIMEOFFSET_I SearchLead Time OffsetCurrencyDLR_10_318
15BOMUSERDEF1_I SearchBOM User Def1StringSTR3030
16BOMUSERDEF2_I SearchBOM User Def2StringSTR_3030
17BOMSINGLELOT_I SearchBOM_Single_LotBooleanCB0
18BOMENGAPPROVAL_I SearchBOM_Eng_ApprovalBooleanCB0
19WCID_I SearchWC IDStringSTR10_Location_Code10
azurecurveProductsManufacturing (346)3rd PartyBill Of Materials Log File (BM010300)

Leave a Reply

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