| CUSTNMBR |
char(15)
''
|
Customer c...(more) Join Now
|
|
|
join ... more text available
|
| PAcustalias |
char(5)
''
|
|
|
|
|
| PAcloseProjcosts |
tinyint
0
|
Allow or d...(more) Join Now
|
|
|
|
| PAclosetobillings |
tinyint
0
|
Allow or d...(more) Join Now
|
|
|
|
| PABILLFORMAT |
char(15)
''
|
The defaul...(more) Join Now
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PABQuantity |
numeric(19,5)
0.00
|
Contains t...(more) Join Now
|
|
|
|
| PABTotalCost |
numeric(19,5)
0.00
|
Total cost...(more) Join Now
|
|
|
|
| PABBillings |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABProfit |
numeric(19,5)
0.00
|
Baseline p...(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
|
|
|
|
| PAFTotalCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFBillings |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFProfit |
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
|
|
|
|
| PAProject_Amount |
numeric(19,5)
0.00
|
PA Project...(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_Project_Fee |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Retainer_Fee |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Service_Fee |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPOSTRETAMT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PA_Unposted_Billed_Reten |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPOSTBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| PA_Actual_Billed_Retenti |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedCommitedQty |
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
|
|
|
|
| PAPostRecogRevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Project_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Retainer_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Service_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSTRETAMT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAWrite_UpDown_Amount |
numeric(19,5)
0.00
|
PA Write U...(more) Join Now
|
|
|
|
| PABilled_QtyN |
numeric(19,5)
0.00
|
PA Billed ...(more) Join Now
|
|
|
|
| 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.
|
|
|
|
| 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
|
|
|
|
|
| PAService_Fee_Amount |
numeric(19,5)
0.00
|
PA Service...(more) Join Now
|
|
|
|
| PARetainer_Fee_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PAProject_Fee_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PARetentionFeeAmount |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PABCWPAMT |
numeric(19,5)
0.00
|
PA BCWP Am...(more) Join Now
|
|
|
|
| PABCWSAMT |
numeric(19,5)
0.00
|
PA BCWS Amount Currency storage type, keyable length: 17, storage size: 10.
|
|
|
|
| PAACWPAMT |
numeric(19,5)
0.00
|
PA ACWP Am...(more) Join Now
|
|
|
|
| PAApproved_Accrued_Reve |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| PAApproved_Cost |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| PAApproved_Quantity |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| PApretainage |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAunpretainage |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PA_Actual_Freight_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Unposted_Freight_Amou |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Actual_Misc_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Unposted_Misc_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| 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
|
|
|
|
| PANOPENDCO |
smallint
0
|
|
|
|
|
| PANUMCO |
smallint
0
|
|
|
|
|
| PACOBASEPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PACOBSLNFEEPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAUNPRRTOTPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAUNABSTOTBILL |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNABSTOTBILL
|
|
|
| PAUNPBSTOTCST |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNPBSTOTCST
|
|
|
| PAUNPBSLTOTPROF |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNPBSLTOTPROF
|
|
|
| PAUNPBSTOTQTY |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNPBSTOTQTY
|
|
|
| PAUNAPFRTOTBILL |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNAPFRTOTBILL
|
|
|
| PAUNAPPFRTOTCST |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNAPPFRTOTCST
|
|
|
| PAUNFRCTOTPROF |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNFRCTOTPROF
|
|
|
| PAUNPFRTOTQTY |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
PA01301.PAUNPFRTOTQTY
|
|
|
| PATOTCHGORDAMT |
numeric(19,5)
0.00
|
PA Total C...(more) Join Now
|
PA01301.PATOTCHGORDAMT
|
|
|
| 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
|
|
|
|
| PAFQLaborOnly |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAAQLaborOnly |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|