C&P Data Dictionary: MEDIA_PLANS

Other files: ACCOUNTS AP AR AR_ITEMS BILLING_INFO CHANGE_ORDER CHECKS CHECK_ITEMS CLIENTS COSTS DEPTS GROUPS HISTORY HISTORY_CLIENT INT_ITEMS JE JOBS JOB_ORDER JOB_TASK JOB_TYPES MEDIA_EST MEDIA_EST_ITEMS MEDIA_ITEMS MEDIA_PLANS PAYMENTS PAYMENT_ITEMS PC PICTURES PO_ITEMS PO_TEMPLATE PRINT_SPECS PROGRAMS PROJECTS PURCHASE_ORDER RATES RECUR_AP RETAINERS STAFF STATIONS STATUS_CODES SUB_CLASSES TASK_TABLE VENDORS WEB_IP_LOG WEB_USERS WORKSHEETS

MEDIA_PLANS See related data files:   JE   SUB_CLASSES 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 32000     M_BUDGET number 2dp M_COST number 2dp     M_START_DATE date x M_END_START date       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     date/time added M_ADDED_BY char 4 who added this? M_REVISION number 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 32000     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 integer 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 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.