BEGIN TRANSACTION GO DELETE FROM [mp_reports] INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (0, 0, 1, '', ' Air report

Air report

Spots list

not-released
Date/Time
(panning)
dd.mm.yyyy
hh:mm:ss
 Released/Unreleased Released time hh:mm:ss Name Spot type
  Unreleased Released Unknown/pending   -    

Schedule:

Contractor:
Date period analysis:
Closing date period analysis:
Media plan number:
Total number of spots in the media plan at the time of its approval:
Total number of released spots:
Total number of unreleased spots
The total value of exits on the fact:

') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (1, 0, 1, '', ' Bill

Bill

 :

Details jur. person:
Spots count:
The cost of one spot:
Total:

Responsible manager:
Date:
Signature:

Spots
count
 Cost Total

') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (4, 0, 1,'', ' Media plan

Media plan

List



Spots information

Spotnumber in media plans Name ID Number Duration Spot type
         

Discounts

Name Percentage Amount
     
       

Schedule:
Contractor:
Deployment dates: -
Released counts:
Total released counts:
Number of bonus spots:

') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (2, 0, 1, '', ' Contractor balance

Contractor balance

Payments list

Jur. People Media plan number Date Account Total accounts Payment amount Balance

Contractor:

') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (3, 0, 1, '', ' Some report

Technical report

Date analysis:
Schedule:
Released spots count:
Unreleased spots count:

not-released
Date Spot Released Released date
    + x    
') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (5, 0, 1, '', ' Grid

Grid

 Spots information
Number of spot in media plans Name ID Number Duration Spot type
Name Percentage Amount
#f3649a

Schedule:
Contractor:
Deployment dates: -
Released count:

Total released count:

') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (6, 1, 1, '', ' Radio From To Order Client Agency Agent Normal releases (for period) Normal releases Cancelled releases Virtual releases Timing Timing (for period) Time study by play-lists Release in play-lists Release in play-lists (for period) Timing by play-lists (for period) Payer Bill Full cost Paid Debt Barter <Нет> <Нет>
') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (7, 1, 1, '', ' Radio Date Day Order Spot Calc. diration Really diration position Start Stop Number (position in block) Attachment
') GO INSERT INTO [mp_reports] ([type], [app_type], [is_used_app], [xml], [xslt]) VALUES (8, 1, 1, '', ' Order Client Agency Agent From To Spot Calc. duration Really duration Normal releases (for period) Normal timing (for period) Virtual releases (for period) Cancelled releases (for period) Attachment <Нет>
') GO COMMIT GO