PA Fee Master File (PA00401)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Fee Master File
Physical Name: PA00401
Technical Name: PA_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
1PAFeeID SearchPA Fee IDSTR15_LBAUString1615
2PAFeeName SearchPA Fee NameSTR30_PTBS Description 1String3230
3PAFeeType SearchPA Fee TypePA_DDL_Fee_TypeInteger20
4PAFrequency SearchPA FrequencyPA_DDL_FrequencyInteger20
5PAPercent_Cost SearchPA Percent CostDLR5_%2Currency108
6PAPercent_Revenue SearchPA Percent RevenueDLR5_%2Currency108
7PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency108
8PAFeeToUse SearchPA Fee To UseGBInteger20
9PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency1017
10PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
11PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
12PAtotcbts SearchPA Label Checkbox - TSCBBoolean20
13PAtotcbEL SearchPA Label Checkbox - ELCBBoolean20
14PAtotcbML SearchPA Label Checkbox - MLCBBoolean20
15PAtotcbvi SearchPA Label Checkbox - VICBBoolean20
16PAtotcber SearchPA Label Checkbox - EECBBoolean20
17PAtotcbinv SearchPA Label Checkbox - INVCBBoolean20
18STRTDATE SearchStart DateDTDate48
19ENDDATE SearchEnd DateDTDate48
20PARenew SearchPA RenewPA_CB_RenewBoolean20
21PARenewal_Date SearchPA Renewal DatePA_DateDate48
22PANOTEINDEX SearchPA Note IndexDLR14Currency1014
23PA_Renew_Day SearchPA Renew DayINT2_U0Integer22
24PA_Renew_Month SearchPA Renew MonthINT2_U0Integer22
25PAUD1 SearchPA User Defined 1STR20String2220
26PAUD2 SearchPA User Defined 2STR20String2220
27DEX_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.

Leave a Reply

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