Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PT00101
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Project Costing Master
Physical Name: PT00101
Technical Name: ptProjectMstrSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PROJNAME 
Project Name String STR20_LBU 20 2 PROJDESC Project Description String STR50 50 3 PROJMGR Project Manager String STR30 30 4 PROJTYPE Project Type String STR30 30 5 ESTSTARTDATE Estimated Start Date Date DT 8 6 ESTCOMPDATE Estimated Completion Date Date DT 8 7 ACTSTARTDATE Actual Start Date Date DT 8 8 ACTCOMPDATE Actual Completion Date Date DT 8 9 PROJSTATUS Project Status Integer DDL_Project_Status 0 10 CLOSEDTOBILL Closed To Billing Boolean CB_Closed_To_Billing 0 11 CLOSEDTOCOST Closed To Costs Boolean CB_Closed_To_Costs 0 12 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Project Costing Master'].CUSTNMBR AS 'Project Costing Master-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PT00101 AS ['Project Costing Master']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Project Costing Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR13 PRBTADCD Primary Billto Address Code String STR15_LBAU 15 14 ADRSCODE Address Code String STR15_Address_Code 15 15 ADDRESS1 Address 1 String STR60 60 16 ADDRESS2 Address 2 String STR60 60 17 CITY City String STR35 35 18 STATE State String STR30_State 29 19 ZIP Zip String STR10 10 20 ESTPREFER Estimate Preference Integer DDL_Estimate_Preference 0 21 ESTMATCOST Estimated Material Cost Currency DLR19_RBS0_STR$ 19 22 ESTLABORCOST Estimated Labor Cost Currency DLR19_RBS0_STR$ 19 23 ESTMISCCOST Estimated Misc Cost Currency DLR19_RBS0_STR$ 19 24 ESTMATREV Estimated Material Revenue Currency DLR19_RBS0_STR$ 19 25 ESTLABORREV Estimated Labor Revenue Currency DLR19_RBS0_STR$ 19 26 ESTMISCREV Estimated Misc Revenue Currency DLR19_RBS0_STR$ 19 27 ACTMATCOST Actual Material Cost Currency DLR19_RBS0_STR$ 19 28 ACTLABORCOST Actual Labor Cost Currency DLR19_RBS0_STR$ 19 29 ACTMISCCOST Actual Misc Cost Currency DLR19_RBS0_STR$ 19 30 ACTMATREV Actual Material Revenue Currency DLR19_RBS0_STR$ 19 31 ACTLABORREV Actual Labor Revenue Currency DLR19_RBS0_STR$ 19 32 ACTMISCREV Actual Misc Revenue Currency DLR19_RBS0_STR$ 19 33 USERDEF1 User Defined 1 String STR20 20 34 USERDEF2 User Defined 2 String STR20 20 35 CREATDDT Created Date Date DT 8 36 CRUSRID Created User ID String STR15_User_ID 15 37 MODIFDT Modified Date Date DT 8 38 MDFUSRID Modified User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Project Costing Master'].MDFUSRID AS 'Project Costing Master-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PT00101 AS ['Project Costing Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Project Costing Master'].MDFUSRID = ['Users Master'].USERID39 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Project Costing Master'].NOTEINDX AS 'Project Costing Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PT00101 AS ['Project Costing Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Project Costing Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX