PA Contract TemplateFile (PA41501)

azurecurveProductsProject Accounting (258)ProjectPA Contract TemplateFile (PA41501)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA41501

Product: Project Accounting (258)
Series: Project

Display Name: PA Contract TemplateFile
Physical Name: PA41501
Technical Name: PA_Contract_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
2PACTN SearchPA Contract Template NameSTR30_PTBS Description 1String3230
3PALONGID SearchPA Long Contract IDPA_Long_Contract_IDComposite 500
4PALONGID_1 SearchPA Long Contract ID:PA Long Contract Segment1PA_STR9_SEG1String109
5PALONGID_2 SearchPA Long Contract ID:PA Long Contract Segment2PA_STR9_SEG2String109
6PALONGID_3 SearchPA Long Contract ID:PA Long Contract Segment3PA_STR9_SEG3String109
7PALONGID_4 SearchPA Long Contract ID:PA Long Contract Segment4PA_STR9_SEG4String109
8PALONGID_5 SearchPA Long Contract ID:PA Long Contract Segment5PA_STR9_SEG5String109
9PAcontclassid SearchPA Contract Class IDSTR15_Contract_Class_IDString1615
10PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
11PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger20
12PASTAT SearchPA StatusPA_DDL_StatusInteger20
13PAContMgrID SearchPA Contract Manager IDSTR15_Employee_IDString1615
14PABusMgrID SearchPA Business Manager IDSTR15_Employee_IDString1615
15LOCATNID SearchLocation IDSTR15_Location_IDString1615
16COMAPPTO SearchCommission Applied ToGBInteger20
17PABILLFORMAT SearchPA Bill FormatSTR15_LBAUString1615
18PABBeginDate SearchPA Baseline Begin DateDATEDate46
19PABEndDate SearchPA Baseline End DateDATEDate46
20PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency1015
21PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency1017
22PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency1017
23PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency1017
24PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency1017
25PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency1017
26PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency1017
27PAFBeginDate SearchPA Forecast Begin DateDATEDate46
28PAFEndDate SearchPA Forecast End DateDATEDate46
29PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency1015
30PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency1017
31PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency1017
32PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency1017
33PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency1017
34PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency1017
35PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency1017
36PAUD1_Cont SearchPA User Defined 1 - ContractSTR50String5250
37PAUD2_Cont SearchPA User Defined 2 - ContractSTR50String5250
38PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean20
39PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
40PAProject_Fee_Amount SearchPA Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
41PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
42PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
43PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency1017
44PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
45PAbillnoteidxts SearchPA Billing Note Index - TSDLR14Currency1014
46PAELbillniteidx SearchPA Billing Note Index - ELDLR14Currency1014
47PAbillnoteidxML SearchPA Billing Note Index - MLDLR14Currency1014
48PAbillnoteidxvi SearchPA Billing Note Index - VIDLR14Currency1014
49PAbillnoteidxee SearchPA Billing Note Index - EEDLR14Currency1014
50PAbillnoteidxinv SearchPA Billing Note Index - INVDLR14Currency1014
51PAbillnoteidxfee SearchPA Billing Note Index - FEEDLR14Currency1014
52NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Contract TemplateFile'].NOTEINDX AS 'PA Contract TemplateFile-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA41501 AS ['PA Contract TemplateFile']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Contract TemplateFile'].NOTEINDX = ['Record Notes Master'].NOTEINDX
53DEX_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 Contract TemplateFile (PA41501)

Leave a Reply

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