PA Report Purchasing Receipt Line (POP10310)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt Line
Physical Name: POP10310
Technical Name: PA_POP_Report_ReceiptLine

Group Display Name: Purchasing Transactions
Group Technical Name: Purchasing Transactions

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	POPRCTNM	POP Receipt Number	STR17_POP_Number	String	18	17
2	RCPTLNNM	Receipt Line Number	LI_Sequence_Number	Long Integer	4	10
3	PONUMBER	PO Number	STR17_POP_Number	String	18	17
4	ITEMNMBR	Item Number	STR30_Item_Number	String	32	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Purchasing Receipt Line'].ITEMNMBR AS 'Purchasing Receipt Line-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN IV00101 AS ['Item Master'] ON ['Purchasing Receipt Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
5	ITEMDESC	Item Description	STR100	String	102	100
6	VNDITNUM	Vendor Item Number	Item_Number	String	32	30
7	VNDITDSC	Vendor Item Description	STR100	String	102	100
8	UMQTYINB	U Of M QTY In Base	DLR17_QTY_RBS0_STR	Currency	10	17
	The quantity of the base unit of measure that is equivalent to one of the units of measure being referenced.
9	ACTLSHIP	Actual Ship Date	DT	Date	4	8
10	COMMNTID	Comment ID	STR15_Comment_ID	String	16	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Purchasing Receipt Line'].COMMNTID AS 'Purchasing Receipt Line-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Purchasing Receipt Line'].COMMNTID = ['Comment Master'].COMMNTID
11	INVINDX	Inventory Index	LI_14	Long Integer	4	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Receipt Line'].INVINDX AS 'Purchasing Receipt Line-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Receipt Line'].INVINDX = ['Account Index Master'].ACTINDX
12	UOFM	U Of M	U_Of_M	String	10	8
	The unit of measure. The value in this field must exist in Inventory.
13	UNITCOST	Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
14	EXTDCOST	Extended Cost	DLR17_RBS0_UTR$	Currency	10	17
15	LOCNCODE	Location Code	STR10_Location_Code	String	12	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Purchasing Receipt Line'].LOCNCODE AS 'Purchasing Receipt Line-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Purchasing Receipt Line'].LOCNCODE = ['Site Setup'].LOCNCODE
16	RcptLineNoteIDArray	ReceiptLine Note ID Array	DLR14	Currency	10	14
17	RcptLineNoteIDArray_1	ReceiptLine Note ID Array[1]	DLR14	Currency	10	14
18	RcptLineNoteIDArray_2	ReceiptLine Note ID Array[2]	DLR14	Currency	10	14
19	RcptLineNoteIDArray_3	ReceiptLine Note ID Array[3]	DLR14	Currency	10	14
20	RcptLineNoteIDArray_4	ReceiptLine Note ID Array[4]	DLR14	Currency	10	14
21	RcptLineNoteIDArray_5	ReceiptLine Note ID Array[5]	DLR14	Currency	10	14
22	RcptLineNoteIDArray_6	ReceiptLine Note ID Array[6]	DLR14	Currency	10	14
23	RcptLineNoteIDArray_7	ReceiptLine Note ID Array[7]	DLR14	Currency	10	14
24	RcptLineNoteIDArray_8	ReceiptLine Note ID Array[8]	DLR14	Currency	10	14
25	NONINVEN	Non IV	INT1	Integer	2	1
	Used to indicate whether an item is an inventory item or non-inventory item. Click to show/hide PO Line Statuses 0 Inventory item 1 Non-inventory item
26	DECPLCUR	Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	2	0
	Number of decimal places for the currency values, based on the item's settings. Click to show/hide Decimal Places Currency 7 0 decimals 8 1 9 2 10 3 11 4 12 5
27	DECPLQTY	Decimal Places QTYS	DDL_Decimal_Places_QTYS	Integer	2	0
	Number of decimal places for the quantities. Click to show/hide Decimal Places Currency 1 0 decimals 2 1 3 2 4 3 5 4 6 5
28	ITMTRKOP	Item Tracking Option	DDL_Track	Integer	2	0
	Designation for the tracking type of the Item. Click to show/hide Item Tracking Options 1 0 decimals 2 1 3 2 4 3 5 4 6 5
29	VCTNMTHD	Valuation Method	DDL_Valuation_Method	Integer	2	0
	The valuation method for the inventory line item. Click to show/hide Valuation methods 1 FIFO Perpetual 2 LIFO Perpetual 3 Average Perpetual 4 FIFO Periodic 5 LIFO Periodic
30	TRXSORCE	TRX Source	STR13	String	14	13
31	JOBNUMBR	Job Number	STR17_LBAU	String	18	17
32	COSTCODE	Cost Code	STR27	String	28	27
33	COSTTYPE	Cost Code Type	INT3_RB0_U	Integer	2	3
34	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt Line'].CURNCYID AS 'Purchasing Receipt Line-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt Line'].CURNCYID = ['Currency Setup'].CURNCYID
35	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt Line'].CURRNIDX AS 'Purchasing Receipt Line-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt Line'].CURRNIDX = ['Currency Setup'].CURRNIDX
36	RATETPID	Rate Type ID	STR15_Rate_Type_ID	String	16	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Purchasing Receipt Line'].RATETPID AS 'Purchasing Receipt Line-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Purchasing Receipt Line'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
37	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
38	RATECALC	Rate Calc Method	INT	Integer	2	0
	Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank. Click to show/hide Rate Calc Methods 0 Multiply 1 Divide
39	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
40	ORUNTCST	Originating Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
41	OREXTCST	Originating Extended Cost	DLR17_RBS0_UTR$	Currency	10	17
42	ODECPLCU	Originating Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	2	0
43	BOLPRONUMBER	BOL_PRO Number	STR30	String	32	30
44	Capital_Item	Capital Item	CB_Capital_Item	Boolean	2	0
45	Product_Indicator	Product Indicator	DDL_Product_Indicator	Integer	2	0
46	Purchase_IV_Item_Taxable	Purchase IV Item Taxable	DDL_Purchase_Tax_Options	Integer	2	0
	Purchase Inventory Item Taxable setting. Click to show/hide Purchase IV Item Taxable 1 Taxable 2 Non-taxable 3 Base on Vendor
47	Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt Line'].Purchase_Item_Tax_Schedu AS 'Purchasing Receipt Line-Purchase Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt Line'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
48	Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt Line'].Purchase_Site_Tax_Schedu AS 'Purchasing Receipt Line-Purchase Site Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt Line'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49	BSIVCTTL	Based On Invoice Total	YN	Boolean	2	0
50	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
51	ORTAXAMT	Originating Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
52	BCKTXAMT	Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
53	OBTAXAMT	Originating Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
54	Revalue_Inventory	Revalue Inventory	CB_Revalue_Inventory	Boolean	2	0
55	Tolerance_Percentage	Tolerance Percentage	LI7_U%3	Long Integer	4	7
56	PURPVIDX	Purchase Price Variance Index	LI_14	Long Integer	4	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Receipt Line'].PURPVIDX AS 'Purchasing Receipt Line-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Receipt Line'].PURPVIDX = ['Account Index Master'].ACTINDX
57	Remaining_AP_Amount	Remaining AP Amount	DLR17_RBS0_UTR$	Currency	10	17
58	SHIPMTHD	Shipping Method	STR15_Shipping_Method	String	16	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Purchasing Receipt Line'].SHIPMTHD AS 'Purchasing Receipt Line-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM POP10310 AS ['Purchasing Receipt Line'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Purchasing Receipt Line'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
59	Landed_Cost_Group_ID	Landed Cost Group ID	STR15_LBAU	String	16	15
60	Landed_Cost_Warnings	Landed Cost Warnings	INT3	Integer	2	3
61	BackoutTradeDiscTax	Backout Trade Discount Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
62	OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
63	Landed_Cost	Landed Cost	CB	Boolean	2	0
64	Invoice_Match	Invoice Match	CB_Invoice_Match	Boolean	2	0
65	RCPTRETNUM	Receipt Return Number	STR17_POP_Number	String	18	17
66	RCPTRETLNNUM	Receipt Return Line Number	LI_Sequence_Number	Long Integer	4	10
67	INVRETNUM	Invoice Return Number	STR17_POP_Number	String	18	17
68	INVRETLNNUM	Invoice Return Line Number	LI_Sequence_Number	Long Integer	4	10
69	ISLINEINTRA	IsLineIntrastat	CB	Boolean	2	0
70	ProjNum	Project Number	STR15_LBAU	String	16	15
71	CostCatID	Cost Category ID	STR15_LBAU	String	16	15
72	TrackedDropShipped	TrackedDropShipped	CB	Boolean	2	0
73	OriginatingPrepaymentAmt	Originating Prepayment Amount	DLR19_RBS0_UTR$	Currency	10	19
74	ORDISTKN	Originating Discount Taken Amount	DLR17_RBS0_UTR$	Currency	10	17
75	ORTDISAM	Originating Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
76	ORFRTAMT	Originating Freight Amount	DLR17_RBS0_UTR$	Currency	10	17
77	ORMISCAMT	Originating Misc Amount	DLR19_RBSO_UTR$	Currency	10	19
78	OriginatingPPTaxAmount	Originating Prepayment Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
79	DEX_ROW_ID		int	int	10	10
	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.

azurecurve Products Project Accounting (258)PurchasingPA Report Purchasing Receipt Line (POP10310)

Leave a Reply Cancel reply