Inventory Bin Quantity Transfer (IV10004)

azurecurve Products Microsoft Dynamics GP (0)InventoryInventory Bin Quantity Transfer (IV10004)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV10004

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Inventory Bin Quantity Transfer
Physical Name: IV10004
Technical Name: ivBinQuantityTransfer

Seq 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'].ITEMNMBR AS 'Inventory Bin Quantity Transfer-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM IV10004 AS ['Inventory Bin Quantity Transfer'] INNER JOIN IV00101 AS ['Item Master'] ON ['Inventory Bin Quantity Transfer'].ITEMNMBR = ['Item Master'].ITEMNMBR
6	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Inventory Bin Quantity Transfer'].LOCNCODE AS 'Inventory Bin Quantity Transfer-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM IV10004 AS ['Inventory Bin Quantity Transfer'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Inventory Bin Quantity Transfer'].LOCNCODE = ['Site Setup'].LOCNCODE
7	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'].USERID AS 'Inventory Bin Quantity Transfer-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM IV10004 AS ['Inventory Bin Quantity Transfer'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Inventory Bin Quantity Transfer'].USERID = ['Users Master'].USERID
17	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Inventory Bin Quantity Transfer'].NOTEINDX AS 'Inventory Bin Quantity Transfer-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM IV10004 AS ['Inventory Bin Quantity Transfer'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Inventory Bin Quantity Transfer'].NOTEINDX = ['Record Notes Master'].NOTEINDX

azurecurve Products Microsoft Dynamics GP (0)InventoryInventory Bin Quantity Transfer (IV10004)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply