PA Rev Recognition Fee DTL Work File (PA23303)

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Fee DTL Work File (PA23303)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Rev Recognition Fee DTL Work File
Physical Name: PA23303
Technical Name: PA_Rev_Recog_Fee_DTL_WORK

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

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 Work File'].CUSTNMBR AS 'PA Rev Recognition Fee DTL Work File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA23303 AS ['PA Rev Recognition Fee DTL Work File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Rev Recognition Fee DTL Work 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
28PABBIEEIDX SearchPA BIEE IDXLI_14Long Integer14
29PABEIEBIDX SearchPA EIEB IDXLI_14Long Integer14
30PA_RR_Subline_ErrorsFee SearchPA RR Subline Errors-FeeML_RR_Subline_Errors_FeeLong Integer0
31NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Rev Recognition Fee DTL Work File'].NOTEINDX AS 'PA Rev Recognition Fee DTL Work File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA23303 AS ['PA Rev Recognition Fee DTL Work File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Rev Recognition Fee DTL Work File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
32PA_ActualCost__LossTest SearchPA ActualCost - LossTestDLR17_RBS0_UTR$Currency17
33PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestDLR17_RBS0_UTR$Currency17
34PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestDLR17_RBS0_UTR$Currency17
35PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestDLR17_RBS0_UTR$Currency17
36PA_Earnings__XcessTest SearchPA Earnings - XcessTestDLR17_RBS0_UTR$Currency17
37PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
38PALossAmount SearchPA Loss AmountDLR17_RBS0_UTR$Currency17
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 Work File (PA23303)

Leave a Reply

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