Field
Name: |
Type: |
Length: |
Index: |
Description: |
W_SEQ |
Sequence |
|
|
|
W_WORK |
char |
4 |
|
user's initials |
W_ORG |
char |
60 |
|
|
W_DATABASE |
char |
60 |
|
name/path of database to automatically open
it |
W_PHONE |
char |
20 |
|
|
W_EXPIRES |
Short date |
1980..2079 |
|
date user record expires |
W_WHERE |
char |
30 |
|
OBSOLETE (formerly W_TAXID1) |
W_IN_OUT |
Short num |
2 dp |
|
OBSOLETE (formerly W_MARKUP) |
W_BILL_RATE |
Short num |
2 dp |
|
|
W_FINANCE_CHG |
Short num |
2 dp |
|
|
W_DEPT |
char |
15 |
|
ex: W_CURRENCY |
W_A_ADD_TASKS |
Short num |
0 dp |
|
prefs - append job tasks |
W_PO_NUMBERING |
Short num |
0 dp |
|
PO numbering method |
W_YEAR |
Short num |
0 dp |
|
year for auto job numbering |
W_CK_STOCK |
Short num |
0 dp |
|
check form to use |
W_DEMO |
Short num |
0 dp |
|
demo database flag |
W_A_EDIT_JOBS |
Short num |
0 dp |
|
0=all access/1=edit status, traffic only/2=view only |
W_GROUP_LIMIT |
Short num |
0 dp |
|
access priv - limit tasks to user's group |
W_A_AR_EDIT |
Short num |
0 dp |
|
pref - add/edit/delete AR? |
W_A_PRODUCTION |
Short num |
0 dp |
|
OBSOLETE see PREF_AR_SHOW_ADD R |
W_NOTE_STATUS_CH ANGE |
Short num |
0 dp |
|
pref - note when job status changes |
W_A_REOPEN_JOBS |
Short num |
0 dp |
|
prefs - user can/can't reopen closed jobs |
W_A_TIME_CLOSED_J OBS |
Short num |
0 dp |
|
prefs - user cançt add time to closed jobs |
W_A_UTILITIES |
Short num |
0 dp |
|
prefs - utilities |
W_A_JOB_WIP |
Short num |
0 dp |
|
prefs - user can edit job WIP |
W_A_UNPOST |
Short num |
0 dp |
|
prefs - can user unpost? |
W_PASSWORD_EXP |
Short date |
1980..2079 |
|
password expires |
W_TERMS |
char |
20 |
|
default client terms |
W_STATUS_NEW |
Short num |
0 dp |
|
|
W_STATUS_REOPEN |
Short num |
0 dp |
|
|
W_STATUS_CLOSED |
Short num |
0 dp |
|
|
W_AE_TEAM |
char |
10 |
|
ae, team |
W_AKA_CLIENT |
char |
20 |
|
|
W_AKA_CLIENTS |
char |
20 |
|
|
W_AKA_JOB |
char |
20 |
|
|
W_AKA_JOBS |
char |
20 |
|
|
W_AKA_TASK |
char |
20 |
|
|
W_AKA_TASKS |
char |
20 |
|
|
W_AKA_VENDOR |
char |
20 |
|
|
W_AKA_VENDORS |
char |
20 |
|
|
W_AKA_AR |
char |
20 |
|
A/R name - one |
W_AKA_ARS |
char |
20 |
|
A/R name - plural |
W_A_OPEN_JOBS |
short int |
(0 to 255) |
|
ex: W_DATE1 |
W_A_DELETE_JOBS |
short int |
(0 to 255) |
|
ex: W_DATE2 |
W_A_REMOVE_TASKS |
short int |
(0 to 255) |
|
ex: W_FIND1 |
W_A_EDIT_EST |
short int |
(0 to 255) |
|
ex: W_FIND2 |
W_A_CHG_ORDERS |
short int |
(0 to 255) |
|
ex: W_REPORT_TITLE |
W_A_UP_PROD_STAT US |
short int |
(0 to 255) |
|
ex: W_REPORT_NOTE |
W_A_UP_BILL_STATU S |
short int |
(0 to 255) |
|
|
W_PO_DISCLAIMER |
char |
2000 |
|
default - PO disclaimer |
W_TAX_DESC1 |
char |
25 |
|
sales tax 1 description |
W_TAX_DESC2 |
char |
25 |
|
sales tax 2 description |
W_TAX_RATE1 |
Number |
4 dp |
|
sales tax rate 1 |
W_TAX_RATE2 |
Number |
4 dp |
|
sales tax rate 2 |
W_TAX_GL1 |
Short num |
2 dp |
|
default sales tax G/L# 1 |
W_TAX_GL2 |
Short num |
2 dp |
|
default sales tax G/L#2 |
W_DATE_FORMAT |
Short num |
0 dp |
|
date format (buttons) |
W_ALERT_PO |
Number |
0 dp |
|
alert - PO budget |
W_ALERT_PO_PC |
Number |
0 dp |
|
PO warning % |
W_ALERT_COST |
Number |
0 dp |
|
warning if APs are overbudget |
W_ALERT_COST_PC |
Number |
0 dp |
|
AP warning % |
W_ALERT_TIME |
Number |
0 dp |
|
warning if time is overbudget |
W_ALERT_TIME_PC |
Number |
0 dp |
|
time warning % |
W_A_STATUS_TABLE |
Short num |
0 dp |
|
OBSOLETE default client aging period |
W_A_UP_TRAFFIC |
Short num |
0 dp |
|
OBSOLETE ex: W_AGE1 |
W_A_UP_SCHEDULES |
Short num |
0 dp |
|
OBSOLETE ex: W_AGE1 |
W_A_CANT_CHG_PO |
Short num |
0 dp |
|
can't change PO amounts |
W_A_HIDE_RATES |
short int |
(0 to 255) |
|
user access - hide time rates |
W_INFO_CTR |
char |
15 |
|
window format - which information center? |
W_A_COST_CHECKS |
short int |
(0 to 255) |
|
user can write job cost checks |
W_A_HIDE_TIME |
Short num |
0 dp |
|
hide time sheets on job cost reports |
W_PO_TO1 |
char |
10 |
|
PO distribution |
W_PO_TO2 |
char |
10 |
|
PO distribution |
W_PO_TO3 |
char |
10 |
|
PO distribution |
W_PO_TO4 |
char |
10 |
|
PO distribution |
W_PO_TO5 |
char |
10 |
|
PO distribution |
W_JOB_NUMBERING |
Short num |
0 dp |
|
job numbering style setting |
W_A_STATUS_CAT |
char |
20 |
|
limit status changes to category |
W_LOGO_ESTIMATE |
Short num |
2 dp |
|
|
W_LOGO_AR |
short int |
(0 to 255) |
|
PICT file for a/r invoices |
W_LOGO_PO |
short int |
(0 to 255) |
|
PICT file for purchase orders |
W_EST_DISCLAIMR |
char |
2000 |
|
estimate disclaimer |
W_STMT_NOTE |
char |
2000 |
|
statement disclaimer |
W_AR_NOTE |
char |
2000 |
|
a/r disclaimer |
W_PO_NOTE |
char |
2000 |
|
PO disclaimer |
W_GL_CASH |
Number |
2 dp |
|
default GL |
W_GL_AR |
Number |
2 dp |
|
default GL |
W_GL_AP |
Number |
2 dp |
|
default GL |
W_GL_RETAINER |
Number |
2 dp |
|
default GL |
W_GL_SALES |
Number |
2 dp |
|
default GL |
W_GL_OVERHEAD |
Number |
2 dp |
|
default GL |
W_GL_COST |
Number |
2 dp |
|
default GL |
W_GL_RE |
Number |
2 dp |
|
default GL retained earnings |
W_PERIOD |
Short num |
0 dp |
|
OBSOLETE current account period |
W_DATE1 |
Date and time |
(#FDT) |
|
OBSOLETE (ex: W_FIRST_DAY) |
W_GL_EMPL_ADV |
Short num |
2 dp |
|
|
W_PRINT_TO |
short int |
(0 to 255) |
|
(ex: W_PERIOD2) |
W_A_EST_OK |
short int |
(0 to 255) |
|
(ex: W_PERIOD3) |
W_A_LOOK_CLIENTS |
short int |
(0 to 255) |
|
(ex: W_PERIOD4) |
W_A_LOOK_JOBS |
short int |
(0 to 255) |
|
(ex: W_PERIOD5) |
W_A_LOOK_STAFF |
short int |
(0 to 255) |
|
(ex: W_PERIOD6) |
W_A_LOOK_COA |
short int |
(0 to 255) |
|
(ex: W_PERIOD7) |
W_A_LOOK_PC |
short int |
(0 to 255) |
|
(ex: W_PERIOD8) |
W_A_LOOK_DEPT |
short int |
(0 to 255) |
|
(ex: W_PERIOD9) |
W_A_LOOK_PO |
short int |
(0 to 255) |
|
(ex: W_PERIOD10) |
W_A_LOOK_PROJ |
short int |
(0 to 255) |
|
(ex: W_PERIOD11) |
W_A_LOOK_TYPES |
short int |
(0 to 255) |
|
(ex: W_PERIOD12) |
W_A_LOOK_VENDORS |
short int |
(0 to 255) |
|
(ex: W_PERIOD13) |
W_EST_HEADING |
char |
30 |
|
estimate heading - default |
W_INV_HEADING |
char |
30 |
|
invoice heading - default |
W_APPROVAL1 |
char |
40 |
|
estimate approval 1 |
W_APPROVAL2 |
char |
40 |
|
estimate approval 2 |
W_APPROVAL3 |
char |
40 |
|
estimate approval 3 |
W_A_ADD_XFERS |
Short num |
2 dp |
|
OBSOLETE |
W_A_IMPORT_PAYROL L |
Short num |
2 dp |
|
|
W_A_XFER_ACCT_BA L |
Short num |
2 dp |
|
|
W_A_TIME |
short int |
(0 to 255) |
|
|
W_A_GL_AUDITOR |
Short num |
2 dp |
|
|
W_A_CLOSE_YEAR |
Short num |
2 dp |
|
|
W_A_RECUR_JE |
Short num |
2 dp |
|
|
W_PO_SHOW_CL |
Short num |
0 dp |
|
PO default - show client name on PO |
W_A_GL_RECONCILE |
Short num |
2 dp |
|
|
W_A_ADD_COA |
Short num |
2 dp |
|
|
W_A_GL_BUDGETS |
Short num |
2 dp |
|
|
W_A_DELETE_OWN_P O |
short int |
(0 to 255) |
|
pref - user can only delete his/her own POs |
W_A_ADJ_JE |
Short num |
2 dp |
|
|
W_A_OVERHEAD_ALL OC |
Short num |
2 dp |
|
(ex: W_A_OVERHEAD_ALL OC) called W_CP_ADMIN in DML |
W_A_IMPORT_TIME |
Short num |
2 dp |
|
OBSOLETE |
W_A_CLOSE_JOBS |
Short num |
2 dp |
|
|
W_AKA_PO |
char |
20 |
|
|
W_PO_APPROVAL1 |
char |
15 |
|
prefs - approval 1 |
W_PO_APPROVAL2 |
char |
15 |
|
prefs - approval 2 |
W_PO_APPROVAL3 |
char |
15 |
|
prefs - approval 3 |
W_PO_FIELD1 |
char |
10 |
|
prefs - user field label 1 |
W_PO_FIELD2 |
char |
10 |
|
prefs - user field label 2 |
W_PO_FIELD3 |
char |
10 |
|
prefs - user field label 3 |
W_PO_FIELD4 |
char |
10 |
|
prefs - user field label 4 |
W_PO_FIELD5 |
char |
10 |
|
prefs - user field label 5 |
W_NEXT_JOB |
Short num |
0 dp |
|
next sequential job number |
W_EQUITY_NAME |
char |
25 |
|
efault name for "equity |
W_INCOME_NAME |
char |
25 |
|
efault name for "income |
W_COSTS_NAME |
char |
25 |
|
efault name for "job costs |
W_OTHERINC_NAME |
char |
25 |
|
efault name for "other income |
W_OTHEREXP_NAME |
char |
25 |
|
efault name for "other expenses |
W_EXPENSES_NAME |
char |
25 |
|
efault name for "expenses |
W_USER_NAME |
char |
40 |
|
user name |
W_NEXT |
char |
64 |
|
next system |
W_NEXT_PO_NUM |
Number |
0 dp |
|
next PO number |
W_A_CHANGE_GL |
Number |
0 dp |
|
OBSOLETE next JE ref number (G/L entries only) |
W_GL_ADV_BILL |
Short num |
2 dp |
|
default - advance billing |
W_LOGGED_IN |
Date and time |
(#FDT) |
|
date/time when user last logged in |
W_LOGGED_OUT |
Date and time |
(#FDT) |
|
date/time user logged out |
W_A_PO_MAX |
Number |
2 dp |
|
max amount user can write a PO |
W_A_GL_POST |
short int |
(0 to 255) |
|
not implemented |
W_AKA_POS |
char |
30 |
|
|
W_JOBS_POS |
char |
15 |
|
default window position |
W_ESTIMATE_POS |
char |
15 |
|
default window position |
W_SCHEDULE_POS |
char |
15 |
|
default window position |
W_AR_POS |
char |
15 |
|
default window position |
W_PO_POS |
char |
15 |
|
default window position |
W_STATUS_POS |
char |
15 |
|
default window position - job status |
W_UPTRAFFIC_POS |
char |
15 |
|
default window position - update traffic |
W_TRAFFIC_POS |
char |
15 |
|
default window position - edit traffic |
W_MEDIA_POS |
char |
15 |
|
default window position - mediaprefs - user can't close jobs
(ex: W_NUM4) |
W_JOBSPECS_POS |
char |
15 |
|
default window position - edit job specs |
W_TIME_POS |
char |
15 |
|
default window position - add time sheets |
W_A_POST_ONLY |
short int |
(0 to 255) |
|
user access - user can only post their entries |
W_GL_AR_DISC |
Short num |
2 dp |
|
default GL - A/R discount |
W_GL_AP_DISC |
Short num |
2 dp |
|
default GL - AP discounts |
W_A_JOBS |
short int |
(0 to 255) |
|
user access - jobs |
W_A_CLIENTS |
short int |
(0 to 255) |
|
user access - clients |
W_A_VENDORS |
short int |
(0 to 255) |
|
user access - vendors |
W_A_STAFF |
short int |
(0 to 255) |
|
user access - staff |
W_A_AP |
short int |
(0 to 255) |
|
user access - A/P |
W_A_CHECKS |
short int |
(0 to 255) |
|
user access - checks |
W_A_EXPENSES |
short int |
(0 to 255) |
|
user access - expenses |
W_A_AR |
short int |
(0 to 255) |
|
user access - A/R |
W_A_MANAGER |
short int |
(0 to 255) |
|
user access - manager level |
W_A_PREFS |
short int |
(0 to 255) |
|
user access - all preferences windows |
W_A_COA |
short int |
(0 to 255) |
|
user access - chart of accounts |
W_A_TASK_TABLE |
short int |
(0 to 255) |
|
user access - task table |
W_A_FINANCIALS |
short int |
(0 to 255) |
|
user access - Financials |
W_A_COSTS |
short int |
(0 to 255) |
|
user access - cost reports |
W_A_SEE_COSTS |
short int |
(0 to 255) |
|
user access - see costs |
W_A_ADHOC |
short int |
(0 to 255) |
|
user access - ad hoc reports |
W_A_GL |
short int |
(0 to 255) |
|
user access - G/L |
W_A_CLIENT_PMTS |
short int |
(0 to 255) |
|
user access - client payments |
W_A_CLIENT_AGING |
short int |
(0 to 255) |
|
user access - client aging |
W_A_VENDOR_AGING |
short int |
(0 to 255) |
|
user access - vendor aging |
W_A_WIP |
short int |
(0 to 255) |
|
user access - work in progress |
W_A_PROFITABILITY |
short int |
(0 to 255) |
|
user access - profitability reports |
W_A_PRODUCTIVITY |
short int |
(0 to 255) |
|
user access - productivity |
W_A_CASH_FLOW |
short int |
(0 to 255) |
|
user access - cash flow |
W_A_MEDIA |
short int |
(0 to 255) |
|
user access - media |
W_A_XFERS |
short int |
(0 to 255) |
|
user access - cost transfers |
W_STATUS_BILLED |
Short num |
0 dp |
|
status when job is billed (ex: W_LOCK1) |
W_STATUS_AR_PAID |
Short num |
0 dp |
|
status when client pays the AR (ex: W_LOCK2) |
W_A_PO_AMT |
short int |
(0 to 255) |
|
force this user to enter a PO amount (ex: W_LOCK3) |
W_GL_MEDIA_WIP |
Number |
2 dp |
|
media accrual G/L# (ex: W_LOCK4) |
W_GL_MEDIA_COSTS |
Number |
2 dp |
|
nedia costs G/L# (ex: W_LOCK5) |
W_A_EMPL_ADV |
short int |
(0 to 255) |
|
|
W_A_TIME_VIEW_DAY S |
short int |
(0 to 255) |
|
|
W_A_HIDE_JOB_AMTS |
short int |
(0 to 255) |
|
|
W_A_APPROVE_PO |
short int |
(0 to 255) |
|
|
W_A_STAFF_ONLY |
short int |
(0 to 255) |
|
user is restricted to only see their own STAFF record (ex:
W_NUM9) |
W_A_CONFID_GL |
short int |
(0 to 255) |
|
(ex: W_NUM10) can see confidential G/L accounts |
W_NUM11 |
short int |
(0 to 255) |
|
user pref - user can run Software Update |
W_NUM12 |
short int |
(0 to 255) |
|
which program runs this database? 0=CL/1=JT/2=Pro/3=SQ L |
W_BUD_ALERT_C1 |
char |
2000 |
|
near-budget alert - costs |
W_BUD_ALERT_C2 |
char |
2000 |
|
over-budget alert - costs |
W_BUD_ALERT_L1 |
char |
2000 |
|
near-budget alert - time |
W_BUD_ALERT_L2 |
char |
2000 |
|
over-budget alert - time |
W_BUD_ALERT_PO1 |
char |
2000 |
|
near-budget alert - POs |
W_BUD_ALERT_PO2 |
char |
2000 |
|
over- budget alert - POs |
W_JOB_COLUMN1 |
char |
12 |
|
unused - colomns for W_JOBS |
W_JOB_COLUMN2 |
char |
12 |
|
|
W_JOB_COLUMN3 |
char |
12 |
|
|
W_AKA |
char |
30 |
|
unused name |
W_SEP |
char |
1 |
|
job number field separator |
W_AKA_PROJECT |
char |
20 |
|
job default - project |
W_FORCE_QUIT |
short int |
(0 to 255) |
|
Force Quit timer is on |
W_FORCE_TIME |
Short time |
|
|
Time to Force Quit |
W_INFO_CTR_MSG |
char |
60 |
|
default info center message |
W_CON_NOTE |
char |
2000 |
|
default contingency note |
W_CON_PC |
Short num |
2 dp |
|
default contingency % |
W_UNIQ_JNUM |
short int |
(0 to 255) |
|
pref - guarantee unique job number |
W_JOBS_FROM |
Short num |
0 dp |
|
pref - lookup jobs from production status |
W_JOBS_TO |
Short num |
0 dp |
|
pref - lookup jobs to production status |
W_AKA_CLIENT_PO |
char |
20 |
|
default for J_FIELD2_LABEL |
W_J_TO1 |
char |
10 |
|
|
W_J_TO2 |
char |
10 |
|
|
W_J_TO3 |
char |
10 |
|
|
W_J_TO4 |
char |
10 |
|
|
W_J_TO5 |
char |
10 |
|
|
W_CHAR20 |
char |
20 |
|
ex: W_TAX_ID2 State tax ID |
W_VERSION_A |
short int |
(0 to 255) |
|
version (ex: 1.x) |
W_VERSION_B |
short int |
(0 to 255) |
|
version (ex: x.1) |
W_VERSION_C |
short int |
(0 to 255) |
|
release (ex: x.x.1) |
W_VERSION_KIND |
char |
2 |
|
AM/JT/CL |
W_USER_FIELD3 |
char |
20 |
|
default job user-defined field 3 label |
W_USER_FIELD4 |
char |
20 |
|
default job user-defined field 4 label |
W_USER_FIELD5 |
char |
20 |
|
default job user-defined field 5 label |
W_USER_FIELD6 |
char |
20 |
|
default job user-defined field 6 label |
W_PO_TOTAL_LABEL |
char |
30 |
|
ame for "total can't exceed label |
W_AKA_PC |
char |
20 |
|
ame for "profit center |
W_AKA_PCS |
char |
20 |
|
ame for "profit centers |
W_A_SALES_TAX |
short int |
(0 to 255) |
|
user can edit sales tax |
W_A_SPELL |
short int |
(0 to 255) |
|
individual user preference to override general prefs |
W_A_IO_MAX |
Number |
2 dp |
|
max limit for PO/IOs |
W_A_APPROVE_AR |
short int |
(0 to 255) |
|
access priv - user can approve ARs |
W_A_DBA |
short int |
(0 to 255) |
|
access priv - can this user administer the database |
W_JOB_COL1 |
short int |
(0 to 255) |
|
job ticket user-defined column 1 |
W_JOB_COL2 |
short int |
(0 to 255) |
|
job ticket user-defined column 2 |
W_JOB_COL3 |
short int |
(0 to 255) |
|
job ticket user-defined column 3 |
W_JOB_COL4 |
short int |
(0 to 255) |
|
job ticket user-defined column 4 |
W_JOB_COL5 |
short int |
(0 to 255) |
|
job ticket user-defined column 5 |
W_JOB_COL6 |
short int |
(0 to 255) |
|
job ticket user-defined column 6 |
W_A_OK_REQUESTS |
short int |
(0 to 255) |
|
access priv - user can approve job requests |
W_A_APPROVE_TIME |
short int |
(0 to 255) |
|
access priv - user can approve time /0=everyone/1=dept/ 2=everyone |
W_A_APPROVE_EXP |
short int |
(0 to 255) |
|
access priv - user can approve expense reports /0=everyone/1=dept/
2=everyone |
W_A_CHANGE_PRIORI TY |
short int |
(0 to 255) |
|
access priv - user can change a job's priority |
W_A_MEDIA_SNAPS |
short int |
(0 to 255) |
|
access privs - media reports |
W_A_CLIENT_ADD |
short int |
(0 to 255) |
|
access priv - can add/delete clients |
W_A_WEB_ACCESS |
short int |
(0 to 255) |
|
access priv - user can change web access settings, start &
stop |
W_A_CUST_REPORTS |
short int |
(0 to 255) |
|
access priv - user can customize reports |
W_A_COLLECT_MGR |
short int |
(0 to 255) |
|
access priv - user can use collection manager |
W_A_EMAIL |
short int |
(0 to 255) |
|
access priv - user can e-mail reports /0=no one/1=clients/2=vend
ors/3=clients+vendors +staff/4=anyone anywhere |