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