Clients & Profits Worldwide :: Data Dictionary

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

Home > Support > Data Dictionary > MEDIA_EST_ITEMS

Search:

C&P Data Dictionary: MEDIA_EST_ITEMS

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

MEDIA_EST_ITEMS is the data file that stores the Media Estimate Line Items. Each MEDIA_EST_ITEMS record contains a Media Estimate Line Item. It is a lookup file used primarly on the Media Estimate Snapshot. Each MEDIA_EST_ITEMS record has fields for the Publication Name (MI_PUB), Media Item Dates (MI_ISSUE_DATE, and MI_CLOSE_DATE). This data file also contains data for Ad# / Caption, Size, & Cost (MI_AD_NAME, MI_AD_SIZE, MI_GROSS, & MI_COST) for each Line Item. These fields are updated when a Media Estimate line Item entries are added.

See related data files: MEDIA_EST

Field Name:	Type:	Length:	Index:	Description:
MI_SEQ	sequence		x	sequence
MI_ME_NUM	char	10	x	media estimate ID#
MI_PUB	char	20		publication name
MI_ISSUE_DATE	char	12		issue date (month)
MI_CLOSE_DATE	short date		x	close date (day)
MI_AD_NAME	char	25		ad name
MI_AD_SIZE	char	30		ad size or unit
MI_GROSS	number	2dp		gross cost
MI_COST	number	2dp		net cost
MI_COMM	number	2dp		commission %
MI_VENDOR_NUM	char	5		publication's vendor number
MI_PO_NUM	char	10		insertion order #
MI_PO_AMT	number	2dp		ordered amount on insertion order
MI_PO_DATE	short date			insertion order date
MI_JOB_NUM	char	10		job number
MI_TASK	char	4		job task
MI_STATUS	char	30		status of this media buy
MI_NOTES	char	2000		media buy notes
MI_SHOW_NOTES	short int	(0 to 255)		show notes on printed estimate?
MI_MATERIALS_DUE	short date		x	materials due date
MI_PERIOD	short int	(0 to 255)		which period does the ad run in?
MI_BILL_NET	short int	(0 to 255)		bill net, not gross
MI_RUN_DATE	short date		x	the date the ad actually airs or appears

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