PA Project Template Fee Master (PA60040)

azurecurve Products Project Accounting (258)ProjectPA Project Template Fee Master (PA60040)

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

Product: Project Accounting (258)
Series:

Display Name: PA Project Template Fee Master
Physical Name: PA60040
Technical Name: PA_Project_Template_Fee_MSTR

Group Display Name: PA Budgeting Templates
Group Technical Name: PA Budgeting Templates

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PAPTID	PA Project Template ID	String	STR15_Project_Class_ID	15
2	PALineItemSeq	PA Line Item Sequence	Long Integer	LI_Sequence_Number	10
3	PAFeeID	PA Fee ID	String	STR15_LBAU	15
4	PAFeeName	PA Fee Name	String	STR30_PTBS Description 1	30
5	PAFeeType	PA Fee Type	Integer	PA_DDL_Fee_Type	0
6	PAPercent_Cost	PA Percent Cost	Currency	DLR5_%2	8
7	PAPercent_Revenue	PA Percent Revenue	Currency	DLR5_%2	8
8	PA_Retention_Percent	PA Retention Percent	Currency	DLR5_%2	8
9	PAFeeToUse	PA Fee To Use	Integer	GB	0
10	PAbegindate	PA Begin Date	Date	PA_Date	8
11	PAEnDate	PA End Date	Date	DT	8
12	PAFeeAmount	PA Fee Amount	Currency	DLR17_RBSO_STR$	17
13	PAbilltaxscheduleid	PA Billing Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
14	PAbillnoteidx	PA Billing Note Index	Currency	DLR14	14
15	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PA Project Template Fee Master'].NOTEINDX AS 'PA Project Template Fee Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PA60040 AS ['PA Project Template Fee Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PA Project Template Fee Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
16	PAFrequency	PA Frequency	Integer	PA_DDL_Frequency	0
17	PASales_Tax_Options	PA Sales Tax Options	Integer	PA_DDL_Tax_Options_Sales	0
18	STRTDATE	Start Date	Date	DT	8
19	ENDDATE	End Date	Date	DT	8
20	PARenewal_Date	PA Renewal Date	Date	PA_Date	8
21	PAtotcber	PA Label Checkbox - EE	Boolean	CB	0
22	PAtotcbEL	PA Label Checkbox - EL	Boolean	CB	0
23	PAtotcbinv	PA Label Checkbox - INV	Boolean	CB	0
24	PAtotcbML	PA Label Checkbox - ML	Boolean	CB	0
25	PAtotcbts	PA Label Checkbox - TS	Boolean	CB	0
26	PAtotcbvi	PA Label Checkbox - VI	Boolean	CB	0
27	TM_AR_Fee_SRC	TM AR Fee SRC	Integer	DDL_Fee_Account_Source	0
28	TM_Prj_Deferred_Rev_Fee_	TM Prj Deferred Rev Fee SRC	Integer	DDL_Fee_Account_Source	0
29	TM_Prj_Rev_Fee_SRC	TM Prj Rev Fee SRC	Integer	DDL_Fee_Account_Source	0
30	PAFF_AR_Fee_SRC	FF AR Fee SRC	Integer	DDL_Fee_Account_Source	0
31	FF_Prj_Billings_Fee_SRC	FF Prj Billings Fee SRC	Integer	DDL_Fee_Account_Source	0
32	FF_Prj_Rev_Fee_SRC	FF Prj Rev Fee SRC	Integer	DDL_Fee_Account_Source	0
33	FF_Retention_Fee_SRC	FF Retention Fee SRC	Integer	DDL_Fee_Account_Source	0
34	FF_WIP_Fee_SRC	FF WIP Fee SRC	Integer	DDL_Fee_Account_Source	0
35	FF_Prj_Deferred_Rev_Fee_	FF Prj Deferred Rev Fee SRC	Integer	DDL_Fee_Account_Source	0
36	FF_BIEE_Fee_SRC	FF BIEE Fee SRC	Integer	DDL_Fee_Account_Source	0
37	FF_EIEB_Fee_SRC	FF EIEB Fee SRC	Integer	DDL_Fee_Account_Source	0
38	PARenew	PA Renew	Boolean	PA_CB_Renew	0
39	PA_Renew_Day	PA Renew Day	Integer	INT2_U0	2
40	PA_Renew_Month	PA Renew Month	Integer	INT2_U0	2
41	PAUD1	PA User Defined 1	String	STR20	20
42	PAUD2	PA User Defined 2	String	STR20	20
43	PAService_Fee_Amount	PA Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17

azurecurve Products Project Accounting (258)ProjectPA Project Template Fee Master (PA60040)

Click to show/hide

Leave a Reply Cancel reply