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 TypeLength
1PADocnumber20 SearchPA Document No.STR17_LBAUString17
2PADOCDT SearchPA Document DatePA_DateDate8
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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 DateDTDate8
5PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
6PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
7PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger0
8PASTAT SearchPA StatusPA_DDL_StatusInteger0
9PAFeeID SearchPA Fee IDSTR15_LBAUString15
10PAFeeType SearchPA Fee TypePA_DDL_Fee_TypeInteger0
11PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency17
12PAPercentCompleted SearchPA Percent CompletedDLR5_%2Currency8
13PAREF SearchPA Revenue Earned-FeeDLR17_RBS0_UTR$Currency17
14PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency17
15PARecognizedFeeAmount SearchPA Recognized Fee AmountDLR17_RBS0_STR$Currency17
16PACBRecogRev SearchPA Recognize Revenue CBPA_CB_Recognize_RevenueBoolean0
17PABIEEAMOUNT SearchPA BIEE AmountDLR17_RBS0_UTR$Currency17
18PAEIEBAMOUNT SearchPA EIEB AmountDLR17_RBS0_UTR$Currency17
19PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
20PA_Trade_Discount_Amount SearchPA Trade Discount AmountPA_DLR17_RBS0_STR$Currency17
21PA_Sales_IDX SearchPA Sales IDXLI_14Long Integer14
22PAAR_IDX SearchPA AR IDXLI_14Long Integer14
23PA_Deferred_RevIDX SearchPA Deferred Rev IDXLI_14Long Integer14
24PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer14
25PABBillingsIDX SearchPA Billings IDXLI_14Long Integer14
26PARev_IDX SearchPA Revenue IDXLI_14Long Integer14
27PA_Retention_AR SearchPA Retention AR IDXLI_14Long Integer14
28PA_RR_Subline_ErrorsFee SearchPA RR Subline Errors-FeeML_RR_Subline_Errors_FeeLong Integer0
29NOTEINDX SearchNote IndexDLR14Currency14
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$Currency17
31PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestDLR17_RBS0_UTR$Currency17
32PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestDLR17_RBS0_UTR$Currency17
33PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestDLR17_RBS0_UTR$Currency17
34PA_Earnings__XcessTest SearchPA Earnings - XcessTestDLR17_RBS0_UTR$Currency17
35PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
36PALossAmount SearchPA Loss AmountDLR17_RBS0_UTR$Currency17
37PABBIEEIDX SearchPA BIEE IDXLI_14Long Integer14
38PABEIEBIDX SearchPA EIEB IDXLI_14Long Integer14
39PAPrevRecognizedRev SearchPA Prev Recognized RevenuePA_DLR17_RBS0_STR$Currency17
40PAPrevBIEEAmount SearchPA Prev BIEE AmountPA_DLR17_RBS0_STR$Currency17
41PAPrevEIEBAmount SearchPA Prev EIEB AmountPA_DLR17_RBS0_STR$Currency17
42PAPrevEarnings SearchPA Prev EarningsPA_DLR17_RBS0_STR$Currency17
43PAPrevBillings SearchPA Prev BillingsPA_DLR17_RBS0_STR$Currency17
44DEX_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 Fee DTL HIST File (PA33303)

Leave a Reply

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