POP PA Receipt Line Hist View (POP31310)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPOP PA Receipt Line Hist View (POP31310)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: POP PA Receipt Line Hist View
Physical Name: POP31310
Technical Name: POP_PA_ReceiptLineHist_View

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
2RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer410
3ProjNum SearchProject NumberSTR15_LBAUString1615
4ProjectName SearchProj. NameSTR30String3230
5CostCatID SearchCost Category IDSTR15_LBAUString1615
6CostCategoryName SearchCost Category NameSTR30String3230
7CONTNBR SearchContract NumberSTR11String1211
8ContractName SearchContract NameSTR30String3230
9CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['POP PA Receipt Line Hist View'].CUSTNMBR AS 'POP PA Receipt Line Hist View-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       POP31310 AS ['POP PA Receipt Line Hist View']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['POP PA Receipt Line Hist View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
10CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['POP PA Receipt Line Hist View'].CURRNIDX AS 'POP PA Receipt Line Hist View-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       POP31310 AS ['POP PA Receipt Line Hist View']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['POP PA Receipt Line Hist View'].CURRNIDX = ['Currency Setup'].CURRNIDX
11AccruedRevenues SearchAccrued RevenuesDLR17_RBS0_UTR$Currency1017
12OrigAccruedRevenues SearchOriginating Accrued RevenuesDLR17_RBS0_UTR$Currency1017
13MCAccruedRevenues SearchMC Accrued RevenuesDLR17_RBS0_UTR$Currency1017
14VarianceAccruedRevenue SearchVariance Accrued RevenuesDLR17_RBS0_UTR$Currency1017
15OrigVarAccruedRevenues SearchOriginating Variance Accrued RevenuesDLR17_RBS0_UTR$Currency1017
16MCVarianceAccruedRev SearchMC Variance Accrued RevenuesDLR17_RBS0_UTR$Currency1017
17EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
18OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
19TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
20ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
21Array_of_Strings_1 SearchArray of Strings[1]STR30String3230
22Array_of_Strings_2 SearchArray of Strings[2]STR30String3230
23Array_of_Strings_3 SearchArray of Strings[3]STR30String3230
24Array_of_Strings_4 SearchArray of Strings[4]STR30String3230
25Array_of_Strings_5 SearchArray of Strings[5]STR30String3230
26Array_of_Strings_6 SearchArray of Strings[6]STR30String3230
27Array_of_Strings_7 SearchArray of Strings[7]STR30String3230
28Array_of_Strings_8 SearchArray of Strings[8]STR30String3230
29Array_of_Strings_9 SearchArray of Strings[9]STR30String3230
30Array_of_Strings_10 SearchArray of Strings[10]STR30String3230
31Array_of_Strings_11 SearchArray of Strings[11]STR30String3230
32Array_of_Strings_12 SearchArray of Strings[12]STR30String3230
33Array_of_Strings_13 SearchArray of Strings[13]STR30String3230
34Array_of_Strings_14 SearchArray of Strings[14]STR30String3230
35Array_of_Strings_15 SearchArray of Strings[15]STR30String3230
36Array_of_Strings_16 SearchArray of Strings[16]STR30String3230
37Array_of_Strings_17 SearchArray of Strings[17]STR30String3230
38Array_of_Strings_18 SearchArray of Strings[18]STR30String3230
39Array_of_Strings_19 SearchArray of Strings[19]STR30String3230
40Array_of_Strings_20 SearchArray of Strings[20]STR30String3230
41Array_of_Dollars_1 SearchArray of Dollars[1]DLR19_RBS0_UTR$Currency1019
42Array_of_Dollars_2 SearchArray of Dollars[2]DLR19_RBS0_UTR$Currency1019
43Array_of_Dollars_3 SearchArray of Dollars[3]DLR19_RBS0_UTR$Currency1019
44Array_of_Dollars_4 SearchArray of Dollars[4]DLR19_RBS0_UTR$Currency1019
45Array_of_Dollars_5 SearchArray of Dollars[5]DLR19_RBS0_UTR$Currency1019
46Array_of_Dollars_6 SearchArray of Dollars[6]DLR19_RBS0_UTR$Currency1019
47Array_of_Dollars_7 SearchArray of Dollars[7]DLR19_RBS0_UTR$Currency1019
48Array_of_Dollars_8 SearchArray of Dollars[8]DLR19_RBS0_UTR$Currency1019
49Array_of_Dollars_9 SearchArray of Dollars[9]DLR19_RBS0_UTR$Currency1019
50Array_of_Dollars_10 SearchArray of Dollars[10]DLR19_RBS0_UTR$Currency1019
51Array_of_Dollars_11 SearchArray of Dollars[11]DLR19_RBS0_UTR$Currency1019
52Array_of_Dollars_12 SearchArray of Dollars[12]DLR19_RBS0_UTR$Currency1019
53Array_of_Dollars_13 SearchArray of Dollars[13]DLR19_RBS0_UTR$Currency1019
54Array_of_Dollars_14 SearchArray of Dollars[14]DLR19_RBS0_UTR$Currency1019
55Array_of_Dollars_15 SearchArray of Dollars[15]DLR19_RBS0_UTR$Currency1019
56Array_of_Dollars_16 SearchArray of Dollars[16]DLR19_RBS0_UTR$Currency1019
57Array_of_Dollars_17 SearchArray of Dollars[17]DLR19_RBS0_UTR$Currency1019
58Array_of_Dollars_18 SearchArray of Dollars[18]DLR19_RBS0_UTR$Currency1019
59Array_of_Dollars_19 SearchArray of Dollars[19]DLR19_RBS0_UTR$Currency1019
60Array_of_Dollars_20 SearchArray of Dollars[20]DLR19_RBS0_UTR$Currency1019
61BillingNote SearchBilling NoteTX500Text2500
62Array_of_Texts_1 SearchArray of Texts[1]TX500Text2500
63Array_of_Texts_2 SearchArray of Texts[2]TX500Text2500
64Array_of_Texts_3 SearchArray of Texts[3]TX500Text2500
65Array_of_Texts_4 SearchArray of Texts[4]TX500Text2500
66Array_of_Texts_5 SearchArray of Texts[5]TX500Text2500
67DEX_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)PurchasingPOP PA Receipt Line Hist View (POP31310)

Leave a Reply

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