Purchasing Receipt Line History (POP30310)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt Line History (POP30310)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt Line History
Physical Name: POP30310
Technical Name: POP_ReceiptLineHist

Group Display Name: Purchasing History
Group Technical Name: Purchasing History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
2	RCPTLNNM	Receipt Line Number	Long Integer	LI_Sequence_Number	10
3	PONUMBER	PO Number	String	STR17_POP_Number	17
4	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Purchasing Receipt Line History'].ITEMNMBR AS 'Purchasing Receipt Line History-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN IV00101 AS ['Item Master'] ON ['Purchasing Receipt Line History'].ITEMNMBR = ['Item Master'].ITEMNMBR
5	ITEMDESC	Item Description	String	STR100	100
6	VNDITNUM	Vendor Item Number	String	Item_Number	30
7	VNDITDSC	Vendor Item Description	String	STR100	100
8	UMQTYINB	U Of M QTY In Base	Currency	DLR17_QTY_RBS0_STR	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	Date	DT	8
10	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Purchasing Receipt Line History'].COMMNTID AS 'Purchasing Receipt Line History-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Purchasing Receipt Line History'].COMMNTID = ['Comment Master'].COMMNTID
11	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Receipt Line History'].INVINDX AS 'Purchasing Receipt Line History-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Receipt Line History'].INVINDX = ['Account Index Master'].ACTINDX
12	UOFM	U Of M	String	U_Of_M	8
	The unit of measure. The value in this field must exist in Inventory.
13	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
14	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
15	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Purchasing Receipt Line History'].LOCNCODE AS 'Purchasing Receipt Line History-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Purchasing Receipt Line History'].LOCNCODE = ['Site Setup'].LOCNCODE
16	RcptLineNoteIDArray	ReceiptLine Note ID Array	DLR14	Currency	14
17	RcptLineNoteIDArray_1	ReceiptLine Note ID Array[1]	Currency	DLR14	14
18	RcptLineNoteIDArray_2	ReceiptLine Note ID Array[2]	Currency	DLR14	14
19	RcptLineNoteIDArray_3	ReceiptLine Note ID Array[3]	Currency	DLR14	14
20	RcptLineNoteIDArray_4	ReceiptLine Note ID Array[4]	Currency	DLR14	14
21	RcptLineNoteIDArray_5	ReceiptLine Note ID Array[5]	Currency	DLR14	14
22	RcptLineNoteIDArray_6	ReceiptLine Note ID Array[6]	Currency	DLR14	14
23	RcptLineNoteIDArray_7	ReceiptLine Note ID Array[7]	Currency	DLR14	14
24	RcptLineNoteIDArray_8	ReceiptLine Note ID Array[8]	Currency	DLR14	14
25	NONINVEN	Non IV	Integer	INT1	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	Integer	DDL_Decimal_Places_Dollars	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	Integer	DDL_Decimal_Places_QTYS	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	Integer	DDL_Track	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	TRXSORCE	TRX Source	String	STR13	13
30	JOBNUMBR	Job Number	String	STR17_LBAU	17
31	COSTCODE	Cost Code	String	STR27	27
32	COSTTYPE	Cost Code Type	Integer	INT3_RB0_U	3
33	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt Line History'].CURRNIDX AS 'Purchasing Receipt Line History-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt Line History'].CURRNIDX = ['Currency Setup'].CURRNIDX
34	ORUNTCST	Originating Unit Cost	Currency	DLR17_RBS0_UTR$	17
35	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
36	ODECPLCU	Originating Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
37	BOLPRONUMBER	BOL_PRO Number	String	STR30	30
38	Capital_Item	Capital Item	Boolean	CB_Capital_Item	0
39	Product_Indicator	Product Indicator	Integer	DDL_Product_Indicator	0
40	Purchase_IV_Item_Taxable	Purchase IV Item Taxable	Integer	DDL_Purchase_Tax_Options	0
	Purchase Inventory Item Taxable setting. Click to show/hide Purchase IV Item Taxable 1 Taxable 2 Non-taxable 3 Base on Vendor
41	Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt Line History'].Purchase_Item_Tax_Schedu AS 'Purchasing Receipt Line History-Purchase Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt Line History'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
42	Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt Line History'].Purchase_Site_Tax_Schedu AS 'Purchasing Receipt Line History-Purchase Site Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt Line History'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
43	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
44	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
45	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
46	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
47	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
48	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Receipt Line History'].PURPVIDX AS 'Purchasing Receipt Line History-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Receipt Line History'].PURPVIDX = ['Account Index Master'].ACTINDX
49	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Purchasing Receipt Line History'].SHIPMTHD AS 'Purchasing Receipt Line History-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM POP30310 AS ['Purchasing Receipt Line History'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Purchasing Receipt Line History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
50	Landed_Cost_Group_ID	Landed Cost Group ID	String	STR15_LBAU	15
51	Landed_Cost_Warnings	Landed Cost Warnings	Integer	INT3	3
52	Landed_Cost	Landed Cost	Boolean	CB	0
53	Invoice_Match	Invoice Match	Boolean	CB_Invoice_Match	0
54	RCPTRETNUM	Receipt Return Number	String	STR17_POP_Number	17
55	RCPTRETLNNUM	Receipt Return Line Number	Long Integer	LI_Sequence_Number	10
56	INVRETNUM	Invoice Return Number	String	STR17_POP_Number	17
57	INVRETLNNUM	Invoice Return Line Number	Long Integer	LI_Sequence_Number	10
58	ISLINEINTRA	IsLineIntrastat	Boolean	CB	0
59	ProjNum	Project Number	String	STR15_LBAU	15
60	CostCatID	Cost Category ID	String	STR15_LBAU	15
61	TrackedDropShipped	TrackedDropShipped	Boolean	CB	0
62	OriginatingPrepaymentAmt	Originating Prepayment Amount	Currency	DLR19_RBS0_UTR$	19
63	ORDISTKN	Originating Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
64	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
65	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
66	ORMISCAMT	Originating Misc Amount	Currency	DLR19_RBSO_UTR$	19
67	OriginatingPPTaxAmount	Originating Prepayment Tax Amount	Currency	DLR17_RBS0_UTR$	17

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt Line History (POP30310)

Leave a Reply Cancel reply