PA 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PADocnumber20	PA Document No.	STR17_LBAU	String	17
2	PADOCDT	PA Document Date	PA_Date	Date	8
3	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	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
4	CUTOFDAT	Cutoff Date	DT	Date	8
5	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	15
6	PAProjectType	PA Project Type	PA_DDL_Project_Type	Integer	0
7	PAAcctgMethod	PA Accounting Method	PA_DDL_Accounting_Method	Integer	0
8	PASTAT	PA Status	PA_DDL_Status	Integer	0
9	PAFeeID	PA Fee ID	STR15_LBAU	String	15
10	PAFeeType	PA Fee Type	PA_DDL_Fee_Type	Integer	0
11	PAFeeAmount	PA Fee Amount	DLR17_RBSO_STR$	Currency	17
12	PAPercentCompleted	PA Percent Completed	DLR5_%2	Currency	8
13	PAREF	PA Revenue Earned-Fee	DLR17_RBS0_UTR$	Currency	17
14	PA_Cost_of_Earnings	PA Cost of Earnings	PA_DLR17_RBS0_STR$	Currency	17
15	PARecognizedFeeAmount	PA Recognized Fee Amount	DLR17_RBS0_STR$	Currency	17
16	PACBRecogRev	PA Recognize Revenue CB	PA_CB_Recognize_Revenue	Boolean	0
17	PABIEEAMOUNT	PA BIEE Amount	DLR17_RBS0_UTR$	Currency	17
18	PAEIEBAMOUNT	PA EIEB Amount	DLR17_RBS0_UTR$	Currency	17
19	PAPostedBillingsN	PA Actual Billings	PA_DLR17_RBS0_STR$	Currency	17
20	PA_Trade_Discount_Amount	PA Trade Discount Amount	PA_DLR17_RBS0_STR$	Currency	17
21	PA_Sales_IDX	PA Sales IDX	LI_14	Long Integer	14
22	PAAR_IDX	PA AR IDX	LI_14	Long Integer	14
23	PA_Deferred_RevIDX	PA Deferred Rev IDX	LI_14	Long Integer	14
24	PACGBWIPIDX	PA WIP IDX	LI_14	Long Integer	14
25	PABBillingsIDX	PA Billings IDX	LI_14	Long Integer	14
26	PARev_IDX	PA Revenue IDX	LI_14	Long Integer	14
27	PA_Retention_AR	PA Retention AR IDX	LI_14	Long Integer	14
28	PA_RR_Subline_ErrorsFee	PA RR Subline Errors-Fee	ML_RR_Subline_Errors_Fee	Long Integer	0
29	NOTEINDX	Note Index	DLR14	Currency	14
	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
30	PA_ActualCost__LossTest	PA ActualCost - LossTest	DLR17_RBS0_UTR$	Currency	17
31	PA_ProjAmt__LossTest	PA ProjAmt - LossTest	DLR17_RBS0_UTR$	Currency	17
32	PA_ActualRecogRev__LossT	PA ActualRecogRev - LossTest	DLR17_RBS0_UTR$	Currency	17
33	PA_ActualBlgs__XcessTest	PA ActualBlgs - XcessTest	DLR17_RBS0_UTR$	Currency	17
34	PA_Earnings__XcessTest	PA Earnings - XcessTest	DLR17_RBS0_UTR$	Currency	17
35	PAPostRecogRevN	PA Actual Recognized Revenue	PA_DLR17_RBS0_STR$	Currency	17
36	PALossAmount	PA Loss Amount	DLR17_RBS0_UTR$	Currency	17
37	PABBIEEIDX	PA BIEE IDX	LI_14	Long Integer	14
38	PABEIEBIDX	PA EIEB IDX	LI_14	Long Integer	14
39	PAPrevRecognizedRev	PA Prev Recognized Revenue	PA_DLR17_RBS0_STR$	Currency	17
40	PAPrevBIEEAmount	PA Prev BIEE Amount	PA_DLR17_RBS0_STR$	Currency	17
41	PAPrevEIEBAmount	PA Prev EIEB Amount	PA_DLR17_RBS0_STR$	Currency	17
42	PAPrevEarnings	PA Prev Earnings	PA_DLR17_RBS0_STR$	Currency	17
43	PAPrevBillings	PA Prev Billings	PA_DLR17_RBS0_STR$	Currency	17
44	DEX_ROW_ID		int	int	10
	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.

azurecurve Products Project Accounting (258)ProjectPA Rev Recognition Fee DTL HIST File (PA33303)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply