Clients & Profits Worldwide :: Data Dictionary

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

Home > Support > Data Dictionary > MEDIA_ITEMS

Search:

C&P Data Dictionary: MEDIA_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

Field Name:	Type:	Length:	Index:	Description:
MX_SEQ	sequence		x
MX_CAMPAIGN_NUM	char	10	x	campaign code number
MX_DATE	date & time	(#FDT)
MX_STATION	char	15		station
MX_GROUP	char	6		group (for sub-totalling)
MX_TIME_PGM	char	30		time/program
MX_GROSS_EA	number	2dp		cost each
MX_F1	number	0dp		Friday - week 1
MX_SA1	number	0dp		Saturday - week 1
MX_SU1	number	0dp		Sunday - week 1
MX_M1	number	0dp		Monday - week 1
MX_T1	number	0dp		Tuesday - week 1
MX_W1	number	0dp		Wednesday - week 1
MX_TH1	number	0dp		Thursday - week 1
MX_F2	number	0dp		Friday - week 2
MX_SA2	number	0dp		Saturday - week 2
MX_SU2	number	0dp		Sunday - week 2
MX_M2	number	0dp		Monday - week 2
MX_T2	number	0dp		Tuesday - week 2
MX_W2	number	0dp		Wednesday - week 2
MX_TH2	number	0dp		Thursday - week 2
MX_F3	number	0dp		Friday - week 3
MX_RATING_EA	number	1dp		rating/each
MX_RATING	number	1dp		rating/total
MX_GROSS_AMT	number	2dp		cost/total
MX_SPOTS	number	0dp		total number of spots
MX_WEEK1_1	char	30
MX_WEEK1_2	char	25
MX_WEEK1_COST	number	2dp
MX_WEEK2_1	char	30
MX_WEEK2_2	char	25
MX_WEEK2_COST	number	2dp
MX_WEEK3_1	char	30
MX_WEEK3_2	char	25
MX_WEEK3_COST	number	2dp
MX_WEEK4_1	char	30
MX_WEEK4_2	char	25
MX_WEEK4_COST	number	2dp
MX_WEEK5_1	char	30
MX_WEEK5_2	char	25
MX_WEEK5_COST	number	2dp
MX_NOTES	char	2000
MX_M_NUM	char	10	x	media plan ID#
MX_MEDIA1	char	40	x	print media - name of mag/newspaper
MX_MEDIA2	char	40
MX_MEDIA3	char	40
MX_PO_NUM	char	10		PO number created for this insertion
MX_DATE_ORDERED	date			date insertion order was made
MX_ORDERED	char	1
MX_WEEK6_1	char	30
MX_WEEK6_2	char	25
MX_WEEK6_COST	Number	2 dp
MX_WEEK7_1	char	30
MX_WEEK7_2	char	25
MX_WEEK7_COST	Number	2 dp
MX_WEEK8_1	char	30
MX_WEEK8_2	char	25
MX_WEEK8_COST	Number	2 dp
MX_WEEK9_1	char	30
MX_WEEK9_2	char	25
MX_WEEK9_COST	Number	2 dp
MX_WEEK10_1	char	30
MX_WEEK10_2	char	25
MX_WEEK10_COST	Number	2 dp
MX_WEEK11_1	char	30
MX_WEEK11_2	char	25
MX_WEEK11_COST	Number	2 dp
MX_WEEK12_1	char	30
MX_WEEK12_2	char	25
MX_WEEK12_COST	Number	2 dp
MX_AMT_ORDERED	Number	2 dp		Amount ordered on insertion orders
MX_WEEK1_PO	char	12
MX_WEEK2_PO	char	12
MX_WEEK3_PO	char	12
MX_WEEK4_PO	char	12
MX_WEEK5_PO	char	12
MX_WEEK6_PO	char	12
MX_WEEK7_PO	char	12
MX_WEEK8_PO	char	12
MX_WEEK9_PO	char	12
MX_WEEK10_PO	char	12
MX_WEEK11_PO	char	12
MX_WEEK12_PO	char	12
MX_AD_CAPTION	char	50		Ad name/caption
MX_WEEK1_3	char	25
MX_WEEK2_3	char	25
MX_WEEK3_3	char	25
MX_WEEK4_3	char	25
MX_WEEK5_3	char	25
MX_WEEK6_3	char	25
MX_WEEK7_3	char	25
MX_WEEK8_3	char	25
MX_WEEK9_3	char	25
MX_WEEK10_3	char	25
MX_WEEK11_3	char	25
MX_WEEK12_3	char	25
MX_RATE_BASIS	char	5
MX_SPACE_CLOSE1	Short date	1980..2079
MX_SPACE_CLOSE2	Short date	1980..2079
MX_SPACE_CLOSE3	Short date	1980..2079	x
MX_SPACE_CLOSE4	Short date	1980..2079
MX_SPACE_CLOSE5	Short date	1980..2079
MX_SPACE_CLOSE6	Short date	1980..2079
MX_SPACE_CLOSE7	Short date	1980..2079
MX_SPACE_CLOSE8	Short date	1980..2079
MX_SPACE_CLOSE9	Short date	1980..2079
MX_SPACE_CLOSE10	Short date	1980..2079
MX_SPACE_CLOSE11	Short date	1980..2079
MX_SPACE_CLOSE12	Short date	1980..2079
MX_MAT_DUE1	Short date	1980..2079
MX_MAT_DUE2	Short date	1980..2079
MX_MAT_DUE3	Short date	1980..2079
MX_MAT_DUE4	Short date	1980..2079
MX_MAT_DUE5	Short date	1980..2079
MX_MAT_DUE6	Short date	1980..2079
MX_MAT_DUE7	Short date	1980..2079
MX_MAT_DUE8	Short date	1980..2079
MX_MAT_DUE9	Short date	1980..2079
MX_MAT_DUE10	Short date	1980..2079
MX_MAT_DUE11	Short date	1980..2079
MX_MAT_DUE12	Short date	1980..2079
MX_LENGTH	char	6
MX_DAY	char	12
MX_DATES	char	25
MX_TIME	char	25
MX_QTY	Short num	0 dp
MX_START_DATE	Short date	1980..2079		date for daily buys to start
MX_RUN_DATE1	Short date	1980..2079
MX_RUN_DATE2	Short date	1980..2079
MX_RUN_DATE3	Short date	1980..2079
MX_RUN_DATE4	Short date	1980..2079
MX_RUN_DATE5	Short date	1980..2079
MX_RUN_DATE6	Short date	1980..2079
MX_RUN_DATE7	Short date	1980..2079
MX_RUN_DATE8	Short date	1980..2079
MX_RUN_DATE9	Short date	1980..2079
MX_RUN_DATE10	Short date	1980..2079
MX_RUN_DATE11	Short date	1980..2079
MX_RUN_DATE12	Short date	1980..2079

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. char 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