PA Project Template File (PA41601)

azurecurveProductsProject Accounting (258)ProjectPA Project Template File (PA41601)

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
Physical Name: PA41601
Technical Name: PA_Project_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
3PAPTN SearchPA Project Template NameSTR30_PTBS Description 1String3230
4PAPROJNUMSEG SearchPA Project Number SegmentSTR5_Doc_IDString65
5PAprjclsid SearchPA Project Class IDSTR15_Project_Class_IDString1615
6PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
7PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger20
8PASTAT SearchPA StatusPA_DDL_StatusInteger20
9PADepartment SearchPA DepartmentSTR6_Payroll_CodeString86
10PABBeginDate SearchPA Baseline Begin DateDATEDate46
11PABEndDate SearchPA Baseline End DateDATEDate46
12PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency1015
13PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency1017
14PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency1017
15PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency1017
16PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency1017
17PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency1017
18PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency1017
19PAFBeginDate SearchPA Forecast Begin DateDATEDate46
20PAFEndDate SearchPA Forecast End DateDATEDate46
21PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency1015
22PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency1017
23PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency1017
24PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency1017
25PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency1017
26PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency1017
27PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency1017
28PAEstimatorID SearchPA Estimator IDSTR15_Employee_IDString1615
29PAprojmngrid SearchPA Project Manager IDSTR15_Employee_IDString1615
30PABusMgrID SearchPA Business Manager IDSTR15_Employee_IDString1615
31LOCATNID SearchLocation IDSTR15_Location_IDString1615
32COMPRCNT SearchCommission PercentINT5_%2Integer25
33COMAPPTO SearchCommission Applied ToGBInteger20
34PALabor_Rate_Table_ID SearchPA Labor Rate Table IDSTR30_Rate_Table_IDString3230
35PALabor_RateTable_Type SearchPA Labor Rate Table TypePA_DDL_Rate_Table_TypeInteger20
36PALabor_Rate_Table_Acc SearchPA Labor Rate Table AcceptCB_Rate_Table_AcceptBoolean20
37PAEquip_Rate_Table_ID SearchPA Equip Rate Table IDSTR30_Rate_Table_IDString3230
38PAEquip_Rate_Table_Acc SearchPA Equip Rate Table AcceptCB_Rate_Table_AcceptBoolean20
39PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger20
40PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
41PAProject_Fee_Amount SearchPA Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
42PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
43PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
44PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency1017
45ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency1019
46PABILLFORMAT SearchPA Bill FormatSTR15_LBAUString1615
47PADiscMetToUse SearchPA Discount Method To UseGBInteger20
48DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency1017
49DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
50PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency108
51PAtotcbts SearchPA Label Checkbox - TSCBBoolean20
52PAtotcbEL SearchPA Label Checkbox - ELCBBoolean20
53PAtotcbML SearchPA Label Checkbox - MLCBBoolean20
54PAtotcbvi SearchPA Label Checkbox - VICBBoolean20
55PAtotcber SearchPA Label Checkbox - EECBBoolean20
56PAtotcbinv SearchPA Label Checkbox - INVCBBoolean20
57PAtotcbfee SearchPA Label Checkbox - FEECBBoolean20
58PAUD1Proj SearchPA User Defined 1 - ProjectSTR50String5250
59PAUD2_Proj SearchPA User Defined 2 - ProjectSTR50String5250
60PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean20
61PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
62PAbillnoteidxts SearchPA Billing Note Index - TSDLR14Currency1014
63PAELbillniteidx SearchPA Billing Note Index - ELDLR14Currency1014
64PAbillnoteidxML SearchPA Billing Note Index - MLDLR14Currency1014
65PAbillnoteidxvi SearchPA Billing Note Index - VIDLR14Currency1014
66PAbillnoteidxee SearchPA Billing Note Index - EEDLR14Currency1014
67PAbillnoteidxinv SearchPA Billing Note Index - INVDLR14Currency1014
68PAbillnoteidxfee SearchPA Billing Note Index - FEEDLR14Currency1014
69NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
70WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
71SUTASTAT SearchSuta StateSTR2_State_CodeString42
72DEX_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 Project Template File (PA41601)

Leave a Reply

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