spacerspacer
Free help: USER GUIDE } WHAT'S NEW
Home > Support > Data Dictionary > MEDIA_PREFS
 Search:   


C&P Data Dictionary: MEDIA_PREFS

 

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:

MPF_SEQ Sequence
Sequence
MPF_NUM Number
0 dp
Next insertion order number
MPF_PREFIX char
3
Insertion order number prefix
MPF_DISCLAIMER char
2000
Standard media disclaimer - insertion orders
MPF_ORG char
50
Agency organization name
MPF_ADDRESS1 char
50
Agency address 1
MPF_ADDRESS2 char
50
Agency address 2
MPF_ADDRESS3 char
50
Agency address 3
MPF_PHONE char
50
Agency phone
MPF_COMM Number
2 dp
Standard agency commission
MPF_TO1 char
10
Copy 1 - insertions
MPF_TO2 char
10
Copy 2
MPF_TO3 char
10
Copy 3
MPF_TO4 char
10
Copy 4
MPF_TO5 char
10
Copy 5
MPF_TO6 char
10
Copy 6
MPF_FIELD1 char
15
User field 1
MPF_FIELD2 char
15
User field 2
MPF_FIELD3 char
15
User field 3
MPF_FIELD4 char
15
User field 4
MPF_FIELD5 char
15
User field 5
MPF_AUTO_NUM short int
(0 to 255)
Auto-numbering method
MPF_LOGO Picture
Logo (PICT or .BMP)
MPF_SHOW_CL short int
(0 to 255)
 
MPF_RADIO_1Q Number
0 dp
 
MPF_RADIO_2Q Number
0 dp
 
MPF_RADIO_3Q Number
0 dp
 
MPF_RADIO_4Q Number
0 dp
 
MPF_TV_1Q Number
0 dp
 
MPF_TV_2Q Number
0 dp
 
MPF_TV_3Q Number
0 dp
 
MPF_TV_4Q Number
0 dp
 
MPF_CABLE_1Q Number
0 dp
 
MPF_CABLE_2Q Number
0 dp
 
MPF_CABLE_3Q Number
0 dp
 
MPF_CABLE_4Q Number
0 dp
 
MPF_NEWS_1Q Number
0 dp
 
MPF_NEWS_2Q Number
0 dp
 
MPF_NEWS_3Q Number
0 dp
 
MPF_NEWS_4Q Number
0 dp
 
MPF_MAG_1Q Number
0 dp
 
MPF_MAG_2Q Number
0 dp
 
MPF_MAG_3Q Number
0 dp
 
MPF_MAG_4Q Number
0 dp
 
MPF_OUT_1Q Number
0 dp
 
MPF_OUT_2Q Number
0 dp
 
MPF_OUT_3Q Number
0 dp
 
MPF_OUT_4Q Number
0 dp
 
MPF_INT_1Q Number
0 dp
 
MPF_INT_2Q Number
0 dp
 
MPF_INT_3Q Number
0 dp
 
MPF_INT_4Q Number
0 dp
 
MPF_OTHER_1Q Number
0 dp
 
MPF_OTHER_2Q Number
0 dp
 
MPF_OTHER_3Q Number
0 dp
 
MPF_OTHER_4Q Number
0 dp
 
MPF_KIND short int
(0 to 255)
0=insertion/1=broadca st/6=interactive/7=ou tdoor

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