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 |