POP PA Receipt Line View (POP11310)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: POP PA Receipt Line View
Physical Name: POP11310
Technical Name: POP_PA_ReceiptLine_View

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
2RCPTLNNM SearchReceipt Line NumberLong IntegerLI_Sequence_Number10
3POPLNERR2 SearchPOP LINE Errors 2Long IntegerML_POP_LINE_Errors_20
4ProjNum SearchProject NumberStringSTR15_LBAU15
5ProjectName SearchProj. NameStringSTR3030
6CostCatID SearchCost Category IDStringSTR15_LBAU15
7CostCategoryName SearchCost Category NameStringSTR3030
8CONTNBR SearchContract NumberStringSTR1111
9ContractName SearchContract NameStringSTR3030
10CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

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

Click to show/hide

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

Leave a Reply

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