| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PACTID | PA Contract Template ID |
String | 16 | View | |
| PACTN | PA Contract Template Name |
String | 32 | View | |
| PALONGID_1 | PA Long Contract ID:PA Long Contract Segment1 |
String | 10 | View | |
| PALONGID_2 | PA Long Contract ID:PA Long Contract Segment2 |
String | 10 | View | |
| PALONGID_3 | PA Long Contract ID:PA Long Contract Segment3 |
String | 10 | View | |
| PALONGID_4 | PA Long Contract ID:PA Long Contract Segment4 |
String | 10 | View | |
| PALONGID_5 | PA Long Contract ID:PA Long Contract Segment5 |
String | 10 | View | |
| PAcontclassid | PA Contract Class ID |
String | 16 | View | |
| PAProjectType | PA Project Type |
Integer | 2 | View | |
| PAAcctgMethod | PA Accounting Method |
Integer | 2 | View | |
| PASTAT | PA Status 1 = Open |
Integer | 2 | View | |
| PAContMgrID | PA Contract Manager ID |
String | 16 | View | |
| PABusMgrID | PA Business Manager ID |
String | 16 | View | |
| LOCATNID | Location ID |
String | 16 | View | |
| COMAPPTO | Commission Applied To |
Integer | 2 | View | |
| PABILLFORMAT | PA Bill Format |
String | 16 | View | |
| PABBeginDate | PA Baseline Begin Date |
Date | 4 | View | |
| PABEndDate | PA Baseline End Date |
Date | 4 | View | |
| PABQuantity | PA Baseline Quantity |
Currency | 10 | View | |
| PABTotalCost | PA Baseline Total Cost |
Currency | 10 | View | |
| PABProfit | PA Baseline Profit |
Currency | 10 | View | |
| PABBillings | PA Baseline Billings |
Currency | 10 | View | |
| PABTaxPaidAmt | PA Baseline Tax Paid Amount |
Currency | 10 | View | |
| PABTaxChargedAmt | PA Baseline Tax Charged Amount |
Currency | 10 | View | |
| PABaselineOvhdCost | PA Baseline Overhead Cost |
Currency | 10 | View | |
| PAFBeginDate | PA Forecast Begin Date |
Date | 4 | View | |
| PAFEndDate | PA Forecast End Date |
Date | 4 | View | |
| PAFQuantity | PA Forecast Quantity |
Currency | 10 | View | |
| PAFTotalCost | PA Forecast Total Cost |
Currency | 10 | View | |
| PAFProfit | PA Forecast Profit |
Currency | 10 | View | |
| PAFBillings | PA Forecast Billings |
Currency | 10 | View | |
| PAFTaxPaidAmt | PA Forecast Tax Paid Amount |
Currency | 10 | View | |
| PAFTaxChargedAmt | PA Forecast Tax Charged Amount |
Currency | 10 | View | |
| PAForecastOvhdCost | PA Forecast Overhead Cost |
Currency | 10 | View | |
| PAUD1_Cont | PA User Defined 1 - Contract |
String | 52 | View | |
| PAUD2_Cont | PA User Defined 2 - Contract |
String | 52 | View | |
| PASegmentCB | PA Segment CB |
Boolean | 2 | View | |
| PAProject_Amount | PA Project Amount |
Currency | 10 | View | |
| PAProject_Fee_Amount | PA Project Fee Amount |
Currency | 10 | View | |
| PAService_Fee_Amount | PA Service Fee Amount |
Currency | 10 | View | |
| PARetainer_Fee_Amount | PA Retainer Fee Amount |
Currency | 10 | View | |
| PARetentionFeeAmount | PA Retention Fee Amount |
Currency | 10 | View | |
| PAbillnoteidx | PA Billing Note Index |
Currency | 10 | View | |
| PAbillnoteidxts | PA Billing Note Index - TS |
Currency | 10 | View | |
| PAELbillniteidx | PA Billing Note Index - EL |
Currency | 10 | View | |
| PAbillnoteidxML | PA Billing Note Index - ML |
Currency | 10 | View | |
| PAbillnoteidxvi | PA Billing Note Index - VI |
Currency | 10 | View | |
| PAbillnoteidxee | PA Billing Note Index - EE |
Currency | 10 | View | |
| PAbillnoteidxinv | PA Billing Note Index - INV |
Currency | 10 | View | |
| PAbillnoteidxfee | PA Billing Note Index - FEE |
Currency | 10 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View |