Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WO010515Rebuild
Product: Manufacturing (346)
Series: 3rd Party
Display Name: Manufacture Order Serial Issue 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: WO010515Rebuild
Technical Name: WO010515RebuildSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITEMNMBR 
Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Manufacture Order Serial Issue'].ITEMNMBR AS 'Manufacture Order Serial Issue-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
WO010515Rebuild AS ['Manufacture Order Serial Issue']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Manufacture Order Serial Issue'].ITEMNMBR = ['Item Master'].ITEMNMBR2 MANUFACTUREORDER_I Manufacture Order STR30_UC String 30 3 SERLNMBR Serial Number STR20_LBAU String 20 4 DATERECD Date Received DATE Date 6 5 DTSEQNUM Date SEQ Number Sequence_Number Currency 19 6 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 7 RETURNTOSTOCKCB_I Return to Stock CB CB Boolean 0 8 SLTSQNUM Serial/Lot SEQ Number LI_Sequence_Number Long Integer 10 9 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Manufacture Order Serial Issue'].LOCNCODE AS 'Manufacture Order Serial Issue-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
WO010515Rebuild AS ['Manufacture Order Serial Issue']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Manufacture Order Serial Issue'].LOCNCODE = ['Site Setup'].LOCNCODE10 WCID_I WC ID STR10_Location_Code String 10 11 POSTED Posted True/False Boolean 0 12 SERLTQTY Serial/Lot QTY DLR17_QTY_RBS0_UTR Currency 17 13 IVDOCNBR IV Document Number STR17_IV_Document_Number String 17 14 IVDOCTYP IV Document Type DDL_IV_Document_Type Integer 0 15 OSRC_Shipped OSRC_Shipped Boolean Boolean 0 16 WIPSEQNMBR WIP SEQ Number Sequence_Number Currency 19 17 QTYCONSUMED QTY Consumed DLR17_QTY_RBS0_UTR Currency 17 18 QTYPENDING QTY Pending DLR17_QTY_RBS0_UTR Currency 17 19 NUMBERSCRAPPED_I Number Scrapped DLR_14_MRP Currency 14 20 ATYALLOC QTY Allocated DLR17_QTY_RBS0_UTR Currency 17 21 PICKNUMBER Pick Number STR17_LBAU_Pick_Number String 17 22 PICKLISTSEQ Picklist Seq LINT_10 Long Integer 10 23 QTY_BACKFLUSHED_I QTY Backflushed DLR17_QTY_RBS0_UTR Currency 17 24 SCRAPBACKFLUSHED Scrap Backflushed DLR17_QTY_RBS0_UTR Currency 17 25 SCRAPCONSUMED Scrap Consumed DLR17_QTY_RBS0_UTR Currency 17 26 BIN Bin STR15_Bin String 15 27 ROWID ROW_ID long Long Integer 8 28 DEX_ROW_ID int int 10