| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| PAFeeID |
char(15)
''
|
PA Fee ID ...(more) Join Now
|
|
|
|
| PAFeeName |
char(31)
''
|
The descri...(more) Join Now
|
|
|
|
| PAFeeType |
smallint
0
|
In additio...(more) Join Now
|
|
|
|
| PAFeeAmount |
numeric(19,5)
0.00
|
PA Fee Amo...(more) Join Now
|
|
|
|
| PAPercent_Cost |
numeric(19,5)
0.00
|
PA Percent...(more) Join Now
|
|
|
|
| PAPercent_Revenue |
numeric(19,5)
0.00
|
PA Percent...(more) Join Now
|
|
|
|
| PA_Retention_Percent |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PAFeeToUse |
smallint
0
|
PA Fee To ...(more) Join Now
|
|
|
|
| PAbilltaxscheduleid |
char(15)
''
|
PA Billing...(more) Join Now
|
|
|
|
| PASales_Tax_Options |
smallint
0
|
PA Sales T...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAbegindate |
datetime
'1/1/1900'
|
PA Begin D...(more) Join Now
|
|
|
|
| PAEnDate |
datetime
'1/1/1900'
|
PA End Dat...(more) Join Now
|
|
|
|
| PAFrequency |
smallint
0
|
PA Frequen...(more) Join Now
|
|
|
|
| STRTDATE |
datetime
'1/1/1900'
|
Start Date...(more) Join Now
|
|
|
|
| ENDDATE |
datetime
'1/1/1900'
|
End Date ...(more) Join Now
|
|
|
|
| PARenew |
tinyint
0
|
PA Renew ...(more) Join Now
|
|
|
|
| PARenewal_Date |
datetime
'1/1/1900'
|
PA Renewal...(more) Join Now
|
|
|
|
| PATotAmt |
numeric(19,5)
0.00
|
PA Total A...(more) Join Now
|
|
|
|
| TM_AR_Fee_SRC |
smallint
0
|
TM AR Fee ...(more) Join Now
|
|
|
|
| TM_Prj_Deferred_Rev_Fee_ |
smallint
0
|
TM Prj Def...(more) Join Now
|
|
|
|
| TM_Prj_Rev_Fee_SRC |
smallint
0
|
TM Prj Rev...(more) Join Now
|
|
|
|
| PAFF_AR_Fee_SRC |
smallint
0
|
FF AR Fee ...(more) Join Now
|
|
|
|
| FF_Prj_Billings_Fee_SRC |
smallint
0
|
FF Prj Bil...(more) Join Now
|
|
|
|
| FF_Prj_Rev_Fee_SRC |
smallint
0
|
FF Prj Rev...(more) Join Now
|
|
|
|
| FF_Retention_Fee_SRC |
smallint
0
|
FF Retenti...(more) Join Now
|
|
|
|
| FF_WIP_Fee_SRC |
smallint
0
|
FF WIP Fee...(more) Join Now
|
|
|
|
| FF_Prj_Deferred_Rev_Fee_ |
smallint
0
|
FF Prj Def...(more) Join Now
|
|
|
|
| FF_BIEE_Fee_SRC |
smallint
0
|
FF BIEE Fe...(more) Join Now
|
|
|
|
| FF_EIEB_Fee_SRC |
smallint
0
|
FF EIEB Fe...(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
|
|
|
|
| PA_Renew_Day |
smallint
0
|
PA Renew D...(more) Join Now
|
|
|
|
| PA_Renew_Month |
smallint
0
|
PA Renew M...(more) Join Now
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PAService_Fee_Amount |
numeric(19,5)
0.00
|
PA Service...(more) Join Now
|
|
|
|
| PA_MC_Fee_Amount |
numeric(19,5)
0.00
|
PA MC Fee ...(more) Join Now
|
|
|
|
| PA_MC_Service_Fee_Amount |
numeric(19,5)
0.00
|
PA MC Serv...(more) Join Now
|
|
|
|
| PA_MC_Total_Amount |
numeric(19,5)
0.00
|
PA MC Tota...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|