Clients & Profits Worldwide :: Data Dictionary

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

Home > Support > Data Dictionary > PRINT_SPECS

Search:

C&P Data Dictionary: PRINT_SPECS

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:
PSPEC_SEQ	sequence		x
PSPEC_JOB_NUM	char	10	x	job number
PSPEC_PROD_COORD	char	10		print production coordinator
PSPEC_DATE	short date	(1980..2079)		print spec date
PSPEC_DATE_NEEDED	short date	(1980..2079)		date needed
PSPEC_DESCRIPTION	char	60		Notes for 'budget estimate', 'firm quote' and the like
PSPEC_ART_DUE	short date	(1980..2079)		art/disks due date
PSPEC_FINAL_DUE	short date	(1980..2079)		finished job due
PSPEC_QTY	char	30		number of pieces
PSPEC_OVERRUN	char	30		overrun approval info
PSPEC_COV_FLATSIZE	char	30		cover flat size
PSPEC_COV_FOLDSIZE	char	30		cover folded size
PSPEC_COV_STOCK	char	60		cover stock, color, weight, finish
PSPEC_COV_OUTSIDE	char	60		outside cover number of colors, ink coverage
PSPEC_COV_INSIDE	char	60		inside cover number of colors, ink coverage
PSPEC_COV_O_BLEEDS	char	30		cover outside bleeds
PSPEC_COV_I_BLEEDS	char	30		cover inside bleeds
PSPEC_COV_PANTONE	char	60		cover pantone colors
PSPEC_TX_FLATSIZE	char	30		text flat size
PSPEC_TX_FOLDSIZE	char	30		text folded size
PSPEC_TX_STOCK	char	60		text stock, color, weight, finish
PSPEC_TX_COLORS	char	60		text colors, coverage, process
PSPEC_TX_BLEEDS	char	30		text bleeds
PSPEC_TX_PANTONE	char	60		text pantone colors
PSPEC_TX_PAGES	char	30		number of pages
PSPEC_IN_FLATSIZE	char	30		insert flat size
PSPEC_IN_FOLDSIZE	char	30		insert folded size
PSPEC_IN_STOCK	char	60		insert stock, color, weight, finish
PSPEC_IN_COLORS	char	60		insert colors, coverage, process
PSPEC_IN_PAGES	char	30		number of inserts
PSPEC_IN_BLEEDS	char	30		insert bleeds
PSPEC_IN_PANTONE	char	60		pantone colors
PSPEC_IN_COLLATE	boolean			collate checkbox
PSPEC_MECH	boolean			conventional mechanicals
PSPEC_ELEC	boolean			Electronic Prepress
PSPEC_FILM	boolean			composed film
PSPEC_NO_IMAGES	char	60		number, screen, description
PSPEC_T1	char	60		transparency 1 qty, orig size, repro size, process
PSPEC_T2	char	60
PSPEC_T3	char	60
PSPEC_T4	char	60
PSPEC_TRANS_SPEC	char	60		special transparency instructions
PSPEC_R1	char	60		reflective 1 qty, orig size, repro size, process
PSPEC_R2	char	60
PSPEC_R3	char	60
PSPEC_R4	char	60
PSPEC_REF_SPEC	char	60		special reflective instructions
PSPEC_STRIPPING	char	2000		stripping instructions
PSPEC_PROOFING	char	2000		proofing instructions
PSPEC_BINDERY	char	2000		bindery instructions
PSPEC_PACKAGE	char	2000		packaging instructions
PSPEC_ADDED_BY	char	4		initials of person who added the print spec
PSPEC_STATUS	char	2000

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