PA Project Template Fee Master (PA60040)

azurecurveProductsProject Accounting (258)ProjectPA Project Template Fee Master (PA60040)

Easily find this page again using the shortlink:

Product: Project Accounting (258)
Series: Project

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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAPTID SearchPA Project Template IDSTR15_Project_Class_IDString15
2PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
3PAFeeID SearchPA Fee IDSTR15_LBAUString15
4PAFeeName SearchPA Fee NameSTR30_PTBS Description 1String30
5PAFeeType SearchPA Fee TypePA_DDL_Fee_TypeInteger0
6PAPercent_Cost SearchPA Percent CostDLR5_%2Currency8
7PAPercent_Revenue SearchPA Percent RevenueDLR5_%2Currency8
8PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency8
9PAFeeToUse SearchPA Fee To UseGBInteger0
10PAbegindate SearchPA Begin DatePA_DateDate8
11PAEnDate SearchPA End DateDTDate8
12PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency17
13PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
14PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
15NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

       ['PA Project Template Fee Master'].NOTEINDX AS 'PA Project Template Fee Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
       PA60040 AS ['PA Project Template Fee Master']
       SY03900 AS ['Record Notes Master']
                     ['PA Project Template Fee Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
16PAFrequency SearchPA FrequencyPA_DDL_FrequencyInteger0
17PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
18STRTDATE SearchStart DateDTDate8
19ENDDATE SearchEnd DateDTDate8
20PARenewal_Date SearchPA Renewal DatePA_DateDate8
21PAtotcber SearchPA Label Checkbox - EECBBoolean0
22PAtotcbEL SearchPA Label Checkbox - ELCBBoolean0
23PAtotcbinv SearchPA Label Checkbox - INVCBBoolean0
24PAtotcbML SearchPA Label Checkbox - MLCBBoolean0
25PAtotcbts SearchPA Label Checkbox - TSCBBoolean0
26PAtotcbvi SearchPA Label Checkbox - VICBBoolean0
27TM_AR_Fee_SRC SearchTM AR Fee SRCDDL_Fee_Account_SourceInteger0
28TM_Prj_Deferred_Rev_Fee_ SearchTM Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger0
29TM_Prj_Rev_Fee_SRC SearchTM Prj Rev Fee SRCDDL_Fee_Account_SourceInteger0
30PAFF_AR_Fee_SRC SearchFF AR Fee SRCDDL_Fee_Account_SourceInteger0
31FF_Prj_Billings_Fee_SRC SearchFF Prj Billings Fee SRCDDL_Fee_Account_SourceInteger0
32FF_Prj_Rev_Fee_SRC SearchFF Prj Rev Fee SRCDDL_Fee_Account_SourceInteger0
33FF_Retention_Fee_SRC SearchFF Retention Fee SRCDDL_Fee_Account_SourceInteger0
34FF_WIP_Fee_SRC SearchFF WIP Fee SRCDDL_Fee_Account_SourceInteger0
35FF_Prj_Deferred_Rev_Fee_ SearchFF Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger0
36FF_BIEE_Fee_SRC SearchFF BIEE Fee SRCDDL_Fee_Account_SourceInteger0
37FF_EIEB_Fee_SRC SearchFF EIEB Fee SRCDDL_Fee_Account_SourceInteger0
38PARenew SearchPA RenewPA_CB_RenewBoolean0
39PA_Renew_Day SearchPA Renew DayINT2_U0Integer2
40PA_Renew_Month SearchPA Renew MonthINT2_U0Integer2
41PAUD1 SearchPA User Defined 1STR20String20
42PAUD2 SearchPA User Defined 2STR20String20
43PAService_Fee_Amount SearchPA Service Fee AmountPA_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 Project Template Fee Master (PA60040)

Leave a Reply

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