Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP30210
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: Purchasing Requisition Line History Group Display Name: Purchasing Requisition History
Physical Name: POP30210
Technical Name: popRequisitionLineHist
Group Technical Name: Purchasing Requisition History
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | POPRequisitionNumber  | POP Requisition Number | STR17_POP_Number | String | 18 | 17 |
| 2 | ORD | Ord | LI_Sequence_Number | Long Integer | 4 | 10 |
| 3 | RequisitionLineStatus | Requisition Line Status | DDL_RequisitionLineStatus | Integer | 2 | 0 |
| 4 | LineNumber | LineNumber | INT | Integer | 2 | 0 |
| 5 | ITEMNMBR | Item Number | STR30_Item_Number | String | 32 | 30 |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Purchasing Requisition Line History'].ITEMNMBR AS 'Purchasing Requisition Line History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Purchasing Requisition Line History'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 6 | ITEMDESC | Item Description | STR100 | String | 102 | 100 |
| 7 | Item_Number_Note_Index | Item Number Note Index | DLR14 | Currency | 10 | 14 |
| 8 | VENDORID | Vendor ID | STR_15_Vendor_ID | String | 16 | 15 |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['Purchasing Requisition Line History'].VENDORID AS 'Purchasing Requisition Line History-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Purchasing Requisition Line History'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 9 | Vendor_Note_Index | Vendor Note Index | DLR14 | Currency | 10 | 14 |
| 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 | UOFM | U Of M | U_Of_M | String | 10 | 8 |
| The unit of measure. The value in this field must exist in Inventory. | ||||||
| 12 | 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. | ||||||
| 13 | LOCNCODE | Location Code | STR10_Location_Code | String | 12 | 10 |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Purchasing Requisition Line History'].LOCNCODE AS 'Purchasing Requisition Line History-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Purchasing Requisition Line History'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 14 | Location_Code_Note_Index | Location Code Note Index | DLR14 | Currency | 10 | 14 |
| 15 | QTYORDER | QTY Ordered | DLR17_QTY_RBS0_UTR | Currency | 10 | 17 |
| 16 | QTYCMTBASE | QTY Committed In Base | DLR17_QTY_RBS0_STR | Currency | 10 | 17 |
| 17 | QTYUNCMTBASE | QTY Uncommitted In Base | DLR17_QTY_RBS0_STR | Currency | 10 | 17 |
| 18 | UNITCOST | Unit Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 19 | ORUNTCST | Originating Unit Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 20 | EXTDCOST | Extended Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 21 | OREXTCST | Originating Extended Cost | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 22 | REQDATE | Required Date | DATE_L | Date | 4 | 0 |
| 23 | REQSTDBY | Requested By | STR20_LB | String | 22 | 20 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Purchasing Requisition Line History'].REQSTDBY AS 'Purchasing Requisition Line History-Requested By'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Purchasing Requisition Line History'].REQSTDBY = ['Users Master'].USERID | ||||||
| 24 | INVINDX | Inventory Index | LI_14 | Long Integer | 4 | 14 |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Purchasing Requisition Line History'].INVINDX AS 'Purchasing Requisition Line History-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Purchasing Requisition Line History'].INVINDX = ['Account Index Master'].ACTINDX | ||||||
| 25 | ACCNTNTINDX | Account Note Index | DLR14 | Currency | 10 | 14 |
| 26 | CURNCYID | Currency ID | STR15_Currency_ID | String | 16 | 15 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Purchasing Requisition Line History'].CURNCYID AS 'Purchasing Requisition Line History-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Requisition Line History'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 27 | Currency_Note_Index | Currency Note Index | DLR14 | Currency | 10 | 14 |
| 28 | CURRNIDX | Currency Index | INT3 | Integer | 2 | 3 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Purchasing Requisition Line History'].CURRNIDX AS 'Purchasing Requisition Line History-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Requisition Line History'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
| 29 | RATETPID | Rate Type ID | STR15_Rate_Type_ID | String | 16 | 15 |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['Purchasing Requisition Line History'].RATETPID AS 'Purchasing Requisition Line History-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Purchasing Requisition Line History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
| 30 | EXGTBLID | Exchange Table ID | STR15_Exchange_Table_ID | String | 16 | 15 |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['Purchasing Requisition Line History'].EXGTBLID AS 'Purchasing Requisition Line History-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Purchasing Requisition Line History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
| 31 | XCHGRATE | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
| 32 | EXCHDATE | Exchange Date | DT_Date | Date | 4 | 6 |
| 33 | TIME1 | Time | TM6 | Time | 4 | 6 |
| 34 | 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 Methods0 Multiply
1 Divide | ||||||
| 35 | DENXRATE | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
| 36 | MCTRXSTT | MC Transaction State | INT1 | Integer | 2 | 1 |
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.
Click to show/hide MC Transaction States0 Euro currency is not created or no denomination currencies are enabled.
1 Originating is not a denomination; Functional is not a denomination
2 Originating is not a denomination; Functional is the Euro currency.
3 Originating is not a denomination; Functional is a denomination.
4 Originating is a denomination; Functional is not a denomination.
5 Originating is a denomination; Functional is a denomination.
6 Originating is a denomination; Functional is the Euro currency.
7 Originating is the Euro currency; Functional is a denomination.
8 Originating is the Euro currency; Functional is not a denomination.
| ||||||
| 37 | 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 | ||||||
| 38 | 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 | ||||||
| 39 | ODECPLCU | Originating Decimal Places Currency | DDL_Decimal_Places_Dollars | Integer | 2 | 0 |
| 40 | 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 | ||||||
| 41 | 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 | ||||||
| 42 | ADRSCODE | Address Code | STR15_Address_Code | String | 16 | 15 |
| 43 | CMPNYNAM | Company Name | STR64_Company_Name | String | 66 | 64 |
| 44 | CONTACT | Contact | STR60 | String | 62 | 60 |
| 45 | ADDRESS1 | Address 1 | STR60 | String | 62 | 60 |
| 46 | ADDRESS2 | Address 2 | STR60 | String | 62 | 60 |
| 47 | ADDRESS3 | Address 3 | STR60 | String | 62 | 60 |
| 48 | CITY | City | STR35 | String | 36 | 35 |
| 49 | STATE | State | STR30_State | String | 30 | 29 |
| 50 | ZIPCODE | Zip Code | STR10 | String | 12 | 10 |
| 51 | CCode | Country Code | STR6_VAT | String | 8 | 6 |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['Purchasing Requisition Line History'].CCode AS 'Purchasing Requisition Line History-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Purchasing Requisition Line History'].CCode = ['VAT Country Code MSTR'].CCode | ||||||
| 52 | COUNTRY | Country | STR60 | String | 62 | 60 |
| 53 | PHONE1 | Phone 1 | Phone_Number | String | 22 | 14 |
| 54 | PHONE2 | Phone 2 | Phone_Number | String | 22 | 14 |
| 55 | PHONE3 | Phone 3 | Phone_Number3 | String | 22 | 14 |
| 56 | FAX | Fax | STR14_FAX | String | 22 | 14 |
| 57 | Print_Phone_NumberGB | Print Phone Number GB | GB | Integer | 2 | 0 |
| 58 | ADDRSOURCE | Address Source | INT1 | Integer | 2 | 1 |
| 59 | Flags | Flags | INT1 | Integer | 2 | 1 |
| 60 | SHIPMTHD | Shipping Method | STR15_Shipping_Method | String | 16 | 15 |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['Purchasing Requisition Line History'].SHIPMTHD AS 'Purchasing Requisition Line History-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Purchasing Requisition Line History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 61 | ShippingMethodNoteIndex | Shipping Method Note Index | DLR14 | Currency | 10 | 14 |
| 62 | FRTAMNT | Freight Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 63 | ORFRTAMT | Originating Freight Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 64 | TAXAMNT | Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 65 | ORTAXAMT | Originating Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 66 | InvalidDataFlag | Invalid Data Flag | LI5_U2 | Long Integer | 4 | 5 |
| 67 | COMMNTID | Comment ID | STR15_Comment_ID | String | 16 | 15 |
Key to the Comment Master (SY04200).
Click to show/hideSELECT
['Purchasing Requisition Line History'].COMMNTID AS 'Purchasing Requisition Line History-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
POP30210 AS ['Purchasing Requisition Line History']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Purchasing Requisition Line History'].COMMNTID = ['Comment Master'].COMMNTID | ||||||
| 68 | Comment_Note_Index | Comment Note Index | DLR14 | Currency | 10 | 14 |
| 69 | USERDEF1 | User Defined 1 | STR20 | String | 22 | 20 |
| 70 | USERDEF2 | User Defined 2 | STR20 | String | 22 | 20 |
| 71 | ProjNum | Project Number | STR15_LBAU | String | 16 | 15 |
| 72 | CostCatID | Cost Category ID | STR15_LBAU | String | 16 | 15 |
| 73 | 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. | ||||||
| 74 | 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. | ||||||