PA Project Fee Master File (PA02101)

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

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

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 TypeSQL DB LengthKeyable Length
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
2PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
3PAFeeID SearchPA Fee IDSTR15_LBAUString1615
4PAFeeName SearchPA Fee NameSTR30_PTBS Description 1String3230
5PAFeeType SearchPA Fee TypePA_DDL_Fee_TypeInteger20
6PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency1017
7PAPercent_Cost SearchPA Percent CostDLR5_%2Currency108
8PAPercent_Revenue SearchPA Percent RevenueDLR5_%2Currency108
9PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency108
10PAFeeToUse SearchPA Fee To UseGBInteger20
11PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
12PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
13PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
14PAbegindate SearchPA Begin DatePA_DateDate48
15PAEnDate SearchPA End DateDTDate48
16PAFrequency SearchPA FrequencyPA_DDL_FrequencyInteger20
17STRTDATE SearchStart DateDTDate48
18ENDDATE SearchEnd DateDTDate48
19PARenew SearchPA RenewPA_CB_RenewBoolean20
20PARenewal_Date SearchPA Renewal DatePA_DateDate48
21PATotAmt SearchPA Total AmountDLR17_RBS0_STR$Currency1017
22TM_AR_Fee_SRC SearchTM AR Fee SRCDDL_Fee_Account_SourceInteger20
23TM_Prj_Deferred_Rev_Fee_ SearchTM Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger20
24TM_Prj_Rev_Fee_SRC SearchTM Prj Rev Fee SRCDDL_Fee_Account_SourceInteger20
25PAFF_AR_Fee_SRC SearchFF AR Fee SRCDDL_Fee_Account_SourceInteger20
26FF_Prj_Billings_Fee_SRC SearchFF Prj Billings Fee SRCDDL_Fee_Account_SourceInteger20
27FF_Prj_Rev_Fee_SRC SearchFF Prj Rev Fee SRCDDL_Fee_Account_SourceInteger20
28FF_Retention_Fee_SRC SearchFF Retention Fee SRCDDL_Fee_Account_SourceInteger20
29FF_WIP_Fee_SRC SearchFF WIP Fee SRCDDL_Fee_Account_SourceInteger20
30FF_Prj_Deferred_Rev_Fee_ SearchFF Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger20
31FF_BIEE_Fee_SRC SearchFF BIEE Fee SRCDDL_Fee_Account_SourceInteger20
32FF_EIEB_Fee_SRC SearchFF EIEB Fee SRCDDL_Fee_Account_SourceInteger20
33PAtotcbts SearchPA Label Checkbox - TSCBBoolean20
34PAtotcbEL SearchPA Label Checkbox - ELCBBoolean20
35PAtotcbML SearchPA Label Checkbox - MLCBBoolean20
36PAtotcbvi SearchPA Label Checkbox - VICBBoolean20
37PAtotcber SearchPA Label Checkbox - EECBBoolean20
38PAtotcbinv SearchPA Label Checkbox - INVCBBoolean20
39PA_Renew_Day SearchPA Renew DayINT2_U0Integer22
40PA_Renew_Month SearchPA Renew MonthINT2_U0Integer22
41PAUD1 SearchPA User Defined 1STR20String2220
42PAUD2 SearchPA User Defined 2STR20String2220
43PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
44PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
45PA_MC_Fee_Amount SearchPA MC Fee AmountPA_DLR17_RBS0_UTR$Currency1017
46PA_MC_Service_Fee_Amount SearchPA MC Service Fee AmountPA_DLR17_RBS0_UTR$Currency1017
47PA_MC_Total_Amount SearchPA MC Total AmountPA_DLR17_RBS0_UTR$Currency1017
48DEX_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 Project Fee Master File (PA02101)

Leave a Reply

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