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 TypeSQL DB LengthKeyable Length
1PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
2PACREATEADDFLY SearchPA Created Add On the FlyPA_CB_Created_Add_On_The_FlyBoolean20
3PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
4CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_DateDate48
6PACODESC SearchPA Change Order DescriptionSTR30String3230
7PACOCUSTNO SearchPA Change Order Customer NumberSTR20_Document_NumberString2220
8PACOTYPE SearchPA Change Order TypePA_DDL_Change Order_TypeInteger20
9PACOSTATUS SearchPA Change Order StatusPA_DDL_Change_Order_StatusInteger20
10REQSTDBY SearchRequested BySTR20_LBString2220
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_LBString2220
12PAREVBY SearchPA Revise BySTR15_User_IDString1615
13PAREVPOSITION SearchPA Revision PositionSTR30String3230
14PALSTREVSEDATE SearchPA Last Revised DatePA_DateDate48
15LSTUSRED SearchLast User to EditSTR15String1615
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_DateDate48
17PAbegindate SearchPA Begin DatePA_DateDate48
18PAPREVENDDT SearchPA Prev End DatePA_DateDate48
19PAEnDate SearchPA End DateDTDate48
20PAAPPROVBY SearchPA Approved BySTR15_User_IDString1615
21DSCRIPTN SearchDescriptionSTR30String3230
22APPRVLDT SearchApproval DateDATEDate46
23PAGBTRKCHG SearchPA GB Track ChangesGBInteger20
24PAREVSBUDGMT SearchPA CO Revised Budget AmountDLR17_RBS0_UTR$Currency1017
25PACOREVSFEEAMT SearchPA CO Revised Fee AmountDLR17_RBS0_UTR$Currency1017
26PATOTCHGORDAMT SearchPA Total Change Order AmountDLR17_RBS0_UTR$Currency1017
27PAPREVPROJAMT SearchPA Prev Project AmountDLR17_RBS0_UTR$Currency1017
28PAVARPROFAMT SearchPA Variance Profit AmountDLR17_RBS0_STR$Currency1017
29PAREVPROJAMT SearchPA Revise Project AmountDLR17_RBS0_UTR$Currency1017
30PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
31PAREVREASON SearchPA Revision ReasonSTR30String3230
32PADOCSTATUS SearchPA Document StatusINT2Integer22
33PAsequencenumber SearchPA Sequence Number 1INT5Integer24
34NOTEINDX SearchNote IndexDLR14Currency1014
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 Index2DLR14Currency1014
36PACOTOTCOST SearchPA Change Order Total CostPA_DLR17_RBS0_STR$Currency1017
37PACOTOTBILL SearchPA Change Order Total BillingsPA_DLR17_RBS0_STR$Currency1017
38PACOTOTQTY SearchPA Change Order Total QtyPA_DLR15_RBS0_STRCurrency1015
39PAVARTOTBILLINGS SearchPA Variance Total BillingsDLR17_RBS0_STR$Currency1017
40PAVARTOTCOST SearchPA Variance Total CostDLR17_RBS0_STR$Currency1017
41PAVARTOTQTY SearchPA Variance Total QtyPA_DLR15_RBS0_STRCurrency1015
42DEX_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 WORK (PA12000)

Leave a Reply

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