Inventory Purchase Receipts Sequence Number (IV10202)

azurecurve Products Microsoft Dynamics GP (0)InventoryInventory Purchase Receipts Sequence Number (IV10202)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Inventory Purchase Receipts Sequence Number
Physical Name: IV10202
Technical Name: IV_Purchase_Receipts_SEQ

Seq 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 ['Inventory Purchase Receipts Sequence Number'].ITEMNMBR AS 'Inventory Purchase Receipts Sequence Number-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM IV10202 AS ['Inventory Purchase Receipts Sequence Number'] INNER JOIN IV00101 AS ['Item Master'] ON ['Inventory Purchase Receipts Sequence Number'].ITEMNMBR = ['Item Master'].ITEMNMBR
2	RCTSEQNM	Receipt SEQ Number	Long Integer	long	8

Seq No

Physical Name

Display Name

Dexterity Data Type

SQL Data Type

Length

ITEMNMBR

Item Number

String

STR30_Item_Number

Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Inventory Purchase Receipts Sequence Number'].ITEMNMBR AS 'Inventory Purchase Receipts Sequence Number-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       IV10202 AS ['Inventory Purchase Receipts Sequence Number']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Inventory Purchase Receipts Sequence Number'].ITEMNMBR = ['Item Master'].ITEMNMBR

RCTSEQNM

Receipt SEQ Number

Long Integer

long

azurecurve Products Microsoft Dynamics GP (0)InventoryInventory Purchase Receipts Sequence Number (IV10202)

Click to show/hide

Leave a Reply Cancel reply