PA Rev Recognition Proj Detail WORK File (PA23302)

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Proj Detail WORK File (PA23302)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Rev Recognition Proj Detail WORK File
Physical Name: PA23302
Technical Name: PA_Rev_Recog_DTL_WORK

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
2PADocnumber20 SearchPA Document No.STR17_LBAUString1817
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Rev Recognition Proj Detail WORK File'].CUSTNMBR AS 'PA Rev Recognition Proj Detail WORK File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA23302 AS ['PA Rev Recognition Proj Detail WORK File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Rev Recognition Proj Detail WORK File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
5PADOCDT SearchPA Document DatePA_DateDate48
6CUTOFDAT SearchCutoff DateDTDate48
7PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
8PAprojname SearchPA Project NameSTR30_PTBS Description 1String3230
9PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean20
10PA_Combine_Mode SearchPA RR Combine ModeINT1Integer21
11PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
12PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger20
13PASTAT SearchPA StatusPA_DDL_StatusInteger20
14PAPercentCompleted SearchPA Percent CompletedDLR5_%2Currency108
15PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
16PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency1017
17PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency1015
18PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency1017
19PAPostCost SearchPA Actual CostDLR17_RBS0_UTR$Currency1017
20PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency1015
21PA_Actual_CostContract SearchPA Actual Cost-ContractDLR17_RBS0_UTR$Currency1017
22PA_Actual_QtyContract SearchPA Actual Qty-ContractPA_DLR15_RBS0_STRCurrency1015
23PARevenueEarned SearchPA Revenue EarnedDLR17_RBS0_UTR$Currency1017
24PAREB SearchPA Revenue Earned-BudgetDLR17_RBS0_UTR$Currency1017
25PAREF SearchPA Revenue Earned-FeeDLR17_RBS0_UTR$Currency1017
26PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
27PABRecognizedProjAmt SearchPA Recognized Project AmountDLR17_RBS0_STR$Currency1017
28PABRecognizedBudgAmount SearchPA Recognized Budget AmountDLR17_RBS0_STR$Currency1017
29PARecognizedFeeAmount SearchPA Recognized Fee AmountDLR17_RBS0_STR$Currency1017
30PABIEEAMOUNT SearchPA BIEE AmountDLR17_RBS0_UTR$Currency1017
31PAEIEBAMOUNT SearchPA EIEB AmountDLR17_RBS0_UTR$Currency1017
32PARRLNEERR SearchPA RR Line ErrorsML_RR_Line_ErrorsLong Integer40
33PA_ActualCost__LossTest SearchPA ActualCost - LossTestDLR17_RBS0_UTR$Currency1017
34PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestDLR17_RBS0_UTR$Currency1017
35PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestDLR17_RBS0_UTR$Currency1017
36PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestDLR17_RBS0_UTR$Currency1017
37PA_Earnings__XcessTest SearchPA Earnings - XcessTestDLR17_RBS0_UTR$Currency1017
38PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
39PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
40PALossAmount SearchPA Loss AmountDLR17_RBS0_UTR$Currency1017
41PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyDLR15_RBU2Currency1015
42PAFTCLaborOnly SearchPA Forecast Total Cost - Labor OnlyDLR17_RBS0_UTR$Currency1017
43PAAQLaborOnly SearchPA Actual Qty - Labor OnlyPA_DLR15_RBS0_STRCurrency1015
44PAACLaborOnly SearchPA Actual Cost - Labor OnlyPA_DLR17_RBS0_STR$Currency1017
45DEX_ROW_ID Searchintint1010

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 WORK File (PA23302)

Leave a Reply

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