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

COMPANY..PA42401 Table Definition

(COMPANY..PA Employee Expense Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAsetupkey smallint
0

PAerdefinedprompt1 char(15)
''

PAerdefinedprompt2 char(15)
''

PAcostdescer char(21)
''

PAerdoccounter char(17)
''

PAVIDROAer smallint
0

PAeeprofittypefrom smallint
0

PAdescriptionfrom smallint
0

USEADVTX smallint
0
Use Advanc...(more) Join Now POP40100.USEADVTX
TAXSCHID char(15)
''

join ... more text available
PAMisc_Taxable_P smallint
0

MSCSCHID char(15)
''
Misc Sched...(more) Join Now RM20101.MSCSCHID
join ... more text available
PAFreight_Taxable_P smallint
0

FRTSCHID char(15)
''
Freight Sc...(more) Join Now RM20101.FRTSCHID
join ... more text available
PAallow_1 tinyint
0

PAallow_2 tinyint
0

PAallow_3 tinyint
0

PAallow_4 tinyint
0

PAallow_5 tinyint
0

PAallow_6 tinyint
0

PAallow_7 tinyint
0

PAallow_8 tinyint
0

PAallow_9 tinyint
0

PAallow_10 tinyint
0

PAallow_11 tinyint
0

PAallow_12 tinyint
0

PAallow_13 tinyint
0

PApasswordoptions_1 char(11)
''

PApasswordoptions_2 char(11)
''

PApasswordoptions_3 char(11)
''

PApasswordoptions_4 char(11)
''

PApasswordoptions_5 char(11)
''

PApasswordoptions_6 char(11)
''

PApasswordoptions_7 char(11)
''

PApasswordoptions_8 char(11)
''

PApasswordoptions_9 char(11)
''

PApasswordoptions_10 char(11)
''

PApasswordoptions_11 char(11)
''

PApasswordoptions_12 char(11)
''

PApasswordoptions_13 char(11)
''

PAbillnoteidx numeric(19,5)
0.00
PA Billing...(more) Join Now
PAExpenseType smallint
0
1-Reimburs...(more) Join Now
PAPaymentMethod smallint
0

PApostoDynPM tinyint
0

PA_Update_Periodic_Opt smallint
0

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