| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| PAFeeType |
smallint
0
|
In additio...(more) Join Now
|
|
|
|
| PAPREVFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARFEESAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeeAmount |
numeric(19,5)
0.00
|
PA Fee Amo...(more) Join Now
|
|
|
|
| PA_Prev_Fee_Percent |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARFEEPRCNT |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeePercent |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeeToUse |
smallint
0
|
PA Fee To ...(more) Join Now
|
|
|
|
| PASales_Tax_Options |
smallint
0
|
PA Sales T...(more) Join Now
|
|
|
|
| PAbilltaxscheduleid |
char(15)
''
|
PA Billing...(more) Join Now
|
|
|
|
| PAPREVBILLTXSCHED |
char(15)
''
|
|
|
|
|
| PAbegindate |
datetime
'1/1/1900'
|
PA Begin D...(more) Join Now
|
|
|
|
| PAPREVBEGINDT |
datetime
'1/1/1900'
|
|
|
|
|
| PAEnDate |
datetime
'1/1/1900'
|
PA End Dat...(more) Join Now
|
|
|
|
| PAPREVENDDT |
datetime
'1/1/1900'
|
|
|
|
|
| PAFrequency |
smallint
0
|
PA Frequen...(more) Join Now
|
|
|
|
| PAPREVFREQ |
smallint
0
|
|
|
|
|
| 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
|
|
|
|
| PAPREVTOTAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Renew_Day |
smallint
0
|
PA Renew D...(more) Join Now
|
|
|
|
| PA_Renew_Month |
smallint
0
|
PA Renew M...(more) Join Now
|
|
|
|
| PAsequencenumber |
smallint
0
|
|
|
|
|
| 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
|
|
|
|
| TM_BIEE_Fee_SRC |
smallint
0
|
|
|
|
|
| TM_EIEB_Fee_SRC |
smallint
0
|
|
|
|
|
| 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
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAPosted_Project_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Retainer_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSTRETAMT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Service_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|