PA Budget Template File (PA40201)

azurecurveProductsProject 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: 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PACTID SearchPA Contract Template IDSTR15_Contract_Class_IDString1615
2PAPTID SearchPA Project Template IDSTR15_Project_Class_IDString1615
3PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
4PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString1615
5PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean20
6PASTAT SearchPA StatusPA_DDL_StatusInteger20
7PAProfitType SearchPA Profit TypePA_DDL_Profit_TypeInteger20
8PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger20
9PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency1015
10PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency1017
11PABaseProfitAmount SearchPA Base Profit AmountDLR17_RBS0_UTR$Currency1017
12PABaseOvhdCost SearchPA Base Overhead CostDLR17_RBS0_UTR$Currency1017
13PAForecastBaseOvrhdAmt SearchPA Forecast Base Overhead AmountDLR17_RBS0_UTR$Currency1017
14PABBeginDate SearchPA Baseline Begin DateDATEDate46
15PABEndDate SearchPA Baseline End DateDATEDate46
16PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency1015
17PABUnitCost SearchPA Baseline Unit CostDLR17_RBS0_UTR$Currency1017
18PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency1017
19PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency1017
20PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency1017
21PABProfitAmt SearchPA Baseline Profit AmountDLR17_RBS0_UTR$Currency1017
22PABProfitPcnt SearchPA Baseline Profit PercentDLR5_%2Currency108
23PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency1017
24PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency1017
25PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency1017
26PAForecastBaseQty SearchPA Forecast Base QtyDLR15_RBU2Currency1015
27PAForecastBaseUnitCost SearchPA Forecast Base Unit CostDLR17_RBS0_UTR$Currency1017
28PAFBeginDate SearchPA Forecast Begin DateDATEDate46
29PAFEndDate SearchPA Forecast End DateDATEDate46
30PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency1015
31PAFUnitCost SearchPA Forecast Unit CostDLR17_RBS0_UTR$Currency1017
32PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency1017
33PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency1017
34PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency1017
35PAFProfitAmt SearchPA Forecast Profit AmountDLR17_RBS0_UTR$Currency1017
36PAFProfitPcnt SearchPA Forecast Profit PercentDLR5_%2Currency108
37PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency1017
38PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency1017
39PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency1017
40PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString108
41UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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
42PAUOfMMult SearchPA UOfM MultiplierDLR17_QTY_RBS0_UTRCurrency1017
43DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
44PAPay_Code_Hourly SearchPA Pay Code HourlySTR6_Payroll_CodeString86
45PAPay_Code_Salary SearchPA Pay Code SalarySTR6_Payroll_CodeString86
46DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
47PALabor_Rate_Table_ID SearchPA Labor Rate Table IDSTR30_Rate_Table_IDString3230
48PALabor_RateTable_Type SearchPA Labor Rate Table TypePA_DDL_Rate_Table_TypeInteger20
49PALabor_Rate_Table_Acc SearchPA Labor Rate Table AcceptCB_Rate_Table_AcceptBoolean20
50PAEquip_Rate_Table_ID SearchPA Equip Rate Table IDSTR30_Rate_Table_IDString3230
51PAEquip_Rate_Table_Acc SearchPA Equip Rate Table AcceptCB_Rate_Table_AcceptBoolean20
52TM_WIP_SRC SearchTM WIP SRCDDL_AccountSourceInteger20
53TM_COGS_SRC SearchTM COGS SRCDDL_AccountSourceInteger20
54TM_Cost_Contra_SRC SearchTM Cost Contra SRCDDL_AccountSourceInteger20
55TM_Unbilled_AR_SRC SearchTM Unbilled AR SRCDDL_AccountSourceInteger20
56TM_Unbilled_Rev_SRC SearchTM Unbilled Rev SRCDDL_AccountSourceInteger20
57TM_AR_SRC SearchTM AR SRCDDL_AccountSourceInteger20
58TM_Prj_Rev_SRC SearchTM Prj Rev SRCDDL_AccountSourceInteger20
59TM_OVHD_SRC SearchTM OVHD SRCDDL_AccountSourceInteger20
60FF_WIP_SRC SearchFF WIP SRCDDL_AccountSourceInteger20
61FF_Cost_Contra_SRC SearchFF Cost Contra SRCDDL_AccountSourceInteger20
62FF_AR_SRC SearchFF AR SRCDDL_AccountSourceInteger20
63FF_Prj_Billings_SRC SearchFF Prj Billings SRCDDL_AccountSourceInteger20
64FF_Prj_Expense_SRC SearchFF Prj Expense SRCDDL_AccountSourceInteger20
65FF_Prj_Revenue_SRC SearchFF Prj Revenue SRCDDL_AccountSourceInteger20
66FF_Prj_Loss_SRC SearchFF Prj Loss SRCDDL_AccountSourceInteger20
67FF_BIEE_SRC SearchFF BIEE SRCDDL_AccountSourceInteger20
68FF_EIEB_SRC SearchFF EIEB SRCDDL_AccountSourceInteger20
69FF_OVHD_SRC SearchFF OVHD SRCDDL_AccountSourceInteger20
70PAcostaxscheduleid SearchPA Cost Tax Schedule IDSTR15_Tax_Schedule_IDString1615
71PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
72PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
73PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
74PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
75PAOverheadRateMethod SearchPA Overhead Rate MethodGBInteger20
76PABaselineOvhdAmtPerUnit SearchPA Baseline Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
77PABaselineOvrhdPct SearchPA Baseline Overhead PercentageDLR5_%2Currency108
78PAForecastOvrhdAmtPerUnt SearchPA Forecast Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
79PAForecastOvrhdPct SearchPA Forecast Overhead PercentageDLR5_%2Currency108
80LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
81PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
82PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
83DEX_ROW_ID Searchintint1010

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.

azurecurveProductsProject Accounting (258)ProjectPA Budget Template File (PA40201)

Leave a Reply

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