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