PA Rev Recognition Proj Detail HIST File (PA33304)

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Proj Detail HIST File (PA33304)

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

Product: Project Accounting (258)
Series:

Display Name: PA Rev Recognition Proj Detail HIST File
Physical Name: PA33304
Technical Name: PA_Rev_Recog_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
1LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
2PADocnumber20 SearchPA Document No.StringSTR17_LBAU17
3CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Rev Recognition Proj Detail HIST File'].CUSTNMBR AS 'PA Rev Recognition Proj Detail HIST File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA33304 AS ['PA Rev Recognition Proj Detail HIST File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Rev Recognition Proj Detail HIST File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
5PADOCDT SearchPA Document DateDatePA_Date8
6CUTOFDAT SearchCutoff DateDateDT8
7PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
8PAprojname SearchPA Project NameStringSTR30_PTBS Description 130
9PASegmentCB SearchPA Segment CBBooleanPA_CB_Segment0
10PA_Combine_Mode SearchPA RR Combine ModeIntegerINT11
11PAProjectType SearchPA Project TypeIntegerPA_DDL_Project_Type0
12PAAcctgMethod SearchPA Accounting MethodIntegerPA_DDL_Accounting_Method0
13PASTAT SearchPA StatusIntegerPA_DDL_Status0
14PAPercentCompleted SearchPA Percent CompletedCurrencyDLR5_%28
15PAProject_Amount SearchPA Project AmountCurrencyDLR17_RBS0_UTR$17
16PAFTotalCost SearchPA Forecast Total CostCurrencyDLR17_RBS0_UTR$17
17PAFQuantity SearchPA Forecast QuantityCurrencyDLR15_RBU215
18PAFBillings SearchPA Forecast BillingsCurrencyDLR17_RBS0_UTR$17
19PAPostCost SearchPA Actual CostCurrencyDLR17_RBS0_UTR$17
20PAPostedQty SearchPA Actual QtyCurrencyPA_DLR15_RBS0_STR15
21PA_Actual_CostContract SearchPA Actual Cost-ContractCurrencyDLR17_RBS0_UTR$17
22PA_Actual_QtyContract SearchPA Actual Qty-ContractCurrencyPA_DLR15_RBS0_STR15
23PARevenueEarned SearchPA Revenue EarnedCurrencyDLR17_RBS0_UTR$17
24PAREB SearchPA Revenue Earned-BudgetCurrencyDLR17_RBS0_UTR$17
25PAREF SearchPA Revenue Earned-FeeCurrencyDLR17_RBS0_UTR$17
26PA_Cost_of_Earnings SearchPA Cost of EarningsCurrencyPA_DLR17_RBS0_STR$17
27PABRecognizedProjAmt SearchPA Recognized Project AmountCurrencyDLR17_RBS0_STR$17
28PABRecognizedBudgAmount SearchPA Recognized Budget AmountCurrencyDLR17_RBS0_STR$17
29PARecognizedFeeAmount SearchPA Recognized Fee AmountCurrencyDLR17_RBS0_STR$17
30PABIEEAMOUNT SearchPA BIEE AmountCurrencyDLR17_RBS0_UTR$17
31PAEIEBAMOUNT SearchPA EIEB AmountCurrencyDLR17_RBS0_UTR$17
32PARRLNEERR SearchPA RR Line ErrorsLong IntegerML_RR_Line_Errors0
33PA_ActualCost__LossTest SearchPA ActualCost - LossTestCurrencyDLR17_RBS0_UTR$17
34PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestCurrencyDLR17_RBS0_UTR$17
35PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestCurrencyDLR17_RBS0_UTR$17
36PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestCurrencyDLR17_RBS0_UTR$17
37PA_Earnings__XcessTest SearchPA Earnings - XcessTestCurrencyDLR17_RBS0_UTR$17
38PAPostedBillingsN SearchPA Actual BillingsCurrencyPA_DLR17_RBS0_STR$17
39PAPostRecogRevN SearchPA Actual Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
40PALossAmount SearchPA Loss AmountCurrencyDLR17_RBS0_UTR$17
41PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyCurrencyDLR15_RBU215
42PAFTCLaborOnly SearchPA Forecast Total Cost - Labor OnlyCurrencyDLR17_RBS0_UTR$17
43PAAQLaborOnly SearchPA Actual Qty - Labor OnlyCurrencyPA_DLR15_RBS0_STR15
44PAACLaborOnly SearchPA Actual Cost - Labor OnlyCurrencyPA_DLR17_RBS0_STR$17
azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Proj Detail HIST File (PA33304)

Leave a Reply

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