| PACTID |
char(15)
''
|
|
|
|
|
| PAPTID |
char(15)
''
|
|
|
|
|
| PAPTN |
char(31)
''
|
|
|
|
|
| PAPROJNUMSEG |
char(5)
''
|
|
|
|
|
| PAprjclsid |
char(15)
''
|
|
|
|
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PAAcctgMethod |
smallint
0
|
Useful in ...(more) Join Now
|
|
|
|
| PASTAT |
smallint
0
|
Contains t...(more) Join Now
|
|
|
|
| PADepartment |
char(7)
''
|
|
|
|
|
| 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
|
|
|
|
| PABTotalCost |
numeric(19,5)
0.00
|
Total cost...(more) Join Now
|
|
|
|
| PABProfit |
numeric(19,5)
0.00
|
Baseline p...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| PAEstimatorID |
char(15)
''
|
|
|
|
|
| PAprojmngrid |
char(15)
''
|
|
|
|
|
| PABusMgrID |
char(15)
''
|
The busine...(more) Join Now
|
|
|
|
| LOCATNID |
char(15)
''
|
The locati...(more) Join Now
|
|
|
join ... more text available
|
| COMPRCNT |
smallint
0
|
The Commis...(more) Join Now
|
|
|
|
| COMAPPTO |
smallint
0
|
The method...(more) Join Now
|
|
|
|
| PALabor_Rate_Table_ID |
char(31)
''
|
PA Labor R...(more) Join Now
|
PA01301.PALabor_Rate_Table_ID
|
|
|
| PALabor_RateTable_Type |
smallint
0
|
PA Labor R...(more) Join Now
|
PA01301.PALabor_RateTable_Type
|
|
|
| PALabor_Rate_Table_Acc |
tinyint
0
|
PA Labor R...(more) Join Now
|
PA01301.PALabor_Rate_Table_Acc
|
|
|
| PAEquip_Rate_Table_ID |
char(31)
''
|
PA Equip R...(more) Join Now
|
PA01301.PAEquip_Rate_Table_ID
|
|
|
| PAEquip_Rate_Table_Acc |
tinyint
0
|
PA Equip R...(more) Join Now
|
PA01301.PAEquip_Rate_Table_Acc
|
|
|
| PAbllngtype |
smallint
0
|
1=Billable...(more) Join Now
|
|
|
|
| PAProject_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PAProject_Fee_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| PARetentionFeeAmount |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| ACCTAMNT |
numeric(19,5)
0.00
|
Account Am...(more) Join Now
|
|
|
|
| PABILLFORMAT |
char(15)
''
|
The defaul...(more) Join Now
|
|
|
|
| PADiscMetToUse |
smallint
0
|
|
|
|
|
| DISCAMNT |
numeric(19,5)
0.00
|
|
|
|
|
| DSCPCTAM |
smallint
0
|
Discount P...(more) Join Now
|
|
|
|
| PA_Retention_Percent |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PAtotcbts |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbEL |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbML |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbvi |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcber |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbinv |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbfee |
tinyint
0
|
|
|
|
|
| PAUD1Proj |
char(51)
''
|
|
|
|
|
| PAUD2_Proj |
char(51)
''
|
|
|
|
|
| PASegmentCB |
tinyint
0
|
Combine ea...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAbillnoteidxts |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAELbillniteidx |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxML |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxvi |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxee |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxinv |
numeric(19,5)
0.00
|
Stores the...(more) Join Now
|
|
|
|
| PAbillnoteidxfee |
numeric(19,5)
0.00
|
Stores the...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
JC00701.WRKRCOMP
|
|
|
| SUTASTAT |
char(3)
''
|
Suta State...(more) Join Now
|
UPR00401.SUTASTAT
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|