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 SQL DB Length Keyable Length 1 USERID2_I 
User ID2 STR15_User_ID String 16 15 2 PICKNUMBER Pick Number STR17_LBAU_Pick_Number String 18 17 3 MANUFACTUREORDER_I Manufacture Order STR30_UC String 32 30 4 PICKLISTSEQ Picklist Seq LINT_10 Long Integer 4 10 5 DSCRIPTN Description STR30 String 32 30 6 ITEMNMBR Item Number STR30_Item_Number String 32 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 102 100 8 POSITION_NUMBER Position Number INT4_RB_U0 Integer 2 4 9 ORIGPICKNUMBER Originating Pick Number STR17_LBAU_Pick_Number String 18 17 10 ORIG_PICK_DOC_LINE_NUM Originating Pick Doc Line Number LI_Sequence_Number Long Integer 4 10 11 BOMTYPE_I BOM Type DDL_BOM_Type Integer 2 0 12 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 10 17 13 UOFM U Of M U_Of_M String 10 8 14 TO_SITE_I To Site STR10_Location_Code String 12 10 15 FROM_SITE_I From Site STR10_Location_Code String 12 10 16 MOP_REQUIRED_QUANTITY_I MOP Required Quantity DLR14_RS5 Currency 10 0 17 U_Of_M_2 U Of M 2 U_Of_M String 10 8 18 REQDATE Required Date DATE_L Date 4 0 19 FGDITMNM Finished Good Item Number Item_Number String 32 30 20 ALTERNATEPARTFOR_I Alternate Part For STR30_Item_Number String 32 30 21 ALT_FOR_SEQ_I Alternate For Sequence LINT_10 Long Integer 4 10 22 BOMSINGLELOT_I BOM_Single_Lot CB Boolean 2 0 23 BACKFLUSHCB Backflush CB CB_Backflush Boolean 2 0 24 USERID User ID STR15_User_ID String 16 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 4 6 26 QTYBSUOM QTY In Base U Of M DLR17_QTY_RBS0_STR Currency 10 17 27 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 2 0 28 QTYSLCTD QTY Selected DLR17_QTY_RBS0_UTR Currency 10 17 29 ITMTRKOP Item Tracking Option DDL_Track Integer 2 0 30 CB_I CB CB Boolean 2 0 31 STR20DUMMY_I STR20 Dummy STR20 String 22 20 32 JOBNUMBER_I Job Num STR30 String 32 30 33 INITIAL_QTY_I Initial QTY DLR17_QTY_RBS0_STR Currency 10 17 34 DEX_ROW_ID int int 10 10