PA Project Fee Master File (PA02101)

azurecurveProductsProject Accounting (258)ProjectPA Project Fee Master File (PA02101)

Easily find this page again using the shortlink:

Product: Project Accounting (258)
Series: Project

Display Name: PA Project Fee Master File
Physical Name: PA02101
Technical Name: PA_Project_Fee_MSTR

Group Display Name: PA Budgeting Cards
Group Technical Name: PA Budgeting Cards

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
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
6PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency17
7PAPercent_Cost SearchPA Percent CostDLR5_%2Currency8
8PAPercent_Revenue SearchPA Percent RevenueDLR5_%2Currency8
9PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency8
10PAFeeToUse SearchPA Fee To UseGBInteger0
11PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
12PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
13PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
14PAbegindate SearchPA Begin DatePA_DateDate8
15PAEnDate SearchPA End DateDTDate8
16PAFrequency SearchPA FrequencyPA_DDL_FrequencyInteger0
17STRTDATE SearchStart DateDTDate8
18ENDDATE SearchEnd DateDTDate8
19PARenew SearchPA RenewPA_CB_RenewBoolean0
20PARenewal_Date SearchPA Renewal DatePA_DateDate8
21PATotAmt SearchPA Total AmountDLR17_RBS0_STR$Currency17
22TM_AR_Fee_SRC SearchTM AR Fee SRCDDL_Fee_Account_SourceInteger0
23TM_Prj_Deferred_Rev_Fee_ SearchTM Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger0
24TM_Prj_Rev_Fee_SRC SearchTM Prj Rev Fee SRCDDL_Fee_Account_SourceInteger0
25PAFF_AR_Fee_SRC SearchFF AR Fee SRCDDL_Fee_Account_SourceInteger0
26FF_Prj_Billings_Fee_SRC SearchFF Prj Billings Fee SRCDDL_Fee_Account_SourceInteger0
27FF_Prj_Rev_Fee_SRC SearchFF Prj Rev Fee SRCDDL_Fee_Account_SourceInteger0
28FF_Retention_Fee_SRC SearchFF Retention Fee SRCDDL_Fee_Account_SourceInteger0
29FF_WIP_Fee_SRC SearchFF WIP Fee SRCDDL_Fee_Account_SourceInteger0
30FF_Prj_Deferred_Rev_Fee_ SearchFF Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger0
31FF_BIEE_Fee_SRC SearchFF BIEE Fee SRCDDL_Fee_Account_SourceInteger0
32FF_EIEB_Fee_SRC SearchFF EIEB Fee SRCDDL_Fee_Account_SourceInteger0
33PAtotcbts SearchPA Label Checkbox - TSCBBoolean0
34PAtotcbEL SearchPA Label Checkbox - ELCBBoolean0
35PAtotcbML SearchPA Label Checkbox - MLCBBoolean0
36PAtotcbvi SearchPA Label Checkbox - VICBBoolean0
37PAtotcber SearchPA Label Checkbox - EECBBoolean0
38PAtotcbinv SearchPA Label Checkbox - INVCBBoolean0
39PA_Renew_Day SearchPA Renew DayINT2_U0Integer2
40PA_Renew_Month SearchPA Renew MonthINT2_U0Integer2
41PAUD1 SearchPA User Defined 1STR20String20
42PAUD2 SearchPA User Defined 2STR20String20
43PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
44PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency17
45PA_MC_Fee_Amount SearchPA MC Fee AmountPA_DLR17_RBS0_UTR$Currency17
46PA_MC_Service_Fee_Amount SearchPA MC Service Fee AmountPA_DLR17_RBS0_UTR$Currency17
47PA_MC_Total_Amount SearchPA MC Total AmountPA_DLR17_RBS0_UTR$Currency17
48DEX_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 Fee Master File (PA02101)

Leave a Reply

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