Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOPW200
Product: Manufacturing (346)
Series: 3rd Party
Display Name: MOP_Comp_Trx_Items_Tab_WORK 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.
Physical Name: MOPW200
Technical Name: MOP_Comp_Trx_Items_Tab_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID2_I 
User ID2 STR15_User_ID String 15 2 PICKNUMBER Pick Number STR17_LBAU_Pick_Number String 17 3 MANUFACTUREORDER_I Manufacture Order STR30_UC String 30 4 PICKLISTSEQ Picklist Seq LINT_10 Long Integer 10 5 DSCRIPTN Description STR30 String 30 6 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['MOP_Comp_Trx_Items_Tab_WORK'].ITEMNMBR AS 'MOP_Comp_Trx_Items_Tab_WORK-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOPW200 AS ['MOP_Comp_Trx_Items_Tab_WORK']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MOP_Comp_Trx_Items_Tab_WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR7 ITEMDESC Item Description STR100 String 100 8 POSITION_NUMBER Position Number INT4_RB_U0 Integer 4 9 ORIGPICKNUMBER Originating Pick Number STR17_LBAU_Pick_Number String 17 10 ORIG_PICK_DOC_LINE_NUM Originating Pick Doc Line Number LI_Sequence_Number Long Integer 10 11 BOMTYPE_I BOM Type DDL_BOM_Type Integer 0 12 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 17 13 UOFM U Of M U_Of_M String 8 14 TO_SITE_I To Site STR10_Location_Code String 10 15 FROM_SITE_I From Site STR10_Location_Code String 10 16 MOP_REQUIRED_QUANTITY_I MOP Required Quantity DLR14_RS5 Currency 0 17 U_Of_M_2 U Of M 2 U_Of_M String 8 18 REQDATE Required Date DATE_L Date 0 19 FGDITMNM Finished Good Item Number Item_Number String 30 20 ALTERNATEPARTFOR_I Alternate Part For STR30_Item_Number String 30 21 ALT_FOR_SEQ_I Alternate For Sequence LINT_10 Long Integer 10 22 BOMSINGLELOT_I BOM_Single_Lot CB Boolean 0 23 BACKFLUSHCB Backflush CB CB_Backflush Boolean 0 24 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['MOP_Comp_Trx_Items_Tab_WORK'].USERID AS 'MOP_Comp_Trx_Items_Tab_WORK-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MOPW200 AS ['MOP_Comp_Trx_Items_Tab_WORK']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MOP_Comp_Trx_Items_Tab_WORK'].USERID = ['Users Master'].USERID25 DATEPICKED Date Picked Date Date 6 26 QTYBSUOM QTY In Base U Of M DLR17_QTY_RBS0_STR Currency 17 27 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 0 28 QTYSLCTD QTY Selected DLR17_QTY_RBS0_UTR Currency 17 29 ITMTRKOP Item Tracking Option DDL_Track Integer 0 30 CB_I CB CB Boolean 0 31 STR20DUMMY_I STR20 Dummy STR20 String 20 32 JOBNUMBER_I Job Num STR30 String 30 33 INITIAL_QTY_I Initial QTY DLR17_QTY_RBS0_STR Currency 17 34 DEX_ROW_ID int int 10