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 Group Display Name: Purchasing History
Physical Name: POP30110
Technical Name: PA_POP_Report_POLineHist
Group Technical Name: Purchasing History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | PONUMBER ![]() | PO Number | STR17_POP_Number | String | 18 | 17 |
2 | ORD ![]() | Ord | LI_Sequence_Number | Long Integer | 4 | 10 |
3 | POLNESTA ![]() | PO Line Status | DDL_PO_Line_Status | Integer | 2 | 0 |
Status assigned to the Purchase Order Line for the order status.
Click to show/hide PO Line Statuses1 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 | 2 | 0 |
Type of Purchase Order.
Click to show/hide PO Types1 Standard
2 Drop Ship
3 Blanket
4 Blanket Drop Ship | ||||||
5 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 32 | 30 |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['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 | 102 | 100 |
7 | VENDORID ![]() | Vendor ID | STR_15_Vendor_ID | String | 16 | 15 |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['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 | 32 | 30 |
9 | VNDITDSC ![]() | Vendor Item Description | STR100 | String | 102 | 100 |
10 | 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 Statuses0 Inventory item
1 Non-inventory item | ||||||
11 | LOCNCODE ![]() | Location Code | STR10_Location_Code | String | 12 | 10 |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['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 | 10 | 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 | 10 | 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 | 10 | 17 |
15 | QTYCANCE ![]() | QTY Canceled | DLR17_QTY_RBS0_UTR | Currency | 10 | 17 |
16 | UNITCOST ![]() | Unit Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
17 | EXTDCOST ![]() | Extended Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
18 | INVINDX ![]() | Inventory Index | LI_14 | Long Integer | 4 | 14 |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['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 | 4 | 0 |
20 | PRMDATE ![]() | Promised Date | DATE_L | Date | 4 | 0 |
21 | PRMSHPDTE ![]() | Promised Ship Date | DATE_L | Date | 4 | 0 |
22 | REQSTDBY ![]() | Requested By | STR20_LB | String | 22 | 20 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | 16 | 15 |
Key to the Comment Master (SY04200).
Click to show/hideSELECT
['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 | 2 | 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 | 10 | 14 |
26 | POLNEARY_1 ![]() | PO Line Note ID Array[1] | DLR14 | Currency | 10 | 14 |
27 | POLNEARY_2 ![]() | PO Line Note ID Array[2] | DLR14 | Currency | 10 | 14 |
28 | POLNEARY_3 ![]() | PO Line Note ID Array[3] | DLR14 | Currency | 10 | 14 |
29 | POLNEARY_4 ![]() | PO Line Note ID Array[4] | DLR14 | Currency | 10 | 14 |
30 | POLNEARY_5 ![]() | PO Line Note ID Array[5] | DLR14 | Currency | 10 | 14 |
31 | POLNEARY_6 ![]() | PO Line Note ID Array[6] | DLR14 | Currency | 10 | 14 |
32 | POLNEARY_7 ![]() | PO Line Note ID Array[7] | DLR14 | Currency | 10 | 14 |
33 | POLNEARY_8 ![]() | PO Line Note ID Array[8] | DLR14 | Currency | 10 | 14 |
34 | POLNEARY_9 ![]() | PO Line Note ID Array[9] | DLR14 | Currency | 10 | 14 |
35 | 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 Currency7 0 decimals
8 1
9 2
10 3
11 4
12 5 | ||||||
36 | DECPLQTY ![]() | Decimal Places QTYS | DDL_Decimal_Places_QTYS | Integer | 2 | 0 |
Number of decimal places for the quantities.
Click to show/hide Decimal Places Currency1 0 decimals
2 1
3 2
4 3
5 4
6 5 | ||||||
37 | BRKFLD1 ![]() | Break Field 1 | INT1 | Integer | 2 | 1 |
38 | JOBNUMBR ![]() | Job Number | STR17_LBAU | String | 18 | 17 |
39 | COSTCODE ![]() | Cost Code | STR27 | String | 28 | 27 |
40 | COSTTYPE ![]() | Cost Code Type | INT3_RB0_U | Integer | 2 | 3 |
41 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 2 | 3 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | 10 | 17 |
43 | OREXTCST ![]() | Originating Extended Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
44 | LINEORIGIN ![]() | Line Origin | DDL_Line_Origin | Integer | 2 | 0 |
45 | FREEONBOARD ![]() | Free On Board | DDL_Free_On_Board | Integer | 2 | 0 |
46 | ODECPLCU ![]() | Originating Decimal Places Currency | DDL_Decimal_Places_Dollars | Integer | 2 | 0 |
47 | Product_Indicator ![]() | Product Indicator | DDL_Product_Indicator | Integer | 2 | 0 |
48 | Source_Document_Number ![]() | Source Document Number | STR11_Document_Number | String | 12 | 11 |
49 | Source_Document_Line_Num ![]() | Source Document Line Number | INT4 | Integer | 2 | 4 |
50 | RELEASEBYDATE ![]() | Release By Date | DATE_L | Date | 4 | 0 |
51 | Released_Date ![]() | Released Date | DATE_L | Date | 4 | 0 |
52 | 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 Taxable1 Taxable
2 Non-taxable
3 Base on Vendor | ||||||
53 | 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/hideSELECT
['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 | 16 | 15 |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | 2 | 1 |
56 | BSIVCTTL ![]() | Based On Invoice Total | YN | Boolean | 2 | 0 |
57 | TAXAMNT ![]() | Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
58 | ORTAXAMT ![]() | Originating Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
59 | BCKTXAMT ![]() | Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
60 | OBTAXAMT ![]() | Originating Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
61 | Landed_Cost_Group_ID ![]() | Landed Cost Group ID | STR15_LBAU | String | 16 | 15 |
62 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 16 | 15 |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['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 | 2 | 0 |
64 | ORIGPRMDATE ![]() | Original Promised Date | DT | Date | 4 | 8 |
65 | FSTRCPTDT ![]() | First Receipt Date | DT | Date | 4 | 8 |
66 | LSTRCPTDT ![]() | Last Receipt Date | DT | Date | 4 | 8 |
67 | RELEASE ![]() | Release | INT | Integer | 2 | 0 |
68 | ADRSCODE ![]() | Address Code | STR15_Address_Code | String | 16 | 15 |
69 | CMPNYNAM ![]() | Company Name | STR64_Company_Name | String | 66 | 64 |
70 | CONTACT ![]() | Contact | STR60 | String | 62 | 60 |
71 | ADDRESS1 ![]() | Address 1 | STR60 | String | 62 | 60 |
72 | ADDRESS2 ![]() | Address 2 | STR60 | String | 62 | 60 |
73 | ADDRESS3 ![]() | Address 3 | STR60 | String | 62 | 60 |
74 | CITY ![]() | City | STR35 | String | 36 | 35 |
75 | STATE ![]() | State | STR30_State | String | 30 | 29 |
76 | ZIPCODE ![]() | Zip Code | STR10 | String | 12 | 10 |
77 | CCode ![]() | Country Code | STR6_VAT | String | 8 | 6 |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['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 | 62 | 60 |
79 | PHONE1 ![]() | Phone 1 | Phone_Number | String | 22 | 14 |
80 | PHONE2 ![]() | Phone 2 | Phone_Number | String | 22 | 14 |
81 | PHONE3 ![]() | Phone 3 | Phone_Number3 | String | 22 | 14 |
82 | FAX ![]() | Fax | STR14_FAX | String | 22 | 14 |
83 | ADDRSOURCE ![]() | Address Source | INT1 | Integer | 2 | 1 |
84 | Flags ![]() | Flags | INT1 | Integer | 2 | 1 |
85 | ProjNum ![]() | Project Number | STR15_LBAU | String | 16 | 15 |
86 | CostCatID ![]() | Cost Category ID | STR15_LBAU | String | 16 | 15 |
87 | ITMTRKOP ![]() | Item Tracking Option | DDL_Track | Integer | 2 | 0 |
Designation for the tracking type of the Item.
Click to show/hide Item Tracking Options1 0 decimals
2 1
3 2
4 3
5 4
6 5 | ||||||
88 | VCTNMTHD ![]() | Valuation Method | DDL_Valuation_Method | Integer | 2 | 0 |
The valuation method for the inventory line item.
Click to show/hide Valuation methods1 FIFO Perpetual
2 LIFO Perpetual
3 Average Perpetual
4 FIFO Periodic
5 LIFO Periodic | ||||||
89 | Print_Phone_NumberGB ![]() | Print Phone Number GB | GB | Integer | 2 | 0 |
90 | DEX_ROW_TS ![]() | datetime | datetime | 3 | 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 | 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. |