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 SQL DB Length Keyable Length 1 ITEMNMBR 
Item Number STR30_Item_Number String 32 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 32 30 3 SERLNMBR Serial Number STR20_LBAU String 22 20 4 DATERECD Date Received DATE Date 4 6 5 DTSEQNUM Date SEQ Number Sequence_Number Currency 10 19 6 LNSEQNBR Line SEQ Number Sequence_Number Currency 10 19 7 RETURNTOSTOCKCB_I Return to Stock CB CB Boolean 2 0 8 SLTSQNUM Serial/Lot SEQ Number LI_Sequence_Number Long Integer 4 10 9 LOCNCODE Location Code STR10_Location_Code String 12 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 12 10 11 POSTED Posted True/False Boolean 2 0 12 SERLTQTY Serial/Lot QTY DLR17_QTY_RBS0_UTR Currency 10 17 13 IVDOCNBR IV Document Number STR17_IV_Document_Number String 18 17 14 IVDOCTYP IV Document Type DDL_IV_Document_Type Integer 2 0 15 OSRC_Shipped OSRC_Shipped Boolean Boolean 2 0 16 WIPSEQNMBR WIP SEQ Number Sequence_Number Currency 10 19 17 QTYCONSUMED QTY Consumed DLR17_QTY_RBS0_UTR Currency 10 17 18 QTYPENDING QTY Pending DLR17_QTY_RBS0_UTR Currency 10 17 19 NUMBERSCRAPPED_I Number Scrapped DLR_14_MRP Currency 10 14 20 ATYALLOC QTY Allocated DLR17_QTY_RBS0_UTR Currency 10 17 21 PICKNUMBER Pick Number STR17_LBAU_Pick_Number String 18 17 22 PICKLISTSEQ Picklist Seq LINT_10 Long Integer 4 10 23 QTY_BACKFLUSHED_I QTY Backflushed DLR17_QTY_RBS0_UTR Currency 10 17 24 SCRAPBACKFLUSHED Scrap Backflushed DLR17_QTY_RBS0_UTR Currency 10 17 25 SCRAPCONSUMED Scrap Consumed DLR17_QTY_RBS0_UTR Currency 10 17 26 BIN Bin STR15_Bin String 16 15 27 ROWID ROW_ID long Long Integer 4 8 28 DEX_ROW_ID int int 10 10