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