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 TypeLength
1PAFeeID SearchPA Fee IDSTR15_LBAUString15
2PAFeeName SearchPA Fee NameSTR30_PTBS Description 1String30
3PAFeeType SearchPA Fee TypePA_DDL_Fee_TypeInteger0
4PAFrequency SearchPA FrequencyPA_DDL_FrequencyInteger0
5PAPercent_Cost SearchPA Percent CostDLR5_%2Currency8
6PAPercent_Revenue SearchPA Percent RevenueDLR5_%2Currency8
7PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency8
8PAFeeToUse SearchPA Fee To UseGBInteger0
9PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency17
10PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
11PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
12PAtotcbts SearchPA Label Checkbox - TSCBBoolean0
13PAtotcbEL SearchPA Label Checkbox - ELCBBoolean0
14PAtotcbML SearchPA Label Checkbox - MLCBBoolean0
15PAtotcbvi SearchPA Label Checkbox - VICBBoolean0
16PAtotcber SearchPA Label Checkbox - EECBBoolean0
17PAtotcbinv SearchPA Label Checkbox - INVCBBoolean0
18STRTDATE SearchStart DateDTDate8
19ENDDATE SearchEnd DateDTDate8
20PARenew SearchPA RenewPA_CB_RenewBoolean0
21PARenewal_Date SearchPA Renewal DatePA_DateDate8
22PANOTEINDEX SearchPA Note IndexDLR14Currency14
23PA_Renew_Day SearchPA Renew DayINT2_U0Integer2
24PA_Renew_Month SearchPA Renew MonthINT2_U0Integer2
25PAUD1 SearchPA User Defined 1STR20String20
26PAUD2 SearchPA User Defined 2STR20String20
27DEX_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.

Leave a Reply

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