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 Group Display Name: PA Budgeting Templates
Physical Name: PA41601
Technical Name: PA_Project_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 | 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/hideSELECT
['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. |