Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA33701
Product: Project Accounting (258)
Series:
Display Name: PA Change Order Header HIST
Physical Name: PA33701
Technical Name: PA_Change_Order_HDR_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PACHGORDNO 
PA Change Order Number String STR17_LBAU 17 2 PACONTNUMBER PA Contract Number String STR10_LBAU 10 3 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['PA Change Order Header HIST'].CUSTNMBR AS 'PA Change Order Header HIST-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA33701 AS ['PA Change Order Header HIST']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Change Order Header HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR4 PADOCDT PA Document Date Date PA_Date 8 5 PACODESC PA Change Order Description String STR30 30 6 PACOCUSTNO PA Change Order Customer Number String STR20_Document_Number 20 7 PACOTYPE PA Change Order Type Integer PA_DDL_Change Order_Type 0 8 PACOSTATUS PA Change Order Status Integer PA_DDL_Change_Order_Status 0 9 REQSTDBY Requested By String STR20_LB 20 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PA Change Order Header HIST'].REQSTDBY AS 'PA Change Order Header HIST-Requested By'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA33701 AS ['PA Change Order Header HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Change Order Header HIST'].REQSTDBY = ['Users Master'].USERID10 PAESTBY PA Estimated By String STR20_LB 20 11 PAREVBY PA Revise By String STR15_User_ID 15 12 PAREVPOSITION PA Revision Position String STR30 30 13 PALSTREVSEDATE PA Last Revised Date Date PA_Date 8 14 LSTUSRED Last User to Edit String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PA Change Order Header HIST'].LSTUSRED AS 'PA Change Order Header HIST-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA33701 AS ['PA Change Order Header HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Change Order Header HIST'].LSTUSRED = ['Users Master'].USERID15 PAbegindate PA Begin Date Date PA_Date 8 16 PAEnDate PA End Date Date DT 8 17 PAAPPROVBY PA Approved By String STR15_User_ID 15 18 DSCRIPTN Description String STR30 30 19 APPRVLDT Approval Date Date DATE 6 20 PAGBTRKCHG PA GB Track Changes Integer GB 0 21 PAREVSBUDGMT PA CO Revised Budget Amount Currency DLR17_RBS0_UTR$ 17 22 PACOREVSFEEAMT PA CO Revised Fee Amount Currency DLR17_RBS0_UTR$ 17 23 PATOTCHGORDAMT PA Total Change Order Amount Currency DLR17_RBS0_UTR$ 17 24 PAREVREASON PA Revision Reason String STR30 30 25 PADOCSTATUS PA Document Status Integer INT2 2 26 PAsequencenumber PA Sequence Number 1 Integer INT5 4 27 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PA Change Order Header HIST'].NOTEINDX AS 'PA Change Order Header HIST-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA33701 AS ['PA Change Order Header HIST']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA Change Order Header HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX28 NOTEINDX2 Note Index2 Currency DLR14 14 29 PACOTOTBILL PA Change Order Total Billings Currency PA_DLR17_RBS0_STR$ 17 30 PACOTOTCOST PA Change Order Total Cost Currency PA_DLR17_RBS0_STR$ 17 31 PACOTOTQTY PA Change Order Total Qty Currency PA_DLR15_RBS0_STR 15 32 PAVARTOTBILLINGS PA Variance Total Billings Currency DLR17_RBS0_STR$ 17 33 PAVARTOTCOST PA Variance Total Cost Currency DLR17_RBS0_STR$ 17 34 PAVARTOTQTY PA Variance Total Qty Currency PA_DLR15_RBS0_STR 15