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 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 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 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
28PABBIEEIDX SearchPA BIEE IDXLI_14Long Integer414
29PABEIEBIDX SearchPA EIEB IDXLI_14Long Integer414
30PA_RR_Subline_ErrorsFee SearchPA RR Subline Errors-FeeML_RR_Subline_Errors_FeeLong Integer40
31NOTEINDX SearchNote IndexDLR14Currency1014
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$Currency1017
33PA_ProjAmt__LossTest SearchPA ProjAmt - LossTestDLR17_RBS0_UTR$Currency1017
34PA_ActualRecogRev__LossT SearchPA ActualRecogRev - LossTestDLR17_RBS0_UTR$Currency1017
35PA_ActualBlgs__XcessTest SearchPA ActualBlgs - XcessTestDLR17_RBS0_UTR$Currency1017
36PA_Earnings__XcessTest SearchPA Earnings - XcessTestDLR17_RBS0_UTR$Currency1017
37PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
38PALossAmount SearchPA Loss AmountDLR17_RBS0_UTR$Currency1017
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 Work File (PA23303)

Leave a Reply

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