PA Budget Template File (PA40201)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Budget Template File
Physical Name: PA40201
Technical Name: PA_Budget_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	SQL DB Length	Keyable Length
1	PACTID	PA Contract Template ID	STR15_Contract_Class_ID	String	16	15
2	PAPTID	PA Project Template ID	STR15_Project_Class_ID	String	16	15
3	PATU	PA Transaction Usage	PA_DDL_Transaction_Usage	Integer	2	0
4	PACOSTCATID	PA Cost Category ID	STR15_Cost_Category_ID	String	16	15
5	PAIV_Item_Checkbox	PA IV Item Checkbox	PA_CB_IV_Item	Boolean	2	0
6	PASTAT	PA Status	PA_DDL_Status	Integer	2	0
7	PAProfitType	PA Profit Type	PA_DDL_Profit_Type	Integer	2	0
8	PAbllngtype	PA Billing Type	PA_DDL_Billing_Type	Integer	2	0
9	PABase_Qty	PA Base Qty	PA_DLR15_RBS0_STR	Currency	10	15
10	PABase_Unit_Cost	PA Base Unit Cost	PA_DLR17_RBS0_STR$	Currency	10	17
11	PABaseProfitAmount	PA Base Profit Amount	DLR17_RBS0_UTR$	Currency	10	17
12	PABaseOvhdCost	PA Base Overhead Cost	DLR17_RBS0_UTR$	Currency	10	17
13	PAForecastBaseOvrhdAmt	PA Forecast Base Overhead Amount	DLR17_RBS0_UTR$	Currency	10	17
14	PABBeginDate	PA Baseline Begin Date	DATE	Date	4	6
15	PABEndDate	PA Baseline End Date	DATE	Date	4	6
16	PABQuantity	PA Baseline Quantity	DLR15_RBU2	Currency	10	15
17	PABUnitCost	PA Baseline Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
18	PABTotalCost	PA Baseline Total Cost	DLR17_RBS0_UTR$	Currency	10	17
19	PABBillings	PA Baseline Billings	DLR17_RBS0_UTR$	Currency	10	17
20	PABProfit	PA Baseline Profit	DLR17_RBS0_STR$	Currency	10	17
21	PABProfitAmt	PA Baseline Profit Amount	DLR17_RBS0_UTR$	Currency	10	17
22	PABProfitPcnt	PA Baseline Profit Percent	DLR5_%2	Currency	10	8
23	PABTaxPaidAmt	PA Baseline Tax Paid Amount	DLR17_RBS0_UTR$	Currency	10	17
24	PABTaxChargedAmt	PA Baseline Tax Charged Amount	DLR17_RBS0_UTR$	Currency	10	17
25	PABaselineOvhdCost	PA Baseline Overhead Cost	DLR17_RBS0_UTR$	Currency	10	17
26	PAForecastBaseQty	PA Forecast Base Qty	DLR15_RBU2	Currency	10	15
27	PAForecastBaseUnitCost	PA Forecast Base Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
28	PAFBeginDate	PA Forecast Begin Date	DATE	Date	4	6
29	PAFEndDate	PA Forecast End Date	DATE	Date	4	6
30	PAFQuantity	PA Forecast Quantity	DLR15_RBU2	Currency	10	15
31	PAFUnitCost	PA Forecast Unit Cost	DLR17_RBS0_UTR$	Currency	10	17
32	PAFTotalCost	PA Forecast Total Cost	DLR17_RBS0_UTR$	Currency	10	17
33	PAFBillings	PA Forecast Billings	DLR17_RBS0_UTR$	Currency	10	17
34	PAFProfit	PA Forecast Profit	DLR17_RBS0_STR$	Currency	10	17
35	PAFProfitAmt	PA Forecast Profit Amount	DLR17_RBS0_UTR$	Currency	10	17
36	PAFProfitPcnt	PA Forecast Profit Percent	DLR5_%2	Currency	10	8
37	PAFTaxPaidAmt	PA Forecast Tax Paid Amount	DLR17_RBS0_UTR$	Currency	10	17
38	PAFTaxChargedAmt	PA Forecast Tax Charged Amount	DLR17_RBS0_UTR$	Currency	10	17
39	PAForecastOvhdCost	PA Forecast Overhead Cost	DLR17_RBS0_UTR$	Currency	10	17
40	PAUnit_of_Measure	PA Unit of Measure	U_Of_M	String	10	8
41	UOMSCHDL	U Of M Schedule	STR10_Schedule	String	12	10
	Key to the Inventory U of M Schedule Setup (IV40201). Click to show/hide SELECT ['PA Budget Template File'].UOMSCHDL AS 'PA Budget Template File-U Of M Schedule' ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule' FROM PA40201 AS ['PA Budget Template File'] INNER JOIN IV40201 AS ['Inventory U of M Schedule Setup'] ON ['PA Budget Template File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
42	PAUOfMMult	PA UOfM Multiplier	DLR17_QTY_RBS0_UTR	Currency	10	17
43	DECPLQTY	Decimal Places QTYS	DDL_Decimal_Places_QTYS	Integer	2	0
44	PAPay_Code_Hourly	PA Pay Code Hourly	STR6_Payroll_Code	String	8	6
45	PAPay_Code_Salary	PA Pay Code Salary	STR6_Payroll_Code	String	8	6
46	DECPLCUR	Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	2	0
47	PALabor_Rate_Table_ID	PA Labor Rate Table ID	STR30_Rate_Table_ID	String	32	30
48	PALabor_RateTable_Type	PA Labor Rate Table Type	PA_DDL_Rate_Table_Type	Integer	2	0
49	PALabor_Rate_Table_Acc	PA Labor Rate Table Accept	CB_Rate_Table_Accept	Boolean	2	0
50	PAEquip_Rate_Table_ID	PA Equip Rate Table ID	STR30_Rate_Table_ID	String	32	30
51	PAEquip_Rate_Table_Acc	PA Equip Rate Table Accept	CB_Rate_Table_Accept	Boolean	2	0
52	TM_WIP_SRC	TM WIP SRC	DDL_AccountSource	Integer	2	0
53	TM_COGS_SRC	TM COGS SRC	DDL_AccountSource	Integer	2	0
54	TM_Cost_Contra_SRC	TM Cost Contra SRC	DDL_AccountSource	Integer	2	0
55	TM_Unbilled_AR_SRC	TM Unbilled AR SRC	DDL_AccountSource	Integer	2	0
56	TM_Unbilled_Rev_SRC	TM Unbilled Rev SRC	DDL_AccountSource	Integer	2	0
57	TM_AR_SRC	TM AR SRC	DDL_AccountSource	Integer	2	0
58	TM_Prj_Rev_SRC	TM Prj Rev SRC	DDL_AccountSource	Integer	2	0
59	TM_OVHD_SRC	TM OVHD SRC	DDL_AccountSource	Integer	2	0
60	FF_WIP_SRC	FF WIP SRC	DDL_AccountSource	Integer	2	0
61	FF_Cost_Contra_SRC	FF Cost Contra SRC	DDL_AccountSource	Integer	2	0
62	FF_AR_SRC	FF AR SRC	DDL_AccountSource	Integer	2	0
63	FF_Prj_Billings_SRC	FF Prj Billings SRC	DDL_AccountSource	Integer	2	0
64	FF_Prj_Expense_SRC	FF Prj Expense SRC	DDL_AccountSource	Integer	2	0
65	FF_Prj_Revenue_SRC	FF Prj Revenue SRC	DDL_AccountSource	Integer	2	0
66	FF_Prj_Loss_SRC	FF Prj Loss SRC	DDL_AccountSource	Integer	2	0
67	FF_BIEE_SRC	FF BIEE SRC	DDL_AccountSource	Integer	2	0
68	FF_EIEB_SRC	FF EIEB SRC	DDL_AccountSource	Integer	2	0
69	FF_OVHD_SRC	FF OVHD SRC	DDL_AccountSource	Integer	2	0
70	PAcostaxscheduleid	PA Cost Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
71	PAPurchase_Tax_Options	PA Purchase Tax Options	PA_DDL_Tax_Options_Purchase	Integer	2	0
72	PAbilltaxscheduleid	PA Billing Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
73	PASales_Tax_Options	PA Sales Tax Options	PA_DDL_Tax_Options_Sales	Integer	2	0
74	PAProject_Amount	PA Project Amount	DLR17_RBS0_UTR$	Currency	10	17
75	PAOverheadRateMethod	PA Overhead Rate Method	GB	Integer	2	0
76	PABaselineOvhdAmtPerUnit	PA Baseline Overhead Amount Per Unit	DLR17_RBS0_UTR$	Currency	10	17
77	PABaselineOvrhdPct	PA Baseline Overhead Percentage	DLR5_%2	Currency	10	8
78	PAForecastOvrhdAmtPerUnt	PA Forecast Overhead Amount Per Unit	DLR17_RBS0_UTR$	Currency	10	17
79	PAForecastOvrhdPct	PA Forecast Overhead Percentage	DLR5_%2	Currency	10	8
80	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
81	PALineItemSeq	PA Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
82	PAbillnoteidx	PA Billing Note Index	DLR14	Currency	10	14
83	DEX_ROW_ID		int	int	10	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 Budget Template File (PA40201)

Click to show/hide

Leave a Reply Cancel reply