| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PACOTRKCHGBY |
smallint
0
|
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(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
|
| PAPREVBEGINDT |
datetime
'1/1/1900'
|
|
|
|
|
| PAbegindate |
datetime
'1/1/1900'
|
PA Begin D...(more) Join Now
|
|
|
|
| PAPREVENDDT |
datetime
'1/1/1900'
|
|
|
|
|
| PAEnDate |
datetime
'1/1/1900'
|
PA End Dat...(more) Join Now
|
|
|
|
| PAPREVPYCDESLY |
char(7)
''
|
|
|
|
|
| PAPay_Code_Salary |
char(7)
''
|
PA Pay Cod...(more) Join Now
|
PA01001.PAPay_Code_Salary
|
|
|
| PAPREVPYCODEHOURLY |
char(7)
''
|
|
|
|
|
| PAPay_Code_Hourly |
char(7)
''
|
PA Pay Cod...(more) Join Now
|
PA01001.PAPay_Code_Hourly
|
|
|
| PAProfitType |
smallint
0
|
PA Profit ...(more) Join Now
|
|
|
|
| PAbllngtype |
smallint
0
|
1=Billable...(more) Join Now
|
|
|
|
| PAPREVPURCHTXOPT |
smallint
0
|
|
|
|
|
| PAPurchase_Tax_Options |
smallint
0
|
PA Purchas...(more) Join Now
|
|
|
|
| PAPREVCOSTXSCHED |
char(15)
''
|
|
|
|
|
| PAPURCHTAXSCHED |
char(15)
''
|
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| PAPREVSALESTXOPT |
smallint
0
|
|
|
|
|
| PASales_Tax_Options |
smallint
0
|
PA Sales T...(more) Join Now
|
|
|
|
| PAPREVBILLTXSCHED |
char(15)
''
|
|
|
|
|
| PAbilltaxscheduleid |
char(15)
''
|
PA Billing...(more) Join Now
|
|
|
|
| PAVarianceQty |
numeric(19,5)
0.00
|
|
|
|
|
| PAQtyQ |
numeric(19,5)
0.00
|
|
|
|
|
| PAVarianceCosts |
numeric(19,5)
0.00
|
|
|
|
|
| PAUNITCOST |
numeric(19,5)
0.00
|
PA Unit Co...(more) Join Now
|
|
|
|
| PAVARTOTCOST |
numeric(19,5)
0.00
|
|
|
|
|
| PAVAROVERHDAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PATOTALOVERH |
numeric(19,5)
0.00
|
|
|
|
|
| PAVAROVERHDPRCNT |
numeric(19,5)
0.00
|
|
|
|
|
| PAOverheaPercentage |
numeric(19,5)
0.00
|
PA Overhea...(more) Join Now
|
|
|
|
| PAVAROVRHDUNIT |
numeric(19,5)
0.00
|
|
|
|
|
| PAOvhdAmtPerUnit |
numeric(19,5)
0.00
|
PA Overhea...(more) Join Now
|
PA01001.PAOvhdAmtPerUnit
|
|
|
| PATOTCST |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARMUPRCNT |
numeric(19,5)
0.00
|
|
|
|
|
| PAProfitPercent |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARPROFAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAProfitAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARTOTLPROF |
numeric(19,5)
0.00
|
|
|
|
|
| PATotalProfit |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARTOTBILLINGS |
numeric(19,5)
0.00
|
|
|
|
|
| PAtotbillings |
numeric(19,5)
0.00
|
|
|
|
|
| PAORIGBUDGTAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAROGPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAProject_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PAPREVPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAPREVBASEQTY |
numeric(19,5)
0.00
|
|
|
|
|
| PABase_Qty |
numeric(19,5)
0.00
|
PA Base Qt...(more) Join Now
|
|
|
|
| PAPREVBSEUNTCST |
numeric(19,5)
0.00
|
|
|
|
|
| PABase_Unit_Cost |
numeric(19,5)
0.00
|
PA Base Un...(more) Join Now
|
|
|
|
| PAPREVBSOVERHDCST |
numeric(19,5)
0.00
|
|
|
|
|
| PABaseOvhdCost |
numeric(19,5)
0.00
|
PA Base Ov...(more) Join Now
|
PA01301.PABaseOvhdCost
|
|
|
| PAPREVBSPROFAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PABaseProfitAmount |
numeric(19,5)
0.00
|
PA Base Pr...(more) Join Now
|
PA01301.PABaseProfitAmount
|
|
|
| PAPROPQUOTEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAFINQUOTEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAQUOTEPREPBY |
char(21)
''
|
|
|
|
|
| PAQUOTEAPPRVBY |
char(21)
''
|
|
|
|
|
| PAREVBUDGTAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAREVPROJAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAsequencenumber |
smallint
0
|
|
|
|
|
| APPRVLDT |
datetime
'1/1/1900'
|
Approval D...(more) Join Now
|
|
|
|
| PAClose_CB |
tinyint
0
|
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| PAPostedTaxPaidN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|