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 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.
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 STR17_POP_Number String 17 2 ORD Ord LI_Sequence_Number Long Integer 10 3 BRKFLD1 Break Field 1 INT1 Integer 1 4 ProjNum Project Number STR15_LBAU String 15 5 ProjectName Proj. Name STR30 String 30 6 CostCatID Cost Category ID STR15_LBAU String 15 7 CostCategoryName Cost Category Name STR30 String 30 8 CONTNBR Contract Number STR11 String 11 9 ContractName Contract Name STR30 String 30 10 CUSTNMBR Customer Number STR15_RM_Customer_Number String 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'].CUSTNMBR
11 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 12 ORTDISAM Originating Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 13 Array_of_Strings_1 Array of Strings[1] STR30 String 30 14 Array_of_Strings_2 Array of Strings[2] STR30 String 30 15 Array_of_Strings_3 Array of Strings[3] STR30 String 30 16 Array_of_Strings_4 Array of Strings[4] STR30 String 30 17 Array_of_Strings_5 Array of Strings[5] STR30 String 30 18 Array_of_Strings_6 Array of Strings[6] STR30 String 30 19 Array_of_Strings_7 Array of Strings[7] STR30 String 30 20 Array_of_Strings_8 Array of Strings[8] STR30 String 30 21 Array_of_Strings_9 Array of Strings[9] STR30 String 30 22 Array_of_Strings_10 Array of Strings[10] STR30 String 30 23 Array_of_Strings_11 Array of Strings[11] STR30 String 30 24 Array_of_Strings_12 Array of Strings[12] STR30 String 30 25 Array_of_Strings_13 Array of Strings[13] STR30 String 30 26 Array_of_Strings_14 Array of Strings[14] STR30 String 30 27 Array_of_Strings_15 Array of Strings[15] STR30 String 30 28 Array_of_Strings_16 Array of Strings[16] STR30 String 30 29 Array_of_Strings_17 Array of Strings[17] STR30 String 30 30 Array_of_Strings_18 Array of Strings[18] STR30 String 30 31 Array_of_Strings_19 Array of Strings[19] STR30 String 30 32 Array_of_Strings_20 Array of Strings[20] STR30 String 30 33 Array_of_Dollars_1 Array of Dollars[1] DLR19_RBS0_UTR$ Currency 19 34 Array_of_Dollars_2 Array of Dollars[2] DLR19_RBS0_UTR$ Currency 19 35 Array_of_Dollars_3 Array of Dollars[3] DLR19_RBS0_UTR$ Currency 19 36 Array_of_Dollars_4 Array of Dollars[4] DLR19_RBS0_UTR$ Currency 19 37 Array_of_Dollars_5 Array of Dollars[5] DLR19_RBS0_UTR$ Currency 19 38 Array_of_Dollars_6 Array of Dollars[6] DLR19_RBS0_UTR$ Currency 19 39 Array_of_Dollars_7 Array of Dollars[7] DLR19_RBS0_UTR$ Currency 19 40 Array_of_Dollars_8 Array of Dollars[8] DLR19_RBS0_UTR$ Currency 19 41 Array_of_Dollars_9 Array of Dollars[9] DLR19_RBS0_UTR$ Currency 19 42 Array_of_Dollars_10 Array of Dollars[10] DLR19_RBS0_UTR$ Currency 19 43 Array_of_Dollars_11 Array of Dollars[11] DLR19_RBS0_UTR$ Currency 19 44 Array_of_Dollars_12 Array of Dollars[12] DLR19_RBS0_UTR$ Currency 19 45 Array_of_Dollars_13 Array of Dollars[13] DLR19_RBS0_UTR$ Currency 19 46 Array_of_Dollars_14 Array of Dollars[14] DLR19_RBS0_UTR$ Currency 19 47 Array_of_Dollars_15 Array of Dollars[15] DLR19_RBS0_UTR$ Currency 19 48 Array_of_Dollars_16 Array of Dollars[16] DLR19_RBS0_UTR$ Currency 19 49 Array_of_Dollars_17 Array of Dollars[17] DLR19_RBS0_UTR$ Currency 19 50 Array_of_Dollars_18 Array of Dollars[18] DLR19_RBS0_UTR$ Currency 19 51 Array_of_Dollars_19 Array of Dollars[19] DLR19_RBS0_UTR$ Currency 19 52 Array_of_Dollars_20 Array of Dollars[20] DLR19_RBS0_UTR$ Currency 19 53 BillingNote Billing Note TX500 Text 500 54 Array_of_Texts_1 Array of Texts[1] TX500 Text 500 55 Array_of_Texts_2 Array of Texts[2] TX500 Text 500 56 Array_of_Texts_3 Array of Texts[3] TX500 Text 500 57 Array_of_Texts_4 Array of Texts[4] TX500 Text 500 58 Array_of_Texts_5 Array of Texts[5] TX500 Text 500 59 DEX_ROW_ID int int 10