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

COMPANY..PA42001 Table Definition

(COMPANY..PA Miscellaneous Log Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAsetupkey smallint
0

PAMLdefinedprompt1 char(15)
''

PAMLdefinedprompt2 char(15)
''

PAcostdesceML char(21)
''

PAMISCLdoccounter char(17)
''

PAMLunitcostfrom smallint
0

PAMLprofittypefrom smallint
0

PAdescriptionfrom smallint
0

PAreportingperiods smallint
0

PAnumofreportingperiods smallint
0

PA1stdatereportperiod datetime
'1/1/1900'

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

PAdexcriptionoptions_1 char(51)
''

PAdexcriptionoptions_2 char(51)
''

PAdexcriptionoptions_3 char(51)
''

PAdexcriptionoptions_4 char(51)
''

PAdexcriptionoptions_5 char(51)
''

PAdexcriptionoptions_6 char(51)
''

PAdexcriptionoptions_7 char(51)
''

PAdexcriptionoptions_8 char(51)
''

PAdexcriptionoptions_9 char(51)
''

PAdexcriptionoptions_10 char(51)
''

PAdexcriptionoptions_11 char(51)
''

PAdexcriptionoptions_12 char(51)
''

PAdexcriptionoptions_13 char(51)
''

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)
''

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