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 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: IV30004
Technical Name: ivBinQuantityTransferHISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE Document Type DDL_Document_Type Integer 0 2 Bin_XFer_Doc_Number Bin Transfer Document Number STR20_Document_Number String 20 3 Bin_XFer_Date Bin Transfer Date DT Date 8 4 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 5 ITEMNMBR Item Number STR30_Item_Number String 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'].ITEMNMBR
6 LOCNCODE Location Code STR10_Location_Code String 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'].LOCNCODE
7 QTYTYPE QTY Type DDL_QTY_Type Integer 0 8 FROMBIN From Bin STR15_Bin String 15 9 TOBIN To Bin STR15_Bin String 15 10 SERLTNUM Serial/Lot Number STR20 String 20 11 SERLTQTY Serial/Lot QTY DLR17_QTY_RBS0_UTR Currency 17 12 DATERECD Date Received DATE Date 6 13 DTSEQNUM Date SEQ Number Sequence_Number Currency 19 14 OVRSERLT Override Serial/Lot INT Integer 0 15 Reason_Code Reason Code STR15_LBAU String 15 16 USERID User ID STR15_User_ID String 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'].USERID
17 NOTEINDX Note Index DLR14 Currency 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
18 DEX_ROW_ID int int 10