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 |