spacerspacer
Free help: USER GUIDE } WHAT'S NEW } SYSTEM MANAGER NEWS
spacer


C&P Data Dictionary: 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:

PREF_SEQ Sequence
Sequence
PREF_GL short int
(0 to 255)
System pref - make G/L entries
PREF_AP_AGING short int
(0 to 255)
System pref - A/P aging
PREF_AR_AGING short int
(0 to 255)
System pref - A/R aging
PREF_DIARY short int
(0 to 255)
System pref - make diary entries
PREF_CHARGE_NUM short int
(0 to 255)
System pref - require charge number
PREF_JOB_TYPE short int
(0 to 255)
System pref - require job type
PREF_CLOSE_JOB_CO STS short int
(0 to 255)
System pref - can't close jobs with unbilled costs
PREF_RATE_KIND short int
(0 to 255)
System pref - which bill rate to use?
PREF_SHARED_PICTS short int
(0 to 255)
System pref - shared pictures with Mac and Windows?
PREF_DATES short int
(0 to 255)
System pref - date format
PREF_FIND_TIME short int
(0 to 255)
System pref - find time by number or staff
PREF_MAIL short int
(0 to 255)
System pref - enable auto mail
PREF_CK_COPIES short int
(0 to 255)
System pref - how many check copies should print?
PREF_WIP short int
(0 to 255)
System pref - auto post WIP entries
PREF_PROOF_PRINTER short int
(0 to 255)
System pref - always print proof lists to printer
PREF_CLOSE_JOB_TA SKS short int
(0 to 255)
System pref - can't close jobs with unfinished tasks
PREF_OVERDUE_EMAIL short int
(0 to 255)
System pref - autosend e-mail for overdue tasks?
PREF_CODE char
4
'XXXX'
PREF_TRAFFIC1 char
25
System pref - Traffic name
PREF_TRAFFIC2 char
25
 
PREF_TRAFFIC3 char
25
 
PREF_TRAFFIC4 char
25
 
PREF_TRAFFIC5 char
25
 
PREF_TRAFFIC6 char
25
 
PREF_TRAF1_INIT char
2
PREF_TRAF2_INIT char
2
 
PREF_TRAF3_INIT char
2
 
PREF_TRAF4_INIT char
2
 
PREF_TRAF5_INIT char
2
 
PREF_TRAF6_INIT char
2
 
PREF_TAX_ID1 char
20
Federal tax ID
PREF_TAX_ID2 char
20
State tax ID
PREF_ADDRESS1 char
60
agency address
PREF_ADDRESS2 char
60
 
PREF_ADDRESS3 char
60
 
PREF_BILL_ORG char
60
billing org name
PREF_BILL_ADDRESS1 char
60
billing address
PREF_BILL_ADDRESS2 char
60
 
PREF_BILL_ADDRESS3 char
60
 
PREF_ORG char
60
organization name
PREF_CURRENCY char
5
currency format
PREF_STD_MARKUP Short num
2 dp
standard markup
PREF_SYS_MGR char
40
designated system manager
PREF_DATE_STARTED Short date
1980..2079
date the database was started
PREF_SMTP_SERVER char
40
SMTP server name
PREF_SYS_MGR_EMAIL char
100
sys mgr's e-mail
PREF_JE_REF Short num
0 dp
sys pref - next JE#
PREF_AR_NUM Short num
0 dp
sys pref - next AR#
PREF_OFFICE_NUM char
10
office number (for remote offices)
PREF_HELP_SYS_TEXT char
2000
default e-mail body for sys mgr help e-mail
PREF_TIME_CHECKED Short date
1980..2079
date TIME was last checked (to send reminder e-mail)
PREF_TIME_MSG char
2000
missing time e-mail message (body)
PREF_EST_T_MARGIN Short num
2 dp
estimate margin - top
PREF_EST_B_MARGIN Short num
2 dp
estimate margin - bottom
PREF_EST_L_MARGIN Short num
2 dp
estimate margin - left
PREF_INV_T_MARGIN Short num
2 dp
invoice margin - top
PREF_INV_B_MARGIN Short num
2 dp
invoice margin - bottom
PREF_INV_L_MARGIN Short num
2 dp
invoice margin - left
PREF_PO_T_MARGIN Short num
2 dp
PO/IO margin - top
PREF_PO_B_MARGIN Short num
2 dp
PO/IO margin - bottom
PREF_PO_L_MARGIN Short num
2 dp
PO/IO margin - left
PREF_STMT_T_MARGI N Short num
2 dp
client statement margin - top
PREF_STMT_B_MARGI N Short num
2 dp
client statement margin - bottom
PREF_STMT_L_MARGI N Short num
2 dp
client statement margin - left
PREF_AR_SHOW_ADD R short int
(0 to 255)
A/R pref - show billing address
PREF_BILL1 char
30
workflow - billing step #1
PREF_BILL2 char
30
workflow - billing step #2
PREF_BILL3 char
30
workflow - billing step #3
PREF_BILL4 char
30
workflow - billing step #4
PREF_BILL5 char
30
workflow - billing step #5System pref - Traffic initials
PREF_BILL6 char
30
workflow - billing step #6
PREF_BILL7 char
30
workflow - billing step #7
PREF_BILL8 char
30
workflow - billing step #8
PREF_OVERBUDGET_E MAIL short int
(0 to 255)
System pref - autosend e-mail for overbudget tasks?
PREF_CLOSE_WRITE_O FF short int
(0 to 255)
System pref - write off all unbilled costs when closing the job
PREF_HOLIDAY1 Short date
1980..2079
System pref - holiday
PREF_HOLIDAY2 Short date
1980..2079
 
PREF_HOLIDAY3 Short date
1980..2079
 
PREF_HOLIDAY4 Short date
1980..2079
 
PREF_HOLIDAY5 Short date
1980..2079
 
PREF_HOLIDAY6 Short date
1980..2079
 
PREF_HOLIDAY7 Short date
1980..2079
 
PREF_HOLIDAY8 Short date
1980..2079
 
PREF_HOLIDAY9 Short date
1980..2079
 
PREF_HOLIDAY10 Short date
1980..2079
 
PREF_HOLIDAY11 Short date
1980..2079
 
PREF_HOLIDAY12 Short date
1980..2079
 
PREF_HOLIDAY13 Short date
1980..2079
 
PREF_HOLIDAY14 Short date
1980..2079
 
PREF_HOLIDAY15 Short date
1980..2079
 
PREF_HOLIDAY16 Short date
1980..2079
 
PREF_HOLIDAY17 Short date
1980..2079
 
PREF_HOLIDAY18 Short date
1980..2079
 
PREF_HOLIDAY19 Short date
1980..2079
 
PREF_HOLIDAY20 Short date
1980..2079
 
PREF_HDAY_DESC1 char
20
 
PREF_HDAY_DESC2 char
20
 
PREF_HDAY_DESC3 char
20
 
PREF_HDAY_DESC4 char
20
 
PREF_HDAY_DESC5 char
20
 
PREF_HDAY_DESC6 char
20
 
PREF_HDAY_DESC7 char
20
 
PREF_HDAY_DESC8 char
20
 
PREF_HDAY_DESC9 char
20
 
PREF_HDAY_DESC10 char
20
 
PREF_HDAY_DESC11 char
20
 
PREF_HDAY_DESC12 char
20
 
PREF_HDAY_DESC13 char
20
 
PREF_HDAY_DESC14 char
20
 
PREF_HDAY_DESC15 char
20
 
PREF_HDAY_DESC16 char
20
 
PREF_HDAY_DESC17 char
20
 
PREF_HDAY_DESC18 char
20
 
PREF_HDAY_DESC19 char
20
 
PREF_HDAY_DESC20 char
20
 
PREF_SPELL short int
(0 to 255)
System prefs - spelling enabled?
PREF_CURR_NAME char
12
name of currency (e.g., dollars, marks, pounds)
PREF_APPROVE_AR short int
(0 to 255)
System prefs - can't post unapproved ARs
PREF_AR_APPROVAL1 char
40
System prefs - AR approval name
PREF_AR_APPROVAL2 char
40
 
PREF_AR_APPROVAL3 char
40
 
PREF_AR_SHOW_EST short int
(0 to 255)
System prefs - show estimates on billing previews
PREF_AR_SHOW_JOB short int
(0 to 255)
System prefs - show job info (i.e., start date) on billing previews
PREF_BILL_INSTRUCTI ONS char
2000
System prefs - billing instructions on previews
PREF_AR_RETURN_DA YS short int
(0 to 255)
System prefs - days to return ok'd billing preview
PREF_HELP_EMAIL char
100
System prefs - internal helpdesk e-mail
PREF_WISH_EMAIL char
100
System prefs - internal wish list e-mail
PREF_USER_FIELD1 short int
(0 to 255)
System Prefs - require projects (user field 1) on jobs
PREF_USER_FIELD2 short int
(0 to 255)
System Prefs - require client po (user field 2) on jobs
PREF_USER_FIELD3 short int
(0 to 255)
System Prefs - require user field 3 on jobs
PREF_USER_FIELD4 short int
(0 to 255)
System Prefs - require user field 4 on jobs
PREF_USER_FIELD5 short int
(0 to 255)
System Prefs - require user field 5 on jobs
PREF_USER_FIELD6 short int
(0 to 255)
System Prefs - require user field 6 on jobs
PREF_PC short int
(0 to 255)
System Prefs - require profit centers on jobs
PREF_BILL_EMAIL short int
(0 to 255)
System Prefs - Email billing preview
PREF_BILL_EMAIL_AE short int
(0 to 255)
System Prefs - Email billing preview AE
PREF_BILL_EMAIL_TRA F1 short int
(0 to 255)
System Prefs - Email billing preview Traffic Assign 1
PREF_BILL_EMAIL_TRA F2 short int
(0 to 255)
System Prefs - Email billing preview Traffic Assign 2
PREF_BILL_EMAIL_TRA F3 short int
(0 to 255)
PREF_BILL_EMAIL_TRA F4 short int
(0 to 255)
System Prefs - Email billing preview Traffic Assign 4
PREF_BILL_EMAIL_TRA F5 short int
(0 to 255)
System Prefs - Email billing preview Traffic Assign 5
PREF_BILL_EMAIL_TRA F6 short int
(0 to 255)
System Prefs - Email billing preview Traffic Assign 6
PREF_PING_SERVER short int
(0 to 255)
System prefs - Always ping e-mail server
PREF_EXPORT_FORMA T short int
(0 to 255)
0=Dif/1=Sylk/2=dBAS E/3=Lotus/4=Delimite d (commas)/5=Delimited (tabs)/6= One field per line/7=OMNIS data transfer
PREF_JOB_COMPLETE short int
(0 to 255)
% job completion
PREF_STATUS_AMIN short int
(0 to 255)
System pref - show status note animiation
PREF_CLIENT_KIND1 char
20
ystem pref - client kind 1 ("Active)
PREF_CLIENT_KIND2 char
20
ystem pref - client kind 2 ("Inactive)
PREF_CLIENT_KIND3 char
20
ystem pref - client kind 3 ("Hot lead)
PREF_CLIENT_KIND4 char
20
ystem pref - client kind 4 ("Prospect)
PREF_CLIENT_KIND5 char
20
ystem pref - client kind 5 ("Curious)
PREF_CLIENT_KIND6 char
20
ystem pref - client kind 6 ("Cold Call)
PREF_PDF_DRIVER short int
(0 to 255)
System pref - which PDF driver? (PDFWriter/PDFW,Print ToPDF/Ppdf, AdobePS/rbDG')
PREF_USER_GUIDE short int
(0 to 255)
System pref - which user guide? (0=offline/1=online)
PREF_EMAIL_BODY_IN V char
2000
System pref - default email body for invoices
PREF_EMAIL_BODY_ES T char
2000
System pref - default email body for estimates
PREF_PRIORITY1 char
20
ob pref - priority label 1 ("Bleeding Rush!)
PREF_PRIORITY2 char
20
ob pref - priority label 2 ("Killer Rush)
PREF_PRIORITY3 char
20
ob pref - priority label 3 ("Rush)
PREF_PRIORITY4 char
20
ob pref - priority label 4 ("Normal)
PREF_PRIORITY5 char
20
ob pref - priority label 5 ("Whenever - No Rush)
PREF_PRIORITY6 char
20
ob pref - priority label 6 ("Who Knows?)
PREF_TIME_APPROVE short int
(0 to 255)
System pref - time cards must be approved before postingSystem Prefs - Email billing preview Traffic Assign 3
PREF_VERIFY Short date
1980..2079
last data verification
PREF_NO_MERCHANT_ IMP short int
(0 to 255)
Credit card pref - don't import merchants/payees
PREF_NO_GRAPHS_JO BS short int
(0 to 255)
to disable automatic graphing in job window
PREF_NO_GRAPHS_CLI ENTS short int
(0 to 255)
to disable automatic graphing in client window
PREF_LNUM Short num
0 dp
Client customer ID
PREF_LSERIAL Short num
0 dp
C&P serial number
PREF_LAST_UPDATE Short date
1980..2079
date of last update

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 } COMMUNITY } LEARN } BUGS/WISH LIST } TIPS Most popular:
     Sign up for Clients & Profits news:
   flag  © 2012 Clients & Profits Worldwide   w e  l o v e  a d v e r t i s i n g