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 |