PA Rev Recognition Fee DTL HIST File (PA33303)

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Fee DTL HIST File (PA33303)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Rev Recognition Fee DTL HIST File
Physical Name: PA33303
Technical Name: PA_Rev_Recog_Fee_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 TypeSQL DB LengthKeyable Length
1PADocnumber20 SearchPA Document No.STR17_LBAUString1817
2PADOCDT SearchPA Document DatePA_DateDate48
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Rev Recognition Fee DTL HIST File'].CUSTNMBR AS 'PA Rev Recognition Fee DTL HIST File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA33303 AS ['PA Rev Recognition Fee DTL HIST File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Rev Recognition Fee DTL HIST File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4CUTOFDAT SearchCutoff DateDTDate48
5PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
6PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
7PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger20
8PASTAT SearchPA StatusPA_DDL_StatusInteger20
9PAFeeID SearchPA Fee IDSTR15_LBAUString1615
10PAFeeType SearchPA Fee TypePA_DDL_Fee_TypeInteger20
11PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency1017
12PAPercentCompleted SearchPA Percent CompletedDLR5_%2Currency108
13PAREF SearchPA Revenue Earned-FeeDLR17_RBS0_UTR$Currency1017
14PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
15PARecognizedFeeAmount SearchPA Recognized Fee AmountDLR17_RBS0_STR$Currency1017
16PACBRecogRev SearchPA Recognize Revenue CBPA_CB_Recognize_RevenueBoolean20
17PABIEEAMOUNT SearchPA BIEE AmountDLR17_RBS0_UTR$Currency1017
18PAEIEBAMOUNT SearchPA EIEB AmountDLR17_RBS0_UTR$Currency1017
19PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
20PA_Trade_Discount_Amount SearchPA Trade Discount AmountPA_DLR17_RBS0_STR$Currency1017
21PA_Sales_IDX SearchPA Sales IDXLI_14Long Integer414
22PAAR_IDX SearchPA AR IDXLI_14Long Integer414
23PA_Deferred_RevIDX SearchPA Deferred Rev IDXLI_14Long Integer414
24PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer414
25PABBillingsIDX SearchPA Billings IDXLI_14Long Integer414
26PARev_IDX SearchPA Revenue IDXLI_14Long Integer414
27PA_Retention_AR SearchPA Retention AR IDXLI_14Long Integer414
28PA_RR_Subline_ErrorsFee SearchPA RR Subline Errors-FeeML_RR_Subline_Errors_FeeLong Integer40
29NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Rev Recognition Fee DTL HIST File'].NOTEINDX AS 'PA Rev Recognition Fee DTL HIST File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA33303 AS ['PA Rev Recognition Fee DTL HIST File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Rev Recognition Fee DTL HIST File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
30PA_ActualCost__LossTest SearchPA ActualCost - LossTestDLR17_RBS0_UTR$Currency1017
31PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestDLR17_RBS0_UTR$Currency1017
32PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestDLR17_RBS0_UTR$Currency1017
33PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestDLR17_RBS0_UTR$Currency1017
34PA_Earnings__XcessTest SearchPA Earnings - XcessTestDLR17_RBS0_UTR$Currency1017
35PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
36PALossAmount SearchPA Loss AmountDLR17_RBS0_UTR$Currency1017
37PABBIEEIDX SearchPA BIEE IDXLI_14Long Integer414
38PABEIEBIDX SearchPA EIEB IDXLI_14Long Integer414
39PAPrevRecognizedRev SearchPA Prev Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
40PAPrevBIEEAmount SearchPA Prev BIEE AmountPA_DLR17_RBS0_STR$Currency1017
41PAPrevEIEBAmount SearchPA Prev EIEB AmountPA_DLR17_RBS0_STR$Currency1017
42PAPrevEarnings SearchPA Prev EarningsPA_DLR17_RBS0_STR$Currency1017
43PAPrevBillings SearchPA Prev BillingsPA_DLR17_RBS0_STR$Currency1017
44DEX_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 Fee DTL HIST File (PA33303)

Leave a Reply

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