| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PAIV_Item_Checkbox |
tinyint
0
|
1 = Is Lin...(more) Join Now
|
|
|
|
| PASTAT |
smallint
0
|
Contains t...(more) Join Now
|
|
|
|
| PAProfitType |
smallint
0
|
PA Profit ...(more) Join Now
|
|
|
|
| PAbllngtype |
smallint
0
|
1=Billable...(more) Join Now
|
|
|
|
| PABase_Qty |
numeric(19,5)
0.00
|
PA Base Qt...(more) Join Now
|
|
|
|
| PABase_Unit_Cost |
numeric(19,5)
0.00
|
PA Base Un...(more) Join Now
|
|
|
|
| PABaseProfitAmount |
numeric(19,5)
0.00
|
PA Base Pr...(more) Join Now
|
|
|
|
| PABaseOvhdCost |
numeric(19,5)
0.00
|
PA Base Ov...(more) Join Now
|
|
|
|
| PAForecastBaseOvrhdAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastBaseQty |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastBaseUnitCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastBaseProfitAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PABBeginDate |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PABEndDate |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PABQuantity |
numeric(19,5)
0.00
|
Contains t...(more) Join Now
|
|
|
|
| PABUnitCost |
numeric(19,5)
0.00
|
PA Baselin...(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
|
|
|
|
| PABProfitAmt |
numeric(19,5)
0.00
|
p>PA Basel...(more) Join Now
|
|
|
|
| PABProfitPcnt |
numeric(19,5)
0.00
|
p>PA Basel...(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
|
|
|
|
| PABaselinePTaxOptions |
smallint
0
|
PA Baselin...(more) Join Now
|
|
|
|
| PABaselineCTaxSchedID |
char(15)
''
|
PA Baselin...(more) Join Now
|
|
|
|
| PABaselineSTaxOptions |
smallint
0
|
PA Baselin...(more) Join Now
|
|
|
|
| PABaselineBTaxSchedID |
char(15)
''
|
PA Baselin...(more) Join Now
|
|
|
|
| PAACTUALBEGDATE |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PA_Actual_End_Date |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PAFBeginDate |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PAFEndDate |
datetime
'1/1/1900'
|
The beginn...(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
|
|
|
|
| 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
|
|
|
|
| PAFProfitAmt |
numeric(19,5)
0.00
|
p>PA Forec...(more) Join Now
|
|
|
|
| PAFProfitPcnt |
numeric(19,5)
0.00
|
p>PA Forec...(more) Join Now
|
|
|
|
| PAForecastOvhdCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastPTaxOptions |
smallint
0
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastCTaxSchedID |
char(15)
''
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastSTaxOptions |
smallint
0
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastBTaxSchedID |
char(15)
''
|
PA Forecas...(more) Join Now
|
|
|
|
| PAUnit_of_Measure |
char(9)
''
|
PA Unit of...(more) Join Now
|
|
|
|
| UOMSCHDL |
char(11)
''
|
U Of M Sch...(more) Join Now
|
|
|
join ... more text available
|
| PAUOfMMult |
numeric(19,5)
0.00
|
PA UofM Mu...(more) Join Now
|
|
|
See I... more text available
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| PAPay_Code_Hourly |
char(7)
''
|
PA Pay Cod...(more) Join Now
|
PA01001.PAPay_Code_Hourly
|
|
|
| PAPay_Code_Salary |
char(7)
''
|
PA Pay Cod...(more) Join Now
|
PA01001.PAPay_Code_Salary
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| PALabor_Rate_Table_ID |
char(31)
''
|
PA Labor R...(more) Join Now
|
|
|
|
| PALabor_RateTable_Type |
smallint
0
|
PA Labor R...(more) Join Now
|
|
|
|
| PALabor_Rate_Table_Acc |
tinyint
0
|
PA Labor R...(more) Join Now
|
|
|
|
| PAEquip_Rate_Table_ID |
char(31)
''
|
PA Equip R...(more) Join Now
|
|
|
|
| PAEquip_Rate_Table_Acc |
tinyint
0
|
PA Equip R...(more) Join Now
|
|
|
|
| TM_WIP_SRC |
smallint
0
|
TM WIP SRC...(more) Join Now
|
|
|
|
| TM_COGS_SRC |
smallint
0
|
TM COGS SR...(more) Join Now
|
|
|
|
| TM_Cost_Contra_SRC |
smallint
0
|
TM Cost Co...(more) Join Now
|
|
|
|
| TM_Unbilled_AR_SRC |
smallint
0
|
TM Unbille...(more) Join Now
|
|
|
|
| TM_Unbilled_Rev_SRC |
smallint
0
|
TM Unbille...(more) Join Now
|
|
|
|
| TM_AR_SRC |
smallint
0
|
TM AR SRC ...(more) Join Now
|
|
|
|
| TM_Prj_Rev_SRC |
smallint
0
|
TM Prj Rev...(more) Join Now
|
|
|
|
| TM_OVHD_SRC |
smallint
0
|
TM OVHD SR...(more) Join Now
|
|
|
|
| FF_WIP_SRC |
smallint
0
|
FF WIP SRC...(more) Join Now
|
|
|
|
| FF_Cost_Contra_SRC |
smallint
0
|
FF Cost Co...(more) Join Now
|
|
|
|
| FF_AR_SRC |
smallint
0
|
FF AR SRC ...(more) Join Now
|
|
|
|
| FF_Prj_Billings_SRC |
smallint
0
|
FF Prj Bil...(more) Join Now
|
|
|
|
| FF_Prj_Expense_SRC |
smallint
0
|
FF Prj Exp...(more) Join Now
|
|
|
|
| FF_Prj_Revenue_SRC |
smallint
0
|
FF Prj Rev...(more) Join Now
|
|
|
|
| FF_Prj_Loss_SRC |
smallint
0
|
FF Prj Los...(more) Join Now
|
|
|
|
| FF_BIEE_SRC |
smallint
0
|
FF BIEE SR...(more) Join Now
|
|
|
|
| FF_EIEB_SRC |
smallint
0
|
FF EIEB SR...(more) Join Now
|
|
|
|
| FF_OVHD_SRC |
smallint
0
|
FF OVHD SR...(more) Join Now
|
|
|
|
| PAProject_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PAOverheadRateMethod |
smallint
0
|
PA Overhea...(more) Join Now
|
PA01001.PAOverheadRateMethod
|
|
|
| PABaselineOvhdAmtPerUnit |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABaselineOvrhdPct |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PAForecastOvrhdAmtPerUnt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastOvrhdPct |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAUBeginDate |
datetime
'1/1/1900'
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUEndDate |
datetime
'1/1/1900'
|
PA Unposte...(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
|
|
|
|
| PAUNPOSTBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAunpostbillamt |
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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
|
| 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
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAUnpostedRecogRevN |
numeric(19,5)
0.00
|
PA Unposte...(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
|
|
|
|
| PACommitted_Costs |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PACommitted_Qty |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PAPOQty |
numeric(19,5)
0.00
|
PA PO Qty ...(more) Join Now
|
|
|
|
| PAPOCost |
numeric(19,5)
0.00
|
PA PO Cost...(more) Join Now
|
|
|
|
| PAPOPostedQty |
numeric(19,5)
0.00
|
PA PO Actu...(more) Join Now
|
|
|
|
| PAPOPostedCost |
numeric(19,5)
0.00
|
PA PO Actu...(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
|
|
|
|
| PAsfid |
smallint
0
|
PA Source ...(more) Join Now
|
|
|
|
| PAPreviouslyOpen |
tinyint
0
|
PA Previou...(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
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PAUNAPPRVPROJAMT |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNAPFRTOTBILL |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNAPPFRTOTCST |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNFRCTOTPROF |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNPFRTOTQTY |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNABSTOTBILL |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNPBSTOTCST |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNPBSLTOTPROF |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PAUNPBSTOTQTY |
numeric(19,5)
0.00
|
PA Unappro...(more) Join Now
|
|
|
|
| PATOTCHGORDAMT |
numeric(19,5)
0.00
|
PA Total C...(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
|
|
|
|
| PAMCCURNCYID |
char(15)
''
|
PA MC Curr...(more) Join Now
|
|
|
|
| PAMCBProfitAmt |
numeric(19,5)
0.00
|
PA MC Base...(more) Join Now
|
|
|
|
| PAMCBBillings |
numeric(19,5)
0.00
|
PA MC Base...(more) Join Now
|
|
|
|
| PAMCFProfitAmt |
numeric(19,5)
0.00
|
PA MC Fore...(more) Join Now
|
|
|
|
| PAMCFBillings |
numeric(19,5)
0.00
|
PA MC Fore...(more) Join Now
|
|
|
|
| PAMCBaseProfitAmount |
numeric(19,5)
0.00
|
PA MC Base...(more) Join Now
|
|
|
|
| PAMCForecastBProfitAmt |
numeric(19,5)
0.00
|
PA MC Fore...(more) Join Now
|
|
|
|
| PAMCProjectAmount |
numeric(19,5)
0.00
|
PA MC Proj...(more) Join Now
|
|
|
|
| PAMCActualBillings |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PAMCActualDiscountAmt |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PAMCActualSalesTaxAmt |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PAMCUnpostBillN |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PAMCUnpostedDiscount |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PAMCUnpostedSalesTax |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PABILLMIN |
numeric(19,5)
0.00
|
|
|
|
|
| PAMCBILLMIN |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|