PA Change Order Header OPEN (PA23400)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Header OPEN (PA23400)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA23400

Product: Project Accounting (258)
Series: Project

Display Name: PA Change Order Header OPEN
Physical Name: PA23400
Technical Name: PA_Change_Order_HDR_OPEN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
2PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Change Order Header OPEN'].CUSTNMBR AS 'PA Change Order Header OPEN-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA23400 AS ['PA Change Order Header OPEN']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Change Order Header OPEN'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4PADOCDT SearchPA Document DatePA_DateDate8
5PACODESC SearchPA Change Order DescriptionSTR30String30
6PACOCUSTNO SearchPA Change Order Customer NumberSTR20_Document_NumberString20
7PACOTYPE SearchPA Change Order TypePA_DDL_Change Order_TypeInteger0
8PACOSTATUS SearchPA Change Order StatusPA_DDL_Change_Order_StatusInteger0
9REQSTDBY SearchRequested BySTR20_LBString20
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PA Change Order Header OPEN'].REQSTDBY AS 'PA Change Order Header OPEN-Requested By'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PA23400 AS ['PA Change Order Header OPEN']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PA Change Order Header OPEN'].REQSTDBY = ['Users Master'].USERID
10PAESTBY SearchPA Estimated BySTR20_LBString20
11PAREVBY SearchPA Revise BySTR15_User_IDString15
12PAREVPOSITION SearchPA Revision PositionSTR30String30
13PALSTREVSEDATE SearchPA Last Revised DatePA_DateDate8
14LSTUSRED SearchLast User to EditSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PA Change Order Header OPEN'].LSTUSRED AS 'PA Change Order Header OPEN-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PA23400 AS ['PA Change Order Header OPEN']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PA Change Order Header OPEN'].LSTUSRED = ['Users Master'].USERID
15PAbegindate SearchPA Begin DatePA_DateDate8
16PAEnDate SearchPA End DateDTDate8
17PAAPPROVBY SearchPA Approved BySTR15_User_IDString15
18DSCRIPTN SearchDescriptionSTR30String30
19APPRVLDT SearchApproval DateDATEDate6
20PAGBTRKCHG SearchPA GB Track ChangesGBInteger0
21PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
22PAREVSBUDGMT SearchPA CO Revised Budget AmountDLR17_RBS0_UTR$Currency17
23PACOREVSFEEAMT SearchPA CO Revised Fee AmountDLR17_RBS0_UTR$Currency17
24PATOTCHGORDAMT SearchPA Total Change Order AmountDLR17_RBS0_UTR$Currency17
25PAREVREASON SearchPA Revision ReasonSTR30String30
26PADOCSTATUS SearchPA Document StatusINT2Integer2
27PAsequencenumber SearchPA Sequence Number 1INT5Integer4
28NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Change Order Header OPEN'].NOTEINDX AS 'PA Change Order Header OPEN-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA23400 AS ['PA Change Order Header OPEN']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Change Order Header OPEN'].NOTEINDX = ['Record Notes Master'].NOTEINDX
29NOTEINDX2 SearchNote Index2DLR14Currency14
30PACOTOTBILL SearchPA Change Order Total BillingsPA_DLR17_RBS0_STR$Currency17
31PACOTOTCOST SearchPA Change Order Total CostPA_DLR17_RBS0_STR$Currency17
32PACOTOTQTY SearchPA Change Order Total QtyPA_DLR15_RBS0_STRCurrency15
33PAVARTOTBILLINGS SearchPA Variance Total BillingsDLR17_RBS0_STR$Currency17
34PAVARTOTCOST SearchPA Variance Total CostDLR17_RBS0_STR$Currency17
35PAVARTOTQTY SearchPA Variance Total QtyPA_DLR15_RBS0_STRCurrency15
36DEX_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 OPEN (PA23400)

Leave a Reply

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