PA Budget Template File (PA40201)

azurecurve Products Project Accounting (258)ProjectPA Budget Template File (PA40201)

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

Product: Project Accounting (258)
Series:

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

azurecurve Products Project Accounting (258)ProjectPA Budget Template File (PA40201)

Click to show/hide

Leave a Reply Cancel reply