spacerspacer
Free help: USER GUIDE } WHAT'S NEW
Home > Support > Data Dictionary > WEB_PREFS
spacer


C&P Data Dictionary: WEB_PREFS


 

Other files:

acc_periods
access_privs
accounts
addresses
ap
ar
ar_items
archived_jobs
asset_types
asset_files
asset_prefs
avail
billing_info
cal
calendar
change_items
change_order
checks
check_items
clients
contacts
costs
credit_card_prefs
date_count
depts
est_revs
f_preference
finance
global_vars
groups
history
history_client
history_vendor
home
int_items
je
jobs
job_order
job_task
job_types
media_briefs
media_est
media_est_items
media_items
media_plans
media_prefs
meetings
mlink
mlink_prefs
odbcusers
outbox
palm_cats
palm_jobs
palm_tasks
payments
payment_items
pc
pictures
po_items
po_template
prefs
print_specs
programs
projects
proposals
purchase_order
rates
recur_ap
retainers
sales_actions
sales_campaigns
sales_letters
schedule_chart
schedule_header
staff
statements
stations
status_codes
sub_classes
task_table
temp_tasks
thought
time_import
timecard
timeline
user_info
vendors
version
web_html
web_ip_log

web_log
web_prefs
web_users_log
working
worksheets
y1099



Field Name:

Type:

Length:

Index:

Description:

WP_BELL_ON_HITS short int
(0 to 255)
sound bell when server is accessed
WP_CURRENT_EVENT char
200
current event being processed
WP_DISABLE_LOG short int
(0 to 255)
disable activity log
WP_SEQ Sequence
 
WP_ALERT_PW short int
(0 to 255)
security alert - notify via e-mail after 3 password attempts
WP_WEBMASTER char
100
security alert - name of person notified
WP_WEBMSTR_EMAIL char
40
security alert - e-mail address of person to notify
WP_ALERT_LOGON short int
(0 to 255)
security alert - notify every bad logon attempt
WP_SMTP_SERVER char
40
SMTP server address (copied from C&P prefs)
WP_AUTO_START short int
(0 to 255)
always begin web server at startup
WP_ALERT_ID short int
(0 to 255)
security alert - notify via e-mail of logins with bad user IDs
WP_DATE Short date
1900..1999
 
WP_USER char
4
user ID
GREETING char
2000
home page greeting
DGL_NAME char
50
lookup value - X_DGL
CGL_NAME char
50
lookup value - X_CGL
KIND char
25
lookup value - X_KIND
TASK_KIND char
20
lookup value - T_KIND
TYPE char
20
lookup value - PO_TYPE
JOB_NAME char
60
lookup value - J_NAME
TASK_NAME char
60
lookup value - X_NAME
WP_ALERT_ERROR short int
(0 to 255)
notify on server errors
EST_REVISION char
10
lookup value - J_REVISION
FINAL_ESTIMATE char
20
lookup value - J_FINAL_EST
STATUS_DESC1 char
40
lookup value - STATUS_DESC
STATUS_DESC2 char
40
lookup value - STATUS_DESC
WP_REMOTE_ADMIN short int
(0 to 255)
allow remote web server administration?
WP_REMOTE_ADMIN_I P char
20
limit remote admin to this IP address
LOOKUP6 char
2000
spare text lookup
LOOKUP5 char
2000
 
LOOKUP4 char
2000
 
LOOKUP3 char
2000
 
LOOKUP2 char
2000
 
LOOKUP_JOBS char
2000
lookup link - jobs
WP_DATETIME Date
D m Y H:N:S
 
HIT_DURATION Short num
0 dp
 
QUERY_DURATION Short num
0 dp
 
TRANSACTION_TYPE char
1000
 
BYTES_RECEIVED Long integer
 
BYTES_SENT Long integer
 
HEADER_LIST List
 
WP_DISCONNECT Short num
0 dp
prefs: minutes until users are auto disconnected
WP_SHOW_DATE Short date
1980..2079
pref: show jobs and invoices from this date forward (hides old ones)
VER char
20
 
ALT_SOCKET Long integer
 
MESSAGE_DATA char
2000
 
POSTED char
20
lookup value - posted?
WP_PORT_NUMBER Long int
port number to use instead of Port 80
WP_BACKUP short int
(0 to 255)
allow database to be shutdown each day for backup
WP_CLOSE_TIME Short time
Time to disconnect from database
WP_OPEN_TIME Short time
time to reconnect to database
WP_FONT_OPEN char
100
table table/size (HTML code) to open the font tag
WP_FONT_CLOSE char
20
table font/size (HTML code) to close the font tag
WP_AUTO_ARCHIVE_L OG short int
(0 to 255)
Automatically archive log every Monday?
WP_LOG_IP_ERRORS short int
(0 to 255)
prefs: log IP errors?
WP_LAST_ARCHIVE Short date
1980..2079
Yes/Empty.
WP_DISABLE_BAD_LO GIN short int
(0 to 255)
prefs: don't disable accounts after bad logins
WP_JS_SERVER char
100
Access the my_script.js from location
CAL_DAY short int
(0 to 255)
Day of the month for the online calendar
CAL_MONTH short int
(0 to 255)
Month of the year for online calendar
CAL_YEAR Long integer
Year for online calendar
CAL_MODE char
10
 

LEGEND:

Type
indicates whether a field contains characters (i.e., "char") which contains any combination of letters or numbers, numbers (which has a set number of decimal places), or integers (i.e., numbers that range from 0 to 255 only).

Length
shows the size of a field. Character fields have lengths that are fixed, depending on their purpose. Description and note fields have a length of 32000, which make them variable-length; their actual size depends on how much data is entered into them.

Index
indicates fields that are indexed in the database, which makes them key fields for finding and sorting data. For best performances on reporting and exporting, searches should made on index fields first.

Need help exporting? See the Exporting Data from Clients & Profits tech note.


For subscribers: VIDEOS } FAQs/TECH NOTES } LEARN
     Sign up for Clients & Profits news:
     © Clients & Profits, Inc. w e  l o v e  a d v e r t i s i n g