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:

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 TypeLength
1PAPTID SearchPA Project Template IDStringSTR15_Project_Class_ID15
2PALineItemSeq SearchPA Line Item SequenceLong IntegerLI_Sequence_Number10
3PAFeeID SearchPA Fee IDStringSTR15_LBAU15
4PAFeeName SearchPA Fee NameStringSTR30_PTBS Description 130
5PAFeeType SearchPA Fee TypeIntegerPA_DDL_Fee_Type0
6PAPercent_Cost SearchPA Percent CostCurrencyDLR5_%28
7PAPercent_Revenue SearchPA Percent RevenueCurrencyDLR5_%28
8PA_Retention_Percent SearchPA Retention PercentCurrencyDLR5_%28
9PAFeeToUse SearchPA Fee To UseIntegerGB0
10PAbegindate SearchPA Begin DateDatePA_Date8
11PAEnDate SearchPA End DateDateDT8
12PAFeeAmount SearchPA Fee AmountCurrencyDLR17_RBSO_STR$17
13PAbilltaxscheduleid SearchPA Billing Tax Schedule IDStringSTR15_Tax_Schedule_ID15
14PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
15NOTEINDX SearchNote IndexCurrencyDLR1414
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 FrequencyIntegerPA_DDL_Frequency0
17PASales_Tax_Options SearchPA Sales Tax OptionsIntegerPA_DDL_Tax_Options_Sales0
18STRTDATE SearchStart DateDateDT8
19ENDDATE SearchEnd DateDateDT8
20PARenewal_Date SearchPA Renewal DateDatePA_Date8
21PAtotcber SearchPA Label Checkbox - EEBooleanCB0
22PAtotcbEL SearchPA Label Checkbox - ELBooleanCB0
23PAtotcbinv SearchPA Label Checkbox - INVBooleanCB0
24PAtotcbML SearchPA Label Checkbox - MLBooleanCB0
25PAtotcbts SearchPA Label Checkbox - TSBooleanCB0
26PAtotcbvi SearchPA Label Checkbox - VIBooleanCB0
27TM_AR_Fee_SRC SearchTM AR Fee SRCIntegerDDL_Fee_Account_Source0
28TM_Prj_Deferred_Rev_Fee_ SearchTM Prj Deferred Rev Fee SRCIntegerDDL_Fee_Account_Source0
29TM_Prj_Rev_Fee_SRC SearchTM Prj Rev Fee SRCIntegerDDL_Fee_Account_Source0
30PAFF_AR_Fee_SRC SearchFF AR Fee SRCIntegerDDL_Fee_Account_Source0
31FF_Prj_Billings_Fee_SRC SearchFF Prj Billings Fee SRCIntegerDDL_Fee_Account_Source0
32FF_Prj_Rev_Fee_SRC SearchFF Prj Rev Fee SRCIntegerDDL_Fee_Account_Source0
33FF_Retention_Fee_SRC SearchFF Retention Fee SRCIntegerDDL_Fee_Account_Source0
34FF_WIP_Fee_SRC SearchFF WIP Fee SRCIntegerDDL_Fee_Account_Source0
35FF_Prj_Deferred_Rev_Fee_ SearchFF Prj Deferred Rev Fee SRCIntegerDDL_Fee_Account_Source0
36FF_BIEE_Fee_SRC SearchFF BIEE Fee SRCIntegerDDL_Fee_Account_Source0
37FF_EIEB_Fee_SRC SearchFF EIEB Fee SRCIntegerDDL_Fee_Account_Source0
38PARenew SearchPA RenewBooleanPA_CB_Renew0
39PA_Renew_Day SearchPA Renew DayIntegerINT2_U02
40PA_Renew_Month SearchPA Renew MonthIntegerINT2_U02
41PAUD1 SearchPA User Defined 1StringSTR2020
42PAUD2 SearchPA User Defined 2StringSTR2020
43PAService_Fee_Amount SearchPA Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
azurecurveProductsProject Accounting (258)ProjectPA Project Template Fee Master (PA60040)

Leave a Reply

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