Purchasing Receipt Line Quantities (POP10500)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchasing Receipt Line Quantities (POP10500)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt Line Quantities
Physical Name: POP10500
Technical Name: POP_PORcptApply

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMBER SearchPO NumberSTR17_POP_NumberString1817
2POLNENUM SearchPO Line NumberLI_Sequence_NumberLong Integer410
3POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
4RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer410
5QTYSHPPD SearchQTY ShippedDLR17_QTY_RBS0_UTRCurrency1017
6QTYINVCD SearchQTY InvoicedDLR17_QTY_RBS0_UTRCurrency1017
7QTYREJ SearchQTY RejectedDLR17_QTY_RBS0_UTRCurrency1017
8QTYMATCH SearchQTY MatchedDLR17_QTY_RBS0_UTRCurrency1017
9QTYRESERVED SearchQTY ReservedDLR17_QTY_RBS0_UTRCurrency1017
10QTYINVRESERVE SearchQTY Invoice ReserveDLR17_QTY_RBS0_UTRCurrency1017
11Status SearchStatusINTInteger20
12UMQTYINB SearchU Of M QTY In BaseDLR17_QTY_RBS0_STRCurrency1017
The quantity of the base unit of measure that is equivalent to one of the units of measure being referenced.
13OLDCUCST SearchOld Current CostDLR17_RBS0_UTR$Currency1017
14JOBNUMBR SearchJob NumberSTR17_LBAUString1817
15COSTCODE SearchCost CodeSTR27String2827
16COSTTYPE SearchCost Code TypeINT3_RB0_UInteger23
17ORCPTCOST SearchOriginating Receipt CostDLR17_RBS0_UTR$Currency1017
18OSTDCOST SearchOriginating Standard CostDLR17_RBS0_UTR$Currency1017
19APPYTYPE SearchApply TypeINTInteger20
20POPTYPE SearchPOP TypeDDL_POP_TypeInteger20
21VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].VENDORID AS 'Purchasing Receipt Line Quantities-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Purchasing Receipt Line Quantities'].VENDORID = ['PM Vendor Master File'].VENDORID
22ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].ITEMNMBR AS 'Purchasing Receipt Line Quantities-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Purchasing Receipt Line Quantities'].ITEMNMBR = ['Item Master'].ITEMNMBR
23UOFM SearchU Of MU_Of_MString108
The unit of measure. The value in this field must exist in Inventory.
24TRXLOCTN SearchTRX LocationSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].TRXLOCTN AS 'Purchasing Receipt Line Quantities-TRX Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Purchasing Receipt Line Quantities'].TRXLOCTN = ['Site Setup'].LOCNCODE
25DATERECD SearchDate ReceivedDATEDate46
26RCTSEQNM SearchReceipt SEQ NumberlongLong Integer48
27SPRCTSEQ SearchSplit Receipt SEQ NumberlongLong Integer48
28PCHRPTCT SearchPurchase Receipt CostDLR17_RBSO_UTR$Currency1017
29SPRCPTCT SearchSplit Receipt CostDLR17_RBS0_UTR$Currency1017
30OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
31RUPPVAMT SearchRemaining UPPV AmountDLR17_RBS0_UTR$Currency1017
32ACPURIDX SearchAccrued Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].ACPURIDX AS 'Purchasing Receipt Line Quantities-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Purchasing Receipt Line Quantities'].ACPURIDX = ['Account Index Master'].ACTINDX
33INVINDX SearchInventory IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].INVINDX AS 'Purchasing Receipt Line Quantities-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Purchasing Receipt Line Quantities'].INVINDX = ['Account Index Master'].ACTINDX
34UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].UPPVIDX AS 'Purchasing Receipt Line Quantities-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Purchasing Receipt Line Quantities'].UPPVIDX = ['Account Index Master'].ACTINDX
35NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].NOTEINDX AS 'Purchasing Receipt Line Quantities-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Purchasing Receipt Line Quantities'].NOTEINDX = ['Record Notes Master'].NOTEINDX
36CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].CURNCYID AS 'Purchasing Receipt Line Quantities-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchasing Receipt Line Quantities'].CURNCYID = ['Currency Setup'].CURNCYID
37CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].CURRNIDX AS 'Purchasing Receipt Line Quantities-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchasing Receipt Line Quantities'].CURRNIDX = ['Currency Setup'].CURRNIDX
38XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
39RATECALC SearchRate Calc MethodINTInteger20
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
40DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
41RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].RATETPID AS 'Purchasing Receipt Line Quantities-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Purchasing Receipt Line Quantities'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
42EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Purchasing Receipt Line Quantities'].EXGTBLID AS 'Purchasing Receipt Line Quantities-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Purchasing Receipt Line Quantities'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
43Capital_Item SearchCapital ItemCB_Capital_ItemBoolean20
44Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger20
45Total_Landed_Cost_Amount SearchTotal Landed Cost AmountDLR17_RBS0_UTR$Currency1017
46QTYTYPE SearchQTY TypeDDL_QTY_TypeInteger20
47Posted_LC_PPV_Amount SearchPosted LC PPV AmountDLR17_RBS0_UTR$Currency1017
48QTYREPLACED SearchQTY ReplacedDLR17_QTY_RBS0_UTRCurrency1017
49QTYINVADJ SearchQTY Invoice AdjustmentDLR17_QTY_RBS0_UTRCurrency1017
50DEX_ROW_ID Searchintint1010

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.

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchasing Receipt Line Quantities (POP10500)

Leave a Reply

Your email address will not be published. Required fields are marked *