Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV30004
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Inventory Bin Quantity Transfer History
Physical Name: IV30004
Technical Name: ivBinQuantityTransferHISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE 
Document Type Integer DDL_Document_Type 0 2 Bin_XFer_Doc_Number Bin Transfer Document Number String STR20_Document_Number 20 3 Bin_XFer_Date Bin Transfer Date Date DT 8 4 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 5 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Inventory Bin Quantity Transfer History'].ITEMNMBR AS 'Inventory Bin Quantity Transfer History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV30004 AS ['Inventory Bin Quantity Transfer History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Inventory Bin Quantity Transfer History'].ITEMNMBR = ['Item Master'].ITEMNMBR6 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Inventory Bin Quantity Transfer History'].LOCNCODE AS 'Inventory Bin Quantity Transfer History-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV30004 AS ['Inventory Bin Quantity Transfer History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Inventory Bin Quantity Transfer History'].LOCNCODE = ['Site Setup'].LOCNCODE7 QTYTYPE QTY Type Integer DDL_QTY_Type 0 8 FROMBIN From Bin String STR15_Bin 15 9 TOBIN To Bin String STR15_Bin 15 10 SERLTNUM Serial/Lot Number String STR20 20 11 SERLTQTY Serial/Lot QTY Currency DLR17_QTY_RBS0_UTR 17 12 DATERECD Date Received Date DATE 6 13 DTSEQNUM Date SEQ Number Currency Sequence_Number 19 14 OVRSERLT Override Serial/Lot Integer INT 0 15 Reason_Code Reason Code String STR15_LBAU 15 16 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Inventory Bin Quantity Transfer History'].USERID AS 'Inventory Bin Quantity Transfer History-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
IV30004 AS ['Inventory Bin Quantity Transfer History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Inventory Bin Quantity Transfer History'].USERID = ['Users Master'].USERID17 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Inventory Bin Quantity Transfer History'].NOTEINDX AS 'Inventory Bin Quantity Transfer History-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
IV30004 AS ['Inventory Bin Quantity Transfer History']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Inventory Bin Quantity Transfer History'].NOTEINDX = ['Record Notes Master'].NOTEINDX