Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP31110
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: POP PA PO Line Hist View
Physical Name: POP31110
Technical Name: POP_PA_POLineHist_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMBER 
PO Number String STR17_POP_Number 17 2 ORD Ord Long Integer LI_Sequence_Number 10 3 BRKFLD1 Break Field 1 Integer INT1 1 4 ProjNum Project Number String STR15_LBAU 15 5 ProjectName Proj. Name String STR30 30 6 CostCatID Cost Category ID String STR15_LBAU 15 7 CostCategoryName Cost Category Name String STR30 30 8 CONTNBR Contract Number String STR11 11 9 ContractName Contract Name String STR30 30 10 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['POP PA PO Line Hist View'].CUSTNMBR AS 'POP PA PO Line Hist View-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
POP31110 AS ['POP PA PO Line Hist View']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['POP PA PO Line Hist View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR11 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 12 ORTDISAM Originating Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 13 Array_of_Strings_1 Array of Strings[1] String STR30 30 14 Array_of_Strings_2 Array of Strings[2] String STR30 30 15 Array_of_Strings_3 Array of Strings[3] String STR30 30 16 Array_of_Strings_4 Array of Strings[4] String STR30 30 17 Array_of_Strings_5 Array of Strings[5] String STR30 30 18 Array_of_Strings_6 Array of Strings[6] String STR30 30 19 Array_of_Strings_7 Array of Strings[7] String STR30 30 20 Array_of_Strings_8 Array of Strings[8] String STR30 30 21 Array_of_Strings_9 Array of Strings[9] String STR30 30 22 Array_of_Strings_10 Array of Strings[10] String STR30 30 23 Array_of_Strings_11 Array of Strings[11] String STR30 30 24 Array_of_Strings_12 Array of Strings[12] String STR30 30 25 Array_of_Strings_13 Array of Strings[13] String STR30 30 26 Array_of_Strings_14 Array of Strings[14] String STR30 30 27 Array_of_Strings_15 Array of Strings[15] String STR30 30 28 Array_of_Strings_16 Array of Strings[16] String STR30 30 29 Array_of_Strings_17 Array of Strings[17] String STR30 30 30 Array_of_Strings_18 Array of Strings[18] String STR30 30 31 Array_of_Strings_19 Array of Strings[19] String STR30 30 32 Array_of_Strings_20 Array of Strings[20] String STR30 30 33 Array_of_Dollars_1 Array of Dollars[1] Currency DLR19_RBS0_UTR$ 19 34 Array_of_Dollars_2 Array of Dollars[2] Currency DLR19_RBS0_UTR$ 19 35 Array_of_Dollars_3 Array of Dollars[3] Currency DLR19_RBS0_UTR$ 19 36 Array_of_Dollars_4 Array of Dollars[4] Currency DLR19_RBS0_UTR$ 19 37 Array_of_Dollars_5 Array of Dollars[5] Currency DLR19_RBS0_UTR$ 19 38 Array_of_Dollars_6 Array of Dollars[6] Currency DLR19_RBS0_UTR$ 19 39 Array_of_Dollars_7 Array of Dollars[7] Currency DLR19_RBS0_UTR$ 19 40 Array_of_Dollars_8 Array of Dollars[8] Currency DLR19_RBS0_UTR$ 19 41 Array_of_Dollars_9 Array of Dollars[9] Currency DLR19_RBS0_UTR$ 19 42 Array_of_Dollars_10 Array of Dollars[10] Currency DLR19_RBS0_UTR$ 19 43 Array_of_Dollars_11 Array of Dollars[11] Currency DLR19_RBS0_UTR$ 19 44 Array_of_Dollars_12 Array of Dollars[12] Currency DLR19_RBS0_UTR$ 19 45 Array_of_Dollars_13 Array of Dollars[13] Currency DLR19_RBS0_UTR$ 19 46 Array_of_Dollars_14 Array of Dollars[14] Currency DLR19_RBS0_UTR$ 19 47 Array_of_Dollars_15 Array of Dollars[15] Currency DLR19_RBS0_UTR$ 19 48 Array_of_Dollars_16 Array of Dollars[16] Currency DLR19_RBS0_UTR$ 19 49 Array_of_Dollars_17 Array of Dollars[17] Currency DLR19_RBS0_UTR$ 19 50 Array_of_Dollars_18 Array of Dollars[18] Currency DLR19_RBS0_UTR$ 19 51 Array_of_Dollars_19 Array of Dollars[19] Currency DLR19_RBS0_UTR$ 19 52 Array_of_Dollars_20 Array of Dollars[20] Currency DLR19_RBS0_UTR$ 19 53 BillingNote Billing Note Text TX500 500 54 Array_of_Texts_1 Array of Texts[1] Text TX500 500 55 Array_of_Texts_2 Array of Texts[2] Text TX500 500 56 Array_of_Texts_3 Array of Texts[3] Text TX500 500 57 Array_of_Texts_4 Array of Texts[4] Text TX500 500 58 Array_of_Texts_5 Array of Texts[5] Text TX500 500