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_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 POPRCTNM 
POP Receipt Number String STR17_POP_Number 17 2 RCPTLNNM Receipt Line Number Long Integer LI_Sequence_Number 10 3 ProjNum Project Number String STR15_LBAU 15 4 ProjectName Proj. Name String STR30 30 5 CostCatID Cost Category ID String STR15_LBAU 15 6 CostCategoryName Cost Category Name String STR30 30 7 CONTNBR Contract Number String STR11 11 8 ContractName Contract Name String STR30 30 9 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 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'].CUSTNMBR10 CURRNIDX Currency Index Integer INT3 3 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'].CURRNIDX11 AccruedRevenues Accrued Revenues Currency DLR17_RBS0_UTR$ 17 12 OrigAccruedRevenues Originating Accrued Revenues Currency DLR17_RBS0_UTR$ 17 13 MCAccruedRevenues MC Accrued Revenues Currency DLR17_RBS0_UTR$ 17 14 VarianceAccruedRevenue Variance Accrued Revenues Currency DLR17_RBS0_UTR$ 17 15 OrigVarAccruedRevenues Originating Variance Accrued Revenues Currency DLR17_RBS0_UTR$ 17 16 MCVarianceAccruedRev MC Variance Accrued Revenues Currency DLR17_RBS0_UTR$ 17 17 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 18 OREXTCST Originating Extended Cost Currency DLR17_RBS0_UTR$ 17 19 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 20 ORTDISAM Originating Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 21 Array_of_Strings_1 Array of Strings[1] String STR30 30 22 Array_of_Strings_2 Array of Strings[2] String STR30 30 23 Array_of_Strings_3 Array of Strings[3] String STR30 30 24 Array_of_Strings_4 Array of Strings[4] String STR30 30 25 Array_of_Strings_5 Array of Strings[5] String STR30 30 26 Array_of_Strings_6 Array of Strings[6] String STR30 30 27 Array_of_Strings_7 Array of Strings[7] String STR30 30 28 Array_of_Strings_8 Array of Strings[8] String STR30 30 29 Array_of_Strings_9 Array of Strings[9] String STR30 30 30 Array_of_Strings_10 Array of Strings[10] String STR30 30 31 Array_of_Strings_11 Array of Strings[11] String STR30 30 32 Array_of_Strings_12 Array of Strings[12] String STR30 30 33 Array_of_Strings_13 Array of Strings[13] String STR30 30 34 Array_of_Strings_14 Array of Strings[14] String STR30 30 35 Array_of_Strings_15 Array of Strings[15] String STR30 30 36 Array_of_Strings_16 Array of Strings[16] String STR30 30 37 Array_of_Strings_17 Array of Strings[17] String STR30 30 38 Array_of_Strings_18 Array of Strings[18] String STR30 30 39 Array_of_Strings_19 Array of Strings[19] String STR30 30 40 Array_of_Strings_20 Array of Strings[20] String STR30 30 41 Array_of_Dollars_1 Array of Dollars[1] Currency DLR19_RBS0_UTR$ 19 42 Array_of_Dollars_2 Array of Dollars[2] Currency DLR19_RBS0_UTR$ 19 43 Array_of_Dollars_3 Array of Dollars[3] Currency DLR19_RBS0_UTR$ 19 44 Array_of_Dollars_4 Array of Dollars[4] Currency DLR19_RBS0_UTR$ 19 45 Array_of_Dollars_5 Array of Dollars[5] Currency DLR19_RBS0_UTR$ 19 46 Array_of_Dollars_6 Array of Dollars[6] Currency DLR19_RBS0_UTR$ 19 47 Array_of_Dollars_7 Array of Dollars[7] Currency DLR19_RBS0_UTR$ 19 48 Array_of_Dollars_8 Array of Dollars[8] Currency DLR19_RBS0_UTR$ 19 49 Array_of_Dollars_9 Array of Dollars[9] Currency DLR19_RBS0_UTR$ 19 50 Array_of_Dollars_10 Array of Dollars[10] Currency DLR19_RBS0_UTR$ 19 51 Array_of_Dollars_11 Array of Dollars[11] Currency DLR19_RBS0_UTR$ 19 52 Array_of_Dollars_12 Array of Dollars[12] Currency DLR19_RBS0_UTR$ 19 53 Array_of_Dollars_13 Array of Dollars[13] Currency DLR19_RBS0_UTR$ 19 54 Array_of_Dollars_14 Array of Dollars[14] Currency DLR19_RBS0_UTR$ 19 55 Array_of_Dollars_15 Array of Dollars[15] Currency DLR19_RBS0_UTR$ 19 56 Array_of_Dollars_16 Array of Dollars[16] Currency DLR19_RBS0_UTR$ 19 57 Array_of_Dollars_17 Array of Dollars[17] Currency DLR19_RBS0_UTR$ 19 58 Array_of_Dollars_18 Array of Dollars[18] Currency DLR19_RBS0_UTR$ 19 59 Array_of_Dollars_19 Array of Dollars[19] Currency DLR19_RBS0_UTR$ 19 60 Array_of_Dollars_20 Array of Dollars[20] Currency DLR19_RBS0_UTR$ 19 61 BillingNote Billing Note Text TX500 500 62 Array_of_Texts_1 Array of Texts[1] Text TX500 500 63 Array_of_Texts_2 Array of Texts[2] Text TX500 500 64 Array_of_Texts_3 Array of Texts[3] Text TX500 500 65 Array_of_Texts_4 Array of Texts[4] Text TX500 500 66 Array_of_Texts_5 Array of Texts[5] Text TX500 500