| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PATRKCHGORDS |
tinyint
0
|
|
|
|
|
| PATRKCOBDGADDFLY |
tinyint
0
|
|
|
|
|
| PATOTCHGORDAMT |
numeric(19,5)
0.00
|
PA Total C...(more) Join Now
|
PA01301.PATOTCHGORDAMT
|
|
|
| PANOPENDCO |
smallint
0
|
|
|
|
|
| PANUMCO |
smallint
0
|
|
|
|
|
| PACOBASEPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAUNPRRTOTPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PACOBSLNFEEPROJAMT |
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
|
|
|
| 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
|
|
|
|
| PAACREV |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostRecogRevN |
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
|
|
|
|
| PApostbillamt |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
PA01301.PApostbillamt
|
|
|
| PA_Actual_Receipts_Amoun |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedBillingsN |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostedDiscDolAmtN |
numeric(19,5)
0.00
|
|
|
|
|
| PAPosted_Sales_Tax_Amou |
numeric(19,5)
0.00
|
|
|
|
|
| ActualWriteOffAmount |
numeric(19,5)
0.00
|
Actual Wri...(more) Join Now
|
|
|
|
| ActualDiscTakenAmount |
numeric(19,5)
0.00
|
Actual Dis...(more) Join Now
|
|
|
|
| PAactjtaxpd |
numeric(19,5)
0.00
|
|
|
|
|
| PAPOSTRETAMT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAActualWOTaxAmt |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAActualTermsTakenTax |
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
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|