|
C&P Data
Dictionary: MEDIA_EST |
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 is
the header file that stores the Media Estimate data. Each MEDIA_EST
record contains a single Media Estimate's header data. It is a
data file used primarly on . Each MEDIA_EST record has fields for
Client, Catagory, and Description (i.e., ME_CLIENT_NUM, ME_CAMPAIGN,
ME_DESC) , Date, Job, Task, and Approvals (i.e., ME_DATE, ME_JOB_NUM,
ME_TASK, and ME_APPROVAL1 thru ME_APPROVAL3), and the Custom Labels
(i.e., ME_LABEL1 thru ME_LABEL5) for each Media Estimate. These
fields are updated when Media Estimates are added. Client Spending
and Status Reports are also created from these data fields.
See related data
files: MEDIA_PLANS
Field
Name: |
Type: |
Length: |
Index: |
Description: |
ME_SEQ |
sequence |
|
x |
sequence |
ME_NUM |
char |
10 |
x |
ID# |
ME_CLIENT_NUM |
char |
10 |
x |
client number |
ME_CAMPAIGN |
char |
20 |
x |
project/brand/campaign |
ME_DATE |
short date |
(1980..2079) |
x |
date opened |
ME_DESC |
char |
2000 |
|
description |
ME_BUYER |
char |
3 |
|
buyer initials |
ME_GROSS |
number |
2dp |
|
gross amount (includes commission) |
ME_LABEL1 |
char |
20 |
|
user-defined label |
ME_LABEL2 |
char |
20 |
|
user-defined label |
ME_LABEL3 |
char |
20 |
|
user-defined label |
ME_LABEL4 |
char |
20 |
|
user-defined label |
ME_LABEL5 |
char |
20 |
|
user-defined label |
ME_STATUS |
char |
30 |
|
current status |
ME_COST |
number |
2dp |
|
net cost amount |
ME_CLOSED |
short int |
(0 to 255) |
|
closed? |
ME_SHOW_DESC |
short int |
(0 to 255) |
|
show description on printed media estimate? |
ME_DISCLAIMER |
char |
2000 |
|
estimate disclaimer |
ME_APPROVAL1 |
char |
30 |
|
approval name 1 |
ME_APPROVAL2 |
char |
30 |
|
approval name 2 |
ME_APPROVAL3 |
char |
30 |
|
approval name 3 |
ME_COMM |
number |
2dp |
|
commission % |
ME_JOB_NUM |
char |
10 |
|
|
ME_TASK |
char |
4 |
|
|
ME_BRAND |
char |
20 |
|
|
ME_INACTIVE |
short int |
(0 to 255) |
|
inactive |
ME_TYPE |
short int |
(0 to 255) |
|
0=PØ 1=Insertion 4=Broadcast Order 6=Interactive 7=Outdoor |
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.
|
|
|
© Clients & Profits Worldwide w
e l o v e a d v e r t i s i n g |
|
|