PA Change Order Header HIST (PA33701)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Header HIST (PA33701)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Change Order Header HIST
Physical Name: PA33701
Technical Name: PA_Change_Order_HDR_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
2PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
4PADOCDT SearchPA Document DatePA_DateDate48
5PACODESC SearchPA Change Order DescriptionSTR30String3230
6PACOCUSTNO SearchPA Change Order Customer NumberSTR20_Document_NumberString2220
7PACOTYPE SearchPA Change Order TypePA_DDL_Change Order_TypeInteger20
8PACOSTATUS SearchPA Change Order StatusPA_DDL_Change_Order_StatusInteger20
9REQSTDBY SearchRequested BySTR20_LBString2220
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'].USERID
10PAESTBY SearchPA Estimated BySTR20_LBString2220
11PAREVBY SearchPA Revise BySTR15_User_IDString1615
12PAREVPOSITION SearchPA Revision PositionSTR30String3230
13PALSTREVSEDATE SearchPA Last Revised DatePA_DateDate48
14LSTUSRED SearchLast User to EditSTR15String1615
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'].USERID
15PAbegindate SearchPA Begin DatePA_DateDate48
16PAEnDate SearchPA End DateDTDate48
17PAAPPROVBY SearchPA Approved BySTR15_User_IDString1615
18DSCRIPTN SearchDescriptionSTR30String3230
19APPRVLDT SearchApproval DateDATEDate46
20PAGBTRKCHG SearchPA GB Track ChangesGBInteger20
21PAREVSBUDGMT SearchPA CO Revised Budget AmountDLR17_RBS0_UTR$Currency1017
22PACOREVSFEEAMT SearchPA CO Revised Fee AmountDLR17_RBS0_UTR$Currency1017
23PATOTCHGORDAMT SearchPA Total Change Order AmountDLR17_RBS0_UTR$Currency1017
24PAREVREASON SearchPA Revision ReasonSTR30String3230
25PADOCSTATUS SearchPA Document StatusINT2Integer22
26PAsequencenumber SearchPA Sequence Number 1INT5Integer24
27NOTEINDX SearchNote IndexDLR14Currency1014
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'].NOTEINDX
28NOTEINDX2 SearchNote Index2DLR14Currency1014
29PACOTOTBILL SearchPA Change Order Total BillingsPA_DLR17_RBS0_STR$Currency1017
30PACOTOTCOST SearchPA Change Order Total CostPA_DLR17_RBS0_STR$Currency1017
31PACOTOTQTY SearchPA Change Order Total QtyPA_DLR15_RBS0_STRCurrency1015
32PAVARTOTBILLINGS SearchPA Variance Total BillingsDLR17_RBS0_STR$Currency1017
33PAVARTOTCOST SearchPA Variance Total CostDLR17_RBS0_STR$Currency1017
34PAVARTOTQTY SearchPA Variance Total QtyPA_DLR15_RBS0_STRCurrency1015
35DEX_ROW_ID Searchintint1010

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 HIST (PA33701)

Leave a Reply

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