| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PAsfid |
smallint
0
|
PA Source ...(more) Join Now
|
PA01301.PAsfid
|
|
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PERIODID |
smallint
0
|
|
|
|
|
| YEAR1 |
smallint
0
|
Year...(more) Join Now
|
SY40101.YEAR1
|
|
|
| PAPeriodStartDate |
datetime
'1/1/1900'
|
|
|
|
|
| PAPeriodEndDate |
datetime
'1/1/1900'
|
|
|
|
|
| PERIODDT |
datetime
'1/1/1900'
|
|
|
|
|
| PAACTUALBEGDATE |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PA_Actual_End_Date |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PABQuantity |
numeric(19,5)
0.00
|
Contains t...(more) Join Now
|
|
|
|
| PAFeeAmount |
numeric(19,5)
0.00
|
PA Fee Amo...(more) Join Now
|
|
|
|
| PABUnitCost |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
PA01301.PABUnitCost
|
|
|
| PABTotalCost |
numeric(19,5)
0.00
|
Total cost...(more) Join Now
|
|
|
|
| PABProfit |
numeric(19,5)
0.00
|
Baseline p...(more) Join Now
|
|
|
|
| PABProfitAmt |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
PA01301.PABProfitAmt
|
|
|
| PABBillings |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABTaxPaidAmt |
numeric(19,5)
0.00
|
The sum of...(more) Join Now
|
|
|
|
| PABTaxChargedAmt |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABaselineOvhdCost |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PAFQuantity |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFUnitCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
PA01301.PAFUnitCost
|
|
|
| PAFTotalCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFProfit |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFBillings |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTaxPaidAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTaxChargedAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastOvhdCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PAUnpostedQty |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedTotalCostN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Overhead |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedProfitN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Tax_Amount |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostAccrRevN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedCommitedQty |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedCommitedCost |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedCommitedTaxAmt |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedRecogRevN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Fee_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PAUNPOSTBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PA_Unposted_Billed_Reten |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAunpostbillamt |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
PA01301.PAunpostbillamt
|
|
|
| PAPostedQty |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedTotalCostN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Overhead |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedProfitN |
numeric(19,5)
0.00
|
PA Actual Profit PA Actual profit is computed as:
PA Actual Profit = PA Actual Billings – PA Actual Total Cost
|
|
|
|
| PAPosted_Tax_Amount |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Accr_RevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedCommitedQty |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostRecogRevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedCommitedCost |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedCommitedTaxAmt |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Fee_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPOSBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PA_Actual_Billed_Retenti |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PApostbillamt |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
PA01301.PApostbillamt
|
|
|
| PAWrite_UpDown_Amount |
numeric(19,5)
0.00
|
PA Write U...(more) Join Now
|
|
|
|
| PAApproved_Quantity |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| PARemaining_Quantity |
numeric(19,5)
0.00
|
|
|
|
|
| PABilled_QtyN |
numeric(19,5)
0.00
|
PA Billed ...(more) Join Now
|
|
|
|
| PAApproved_Cost |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| PARemaining_Cost |
numeric(19,5)
0.00
|
|
|
|
|
| PABilled_Cost |
numeric(19,5)
0.00
|
PA Billed Cost The total billed cost for the contract. Currency storage type, keyable length: 17, storage size: 10.
|
|
|
|
| PAApproved_Accrued_Reve |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| PARemaining_Accrued_Rev |
numeric(19,5)
0.00
|
|
|
|
|
| PABilled_Accrued_Revenu |
numeric(19,5)
0.00
|
PA Billed ...(more) Join Now
|
|
|
|
| PACostPcntCompleted |
numeric(19,5)
0.00
|
PA Cost Pe...(more) Join Now
|
|
|
|
| PAQuantityPcntCompleted |
numeric(19,5)
0.00
|
PA Quantit...(more) Join Now
|
|
|
|
| PA_Receipts_Amount |
numeric(19,5)
0.00
|
PA Receipt...(more) Join Now
|
|
|
|
| PA_Actual_Receipts_Amoun |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PA_Earnings |
numeric(19,5)
0.00
|
PA Earning...(more) Join Now
|
|
|
|
| PA_Cost_of_Earnings |
numeric(19,5)
0.00
|
table styl...(more) Join Now
|
|
|
|
| PAUnpostBillN |
numeric(19,5)
0.00
|
PA Unposted Billings The sum of all unposted billings for the contract. Currency storage type, keyable length: 17, storage size: 10.
|
|
|
|
| PAUnpostDiscDolAmtN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Sales_Tax_Am |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAPostedBillingsN |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostedDiscDolAmtN |
numeric(19,5)
0.00
|
|
|
|
|
| PAPosted_Sales_Tax_Amou |
numeric(19,5)
0.00
|
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| ActualWriteOffAmount |
numeric(19,5)
0.00
|
Actual Wri...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| ActualDiscTakenAmount |
numeric(19,5)
0.00
|
Actual Dis...(more) Join Now
|
|
|
|
| PACommitted_Costs |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PACommitted_Qty |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PAPOCost |
numeric(19,5)
0.00
|
PA PO Cost...(more) Join Now
|
|
|
|
| PAPOQty |
numeric(19,5)
0.00
|
PA PO Qty ...(more) Join Now
|
|
|
|
| PAPOPostedCost |
numeric(19,5)
0.00
|
PA PO Actu...(more) Join Now
|
|
|
|
| PAPOPostedQty |
numeric(19,5)
0.00
|
PA PO Actu...(more) Join Now
|
|
|
|
| PAtaxpaidamt |
numeric(19,5)
0.00
|
PA Tax Pai...(more) Join Now
|
|
|
|
| PAPostedTaxPaidN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSTRETAMT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAUNPOSTRETAMT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PA_Write_Off_Tax_Amount |
numeric(19,5)
0.00
|
PA Write O...(more) Join Now
|
|
|
|
| PAActualWOTaxAmt |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PA_Terms_Taken_Tax_Amt |
numeric(19,5)
0.00
|
PA Terms T...(more) Join Now
|
|
|
|
| PAActualTermsTakenTax |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Earnings |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAActualCostofEarnings |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAUnpostedLossAmount |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAActualLossAmount |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|