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:

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 IDStringSTR15_Contract_Class_ID15
2PACTN SearchPA Contract Template NameStringSTR30_PTBS Description 130
3PALONGID_1 SearchPA Long Contract ID:PA Long Contract Segment1StringPA_STR9_SEG19
4PALONGID SearchPA Long Contract IDPA_Long_Contract_IDComposite 0
5PALONGID_2 SearchPA Long Contract ID:PA Long Contract Segment2StringPA_STR9_SEG29
6PALONGID_3 SearchPA Long Contract ID:PA Long Contract Segment3StringPA_STR9_SEG39
7PALONGID_4 SearchPA Long Contract ID:PA Long Contract Segment4StringPA_STR9_SEG49
8PALONGID_5 SearchPA Long Contract ID:PA Long Contract Segment5StringPA_STR9_SEG59
9PAcontclassid SearchPA Contract Class IDStringSTR15_Contract_Class_ID15
10PAProjectType SearchPA Project TypeIntegerPA_DDL_Project_Type0
11PAAcctgMethod SearchPA Accounting MethodIntegerPA_DDL_Accounting_Method0
12PASTAT SearchPA StatusIntegerPA_DDL_Status0
13PAContMgrID SearchPA Contract Manager IDStringSTR15_Employee_ID15
14PABusMgrID SearchPA Business Manager IDStringSTR15_Employee_ID15
15LOCATNID SearchLocation IDStringSTR15_Location_ID15
16COMAPPTO SearchCommission Applied ToIntegerGB0
17PABILLFORMAT SearchPA Bill FormatStringSTR15_LBAU15
18PABBeginDate SearchPA Baseline Begin DateDateDATE6
19PABEndDate SearchPA Baseline End DateDateDATE6
20PABQuantity SearchPA Baseline QuantityCurrencyDLR15_RBU215
21PABTotalCost SearchPA Baseline Total CostCurrencyDLR17_RBS0_UTR$17
22PABProfit SearchPA Baseline ProfitCurrencyDLR17_RBS0_STR$17
23PABBillings SearchPA Baseline BillingsCurrencyDLR17_RBS0_UTR$17
24PABTaxPaidAmt SearchPA Baseline Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
25PABTaxChargedAmt SearchPA Baseline Tax Charged AmountCurrencyDLR17_RBS0_UTR$17
26PABaselineOvhdCost SearchPA Baseline Overhead CostCurrencyDLR17_RBS0_UTR$17
27PAFBeginDate SearchPA Forecast Begin DateDateDATE6
28PAFEndDate SearchPA Forecast End DateDateDATE6
29PAFQuantity SearchPA Forecast QuantityCurrencyDLR15_RBU215
30PAFTotalCost SearchPA Forecast Total CostCurrencyDLR17_RBS0_UTR$17
31PAFProfit SearchPA Forecast ProfitCurrencyDLR17_RBS0_STR$17
32PAFBillings SearchPA Forecast BillingsCurrencyDLR17_RBS0_UTR$17
33PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
34PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountCurrencyDLR17_RBS0_UTR$17
35PAForecastOvhdCost SearchPA Forecast Overhead CostCurrencyDLR17_RBS0_UTR$17
36PAUD1_Cont SearchPA User Defined 1 - ContractStringSTR5050
37PAUD2_Cont SearchPA User Defined 2 - ContractStringSTR5050
38PASegmentCB SearchPA Segment CBBooleanPA_CB_Segment0
39PAProject_Amount SearchPA Project AmountCurrencyDLR17_RBS0_UTR$17
40PAProject_Fee_Amount SearchPA Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
41PAService_Fee_Amount SearchPA Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
42PARetainer_Fee_Amount SearchPA Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
43PARetentionFeeAmount SearchPA Retention Fee AmountCurrencyPA_DLR17_RBS0_STR$17
44PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
45PAbillnoteidxts SearchPA Billing Note Index - TSCurrencyDLR1414
46PAELbillniteidx SearchPA Billing Note Index - ELCurrencyDLR1414
47PAbillnoteidxML SearchPA Billing Note Index - MLCurrencyDLR1414
48PAbillnoteidxvi SearchPA Billing Note Index - VICurrencyDLR1414
49PAbillnoteidxee SearchPA Billing Note Index - EECurrencyDLR1414
50PAbillnoteidxinv SearchPA Billing Note Index - INVCurrencyDLR1414
51PAbillnoteidxfee SearchPA Billing Note Index - FEECurrencyDLR1414
52NOTEINDX SearchNote IndexCurrencyDLR1414
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
azurecurveProductsProject Accounting (258)ProjectPA Contract TemplateFile (PA41501)

Leave a Reply

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