PA Customer MSTR COST SUM (PA00532)

azurecurveProductsProject Accounting (258)ProjectPA Customer MSTR COST SUM (PA00532)

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

Product: Project Accounting (258)
Series:

Display Name: PA Customer MSTR COST SUM
Physical Name: PA00532
Technical Name: PA_Customer_MSTR_COST_SUM

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Customer MSTR COST SUM'].CUSTNMBR AS 'PA Customer MSTR COST SUM-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA00532 AS ['PA Customer MSTR COST SUM']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Customer MSTR COST SUM'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2PA_Aging_Period_WIP_Amt SearchPA Aging Period WIP AmountPA_DLR17_RBS0_STR$Currency17
3PA_Aging_Period_WIP_Amt_1 SearchPA Aging Period WIP Amount[1]CurrencyPA_DLR17_RBS0_STR$17
4PA_Aging_Period_WIP_Amt_2 SearchPA Aging Period WIP Amount[2]CurrencyPA_DLR17_RBS0_STR$17
5PA_Aging_Period_WIP_Amt_3 SearchPA Aging Period WIP Amount[3]CurrencyPA_DLR17_RBS0_STR$17
6PA_Aging_Period_WIP_Amt_4 SearchPA Aging Period WIP Amount[4]CurrencyPA_DLR17_RBS0_STR$17
7PA_Aging_Period_WIP_Amt_5 SearchPA Aging Period WIP Amount[5]CurrencyPA_DLR17_RBS0_STR$17
8PA_Aging_Period_WIP_Amt_6 SearchPA Aging Period WIP Amount[6]CurrencyPA_DLR17_RBS0_STR$17
9PA_Aging_Period_WIP_Amt_7 SearchPA Aging Period WIP Amount[7]CurrencyPA_DLR17_RBS0_STR$17
10PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
11LASTAGED SearchLast AgedDateDATE6
azurecurveProductsProject Accounting (258)ProjectPA Customer MSTR COST SUM (PA00532)

Leave a Reply

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