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


C&P Data Dictionary: WORKING

 

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:

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

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