PA Project Template File (PA41601)

azurecurve Products Project Accounting (258)ProjectPA Project Template File (PA41601)

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

Product: Project Accounting (258)
Series:

Display Name: PA Project Template File
Physical Name: PA41601
Technical Name: PA_Project_Template_SETP

Group Display Name: PA Budgeting Templates
Group Technical Name: PA Budgeting Templates

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PACTID	PA Contract Template ID	String	STR15_Contract_Class_ID	15
2	PAPTID	PA Project Template ID	String	STR15_Project_Class_ID	15
3	PAPTN	PA Project Template Name	String	STR30_PTBS Description 1	30
4	PAPROJNUMSEG	PA Project Number Segment	String	STR5_Doc_ID	5
5	PAprjclsid	PA Project Class ID	String	STR15_Project_Class_ID	15
6	PAProjectType	PA Project Type	Integer	PA_DDL_Project_Type	0
7	PAAcctgMethod	PA Accounting Method	Integer	PA_DDL_Accounting_Method	0
8	PASTAT	PA Status	Integer	PA_DDL_Status	0
9	PADepartment	PA Department	String	STR6_Payroll_Code	6
10	PABBeginDate	PA Baseline Begin Date	Date	DATE	6
11	PABEndDate	PA Baseline End Date	Date	DATE	6
12	PABQuantity	PA Baseline Quantity	Currency	DLR15_RBU2	15
13	PABTotalCost	PA Baseline Total Cost	Currency	DLR17_RBS0_UTR$	17
14	PABProfit	PA Baseline Profit	Currency	DLR17_RBS0_STR$	17
15	PABBillings	PA Baseline Billings	Currency	DLR17_RBS0_UTR$	17
16	PABTaxPaidAmt	PA Baseline Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
17	PABTaxChargedAmt	PA Baseline Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
18	PABaselineOvhdCost	PA Baseline Overhead Cost	Currency	DLR17_RBS0_UTR$	17
19	PAFBeginDate	PA Forecast Begin Date	Date	DATE	6
20	PAFEndDate	PA Forecast End Date	Date	DATE	6
21	PAFQuantity	PA Forecast Quantity	Currency	DLR15_RBU2	15
22	PAFTotalCost	PA Forecast Total Cost	Currency	DLR17_RBS0_UTR$	17
23	PAFProfit	PA Forecast Profit	Currency	DLR17_RBS0_STR$	17
24	PAFBillings	PA Forecast Billings	Currency	DLR17_RBS0_UTR$	17
25	PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
26	PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
27	PAForecastOvhdCost	PA Forecast Overhead Cost	Currency	DLR17_RBS0_UTR$	17
28	PAEstimatorID	PA Estimator ID	String	STR15_Employee_ID	15
29	PAprojmngrid	PA Project Manager ID	String	STR15_Employee_ID	15
30	PABusMgrID	PA Business Manager ID	String	STR15_Employee_ID	15
31	LOCATNID	Location ID	String	STR15_Location_ID	15
32	COMPRCNT	Commission Percent	Integer	INT5_%2	5
33	COMAPPTO	Commission Applied To	Integer	GB	0
34	PALabor_Rate_Table_ID	PA Labor Rate Table ID	String	STR30_Rate_Table_ID	30
35	PALabor_RateTable_Type	PA Labor Rate Table Type	Integer	PA_DDL_Rate_Table_Type	0
36	PALabor_Rate_Table_Acc	PA Labor Rate Table Accept	Boolean	CB_Rate_Table_Accept	0
37	PAEquip_Rate_Table_ID	PA Equip Rate Table ID	String	STR30_Rate_Table_ID	30
38	PAEquip_Rate_Table_Acc	PA Equip Rate Table Accept	Boolean	CB_Rate_Table_Accept	0
39	PAbllngtype	PA Billing Type	Integer	PA_DDL_Billing_Type	0
40	PAProject_Amount	PA Project Amount	Currency	DLR17_RBS0_UTR$	17
41	PAProject_Fee_Amount	PA Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
42	PAService_Fee_Amount	PA Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
43	PARetainer_Fee_Amount	PA Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
44	PARetentionFeeAmount	PA Retention Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
45	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19
46	PABILLFORMAT	PA Bill Format	String	STR15_LBAU	15
47	PADiscMetToUse	PA Discount Method To Use	Integer	GB	0
48	DISCAMNT	Discount Amount	Currency	DLR17_RBS0_STR$	17
49	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
50	PA_Retention_Percent	PA Retention Percent	Currency	DLR5_%2	8
51	PAtotcbts	PA Label Checkbox - TS	Boolean	CB	0
52	PAtotcbEL	PA Label Checkbox - EL	Boolean	CB	0
53	PAtotcbML	PA Label Checkbox - ML	Boolean	CB	0
54	PAtotcbvi	PA Label Checkbox - VI	Boolean	CB	0
55	PAtotcber	PA Label Checkbox - EE	Boolean	CB	0
56	PAtotcbinv	PA Label Checkbox - INV	Boolean	CB	0
57	PAtotcbfee	PA Label Checkbox - FEE	Boolean	CB	0
58	PAUD1Proj	PA User Defined 1 - Project	String	STR50	50
59	PAUD2_Proj	PA User Defined 2 - Project	String	STR50	50
60	PASegmentCB	PA Segment CB	Boolean	PA_CB_Segment	0
61	PAbillnoteidx	PA Billing Note Index	Currency	DLR14	14
62	PAbillnoteidxts	PA Billing Note Index - TS	Currency	DLR14	14
63	PAELbillniteidx	PA Billing Note Index - EL	Currency	DLR14	14
64	PAbillnoteidxML	PA Billing Note Index - ML	Currency	DLR14	14
65	PAbillnoteidxvi	PA Billing Note Index - VI	Currency	DLR14	14
66	PAbillnoteidxee	PA Billing Note Index - EE	Currency	DLR14	14
67	PAbillnoteidxinv	PA Billing Note Index - INV	Currency	DLR14	14
68	PAbillnoteidxfee	PA Billing Note Index - FEE	Currency	DLR14	14
69	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PA Project Template File'].NOTEINDX AS 'PA Project Template File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PA41601 AS ['PA Project Template File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PA Project Template File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
70	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
71	SUTASTAT	Suta State	String	STR2_State_Code	2

azurecurve Products Project Accounting (258)ProjectPA Project Template File (PA41601)

Click to show/hide

Leave a Reply Cancel reply