PA Rev Recognition Budget DTL HIST File (PA33302)

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Budget DTL HIST File (PA33302)

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

Product: Project Accounting (258)
Series:

Display Name: PA Rev Recognition Budget DTL HIST File
Physical Name: PA33302
Technical Name: PA_Rev_Recog_Budg_DTL_HIST

Group Display Name: PA Revenue Recog Transactions History
Group Technical Name: PA Revenue Recog Transactions History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PADocnumber20 SearchPA Document No.StringSTR17_LBAU17
2PADOCDT SearchPA Document DateDatePA_Date8
3CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Rev Recognition Budget DTL HIST File'].CUSTNMBR AS 'PA Rev Recognition Budget DTL HIST File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA33302 AS ['PA Rev Recognition Budget DTL HIST File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Rev Recognition Budget DTL HIST File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4CUTOFDAT SearchCutoff DateDateDT8
5PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
6PAprojname SearchPA Project NameStringSTR30_PTBS Description 130
7PAAcctgMethod SearchPA Accounting MethodIntegerPA_DDL_Accounting_Method0
8PASTAT SearchPA StatusIntegerPA_DDL_Status0
9PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
10PACBRecogRev SearchPA Recognize Revenue CBBooleanPA_CB_Recognize_Revenue0
11PATU SearchPA Transaction UsageIntegerPA_DDL_Transaction_Usage0
12PAFTotalCost SearchPA Forecast Total CostCurrencyDLR17_RBS0_UTR$17
13PAFQuantity SearchPA Forecast QuantityCurrencyDLR15_RBU215
14PAFBillings SearchPA Forecast BillingsCurrencyDLR17_RBS0_UTR$17
15PAPostCost SearchPA Actual CostCurrencyDLR17_RBS0_UTR$17
16PAPostedQtySTDN SearchPA Actual Qty STDCurrencyPA_DLR15_RBS0_STR15
17PAPercentCompleted SearchPA Percent CompletedCurrencyDLR5_%28
18PAREB SearchPA Revenue Earned-BudgetCurrencyDLR17_RBS0_UTR$17
19PA_Cost_of_Earnings SearchPA Cost of EarningsCurrencyPA_DLR17_RBS0_STR$17
20PABRecognizedBudgAmount SearchPA Recognized Budget AmountCurrencyDLR17_RBS0_STR$17
21PABIEEAMOUNT SearchPA BIEE AmountCurrencyDLR17_RBS0_UTR$17
22PAEIEBAMOUNT SearchPA EIEB AmountCurrencyDLR17_RBS0_UTR$17
23PAPostedBillingsN SearchPA Actual BillingsCurrencyPA_DLR17_RBS0_STR$17
24PA_Trade_Discount_Amount SearchPA Trade Discount AmountCurrencyPA_DLR17_RBS0_STR$17
25PACGBWIPIDX SearchPA WIP IDXLong IntegerLI_1414
26PABBillingsIDX SearchPA Billings IDXLong IntegerLI_1414
27PABExpenseIDX SearchPA Expense IDXLong IntegerLI_1414
28PABLossIDX SearchPA Loss IDXLong IntegerLI_1414
29PARev_IDX SearchPA Revenue IDXLong IntegerLI_1414
30PABEIEBIDX SearchPA EIEB IDXLong IntegerLI_1414
31PABBIEEIDX SearchPA BIEE IDXLong IntegerLI_1414
32PACGBRRSublineErrorsB SearchPA RR Subline Errors-BudgetLong IntegerML_RR_Subline_Errors_Budg0
33NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Rev Recognition Budget DTL HIST File'].NOTEINDX AS 'PA Rev Recognition Budget DTL HIST File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA33302 AS ['PA Rev Recognition Budget DTL HIST File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Rev Recognition Budget DTL HIST File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
34PA_ActualCost__LossTest SearchPA ActualCost - LossTestCurrencyDLR17_RBS0_UTR$17
35PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestCurrencyDLR17_RBS0_UTR$17
36PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestCurrencyDLR17_RBS0_UTR$17
37PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestCurrencyDLR17_RBS0_UTR$17
38PA_Earnings__XcessTest SearchPA Earnings - XcessTestCurrencyDLR17_RBS0_UTR$17
39PAPostRecogRevN SearchPA Actual Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
40PALossAmount SearchPA Loss AmountCurrencyDLR17_RBS0_UTR$17
41PAPrevRecognizedRev SearchPA Prev Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
42PAPrevBIEEAmount SearchPA Prev BIEE AmountCurrencyPA_DLR17_RBS0_STR$17
43PAPrevEIEBAmount SearchPA Prev EIEB AmountCurrencyPA_DLR17_RBS0_STR$17
44PAPrevEarnings SearchPA Prev EarningsCurrencyPA_DLR17_RBS0_STR$17
45PAPrevLossAmount SearchPA Prev Loss AmountCurrencyPA_DLR17_RBS0_STR$17
46PAPrevBillings SearchPA Prev BillingsCurrencyPA_DLR17_RBS0_STR$17
47PAPrevCost SearchPA Prev CostCurrencyPA_DLR17_RBS0_STR$17
azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Budget DTL HIST File (PA33302)

Leave a Reply

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