Purchase Order Line History (POP30110)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchase Order Line History (POP30110)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchase Order Line History
Physical Name: POP30110
Technical Name: PA_POP_Report_POLineHist

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	STR17_POP_Number	String	17
2	ORD	Ord	LI_Sequence_Number	Long Integer	10
3	POLNESTA	PO Line Status	DDL_PO_Line_Status	Integer	0
	Status assigned to the Purchase Order Line for the order status. Click to show/hide PO Line Statuses 1 New 2 Released (i.e. emailed/printed) 3 Change Order 4 Received 5 Closed 6 Cancelled
4	POTYPE	PO Type	DDL_POP_PO_Type	Integer	0
	Type of Purchase Order. Click to show/hide PO Types 1 Standard 2 Drop Ship 3 Blanket 4 Blanket Drop Ship
5	ITEMNMBR	Item Number	STR30_Item_Number	String	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Purchase Order Line History'].ITEMNMBR AS 'Purchase Order Line History-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN IV00101 AS ['Item Master'] ON ['Purchase Order Line History'].ITEMNMBR = ['Item Master'].ITEMNMBR
6	ITEMDESC	Item Description	STR100	String	100
7	VENDORID	Vendor ID	STR_15_Vendor_ID	String	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Purchase Order Line History'].VENDORID AS 'Purchase Order Line History-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchase Order Line History'].VENDORID = ['PM Vendor Master File'].VENDORID
8	VNDITNUM	Vendor Item Number	Item_Number	String	30
9	VNDITDSC	Vendor Item Description	STR100	String	100
10	NONINVEN	Non IV	INT1	Integer	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
11	LOCNCODE	Location Code	STR10_Location_Code	String	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Purchase Order Line History'].LOCNCODE AS 'Purchase Order Line History-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Purchase Order Line History'].LOCNCODE = ['Site Setup'].LOCNCODE
12	UOFM	U Of M	U_Of_M	String	8
	The unit of measure. The value in this field must exist in Inventory.
13	UMQTYINB	U Of M QTY In Base	DLR17_QTY_RBS0_STR	Currency	17
	The quantity of the base unit of measure that is equivalent to one of the units of measure being referenced.
14	QTYORDER	QTY Ordered	DLR17_QTY_RBS0_UTR	Currency	17
15	QTYCANCE	QTY Canceled	DLR17_QTY_RBS0_UTR	Currency	17
16	UNITCOST	Unit Cost	DLR17_RBS0_UTR$	Currency	17
17	EXTDCOST	Extended Cost	DLR17_RBS0_UTR$	Currency	17
18	INVINDX	Inventory Index	LI_14	Long Integer	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchase Order Line History'].INVINDX AS 'Purchase Order Line History-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchase Order Line History'].INVINDX = ['Account Index Master'].ACTINDX
19	REQDATE	Required Date	DATE_L	Date	0
20	PRMDATE	Promised Date	DATE_L	Date	0
21	PRMSHPDTE	Promised Ship Date	DATE_L	Date	0
22	REQSTDBY	Requested By	STR20_LB	String	20
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchase Order Line History'].REQSTDBY AS 'Purchase Order Line History-Requested By' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchase Order Line History'].REQSTDBY = ['Users Master'].USERID
23	COMMNTID	Comment ID	STR15_Comment_ID	String	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Purchase Order Line History'].COMMNTID AS 'Purchase Order Line History-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Purchase Order Line History'].COMMNTID = ['Comment Master'].COMMNTID
24	DOCTYPE	Document Type	DDL_Document_Type	Integer	0
	Click to show/hide Document Types 1 Invoice 2 Finance Charge 3 Miscellaneous Charges 4 Return 5 Credit Memo
25	POLNEARY	PO Line Note ID Array	DLR14	Currency	14
26	POLNEARY_1	PO Line Note ID Array[1]	DLR14	Currency	14
27	POLNEARY_2	PO Line Note ID Array[2]	DLR14	Currency	14
28	POLNEARY_3	PO Line Note ID Array[3]	DLR14	Currency	14
29	POLNEARY_4	PO Line Note ID Array[4]	DLR14	Currency	14
30	POLNEARY_5	PO Line Note ID Array[5]	DLR14	Currency	14
31	POLNEARY_6	PO Line Note ID Array[6]	DLR14	Currency	14
32	POLNEARY_7	PO Line Note ID Array[7]	DLR14	Currency	14
33	POLNEARY_8	PO Line Note ID Array[8]	DLR14	Currency	14
34	POLNEARY_9	PO Line Note ID Array[9]	DLR14	Currency	14
35	DECPLCUR	Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	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
36	DECPLQTY	Decimal Places QTYS	DDL_Decimal_Places_QTYS	Integer	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
37	BRKFLD1	Break Field 1	INT1	Integer	1
38	JOBNUMBR	Job Number	STR17_LBAU	String	17
39	COSTCODE	Cost Code	STR27	String	27
40	COSTTYPE	Cost Code Type	INT3_RB0_U	Integer	3
41	CURRNIDX	Currency Index	INT3	Integer	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchase Order Line History'].CURRNIDX AS 'Purchase Order Line History-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchase Order Line History'].CURRNIDX = ['Currency Setup'].CURRNIDX
42	ORUNTCST	Originating Unit Cost	DLR17_RBS0_UTR$	Currency	17
43	OREXTCST	Originating Extended Cost	DLR17_RBS0_UTR$	Currency	17
44	LINEORIGIN	Line Origin	DDL_Line_Origin	Integer	0
45	FREEONBOARD	Free On Board	DDL_Free_On_Board	Integer	0
46	ODECPLCU	Originating Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	0
47	Product_Indicator	Product Indicator	DDL_Product_Indicator	Integer	0
48	Source_Document_Number	Source Document Number	STR11_Document_Number	String	11
49	Source_Document_Line_Num	Source Document Line Number	INT4	Integer	4
50	RELEASEBYDATE	Release By Date	DATE_L	Date	0
51	Released_Date	Released Date	DATE_L	Date	0
52	Purchase_IV_Item_Taxable	Purchase IV Item Taxable	DDL_Purchase_Tax_Options	Integer	0
	Purchase Inventory Item Taxable setting. Click to show/hide Purchase IV Item Taxable 1 Taxable 2 Non-taxable 3 Base on Vendor
53	Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	STR15_LBAU	String	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchase Order Line History'].Purchase_Item_Tax_Schedu AS 'Purchase Order 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 POP30110 AS ['Purchase Order Line History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchase Order Line History'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
54	Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	STR15_LBAU	String	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchase Order Line History'].Purchase_Site_Tax_Schedu AS 'Purchase Order 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 POP30110 AS ['Purchase Order Line History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchase Order Line History'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
55	PURCHSITETXSCHSRC	Purchase Site Tax Schedule Source	INT1	Integer	1
56	BSIVCTTL	Based On Invoice Total	YN	Boolean	0
57	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	17
58	ORTAXAMT	Originating Tax Amount	DLR17_RBS0_UTR$	Currency	17
59	BCKTXAMT	Backout Tax Amount	DLR17_RBS0_UTR$	Currency	17
60	OBTAXAMT	Originating Backout Tax Amount	DLR17_RBS0_UTR$	Currency	17
61	Landed_Cost_Group_ID	Landed Cost Group ID	STR15_LBAU	String	15
62	SHIPMTHD	Shipping Method	STR15_Shipping_Method	String	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Purchase Order Line History'].SHIPMTHD AS 'Purchase Order Line History-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Purchase Order Line History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
63	LineNumber	LineNumber	INT	Integer	0
64	ORIGPRMDATE	Original Promised Date	DT	Date	8
65	FSTRCPTDT	First Receipt Date	DT	Date	8
66	LSTRCPTDT	Last Receipt Date	DT	Date	8
67	RELEASE	Release	INT	Integer	0
68	ADRSCODE	Address Code	STR15_Address_Code	String	15
69	CMPNYNAM	Company Name	STR64_Company_Name	String	64
70	CONTACT	Contact	STR60	String	60
71	ADDRESS1	Address 1	STR60	String	60
72	ADDRESS2	Address 2	STR60	String	60
73	ADDRESS3	Address 3	STR60	String	60
74	CITY	City	STR35	String	35
75	STATE	State	STR30_State	String	29
76	ZIPCODE	Zip Code	STR10	String	10
77	CCode	Country Code	STR6_VAT	String	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['Purchase Order Line History'].CCode AS 'Purchase Order Line History-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM POP30110 AS ['Purchase Order Line History'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Purchase Order Line History'].CCode = ['VAT Country Code MSTR'].CCode
78	COUNTRY	Country	STR60	String	60
79	PHONE1	Phone 1	Phone_Number	String	14
80	PHONE2	Phone 2	Phone_Number	String	14
81	PHONE3	Phone 3	Phone_Number3	String	14
82	FAX	Fax	STR14_FAX	String	14
83	ADDRSOURCE	Address Source	INT1	Integer	1
84	Flags	Flags	INT1	Integer	1
85	ProjNum	Project Number	STR15_LBAU	String	15
86	CostCatID	Cost Category ID	STR15_LBAU	String	15
87	ITMTRKOP	Item Tracking Option	DDL_Track	Integer	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
88	VCTNMTHD	Valuation Method	DDL_Valuation_Method	Integer	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
89	Print_Phone_NumberGB	Print Phone Number GB	GB	Integer	0
90	DEX_ROW_TS		datetime	datetime	3
	DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
91	DEX_ROW_ID		int	int	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 Microsoft Dynamics GP (0)PurchasingPurchase Order Line History (POP30110)

Leave a Reply Cancel reply