Module List > Module PA tables PA12102
You are currently viewing the COMPANY database.
Change

COMPANY..PA12102 Table Definition

(COMPANY..PA Change Order Fee Detail WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3