PA Change Order Header WORK (PA12000)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Header WORK (PA12000)

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
Physical Name: PA12000
Technical Name: PA_Change_Order_HDR_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
2PACREATEADDFLY SearchPA Created Add On the FlyPA_CB_Created_Add_On_The_FlyBoolean0
3PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
4CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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'].CUSTNMBR
5PADOCDT SearchPA Document DatePA_DateDate8
6PACODESC SearchPA Change Order DescriptionSTR30String30
7PACOCUSTNO SearchPA Change Order Customer NumberSTR20_Document_NumberString20
8PACOTYPE SearchPA Change Order TypePA_DDL_Change Order_TypeInteger0
9PACOSTATUS SearchPA Change Order StatusPA_DDL_Change_Order_StatusInteger0
10REQSTDBY SearchRequested BySTR20_LBString20
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'].USERID
11PAESTBY SearchPA Estimated BySTR20_LBString20
12PAREVBY SearchPA Revise BySTR15_User_IDString15
13PAREVPOSITION SearchPA Revision PositionSTR30String30
14PALSTREVSEDATE SearchPA Last Revised DatePA_DateDate8
15LSTUSRED SearchLast User to EditSTR15String15
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'].USERID
16PAPREVBEGINDT SearchPA Prev Begin DatePA_DateDate8
17PAbegindate SearchPA Begin DatePA_DateDate8
18PAPREVENDDT SearchPA Prev End DatePA_DateDate8
19PAEnDate SearchPA End DateDTDate8
20PAAPPROVBY SearchPA Approved BySTR15_User_IDString15
21DSCRIPTN SearchDescriptionSTR30String30
22APPRVLDT SearchApproval DateDATEDate6
23PAGBTRKCHG SearchPA GB Track ChangesGBInteger0
24PAREVSBUDGMT SearchPA CO Revised Budget AmountDLR17_RBS0_UTR$Currency17
25PACOREVSFEEAMT SearchPA CO Revised Fee AmountDLR17_RBS0_UTR$Currency17
26PATOTCHGORDAMT SearchPA Total Change Order AmountDLR17_RBS0_UTR$Currency17
27PAPREVPROJAMT SearchPA Prev Project AmountDLR17_RBS0_UTR$Currency17
28PAVARPROFAMT SearchPA Variance Profit AmountDLR17_RBS0_STR$Currency17
29PAREVPROJAMT SearchPA Revise Project AmountDLR17_RBS0_UTR$Currency17
30PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
31PAREVREASON SearchPA Revision ReasonSTR30String30
32PADOCSTATUS SearchPA Document StatusINT2Integer2
33PAsequencenumber SearchPA Sequence Number 1INT5Integer4
34NOTEINDX SearchNote IndexDLR14Currency14
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'].NOTEINDX
35NOTEINDX2 SearchNote Index2DLR14Currency14
36PACOTOTCOST SearchPA Change Order Total CostPA_DLR17_RBS0_STR$Currency17
37PACOTOTBILL SearchPA Change Order Total BillingsPA_DLR17_RBS0_STR$Currency17
38PACOTOTQTY SearchPA Change Order Total QtyPA_DLR15_RBS0_STRCurrency15
39PAVARTOTBILLINGS SearchPA Variance Total BillingsDLR17_RBS0_STR$Currency17
40PAVARTOTCOST SearchPA Variance Total CostDLR17_RBS0_STR$Currency17
41PAVARTOTQTY SearchPA Variance Total QtyPA_DLR15_RBS0_STRCurrency15
42DEX_ROW_ID Searchintint10

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.

azurecurveProductsProject Accounting (258)ProjectPA Change Order Header WORK (PA12000)

Leave a Reply

Your email address will not be published. Required fields are marked *