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 TypeLength
1PACTID SearchPA Contract Template IDSTR15_Contract_Class_IDString15
2PAPTID SearchPA Project Template IDSTR15_Project_Class_IDString15
3PAPTN SearchPA Project Template NameSTR30_PTBS Description 1String30
4PAPROJNUMSEG SearchPA Project Number SegmentSTR5_Doc_IDString5
5PAprjclsid SearchPA Project Class IDSTR15_Project_Class_IDString15
6PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
7PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger0
8PASTAT SearchPA StatusPA_DDL_StatusInteger0
9PADepartment SearchPA DepartmentSTR6_Payroll_CodeString6
10PABBeginDate SearchPA Baseline Begin DateDATEDate6
11PABEndDate SearchPA Baseline End DateDATEDate6
12PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency15
13PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency17
14PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency17
15PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency17
16PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency17
17PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency17
18PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency17
19PAFBeginDate SearchPA Forecast Begin DateDATEDate6
20PAFEndDate SearchPA Forecast End DateDATEDate6
21PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
22PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
23PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency17
24PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
25PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency17
26PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency17
27PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency17
28PAEstimatorID SearchPA Estimator IDSTR15_Employee_IDString15
29PAprojmngrid SearchPA Project Manager IDSTR15_Employee_IDString15
30PABusMgrID SearchPA Business Manager IDSTR15_Employee_IDString15
31LOCATNID SearchLocation IDSTR15_Location_IDString15
32COMPRCNT SearchCommission PercentINT5_%2Integer5
33COMAPPTO SearchCommission Applied ToGBInteger0
34PALabor_Rate_Table_ID SearchPA Labor Rate Table IDSTR30_Rate_Table_IDString30
35PALabor_RateTable_Type SearchPA Labor Rate Table TypePA_DDL_Rate_Table_TypeInteger0
36PALabor_Rate_Table_Acc SearchPA Labor Rate Table AcceptCB_Rate_Table_AcceptBoolean0
37PAEquip_Rate_Table_ID SearchPA Equip Rate Table IDSTR30_Rate_Table_IDString30
38PAEquip_Rate_Table_Acc SearchPA Equip Rate Table AcceptCB_Rate_Table_AcceptBoolean0
39PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger0
40PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
41PAProject_Fee_Amount SearchPA Project Fee AmountPA_DLR17_RBS0_STR$Currency17
42PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency17
43PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
44PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency17
45ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
46PABILLFORMAT SearchPA Bill FormatSTR15_LBAUString15
47PADiscMetToUse SearchPA Discount Method To UseGBInteger0
48DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency17
49DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
50PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency8
51PAtotcbts SearchPA Label Checkbox - TSCBBoolean0
52PAtotcbEL SearchPA Label Checkbox - ELCBBoolean0
53PAtotcbML SearchPA Label Checkbox - MLCBBoolean0
54PAtotcbvi SearchPA Label Checkbox - VICBBoolean0
55PAtotcber SearchPA Label Checkbox - EECBBoolean0
56PAtotcbinv SearchPA Label Checkbox - INVCBBoolean0
57PAtotcbfee SearchPA Label Checkbox - FEECBBoolean0
58PAUD1Proj SearchPA User Defined 1 - ProjectSTR50String50
59PAUD2_Proj SearchPA User Defined 2 - ProjectSTR50String50
60PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean0
61PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
62PAbillnoteidxts SearchPA Billing Note Index - TSDLR14Currency14
63PAELbillniteidx SearchPA Billing Note Index - ELDLR14Currency14
64PAbillnoteidxML SearchPA Billing Note Index - MLDLR14Currency14
65PAbillnoteidxvi SearchPA Billing Note Index - VIDLR14Currency14
66PAbillnoteidxee SearchPA Billing Note Index - EEDLR14Currency14
67PAbillnoteidxinv SearchPA Billing Note Index - INVDLR14Currency14
68PAbillnoteidxfee SearchPA Billing Note Index - FEEDLR14Currency14
69NOTEINDX SearchNote IndexDLR14Currency14
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_CodeString6
71SUTASTAT SearchSuta StateSTR2_State_CodeString2
72DEX_ROW_ID Searchintint10

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 *