|
report_path
|
varchar/varchar2
|
75
|
Within the Reporting Information, this data is
labeled, Crystal's RPT Default Location.
|
|
report_output
|
varchar/varchar2
|
75
|
Within the Reporting Information, this data is
labeled, HTML Report Location.
|
|
template_path
|
varchar/varchar2
|
75
|
Within the Reporting Information, this data is
labeled, Report Template Format Location.
|
|
institution_name
|
varchar/varchar2
|
60
|
Within the Reporting Information, this data is
labeled, Institution Name.
|
|
mill_internet_path
|
varchar/varchar2
|
75
|
Within the System Settings, this data is labeled,
Internet Directory.
|
|
sql_database
|
varchar/varchar2
|
30
|
Within the System Settings, this data is
labeled, Database Server.
|
|
version
|
varchar/varchar2
|
30
|
This is an internal tracking of the version number
of the Millennium software that is in place.
|
|
registration
|
varchar/varchar2
|
30
|
Reserved for future use.
|
|
max_frequency
|
numeric/number
|
5
|
This sets the timing interval for the system to
execute Assignment checking. Individual assignments may be given their
own interval, but they will not execute more frequently than the interval
defined in this field. Defaults to 240.
|
|
GNP_search
|
char
|
1
|
Reserved for future use.
|
|
default_UNC
|
varchar
|
128
|
This allows the institution to specify a default
location for Export worktables.
|
|
site_license
|
varchar
|
35
|
This contains Millennium licensing information.
|
|
site_code
|
varchar
|
20
|
This contains Millennium licensing information.
|
|
site_replicate
|
char
|
1
|
This is a flag indicating whether a site does or
does not use replication.
|
|
site_repl_server
|
varchar
|
128
|
This is the name of the replication server in use
(if any.)
|
|
match_tender_default
|
char
|
6
|
This allows a site to specify the method of Tender
that they want to use as a default for the automatic prompted Matching
Pledge and Match Potential transactions. Controlled by the Tender lookup
table.
|
|
super_delete_warning
|
char
|
1
|
This allows a site to use (or not use) a warning
message that all of a constituent's data is about to be deleted when the
Basic Data is deleted.
|
|
ecomm_pub_00
|
char
|
1
|
This allows a site to control the publication of
any Basic Data information for any constituent.
|
|
ecomm_upd_00
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Basic Data information for
any constituent.
|
|
ecomm_pub_01
|
char
|
1
|
This allows a site to control the publication of
any Name information for any constituent.
|
|
ecomm_upd_01
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Name information for any
constituent.
|
|
ecomm_pub_02
|
char
|
1
|
This allows a site to control the publication of
any Address information for any constituent.
|
|
ecomm_upd_02
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Address information for
any constituent.
|
|
ecomm_pub_03
|
char
|
1
|
This allows a site to control the publication of
any Attribute information for any constituent.
|
|
ecomm_upd_03
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Attribute information for
any constituent.
|
|
ecomm_pub_04
|
char
|
1
|
This allows a site to control the publication of
any Relationship information for any constituent.
|
|
ecomm_upd_04
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Relationship information
for any constituent.
|
|
ecomm_pub_05
|
char
|
1
|
This allows a site to control the publication of
any Gift information for any constituent.
|
|
ecomm_upd_05
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Gift information for any
constituent.
|
|
ecomm_pub_06
|
char
|
1
|
This allows a site to control the publication of
any Employment information for any constituent.
|
|
ecomm_upd_06
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Employment information for
any constituent.
|
|
ecomm_pub_07
|
char
|
1
|
This allows a site to control the publication of
any Education information for any constituent.
|
|
ecomm_upd_07
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Education information for
any constituent.
|
|
ecomm_pub_08
|
char
|
1
|
This allows a site to control the publication of
any Dues information for any constituent.
|
|
ecomm_upd_08
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Dues information for any
constituent.
|
|
ecomm_pub_26
|
char
|
1
|
This allows a site to control the publication of
any Phone information for any constituent.
|
|
ecomm_upd_26
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Phone information for any
constituent.
|
|
ecomm_pub_28
|
char
|
1
|
This allows a site to control the publication of
any Membership information for any constituent.
|
|
ecomm_upd_28
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Membership information for
any constituent.
|
|
display_type
|
char
|
1
|
This is always set to Customizer.
|
|
update_directly
|
char
|
1
|
This allows a site to have the information entered
by using the Online Constituent Directory update automatically.
|
|
degree_of_separation
|
numeric/number
|
3, 0
|
This allows a site to enter the maximum number
for the Degrees of Separation used in the Relation Tree.
|
|
search_col1
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col2
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col3
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col4
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col5
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col6
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col7
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col8
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col9
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col10
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col11
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col12
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col13
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col14
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col15
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col16
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col17
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col18
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col19
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
search_col20
|
char
|
10
|
Used to customize the Search Results Display screen
|
|
ecomm_email
|
char
|
70
|
This field holds the email to be used as the reply
account under email Options.
|
|
password_user_change
|
char
|
1
|
This Y/N flag indicates whether the users may change
their own password.
|
|
password_frequency
|
integer
|
|
This allows a site to set the number of days in
which the user must change their password.
|
|
password_min_length
|
integer
|
|
This allows a site to set the minimum required
length for the passwords.
|
|
password_min_numeric
|
integer
|
|
This allows a site to set the minimum number of
numeric characters a user can use in their new password.
|
|
password_min_alpha
|
integer
|
|
This allows a site to set the minimum number of
alphabetic characters a user can use in their new password.
|
|
pref_address_check
|
char
|
1
|
This Y/N flag indicates whether an alert notification
is or is not to be delivered when one or more or no Preferred Addresses
are encountered during data entry.
|
|
journal_credithonor
|
char
|
1
|
This Y/N flag indicates whether it will journal
all linked Credit and Honor transactions for that transaction being Journaled.
|
|
ecomm_pub_09
|
char
|
1
|
This allows a site to control the publication of
any Comments information for any constituent.
|
|
ecomm_upd_09
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Comments information for
any constituent.
|
|
ssn_display_mask
|
char
|
9
|
This allows a site to set how the social security
numbers will be displayed.
|
|
bankaccnt_display_mask
|
char
|
20
|
This allows a site to set how the bank account
numbers will be displayed.
|
|
update_linked_trans
|
char
|
1
|
This Y/N flag indicates whether it will update
linked transactions.
|
|
update_payment_trans
|
char
|
1
|
This Y/N flag indicates whether it will update
payment transactions.
|
|
screen_resolution
|
char
|
1
|
This allows a site to set the screen resolution.
|
|
match_level1_a
|
integer
|
|
This allows a site to set the New Constituent Matching
Level One, drop-down list one, under eDirectory Setup.
|
|
match_level1_b
|
integer
|
|
This allows a site to set the New Constituent Matching
Level One, drop-down list two, under eDirectory Setup.
|
|
match_level2_a
|
integer
|
|
This allows a site to set the New Constituent Matching
Level Two, drop-down list one, under eDirectory Setup.
|
|
match_level2_b
|
integer
|
|
This allows a site to set the New Constituent Matching
Level Two, drop-down list two, under eDirectory Setup.
|
|
match_level3_a
|
integer
|
|
This allows a site to set the New Constituent Matching
Level Three, drop-down list one, under eDirectory Setup.
|
|
match_level3_b
|
integer
|
|
This allows a site to set the New Constituent Matching
Level Three, drop-down list two, under eDirectory Setup.
|
|
matchautol1
|
char
|
1
|
This tells the automatic update which matching
search levels to use.
|
|
matchautol2
|
char
|
1
|
This tells the automatic update which matching
search levels to use.
|
|
matchautol3
|
char
|
1
|
This tells the automatic update which matching
search levels to use.
|
|
benefitdeliverydate
|
integer
|
|
This allows a site to set how the Benefit Delivery
Date will be displayed.
|
|
spouse_button_label
|
char
|
1
|
This allows the site to choose the label to display
on the Spouse Button
|
|
verus_id
|
char
|
12
|
no longer in use by the system
|
|
verus_key
|
char
|
12
|
no longer in use by the system
|
|
verus_allow_ccsave
|
char
|
1
|
This tells the system to allow credit card and
bank draft account information to be saved for future use.
|
|
comment_formatting
|
char
|
1
|
This tells the system to remove tabs, line feeds
and returns from comments as they are inserted or updated.
|
|
ecomm_pub_81
|
char
|
1
|
This allows a site to control the publication of
any Internet Address information for any constituent.
|
|
ecomm_upd_81
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Internet Address information
for any constituent.
|
|
old_match_through
|
char
|
1
|
This tells the system that if a Corporation is
set up as matching through a Foundation, the matching ratios are pulled
from the Foundation record and not the Corporation record.
|
|
mp_schedule_auto_create
|
char
|
1
|
This tells the system to display a payment schedule
for confirmation after posting a matching pledge.
|
|
ecomm_pub_69
|
char
|
1
|
This allows a site to control the publication of
any Custom Bio information for any constituent.
|
|
ecomm_upd_69
|
char
|
1
|
This allows a site to control the ability of the
constituent to provide online updates for any Custom Bio information for
any constituent.
|
|
copy_to_clipboard
|
char
|
1
|
If users are allowed to copy ID Numbers from the
Search Results screen to the Clipboard, this will be set to 1. If not,
this is set to 0. (This will initially be set to Null until the system administrator 'edits' this option)
|
|
fy_start_month
|
char
|
2
|
Indicates the start month of your institution's
fiscal year. For example, if your fiscal year goes from October 1 through
September 30, the value of this field will be '10'.
|
|
login_lockouts
|
integer
|
[0]
|
Indicates the number of log on attempts a user
may make before being locked out of the system.
|
|
lockout_minutes
|
integer
|
[0]
|
Indicates the duration of the lockout, in minutes.
|
|
enable_audits
|
char
|
0
['0']
{'0' or '1'}
|
Set to '1' if the system option to keep track of
user log on attempts has been selected. The system will then record all
log on attempts in the login_audit system table.
Set to '0' if the system option to keep track of
user log on attempts is not selected.
|
|
password_min_capital
|
integer
|
[0]
|
Indicates the minimum number of upper case alphabetic
characters a user must use in his or her new password.
|
|
password_min_special
|
integer
|
[0]
|
Indicates the minimum number of special characters
a user must use in his or her new password.
|
|
display_honor_insert
|
char
|
1
|
This field is reserved for future use.
|
|
slist_col1
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col2
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col3
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col4
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col5
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col6
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col7
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col8
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col9
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col10
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col11
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col12
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col13
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col14
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col15
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col16
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col17
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col18
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col19
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
slist_col20
|
char
|
11
|
Used to customize the My Staff Favorites list.
|
|
plist_col1
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col2
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col3
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col4
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col5
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col6
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col7
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col8
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col9
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col10
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col11
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col12
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col13
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col14
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col15
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col16
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col17
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col18
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col19
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
plist_col20
|
char
|
11
|
Used to customize the My Prospects Favorites list.
|
|
prospect_list_filter1
|
char
|
10
|
Used to customize what filters are displayed on
the My Prospect Favorites list.
|
|
prospect_list_filter2
|
char
|
10
|
Used to customize what filters are displayed on
the My Prospect Favorites list.
|
|
prospect_list_filter3
|
char
|
10
|
Used to customize what filters are displayed on
the My Prospect Favorites list.
|
|
prospect_list_filter4
|
char
|
10
|
Used to customize what filters are displayed on
the My Prospect Favorites list.
|
|
prospect_list_filter5
|
char
|
10
|
Used to customize what filters are displayed on
the My Prospect Favorites list.
|
|
prospect_number_label
|
char
|
30
|
If the users' My Prospects Display list the count
of the user's prospects, then this field holds the text for the label
of that count.
|
|
ade_col1
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col2
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col3
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col4
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col5
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col6
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col7
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col8
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col9
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col10
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col11
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col12
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col13
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col14
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col15
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col16
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col17
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col18
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col19
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
ade_col20
|
char
|
11
|
Used to customize the Advanced Data Examiner Search
Results Display list.
|
|
audit_00
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Basic Data table.
|
|
audit_01
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Names table.
|
|
audit_02
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Addresses table.
|
|
audit_03
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Attribute table.
|
|
audit_04
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Relationships table.
|
|
audit_05
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Giving Details table.
|
|
audit_06
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Employment table.
|
|
audit_07
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Education table.
|
|
audit_08
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Dues Detail table.
|
|
audit_09
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Comments table.
|
|
audit_10
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Tracking table.
|
|
audit_11
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Actions table.
|
|
audit_12
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Tasks table.
|
|
audit_13
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Media Reference
table.
|
|
audit_14
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Screening table.
|
|
audit_15
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Ratings table.
|
|
audit_16
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Planned Giving table.
|
|
audit_17
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Death table.
|
|
audit_19
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Financial table.
|
|
audit_20
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Demographics table.
|
|
audit_22
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Correspondence table.
|
|
audit_25
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Citizenship table.
|
|
audit_26
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Phone Numbers table.
|
|
audit_27
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Research Source
table.
|
|
audit_28
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Membership table.
|
|
audit_30
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the PG/Proposal Ratings
table.
|
|
audit_42
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Proposals table.
|
|
audit_53
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Attendance table.
|
|
audit_54
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Event Guest table.
|
|
audit_56
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Registration table.
|
|
audit_69
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Custom Bio table.
|
|
audit_70
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Custom Prospect
table.
|
|
audit_81
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Internet Addresses
table.
|
|
we_id
|
char
|
30
|
For sites that use a WealthEngine Proxy Service Account, this field is used to store the WealthEngine user name. This
field is not used for sites who use WealthEngine Named User Accounts.
|
|
we_password
|
char
|
240
|
For sites that use a WealthEngine Proxy Service Account, this field is used to store the WealthEngine password (encrypted).
This
field is not used for sites who use WealthEngine Named User Accounts.
|
|
we_import_opts
|
char
|
100
|
Used to store WealthEngine import options.
|
|
outlook_integration
|
char
|
1
['0']
{'0' or '1' or '2'}
|
This field indicates the level of Outlook to Millennium and Millennium to Microsoft Outlook integration with that
is allowed at your site. '0' indicates no integration, '1' indicates Manual
Integration only, '2' indicates Real Time integration.
|
|
enable_contact_upload
|
char
|
1
['0']
{'0' or '1'}
|
This field indicates if your site will allow its
users to upload constituent contact information to Microsoft Outlook.
'1 indicates that users can upload contact information to Outlook. '0'
indicates that they can not.
|
|
sps_url
|
char
|
80
|
This field indicates the URL used for Paya Payment Solutions.
|
|
photo_path
|
varchar/carchar2
|
75
["]
|
This field stores the UNC path to the Docs Virtual Directory. The Docs Virtual Directory is the location of the Millennium Attachments. The system uses this field to display photos on reports.
|
|
pep_data
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable PUP data collection.
|
|
text_formatting
|
char
|
1
['0']
{'0' or '1' or '2'}
|
Formatting options for all comments and the custom
text fields.
|
|
serialreipt_run_table
|
char
|
30
|
Name of the temporary table that is used during
Issue New Receipts, Reprint Receipts, and Void Receipts Tax Receipting
Processes.
|
|
serialreceipt_use
|
char
|
1
['0']
{'0' or '1'}
|
Used to enable Serialized Tax Receipting at the
site level
|
|
serialreceipt_next_number
|
char
|
10
|
Used to store next available receipt number for
Serialized Tax Receipting
|
|
serialreceipt_run_prefix
|
char
|
10
|
Used to store the system default receipt prefix
for Serialized Tax Receipting.
|
| SQL_reporting_db_name
|
char |
30 |
Used to store the reporting database name (millreports). |
| audit_23
|
char |
1
['0']
{'0' or '1'}
|
Used to enable auditing of the Coverage table. |