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

COMPANY..PA00401 Table Definition

(COMPANY..PA Fee Master File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
PAFrequency smallint
0
PA Frequen...(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
PAFeeAmount numeric(19,5)
0.00
PA Fee Amo...(more) Join Now
PASales_Tax_Options smallint
0
PA Sales T...(more) Join Now
PAbilltaxscheduleid char(15)
''
PA Billing...(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
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
PANOTEINDEX numeric(19,5)
0.00
PA Note In...(more) Join Now PA01001.PANOTEINDEX
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
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