Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BM010416
Product: Manufacturing (346)
Series:
Display Name: BOM_Revision_HIST
Physical Name: BM010416
Technical Name: BOM_Revision_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITEMNMBR 
Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['BOM_Revision_HIST'].ITEMNMBR AS 'BOM_Revision_HIST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
BM010416 AS ['BOM_Revision_HIST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['BOM_Revision_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR2 BOMCAT_I BOM Cat Integer DDL_BOM_Cat 0 3 BOMNAME_I BOM Name String STR15_LBU 15 4 REVISIONLEVEL_I Revision Level String STR50 50 5 REV_LEVEL_SEQ Revision Level Sequence Long Integer LINT_10 10 6 EFFECTIVEDATE_I Effective Date0 Date DT 8 7 BACKFLUSHITEM_I Backflush Item Boolean CB_Backflush Item 0 8 BOMTYPE_I BOM Type Integer DDL_BOM_Type 0 9 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['BOM_Revision_HIST'].LOCNCODE AS 'BOM_Revision_HIST-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
BM010416 AS ['BOM_Revision_HIST']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['BOM_Revision_HIST'].LOCNCODE = ['Site Setup'].LOCNCODE10 WCID_I WC ID String STR10_Location_Code 10 11 Net_Phantom_Inventory Net Phantom Inventory Boolean CB 0 12 CHANGEDATE_I Change Date Date DT 8 13 CHANGEBY_I Change By String STR15_User_ID 15 14 MFGNOTEINDEX3_I MFG Note Index3 Currency DLR14 14