Clients & Profits | Data Dictionary

Free help: USER GUIDE } WHAT'S NEW

Home > Support > Data Dictionary > JOBS

Search:

C&P Data Dictionary: JOBS

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

JOBS is the data file that stores the Job Ticket Header Data. Each JOBS record contains a single Job Ticket. It is a data file used primarly on . Each JOBS record has fields for Job Ticket data (i.e., J_NUM, J_CLIENT_NUM, J_DESC, etc.), Job Costing data (i.e., J_AMT1 thru J_AMT6) and Milestone Data (i.e., J_MILE1 thru J_MILE12) for each Job Ticket. These fields are updated when a new Job ticked is created. Financial statements are also created from these amount fields.

See related data files: JOB_TYPES STATUS_CODES JOB_TASK CLIENTS

Field Name:	Type:	Length:	Index:	Description:
J_SEQ	sequence		x	sequence #
J_NUM	char	10	x	job number
J_START_DATE	short date	1980..2079	x	date job is opened/started
J_NAME	national	60	x	job name/title
J_CLIENT_NUM	char	10	x	client number
J_CLOSED	short int	(0 to 255)		job closed? flag (yes/no)
J_DUE_DATE	short date	1980..2079	x	due/finished date
J_USER_FIELD2	char	15	x	client's PO number
J_CONT_AMT	number	2dp		estimate contingency %
J_REVISION	short num	0dp		current revision # of estimate
J_USER_FIELD1	char	20	x	project code (user-defined name)
J_PROD_STATUS	short num	0dp	x	production status
J_DESC	char	2000		job description or specifications
J_WHO	char	4		initials of person who opened the job
J_CLIENT_CONTACT	char	30	x	client contact
J_AGENCY_CONTACT	char	30		agency contact
J_AE_TEAM	char	10	x	AE (dept, or acct team)
J_TYPE	char	15	x	job type (a lookup table)
J_AMT1	short num	2dp
J_AMT2	short num	2dp
J_AMT3	short num	2dp
J_AMT4	short num	2dp
J_AMT5	short num	2dp
J_AMT6	short num	2dp
J_NEXT_STEPS	char	2000		next steps or status description
J_DATE_ADDED	short date	1980..2079		date job was added, not started
J_PC	char	10		profit center
J_CONT_NOTE	char	2000		contingency description
J_BILL_STATUS	number	0dp	x	billing status
J_MILE1	char	6		traffic milestone
J_MILE2	char	6		traffic milestone
J_MILE3	char	6		traffic milestone
J_MILE4	char	6		traffic milestone
J_MILE5	char	6		traffic milestone
J_MILE6	char	6		traffic milestone
J_MILE7	char	6		traffic milestone
J_MILE8	char	6		traffic milestone
J_MILE9	char	6		traffic milestone
J_MILE10	char	6		traffic milestone
J_MILE11	char	6		traffic milestone
J_MILE12	char	6		traffic milestone
J_HISTORY_COUNT	short num	0dp		quantity of history records
J_CONTINGENCY	short int	(0 to 255)		type of contingency (0=%, 1=$)
J_CONT_PC	short num	2dp		contingency $ amount
J_EST_FORM	char	20		ad hoc report form name
J_APPROVAL1	char	40		estimate approval 1
J_APPROVAL2	char	40		estimate approval 2
J_APPROVAL3	char	40		estimate approval 3
J_SHOW_ZERO_AS	char	15		show zero as placeholder
J_HEADING	char	25		estimate heading/title
J_SHOW_HOURS	Short int	(0 to 255)		show hours on estimates
J_SHOW_DATES	Short int	(0 to 255)		show due dates on estimate
J_SHOW_TOTALS	Short int	(0 to 255)		show totals only on estimates
J_DISCLAIMER	char	2000		estimate disclaimer
J_EST_CUSTOM	char	12		name of custom estimate report format
J_EST_COLUMN1	char	15		estimate heading - column 1
J_EST_COLUMN2	char	15		estimate heading - column 2
J_EST_COLUMN3	char	15		estimate heading - column 3
J_FINAL_EST	Short num	0 dp		column number of final estimate (user-defined)
J_TO1	char	10		print to name 1
J_TO2	char	10		print to name 2
J_TO3	char	10		print to name 3
J_TO4	char	10		print to name 4
J_TO5	char	10		print to name 5
J_AE_TITLE	char	20		user-defined title for AE
J_ADV_BILLED	Number	2 dp		amount of advanced billing
J_EST_TO_GO	Number	2 dp		estimate amount to complete the job
J_HOURS_TO_GO	Number	2 dp		estimate hours needed to complete the job
J_SNAP_UPDATED	Short date	1980..2079		date estimates-to-complete was updated
J_COSTS_TO_GO	Number	2 dp		costs needed to complete the job
J_NEXT_BILL_AMT	Number	2 dp		to be billed next billing cycle
J_NEXT_BILL_DATE	Short date	1980..2079	x	next expected billing date
J_HIDE_EST_TASKS	Number	2 dp		hide tasks with no estimates (ex: J_NUM1)
J_CLIENT_BILLED	Number	2 dp		total job billings (unused)
J_CLIENT_PAID	Number	2 dp		total client payments (unused)
J_UNBILLABLE	Short int	(0 to 255)		entire job is unbillable
J_CLIENT_PHONE	char	15		client contact - phone number
J_CLIENT_TITLE	char	20		client contact label
J_AE_PHONE	char	15		AE phone number
J_FIELD1_LABEL	char	20		custom field (project)
J_FIELD2_LABEL	char	20		custom field (client PO#)
J_FIELD3_LABEL	char	20		custom field (unused)
J_USER_FIELD3	char	20		custom field value
J_CHARGE_NUM	char	20	x	charge number
J_FIELD4_LABEL	char	20		user-defined label for J_FIELD4
J_FIELD5_LABEL	char	20		user-defined label for J_FIELD5
J_FIELD6_LABEL	char	20		user-defined label for J_FIELD5
J_USER_FIELD4	char	20		user-defined field
J_USER_FIELD5	char	20		user-defined field
J_USER_FIELD6	char	20		user-defined field
J_LAST_BILLED	Short date	1980..2079		date of last A/R invoice for this job (unused)
J_DATE_CLOSED	Short date	1980..2079		date job was closed
J_DATE3	Short date	1980..2079		spare date 3 (unused)
J_STATUS_NOTE	National	40		short status note
J_RATE_KIND	Short int	(0 to 255)		billing rate method (staff/client/task)
J_WORK_ORDER	char	2000		job work order text
J_TRAF1	char	4		assignment 1
J_TRAF2	char	4		assignment 2
J_TRAF3	char	4		assignment 3
J_TRAF4	char	4		assignment 4
J_TRAF5	char	4		assignment 5
J_TRAF6	char	4		assignment 6
J_ADDRESS1	char	50		estimate address
J_ADDRESS2	char	50		estimate address
J_ADDRESS3	char	50		estimate address
J_ADDRESS4	char	50		estimate address
J_ADDRESS5	char	50		estimate address
J_ADDRESS6	char	50		estimate address
J_BUDGET	Short num	2 dp		job's initial budget
J_SHIP_TO1	char	40
J_SHIP_TO2	char	40
J_SHIP_TO3	char	40
J_SHIP_TO4	char	40
J_ARCHIVED_ON	char	15		archive on location
J_BILL_TO	char	10		bill to client number
J_EST_OK	Short int	(0 to 255)		estimate approved
J_EST_OK_BY	char	4		estimate approved by - initials
J_EST_OK_WHEN	Short date	1980..2079		estimate approved - when
J_EXPORTED	Short date	1980..2079		Job exported
J_CLOSED_BY	char	4		who closed the job - initials
J_PRIORITY	Short num	0 dp		-3=bleeding rush -2=killer rush -1=rush 0=normal (no rush) 2=who knows
J_ALL_REVS	Short int	(0 to 255)		total number of revisions

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