Purchase Order Line (POP10110)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchase Order Line (POP10110)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchase Order Line
Physical Name: POP10110
Technical Name: POP_POLine

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	String	STR17_POP_Number	17
2	ORD	Ord	Long Integer	LI_Sequence_Number	10
3	POLNESTA	PO Line Status	Integer	DDL_PO_Line_Status	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	Integer	DDL_POP_PO_Type	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	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Purchase Order Line'].ITEMNMBR AS 'Purchase Order Line-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN IV00101 AS ['Item Master'] ON ['Purchase Order Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
6	ITEMDESC	Item Description	String	STR100	100
7	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Purchase Order Line'].VENDORID AS 'Purchase Order Line-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchase Order Line'].VENDORID = ['PM Vendor Master File'].VENDORID
8	VNDITNUM	Vendor Item Number	String	Item_Number	30
9	VNDITDSC	Vendor Item Description	String	STR100	100
10	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
11	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Purchase Order Line'].LOCNCODE AS 'Purchase Order Line-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Purchase Order Line'].LOCNCODE = ['Site Setup'].LOCNCODE
12	UOFM	U Of M	String	U_Of_M	8
	The unit of measure. The value in this field must exist in Inventory.
13	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.
14	QTYORDER	QTY Ordered	Currency	DLR17_QTY_RBS0_UTR	17
15	QTYCANCE	QTY Canceled	Currency	DLR17_QTY_RBS0_UTR	17
16	QTYCMTBASE	QTY Committed In Base	Currency	DLR17_QTY_RBS0_STR	17
	Tracks the sum of all QTY On PO In Base for all line items in the SOP_LINE_WORK which are linked to this PO Line. It is necessary to track this quantity in base, because each Sales Order Processing line may be in a different U of M.
17	QTYUNCMTBASE	QTY Uncommitted In Base	Currency	DLR17_QTY_RBS0_STR	17
	Gives the unreceived quantity of goods on this PO Line that have not been committed to a sale order processing line. New SOP Lines that require less than or equal to QTY Uncommitted In Base can be linked to this PO Line.
18	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
19	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
	Extended Cost is calculated using the following formula: (Originating Unit Cost * Quantity Ordered) using Rate Calc Method and Exchange Rate to determine functional value.
20	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchase Order Line'].INVINDX AS 'Purchase Order Line-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchase Order Line'].INVINDX = ['Account Index Master'].ACTINDX
21	REQDATE	Required Date	Date	DATE_L	0
22	PRMDATE	Promised Date	Date	DATE_L	0
23	PRMSHPDTE	Promised Ship Date	Date	DATE_L	0
24	REQSTDBY	Requested By	String	STR20_LB	20
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchase Order Line'].REQSTDBY AS 'Purchase Order Line-Requested By' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchase Order Line'].REQSTDBY = ['Users Master'].USERID
25	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Purchase Order Line'].COMMNTID AS 'Purchase Order Line-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Purchase Order Line'].COMMNTID = ['Comment Master'].COMMNTID
26	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
	Click to show/hide Document Types 1 Invoice 2 Finance Charge 3 Miscellaneous Charges 4 Return 5 Credit Memo
27	POLNEARY	PO Line Note ID Array	DLR14	Currency	14
28	POLNEARY_1	PO Line Note ID Array[1]	Currency	DLR14	14
29	POLNEARY_2	PO Line Note ID Array[2]	Currency	DLR14	14
30	POLNEARY_3	PO Line Note ID Array[3]	Currency	DLR14	14
31	POLNEARY_4	PO Line Note ID Array[4]	Currency	DLR14	14
32	POLNEARY_5	PO Line Note ID Array[5]	Currency	DLR14	14
33	POLNEARY_6	PO Line Note ID Array[6]	Currency	DLR14	14
34	POLNEARY_7	PO Line Note ID Array[7]	Currency	DLR14	14
35	POLNEARY_8	PO Line Note ID Array[8]	Currency	DLR14	14
36	POLNEARY_9	PO Line Note ID Array[9]	Currency	DLR14	14
37	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
38	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
39	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
40	VCTNMTHD	Valuation Method	Integer	DDL_Valuation_Method	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
41	BRKFLD1	Break Field 1	Integer	INT1	1
42	PO_Line_Status_Orig	PO Line Status Orig	Integer	DDL_PO_Line_Status	0
43	QTY_Canceled_Orig	QTY Canceled Orig	Currency	DLR17_QTY_RBS0_UTR	17
44	OPOSTSUB	Originating Posted Subtotal	Currency	DLR17_RBS0_STR$	17
45	JOBNUMBR	Job Number	String	STR17_LBAU	17
46	COSTCODE	Cost Code	String	STR27	27
47	COSTTYPE	Cost Code Type	Integer	INT3_RB0_U	3
48	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchase Order Line'].CURNCYID AS 'Purchase Order Line-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchase Order Line'].CURNCYID = ['Currency Setup'].CURNCYID
49	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchase Order Line'].CURRNIDX AS 'Purchase Order Line-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchase Order Line'].CURRNIDX = ['Currency Setup'].CURRNIDX
50	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
51	RATECALC	Rate Calc Method	Integer	INT	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
52	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
53	ORUNTCST	Originating Unit Cost	Currency	DLR17_RBS0_UTR$	17
54	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
55	LINEORIGIN	Line Origin	Integer	DDL_Line_Origin	0
56	FREEONBOARD	Free On Board	Integer	DDL_Free_On_Board	0
57	ODECPLCU	Originating Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
58	Capital_Item	Capital Item	Boolean	CB_Capital_Item	0
59	Product_Indicator	Product Indicator	Integer	DDL_Product_Indicator	0
60	Source_Document_Number	Source Document Number	String	STR11_Document_Number	11
61	Source_Document_Line_Num	Source Document Line Number	Integer	INT4	4
62	RELEASEBYDATE	Release By Date	Date	DATE_L	0
63	Released_Date	Released Date	Date	DATE_L	0
64	Change_Order_Flag	Change Order Flag	Integer	INT	0
65	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
66	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 ['Purchase Order Line'].Purchase_Item_Tax_Schedu AS 'Purchase Order Line-Purchase Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchase Order Line'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
67	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 ['Purchase Order Line'].Purchase_Site_Tax_Schedu AS 'Purchase Order Line-Purchase Site Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchase Order Line'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
68	PURCHSITETXSCHSRC	Purchase Site Tax Schedule Source	Integer	INT1	1
69	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
70	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
71	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
72	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
73	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
74	Landed_Cost_Group_ID	Landed Cost Group ID	String	STR15_LBAU	15
75	PLNNDSPPLID	Planned Supply ID	Integer	INT	0
76	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Purchase Order Line'].SHIPMTHD AS 'Purchase Order Line-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Purchase Order Line'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
77	BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
78	OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
79	LineNumber	LineNumber	Integer	INT	0
80	ORIGPRMDATE	Original Promised Date	Date	DT	8
81	FSTRCPTDT	First Receipt Date	Date	DT	8
82	LSTRCPTDT	Last Receipt Date	Date	DT	8
83	RELEASE	Release	Integer	INT	0
84	ADRSCODE	Address Code	String	STR15_Address_Code	15
85	CMPNYNAM	Company Name	String	STR64_Company_Name	64
86	CONTACT	Contact	String	STR60	60
87	ADDRESS1	Address 1	String	STR60	60
88	ADDRESS2	Address 2	String	STR60	60
89	ADDRESS3	Address 3	String	STR60	60
90	CITY	City	String	STR35	35
91	STATE	State	String	STR30_State	29
92	ZIPCODE	Zip Code	String	STR10	10
93	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['Purchase Order Line'].CCode AS 'Purchase Order Line-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM POP10110 AS ['Purchase Order Line'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Purchase Order Line'].CCode = ['VAT Country Code MSTR'].CCode
94	COUNTRY	Country	String	STR60	60
95	PHONE1	Phone 1	String	Phone_Number	14
96	PHONE2	Phone 2	String	Phone_Number	14
97	PHONE3	Phone 3	String	Phone_Number3	14
98	FAX	Fax	String	STR14_FAX	14
99	ADDRSOURCE	Address Source	Integer	INT1	1
100	Flags	Flags	Integer	INT1	1
101	ProjNum	Project Number	String	STR15_LBAU	15
102	CostCatID	Cost Category ID	String	STR15_LBAU	15
103	Print_Phone_NumberGB	Print Phone Number GB	Integer	GB	0
104	QTYCommittedInBaseOrig	QTY Committed In Base Orig	Currency	DLR17_QTY_RBS0_STR	17

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchase Order Line (POP10110)

Leave a Reply Cancel reply