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: Project

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 SequenceLI_Sequence_NumberLong Integer10
2PADocnumber20 SearchPA Document No.STR17_LBAUString17
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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 NumberSTR10_LBAUString10
5PADOCDT SearchPA Document DatePA_DateDate8
6CUTOFDAT SearchCutoff DateDTDate8
7PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
8PAprojname SearchPA Project NameSTR30_PTBS Description 1String30
9PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean0
10PA_Combine_Mode SearchPA RR Combine ModeINT1Integer1
11PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
12PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger0
13PASTAT SearchPA StatusPA_DDL_StatusInteger0
14PAPercentCompleted SearchPA Percent CompletedDLR5_%2Currency8
15PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
16PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
17PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
18PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
19PAPostCost SearchPA Actual CostDLR17_RBS0_UTR$Currency17
20PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
21PA_Actual_CostContract SearchPA Actual Cost-ContractDLR17_RBS0_UTR$Currency17
22PA_Actual_QtyContract SearchPA Actual Qty-ContractPA_DLR15_RBS0_STRCurrency15
23PARevenueEarned SearchPA Revenue EarnedDLR17_RBS0_UTR$Currency17
24PAREB SearchPA Revenue Earned-BudgetDLR17_RBS0_UTR$Currency17
25PAREF SearchPA Revenue Earned-FeeDLR17_RBS0_UTR$Currency17
26PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency17
27PABRecognizedProjAmt SearchPA Recognized Project AmountDLR17_RBS0_STR$Currency17
28PABRecognizedBudgAmount SearchPA Recognized Budget AmountDLR17_RBS0_STR$Currency17
29PARecognizedFeeAmount SearchPA Recognized Fee AmountDLR17_RBS0_STR$Currency17
30PABIEEAMOUNT SearchPA BIEE AmountDLR17_RBS0_UTR$Currency17
31PAEIEBAMOUNT SearchPA EIEB AmountDLR17_RBS0_UTR$Currency17
32PARRLNEERR SearchPA RR Line ErrorsML_RR_Line_ErrorsLong Integer0
33PA_ActualCost__LossTest SearchPA ActualCost - LossTestDLR17_RBS0_UTR$Currency17
34PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestDLR17_RBS0_UTR$Currency17
35PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestDLR17_RBS0_UTR$Currency17
36PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestDLR17_RBS0_UTR$Currency17
37PA_Earnings__XcessTest SearchPA Earnings - XcessTestDLR17_RBS0_UTR$Currency17
38PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
39PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
40PALossAmount SearchPA Loss AmountDLR17_RBS0_UTR$Currency17
41PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyDLR15_RBU2Currency15
42PAFTCLaborOnly SearchPA Forecast Total Cost - Labor OnlyDLR17_RBS0_UTR$Currency17
43PAAQLaborOnly SearchPA Actual Qty - Labor OnlyPA_DLR15_RBS0_STRCurrency15
44PAACLaborOnly SearchPA Actual Cost - Labor OnlyPA_DLR17_RBS0_STR$Currency17
45DEX_ROW_ID Searchintint10

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 Rev Recognition Proj Detail HIST File (PA33304)

Leave a Reply

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