Field
Name: |
Type: |
Length: |
Index: |
Description: |
PGM_SEQ |
sequence |
|
x |
PGM/AD SIZE RSN |
PGM_CODE |
char |
20 |
x |
Publication code/Station letters |
PGM_TIME_PGM |
char |
30 |
x |
Program - time |
PGM_RATING_EA |
short num |
2dp |
|
Program - rating/each spot |
PGM_COST_EA |
short num |
2dp |
|
Program - cost/each spot |
PGM_GROUP |
char |
6 |
|
Program - group (for sub-totaling) |
PGM_NOTE |
char |
2000 |
|
Program - Notes |
PGM_TYPE |
char |
2 |
x |
PR=Print/TV=Television
RA=Radio/CA=Cable/ |
AD_NAME |
char |
30 |
|
Ad Size - Space/Name |
AD_POSITION |
char |
30 |
|
Ad Size - Position |
AD_NOTES |
char |
2000 |
|
Ad Size - Notes |
AD_GROSS_AMT |
number |
2dp |
|
Ad Size - Gross Amount |
AD_COMM |
short num |
2dp |
|
Ad Size - Commission % |
AD_NET_AMT |
number |
2dp |
|
Ad Size - Net Cost |
AD_EXTRA_AMT |
number |
2dp |
|
Ad Size - Extra amount |
AD_BILL_NET |
short num |
0dp |
|
Ad Size - Bill Net, not Gross |
AD_ISSUE_DATE |
char |
30 |
|
Ad Size - Issue date |
AD_SPACE_CLOSE |
char |
30 |
|
Ad Size - Space closing |
AD_MAT_CLOSE |
short num |
0dp |
|
Ad Size - Materials close (day) |
PGM_KEY |
char |
50 |
x |
|
PGM_CLIENT_NUM |
char |
10 |
x |
Program - client number |
AD_RATE_BASIS |
char |
4 |
|
Publication - Rate Basis |