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

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 SearchPPNSTR30_UCString30
2ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 NumberINT5Integer4
4DESCRIPTIN50 SearchIC_DescriptionSTR50String50
5UNIT_I SearchUnitSTR10_UString10
6ADDCHG_I SearchAdd ChgSTR15String15
7DATE1 SearchDateDT6Date6
8TIME1 SearchTimeTM6Time6
9QUANTITY_I SearchQuantityDLR12_RBN_UT2Currency12
10OPTPERCENT_I SearchOPT PercentINTXXX.X%Long Integer4
11SCRAPPERCENT_I SearchScrap PercentINTXXX.X%Long Integer4
12ALTERNATE_I SearchAlternateCBBoolean0
13ALTERNATEPARTFOR_I SearchAlternate Part ForSTR30_Item_NumberString30
14LEADTIMEOFFSET_I SearchLead Time OffsetDLR_10_3Currency18
15BOMUSERDEF1_I SearchBOM User Def1STR30String30
16BOMUSERDEF2_I SearchBOM User Def2STR_30String30
17BOMSINGLELOT_I SearchBOM_Single_LotCBBoolean0
18BOMENGAPPROVAL_I SearchBOM_Eng_ApprovalCBBoolean0
19WCID_I SearchWC IDSTR10_Location_CodeString10
20DEX_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 PartyBill Of Materials Log File (BM010300)

Leave a Reply

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