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 TypeLength
1PACTID SearchPA Contract Template IDSTR15_Contract_Class_IDString15
2PACTN SearchPA Contract Template NameSTR30_PTBS Description 1String30
3PALONGID SearchPA Long Contract IDPA_Long_Contract_IDComposite 0
4PALONGID_1 SearchPA Long Contract ID:PA Long Contract Segment1PA_STR9_SEG1String9
5PALONGID_2 SearchPA Long Contract ID:PA Long Contract Segment2PA_STR9_SEG2String9
6PALONGID_3 SearchPA Long Contract ID:PA Long Contract Segment3PA_STR9_SEG3String9
7PALONGID_4 SearchPA Long Contract ID:PA Long Contract Segment4PA_STR9_SEG4String9
8PALONGID_5 SearchPA Long Contract ID:PA Long Contract Segment5PA_STR9_SEG5String9
9PAcontclassid SearchPA Contract Class IDSTR15_Contract_Class_IDString15
10PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
11PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger0
12PASTAT SearchPA StatusPA_DDL_StatusInteger0
13PAContMgrID SearchPA Contract Manager IDSTR15_Employee_IDString15
14PABusMgrID SearchPA Business Manager IDSTR15_Employee_IDString15
15LOCATNID SearchLocation IDSTR15_Location_IDString15
16COMAPPTO SearchCommission Applied ToGBInteger0
17PABILLFORMAT SearchPA Bill FormatSTR15_LBAUString15
18PABBeginDate SearchPA Baseline Begin DateDATEDate6
19PABEndDate SearchPA Baseline End DateDATEDate6
20PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency15
21PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency17
22PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency17
23PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency17
24PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency17
25PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency17
26PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency17
27PAFBeginDate SearchPA Forecast Begin DateDATEDate6
28PAFEndDate SearchPA Forecast End DateDATEDate6
29PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
30PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
31PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency17
32PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
33PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency17
34PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency17
35PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency17
36PAUD1_Cont SearchPA User Defined 1 - ContractSTR50String50
37PAUD2_Cont SearchPA User Defined 2 - ContractSTR50String50
38PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean0
39PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
40PAProject_Fee_Amount SearchPA Project Fee AmountPA_DLR17_RBS0_STR$Currency17
41PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency17
42PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
43PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency17
44PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
45PAbillnoteidxts SearchPA Billing Note Index - TSDLR14Currency14
46PAELbillniteidx SearchPA Billing Note Index - ELDLR14Currency14
47PAbillnoteidxML SearchPA Billing Note Index - MLDLR14Currency14
48PAbillnoteidxvi SearchPA Billing Note Index - VIDLR14Currency14
49PAbillnoteidxee SearchPA Billing Note Index - EEDLR14Currency14
50PAbillnoteidxinv SearchPA Billing Note Index - INVDLR14Currency14
51PAbillnoteidxfee SearchPA Billing Note Index - FEEDLR14Currency14
52NOTEINDX SearchNote IndexDLR14Currency14
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 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 Contract TemplateFile (PA41501)

Leave a Reply

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