Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00702V
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: IV Transfer Order Line Serial Lot View
Physical Name: IV00702V
Technical Name: ivTransferOrderLineSerialLotViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ORDDOCID 
Order Document ID String STR15_LBAU 15 2 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 3 QTYTYPE QTY Type Integer DDL_QTY_Type 0 4 SERLTNUM Serial/Lot Number String STR20 20 5 SERLTQTY Serial/Lot QTY Currency DLR17_QTY_RBS0_UTR 17 6 SLTSQNUM Serial/Lot SEQ Number Long Integer LI_Sequence_Number 10 7 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['IV Transfer Order Line Serial Lot View'].ITEMNMBR AS 'IV Transfer Order Line Serial Lot View-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV00702V AS ['IV Transfer Order Line Serial Lot View']
INNER JOIN
IV00101 AS ['Item Master']
ON
['IV Transfer Order Line Serial Lot View'].ITEMNMBR = ['Item Master'].ITEMNMBR8 DATERECD Date Received Date DATE 6 9 POSTED Posted Boolean True/False 0 10 FROMBIN From Bin String STR15_Bin 15 11 TOBIN To Bin String STR15_Bin 15 12 Status Status Integer INT 0 13 OVRSERLT Override Serial/Lot Integer INT 0 14 MFGDATE Manufacture Date Date DT_Date 6 15 EXPNDATE Expiration Date Date DT_Date 6 16 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 17 DTSEQNUM Date SEQ Number Currency Sequence_Number 19