Field
Name: |
Type: |
Length: |
Index: |
Description: |
M_SEQ |
sequence |
|
x |
|
M_CAMPAIGN |
char |
10 |
x |
campaign ID code or number |
M_NAME |
char |
100 |
x |
|
M_DESC |
char |
2000 |
|
|
M_BUDGET |
number |
2dp |
|
|
M_COST |
number |
2dp |
|
|
M_START_DATE |
short date |
(1980..2079) |
x |
|
M_END_START |
short date |
(1980..2079) |
|
|
M_SPOTS_TOTAL |
number |
0dp |
|
|
M_RATING_TOTAL |
number |
2dp |
|
|
M_COST_TOTAL |
number |
2dp |
|
|
M_CPP_TOTAL |
number |
2dp |
|
|
M_CPS_TOTAL |
number |
2dp |
|
|
M_RF_TOTAL |
number |
2dp |
|
|
M_CLIENT_NUM |
char |
10 |
x |
|
M_DATE_ADDED |
date & time |
(#FDT) |
|
date/time added |
M_ADDED_BY |
char |
4 |
|
who added this? |
M_REVISION |
short num |
0dp |
|
revision number (auto-count) |
M_REV_NOTE |
char |
40 |
|
revision note (describes the current revision) |
M_STATUS_NOTE |
char |
40 |
|
status of this media plan (client doesn't
see it) |
M_PO_COST |
number |
2dp |
|
cost amount ordered from insertion orders |
M_PO_GROSS |
number |
2dp |
|
gross amount ordered from insertion orders |
M_BILLED |
number |
2dp |
|
amount billed in A/R from Media Billing option |
M_PERIOD1 |
char |
10 |
|
print plan column heading |
M_PERIOD2 |
char |
10 |
|
print plan column heading |
M_PERIOD3 |
char |
10 |
|
print plan column heading |
M_PERIOD4 |
char |
10 |
|
print plan column heading |
M_PERIOD5 |
char |
10 |
|
print plan column heading |
M_TYPE |
number |
0dp |
x |
0=Broadcast/1=Print 2=Outdoor/3=Other |
M_MEMO |
char |
2000 |
|
|
M_NUM |
char |
10 |
x |
Plan number |
M_FIELD_LABEL1 |
char |
20 |
|
|
M_FIELD_LABEL2 |
char |
20 |
|
|
M_FIELD_LABEL3 |
char |
20 |
|
|
M_FIELD_LABEL4 |
char |
20 |
|
|
M_FIELD_LABEL5 |
char |
20 |
|
|
M_FIELD_LABEL6 |
char |
20 |
|
|
M_FIELD1 |
char |
20 |
|
|
M_FIELD2 |
char |
20 |
|
|
M_FIELD3 |
char |
20 |
|
|
M_FIELD4 |
char |
20 |
|
|
M_FIELD5 |
char |
20 |
|
|
M_FIELD6 |
char |
20 |
|
|
M_AE_TEAM |
char |
10 |
x |
|
M_CLIENT_CONT |
char |
40 |
|
client contact |
M_CLIENT_PHONE |
char |
20 |
|
client phone |
M_F1 |
char |
2 |
|
|
M_SA1 |
char |
2 |
|
|
M_SU1 |
char |
2 |
|
|
M_M1 |
char |
2 |
|
|
M_TU1 |
char |
2 |
|
|
M_W1 |
char |
2 |
|
|
M_TH1 |
char |
2 |
|
|
M_F2 |
char |
2 |
|
|
M_SA2 |
char |
2 |
|
|
M_SU2 |
char |
2 |
|
|
M_M2 |
char |
2 |
|
|
M_TU2 |
char |
2 |
|
|
M_W2 |
char |
2 |
|
|
M_TH2 |
char |
2 |
|
|
M_F3 |
char |
2 |
|
|
M_PER_LABEL1 |
char |
10 |
|
|
M_PER_LABEL2 |
char |
10 |
|
|
M_PER_LABEL3 |
char |
10 |
|
|
M_PER_LABEL4 |
char |
10 |
|
|
M_PER_LABEL5 |
char |
10 |
|
|
M_PER_LABEL6 |
char |
10 |
|
|
M_PER_LABEL7 |
char |
10 |
|
|
M_PER_LABEL8 |
char |
10 |
|
|
M_PER_LABEL9 |
char |
10 |
|
|
M_PER_LABEL10 |
char |
10 |
|
|
M_PER_LABEL11 |
char |
10 |
|
|
M_PER_LABEL12 |
char |
10 |
|
|
M_PERIOD6 |
char |
10 |
|
|
M_PERIOD7 |
char |
10 |
|
|
M_PERIOD8 |
char |
10 |
|
|
M_PERIOD9 |
char |
10 |
|
|
M_PERIOD10 |
char |
10 |
|
|
M_PERIOD11 |
char |
10 |
|
|
M_PERIOD12 |
char |
10 |
|
|
M_JOB_NUM |
char |
10 |
x |
|
M_TASK |
char |
4 |
|
|
M_APPROVAL1 |
char |
30 |
|
approval name 1 |
M_APPROVAL2 |
char |
30 |
|
approval name 2 |
M_APPROVAL3 |
char |
30 |
|
approval name 3 |
M_FLIGHT |
char |
100 |
|
|
M_KIND |
short int |
(0 to 255) |
|
Print plan: 1=daily/2=weekly 3=monthly/4=quarterly |
M_COMMISSION |
number |
2dp |
|
media commission |
M_STATUS |
number |
0dp |
|
|
M_BRAND |
char |
20 |
|
|
M_CLOSED |
integer |
|
|
closed |
M_INACTIVE |
integer |
|
|
inactive |