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:

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PACHGORDNO SearchPA Change Order NumberStringSTR17_LBAU17
2PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
3CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 DateDatePA_Date8
5PACODESC SearchPA Change Order DescriptionStringSTR3030
6PACOCUSTNO SearchPA Change Order Customer NumberStringSTR20_Document_Number20
7PACOTYPE SearchPA Change Order TypeIntegerPA_DDL_Change Order_Type0
8PACOSTATUS SearchPA Change Order StatusIntegerPA_DDL_Change_Order_Status0
9REQSTDBY SearchRequested ByStringSTR20_LB20
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 ByStringSTR20_LB20
11PAREVBY SearchPA Revise ByStringSTR15_User_ID15
12PAREVPOSITION SearchPA Revision PositionStringSTR3030
13PALSTREVSEDATE SearchPA Last Revised DateDatePA_Date8
14LSTUSRED SearchLast User to EditStringSTR1515
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 DateDatePA_Date8
16PAEnDate SearchPA End DateDateDT8
17PAAPPROVBY SearchPA Approved ByStringSTR15_User_ID15
18DSCRIPTN SearchDescriptionStringSTR3030
19APPRVLDT SearchApproval DateDateDATE6
20PAGBTRKCHG SearchPA GB Track ChangesIntegerGB0
21PAREVSBUDGMT SearchPA CO Revised Budget AmountCurrencyDLR17_RBS0_UTR$17
22PACOREVSFEEAMT SearchPA CO Revised Fee AmountCurrencyDLR17_RBS0_UTR$17
23PATOTCHGORDAMT SearchPA Total Change Order AmountCurrencyDLR17_RBS0_UTR$17
24PAREVREASON SearchPA Revision ReasonStringSTR3030
25PADOCSTATUS SearchPA Document StatusIntegerINT22
26PAsequencenumber SearchPA Sequence Number 1IntegerINT54
27NOTEINDX SearchNote IndexCurrencyDLR1414
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 Index2CurrencyDLR1414
29PACOTOTBILL SearchPA Change Order Total BillingsCurrencyPA_DLR17_RBS0_STR$17
30PACOTOTCOST SearchPA Change Order Total CostCurrencyPA_DLR17_RBS0_STR$17
31PACOTOTQTY SearchPA Change Order Total QtyCurrencyPA_DLR15_RBS0_STR15
32PAVARTOTBILLINGS SearchPA Variance Total BillingsCurrencyDLR17_RBS0_STR$17
33PAVARTOTCOST SearchPA Variance Total CostCurrencyDLR17_RBS0_STR$17
34PAVARTOTQTY SearchPA Variance Total QtyCurrencyPA_DLR15_RBS0_STR15
azurecurveProductsProject Accounting (258)ProjectPA Change Order Header HIST (PA33701)

Leave a Reply

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