| PACTID |
char(15)
''
|
|
|
|
|
| PACTN |
char(31)
''
|
|
|
|
|
| PALONGID_1 |
char(9)
''
|
The long c...(more) Join Now
|
|
|
|
| PALONGID_2 |
char(9)
''
|
|
|
|
|
| PALONGID_3 |
char(9)
''
|
|
|
|
|
| PALONGID_4 |
char(9)
''
|
|
|
|
|
| PALONGID_5 |
char(9)
''
|
|
|
|
|
| PAcontclassid |
char(15)
''
|
Contains t...(more) Join Now
|
|
|
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PAAcctgMethod |
smallint
0
|
Useful in ...(more) Join Now
|
|
|
|
| PASTAT |
smallint
0
|
Contains t...(more) Join Now
|
|
|
|
| PAContMgrID |
char(15)
''
|
The contra...(more) Join Now
|
|
|
|
| PABusMgrID |
char(15)
''
|
The busine...(more) Join Now
|
|
|
|
| LOCATNID |
char(15)
''
|
The locati...(more) Join Now
|
|
|
join ... more text available
|
| COMAPPTO |
smallint
0
|
The method...(more) Join Now
|
|
|
|
| PABILLFORMAT |
char(15)
''
|
The defaul...(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
|
|
|
|
| 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
|
|
|
|
| PAUD1_Cont |
char(51)
''
|
Enter a us...(more) Join Now
|
|
|
|
| PAUD2_Cont |
char(51)
''
|
Enter a us...(more) Join Now
|
|
|
|
| PASegmentCB |
tinyint
0
|
Combine ea...(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
|
|
|
|
| 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
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|