PA Project Template Fee Master (PA60040)

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

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

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 TypeSQL DB LengthKeyable Length
1PAPTID SearchPA Project Template IDSTR15_Project_Class_IDString1615
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
6PAPercent_Cost SearchPA Percent CostDLR5_%2Currency108
7PAPercent_Revenue SearchPA Percent RevenueDLR5_%2Currency108
8PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency108
9PAFeeToUse SearchPA Fee To UseGBInteger20
10PAbegindate SearchPA Begin DatePA_DateDate48
11PAEnDate SearchPA End DateDTDate48
12PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency1017
13PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
14PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
15NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Project Template Fee Master'].NOTEINDX AS 'PA Project Template Fee Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA60040 AS ['PA Project Template Fee Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Project Template Fee Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
16PAFrequency SearchPA FrequencyPA_DDL_FrequencyInteger20
17PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
18STRTDATE SearchStart DateDTDate48
19ENDDATE SearchEnd DateDTDate48
20PARenewal_Date SearchPA Renewal DatePA_DateDate48
21PAtotcber SearchPA Label Checkbox - EECBBoolean20
22PAtotcbEL SearchPA Label Checkbox - ELCBBoolean20
23PAtotcbinv SearchPA Label Checkbox - INVCBBoolean20
24PAtotcbML SearchPA Label Checkbox - MLCBBoolean20
25PAtotcbts SearchPA Label Checkbox - TSCBBoolean20
26PAtotcbvi SearchPA Label Checkbox - VICBBoolean20
27TM_AR_Fee_SRC SearchTM AR Fee SRCDDL_Fee_Account_SourceInteger20
28TM_Prj_Deferred_Rev_Fee_ SearchTM Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger20
29TM_Prj_Rev_Fee_SRC SearchTM Prj Rev Fee SRCDDL_Fee_Account_SourceInteger20
30PAFF_AR_Fee_SRC SearchFF AR Fee SRCDDL_Fee_Account_SourceInteger20
31FF_Prj_Billings_Fee_SRC SearchFF Prj Billings Fee SRCDDL_Fee_Account_SourceInteger20
32FF_Prj_Rev_Fee_SRC SearchFF Prj Rev Fee SRCDDL_Fee_Account_SourceInteger20
33FF_Retention_Fee_SRC SearchFF Retention Fee SRCDDL_Fee_Account_SourceInteger20
34FF_WIP_Fee_SRC SearchFF WIP Fee SRCDDL_Fee_Account_SourceInteger20
35FF_Prj_Deferred_Rev_Fee_ SearchFF Prj Deferred Rev Fee SRCDDL_Fee_Account_SourceInteger20
36FF_BIEE_Fee_SRC SearchFF BIEE Fee SRCDDL_Fee_Account_SourceInteger20
37FF_EIEB_Fee_SRC SearchFF EIEB Fee SRCDDL_Fee_Account_SourceInteger20
38PARenew SearchPA RenewPA_CB_RenewBoolean20
39PA_Renew_Day SearchPA Renew DayINT2_U0Integer22
40PA_Renew_Month SearchPA Renew MonthINT2_U0Integer22
41PAUD1 SearchPA User Defined 1STR20String2220
42PAUD2 SearchPA User Defined 2STR20String2220
43PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
44DEX_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 Template Fee Master (PA60040)

Leave a Reply

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