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