Field
Name: |
Type: |
Length: |
Index: |
Description: |
PUB_SEQ |
sequence |
|
x |
|
PUB_CODE |
char |
20 |
x |
station ID/publication name |
PUB_NAME |
national |
40 |
x |
|
PUB_REP |
national |
40 |
|
station sales rep |
PUB_PHONE |
char |
20 |
|
rep's phone |
PUB_ADDRESS1 |
char |
40 |
|
|
PUB_ADDRESS2 |
char |
40 |
|
|
PUB_ADDRESS3 |
char |
40 |
|
|
PUB_ADDRESS4 |
char |
40 |
|
|
PUB_NOTE |
char |
2000 |
|
|
PUB_FAX |
char |
15 |
|
|
PUB_VENDOR_NUM |
char |
10 |
x |
|
PUB_COMM_PC |
short num |
2dp |
|
commission % (not markup) |
PUB_TYPE |
char |
2 |
x |
TV=Television/RA=Radio/CA=Cable/PR=Print |
PUB_REP_ADDRESS1 |
char |
40 |
|
|
PUB_REP_ADDRESS2 |
char |
40 |
|
|
PUB_REP_ADDRESS3 |
char |
40 |
|
|
PUB_REP_ADDRESS4 |
char |
40 |
|
|
PUB_REP_ADDRESS5 |
char |
40 |
|
|
PUB_ISSUE_DATE |
char |
30 |
|
|
PUB_CLOSE_DATE |
char |
30 |
|
|
PUB_CIRC |
char |
20 |
|
circulation |
PUB_MARKET |
char |
40 |
|
media market |