| Column | Description | Data Type | Length | Tables This Field Is In | In Query () | 
| PAPROJNUMBER | PA Project Number | String | 16 | View | |
| PATU | PA Transaction Usage 1 = Timesheet | Integer | 2 | View | |
| PAsfid | PA Source File ID | Integer | 2 | View | |
| PACOSTCATID | PA Cost Category ID | String | 16 | View | |
| PERIODID | Period ID | Integer | 2 | View | |
| YEAR1 | Year | Integer | 2 | View | |
| PAPeriodStartDate | PA Period Start Date | Date | 4 | View | |
| PAPeriodEndDate | PA Period End Date | Date | 4 | View | |
| PERIODDT | Period Date | Date | 4 | View | |
| PAACTUALBEGDATE | PA Actual Begin Date | Date | 4 | View | |
| PA_Actual_End_Date | PA Actual End Date | Date | 4 | View | |
| PABQuantity | PA Baseline Quantity | Currency | 10 | View | |
| PAFeeAmount | PA Fee Amount | Currency | 10 | View | |
| PABUnitCost | PA Baseline Unit Cost | Currency | 10 | View | |
| PABTotalCost | PA Baseline Total Cost | Currency | 10 | View | |
| PABProfit | PA Baseline Profit | Currency | 10 | View | |
| PABProfitAmt | PA Baseline Profit Amount | 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 | |
| PAFQuantity | PA Forecast Quantity | Currency | 10 | View | |
| PAFUnitCost | PA Forecast Unit Cost | 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 | |
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | View | |
| PAUnpostedQty | PA Unposted Qty | Currency | 10 | View | |
| PAUnpostedTotalCostN | PA Unposted Total Cost | Currency | 10 | View | |
| PAUnposted_Overhead | PA Unposted Overhead | Currency | 10 | View | |
| PAUnpostedProfitN | PA Unposted Profit | Currency | 10 | View | |
| PAUnposted_Tax_Amount | PA Unposted Tax Amount | Currency | 10 | View | |
| PAUnpostAccrRevN | PA Unposted Accrued Revenues | Currency | 10 | View | |
| PAUnpostedCommitedQty | PA Unposted Commited Qty | Currency | 10 | View | |
| PAUnpostedCommitedCost | PA Unposted Commited Cost | Currency | 10 | View | |
| PAUnpostedCommitedTaxAmt | PA Unposted Commited Tax Amount | Currency | 10 | View | |
| PAUnpostedRecogRevN | PA Unposted Recognized Revenue | Currency | 10 | View | |
| PAUnposted_Fee_Amount | PA Unposted Fee Amount | Currency | 10 | View | |
| PAUNPOSTBIEEAMOUNT | PA Unposted BIEE Amount | Currency | 10 | View | |
| PAUNPEIEBAMOUNT | PA Unposted EIEB Amount | Currency | 10 | View | |
| PA_Unposted_Billed_Reten | PA Unposted Billed Retention | Currency | 10 | View | |
| PAunpostbillamt | PA Unposted Billed Amount | Currency | 10 | View | |
| PAPostedQty | PA Actual Qty | Currency | 10 | View | |
| PAPostedTotalCostN | PA Actual Total Cost | Currency | 10 | View | |
| PAPosted_Overhead | PA Actual Overhead | Currency | 10 | View | |
| PAPostedProfitN | PA Actual Profit | Currency | 10 | View | |
| PAPosted_Tax_Amount | PA Actual Tax Amount | Currency | 10 | View | |
| PAPosted_Accr_RevN | PA Actual Accrued Revenues | Currency | 10 | View | |
| PAPostedCommitedQty | PA Actual Commited Qty | Currency | 10 | View | |
| PAPostRecogRevN | PA Actual Recognized Revenue | Currency | 10 | View | |
| PAPostedCommitedCost | PA Actual Commited Cost | Currency | 10 | View | |
| PAPostedCommitedTaxAmt | PA Actual Commited Tax Amount | Currency | 10 | View | |
| PAPosted_Fee_Amount | PA Actual Fee Amount | Currency | 10 | View | |
| PAPOSBIEEAMOUNT | PA Actual BIEE Amount | Currency | 10 | View | |
| PAPOSEIEBAMOUNT | PA Actual EIEB Amount | Currency | 10 | View | |
| PA_Actual_Billed_Retenti | PA Actual Billed Retention | Currency | 10 | View | |
| PApostbillamt | PA Actual Billed Amount | Currency | 10 | View | |
| PAWrite_UpDown_Amount | PA Write Up/Down Amount | Currency | 10 | View | |
| PAApproved_Quantity | PA Approved Quantity | Currency | 10 | View | |
| PARemaining_Quantity | PA Remaining Quantity | Currency | 10 | View | |
| PABilled_QtyN | PA Billed Qty | Currency | 10 | View | |
| PAApproved_Cost | PA Approved Cost | Currency | 10 | View | |
| PARemaining_Cost | PA Remaining Cost | Currency | 10 | View | |
| PABilled_Cost | PA Billed Cost | Currency | 10 | View | |
| PAApproved_Accrued_Reve | PA Approved Accrued Revenues | Currency | 10 | View | |
| PARemaining_Accrued_Rev | PA Remaining Accrued Revenues | Currency | 10 | View | |
| PABilled_Accrued_Revenu | PA Billed Accrued Revenues | Currency | 10 | View | |
| PACostPcntCompleted | PA Cost Percent Completed | Currency | 10 | View | |
| PAQuantityPcntCompleted | PA Quantity Percent Completed | Currency | 10 | View | |
| PA_Receipts_Amount | PA Receipts Amount | Currency | 10 | View | |
| PA_Actual_Receipts_Amoun | PA Actual Receipts Amount | Currency | 10 | View | |
| PA_Earnings | PA Earnings | Currency | 10 | View | |
| PA_Cost_of_Earnings | PA Cost of Earnings | Currency | 10 | View | |
| PAUnpostBillN | PA Unposted Billings | Currency | 10 | View | |
| PAUnpostDiscDolAmtN | PA Unposted Discount Dollar Amount | Currency | 10 | View | |
| PAUnposted_Sales_Tax_Am | PA Unposted Sales Tax Amount | Currency | 10 | View | |
| PAPostedBillingsN | PA Actual Billings | Currency | 10 | View | |
| PAPostedDiscDolAmtN | PA Actual Discount Dollar Amount | Currency | 10 | View | |
| PAPosted_Sales_Tax_Amou | PA Actual Sales Tax Amount | Currency | 10 | View | |
| WROFAMNT | Write Off Amount | Currency | 10 | View | |
| ActualWriteOffAmount | Actual Write Off Amount | Currency | 10 | View | |
| DISTKNAM | Discount Taken Amount | Currency | 10 | View | |
| ActualDiscTakenAmount | Actual Discount Taken Amount | Currency | 10 | View | |
| PACommitted_Costs | PA Committed Costs | Currency | 10 | View | |
| PACommitted_Qty | PA Committed Qty | Currency | 10 | View | |
| PAPOCost | PA PO Cost | Currency | 10 | View | |
| PAPOQty | PA PO Qty | Currency | 10 | View | |
| PAPOPostedCost | PA PO Actual Cost | Currency | 10 | View | |
| PAPOPostedQty | PA PO Actual Qty | Currency | 10 | View | |
| PAtaxpaidamt | PA Tax Paid Amount | Currency | 10 | View | |
| PAPostedTaxPaidN | PA Actual Tax Paid | Currency | 10 | View | |
| PAPOSTRETAMT | PA Actual Retention Amount | Currency | 10 | View | |
| PAUNPOSTRETAMT | PA Unposted Retention Amount | Currency | 10 | View | |
| PA_Write_Off_Tax_Amount | PA Write Off Tax Amount | Currency | 10 | View | |
| PAActualWOTaxAmt | PA Actual Write Off Tax Amount | Currency | 10 | View | |
| PA_Terms_Taken_Tax_Amt | PA Terms Taken Tax Amt | Currency | 10 | View | |
| PAActualTermsTakenTax | PA Actual Terms Taken Tax Amt | Currency | 10 | View | |
| PAPosted_Earnings | PA Actual Earnings | Currency | 10 | View | |
| PAActualCostofEarnings | PA Actual Cost of Earnings | Currency | 10 | View | |
| PAUnpostedLossAmount | PA Unposted Loss Amount | Currency | 10 | View | |
| PAActualLossAmount | PA Actual Loss Amount | Currency | 10 | View |