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: Project

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

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

Click to show/hide

Leave a Reply Cancel reply