Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP10310
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: Purchasing Receipt Line Group Display Name: Purchasing Transactions
Physical Name: POP10310
Technical Name: PA_POP_Report_ReceiptLine
Group Technical Name: Purchasing Transactions
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | POPRCTNM ![]() | POP Receipt Number | STR17_POP_Number | String | 17 | |
2 | RCPTLNNM ![]() | Receipt Line Number | LI_Sequence_Number | Long Integer | 10 | |
3 | PONUMBER ![]() | PO Number | STR17_POP_Number | String | 17 | |
4 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Purchasing Receipt Line'].ITEMNMBR AS 'Purchasing Receipt Line-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Purchasing Receipt Line'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
5 | ITEMDESC ![]() | Item Description | STR100 | String | 100 | |
6 | VNDITNUM ![]() | Vendor Item Number | Item_Number | String | 30 | |
7 | VNDITDSC ![]() | Vendor Item Description | STR100 | String | 100 | |
8 | 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. | ||||||
9 | ACTLSHIP ![]() | Actual Ship Date | DT | Date | 8 | |
10 | COMMNTID ![]() | Comment ID | STR15_Comment_ID | String | 15 | |
Key to the Comment Master (SY04200).
Click to show/hideSELECT
['Purchasing Receipt Line'].COMMNTID AS 'Purchasing Receipt Line-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Purchasing Receipt Line'].COMMNTID = ['Comment Master'].COMMNTID | ||||||
11 | INVINDX ![]() | Inventory Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Purchasing Receipt Line'].INVINDX AS 'Purchasing Receipt Line-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Purchasing Receipt Line'].INVINDX = ['Account Index Master'].ACTINDX | ||||||
12 | UOFM ![]() | U Of M | U_Of_M | String | 8 | |
The unit of measure. The value in this field must exist in Inventory. | ||||||
13 | UNITCOST ![]() | Unit Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
14 | EXTDCOST ![]() | Extended Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
15 | LOCNCODE ![]() | Location Code | STR10_Location_Code | String | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Purchasing Receipt Line'].LOCNCODE AS 'Purchasing Receipt Line-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Purchasing Receipt Line'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
16 | RcptLineNoteIDArray ![]() | ReceiptLine Note ID Array | DLR14 | Currency | 14 | |
17 | RcptLineNoteIDArray_1 ![]() | ReceiptLine Note ID Array[1] | DLR14 | Currency | 14 | |
18 | RcptLineNoteIDArray_2 ![]() | ReceiptLine Note ID Array[2] | DLR14 | Currency | 14 | |
19 | RcptLineNoteIDArray_3 ![]() | ReceiptLine Note ID Array[3] | DLR14 | Currency | 14 | |
20 | RcptLineNoteIDArray_4 ![]() | ReceiptLine Note ID Array[4] | DLR14 | Currency | 14 | |
21 | RcptLineNoteIDArray_5 ![]() | ReceiptLine Note ID Array[5] | DLR14 | Currency | 14 | |
22 | RcptLineNoteIDArray_6 ![]() | ReceiptLine Note ID Array[6] | DLR14 | Currency | 14 | |
23 | RcptLineNoteIDArray_7 ![]() | ReceiptLine Note ID Array[7] | DLR14 | Currency | 14 | |
24 | RcptLineNoteIDArray_8 ![]() | ReceiptLine Note ID Array[8] | DLR14 | Currency | 14 | |
25 | 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 Statuses0 Inventory item
1 Non-inventory item | ||||||
26 | 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 Currency7 0 decimals
8 1
9 2
10 3
11 4
12 5 | ||||||
27 | DECPLQTY ![]() | Decimal Places QTYS | DDL_Decimal_Places_QTYS | Integer | 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 | ||||||
28 | ITMTRKOP ![]() | Item Tracking Option | DDL_Track | Integer | 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 | ||||||
29 | VCTNMTHD ![]() | Valuation Method | DDL_Valuation_Method | Integer | 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 | ||||||
30 | TRXSORCE ![]() | TRX Source | STR13 | String | 13 | |
31 | JOBNUMBR ![]() | Job Number | STR17_LBAU | String | 17 | |
32 | COSTCODE ![]() | Cost Code | STR27 | String | 27 | |
33 | COSTTYPE ![]() | Cost Code Type | INT3_RB0_U | Integer | 3 | |
34 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Purchasing Receipt Line'].CURNCYID AS 'Purchasing Receipt Line-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Receipt Line'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
35 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Purchasing Receipt Line'].CURRNIDX AS 'Purchasing Receipt Line-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Receipt Line'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
36 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['Purchasing Receipt Line'].RATETPID AS 'Purchasing Receipt Line-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Purchasing Receipt Line'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
37 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
38 | RATECALC ![]() | Rate Calc Method | INT | Integer | 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 | ||||||
39 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
40 | ORUNTCST ![]() | Originating Unit Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
41 | OREXTCST ![]() | Originating Extended Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
42 | ODECPLCU ![]() | Originating Decimal Places Currency | DDL_Decimal_Places_Dollars | Integer | 0 | |
43 | BOLPRONUMBER ![]() | BOL_PRO Number | STR30 | String | 30 | |
44 | Capital_Item ![]() | Capital Item | CB_Capital_Item | Boolean | 0 | |
45 | Product_Indicator ![]() | Product Indicator | DDL_Product_Indicator | Integer | 0 | |
46 | 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 Taxable1 Taxable
2 Non-taxable
3 Base on Vendor | ||||||
47 | 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/hideSELECT
['Purchasing Receipt Line'].Purchase_Item_Tax_Schedu AS 'Purchasing Receipt Line-Purchase Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Purchasing Receipt Line'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
48 | 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/hideSELECT
['Purchasing Receipt Line'].Purchase_Site_Tax_Schedu AS 'Purchasing Receipt Line-Purchase Site Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Purchasing Receipt Line'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
49 | BSIVCTTL ![]() | Based On Invoice Total | YN | Boolean | 0 | |
50 | TAXAMNT ![]() | Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
51 | ORTAXAMT ![]() | Originating Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
52 | BCKTXAMT ![]() | Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
53 | OBTAXAMT ![]() | Originating Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
54 | Revalue_Inventory ![]() | Revalue Inventory | CB_Revalue_Inventory | Boolean | 0 | |
55 | Tolerance_Percentage ![]() | Tolerance Percentage | LI7_U%3 | Long Integer | 7 | |
56 | PURPVIDX ![]() | Purchase Price Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Purchasing Receipt Line'].PURPVIDX AS 'Purchasing Receipt Line-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Purchasing Receipt Line'].PURPVIDX = ['Account Index Master'].ACTINDX | ||||||
57 | Remaining_AP_Amount ![]() | Remaining AP Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
58 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['Purchasing Receipt Line'].SHIPMTHD AS 'Purchasing Receipt Line-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
POP10310 AS ['Purchasing Receipt Line']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Purchasing Receipt Line'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
59 | Landed_Cost_Group_ID ![]() | Landed Cost Group ID | STR15_LBAU | String | 15 | |
60 | Landed_Cost_Warnings ![]() | Landed Cost Warnings | INT3 | Integer | 3 | |
61 | BackoutTradeDiscTax ![]() | Backout Trade Discount Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
62 | OrigBackoutTradeDiscTax ![]() | Originating Backout Trade Discount Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
63 | Landed_Cost ![]() | Landed Cost | CB | Boolean | 0 | |
64 | Invoice_Match ![]() | Invoice Match | CB_Invoice_Match | Boolean | 0 | |
65 | RCPTRETNUM ![]() | Receipt Return Number | STR17_POP_Number | String | 17 | |
66 | RCPTRETLNNUM ![]() | Receipt Return Line Number | LI_Sequence_Number | Long Integer | 10 | |
67 | INVRETNUM ![]() | Invoice Return Number | STR17_POP_Number | String | 17 | |
68 | INVRETLNNUM ![]() | Invoice Return Line Number | LI_Sequence_Number | Long Integer | 10 | |
69 | ISLINEINTRA ![]() | IsLineIntrastat | CB | Boolean | 0 | |
70 | ProjNum ![]() | Project Number | STR15_LBAU | String | 15 | |
71 | CostCatID ![]() | Cost Category ID | STR15_LBAU | String | 15 | |
72 | TrackedDropShipped ![]() | TrackedDropShipped | CB | Boolean | 0 | |
73 | OriginatingPrepaymentAmt ![]() | Originating Prepayment Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
74 | ORDISTKN ![]() | Originating Discount Taken Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
75 | ORTDISAM ![]() | Originating Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
76 | ORFRTAMT ![]() | Originating Freight Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
77 | ORMISCAMT ![]() | Originating Misc Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
78 | OriginatingPPTaxAmount ![]() | Originating Prepayment Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
79 | 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. |