File
Contents: Contains information on subscription items. Each
subscription is a separate record in this file.
The column
headings in the table include the following.
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
PUB_CODE
|
Character
|
8
|
N/A
|
Publication code.
|
|
2
|
CUSTNUM
|
Numeric
|
8
|
N/A
|
Subscription customer number (the person
|
|
3
|
BCUSTNUM
|
Numeric
|
8
|
N/A
|
Billing customer number (only when
|
|
4
|
JOIN_DATE
|
Date
|
8
|
N/A
|
Initial join date. Set to order entry date
|
|
5
|
NEW_MEMBER
|
Logical
|
1
|
N/A
|
New member status flag set to true
|
|
6
|
RENEWED
|
Logical
|
1
|
N/A
|
Set to true when a renewal takes
|
|
7
|
ISSUES_LFT
|
Numeric
|
4
|
N/A
|
Number of issues remaining on this
|
|
8
|
ISSUES_SNT
|
Numeric
|
4
|
N/A
|
Number of issues sent to date.
|
|
9
|
MAIL_ISSUE
|
Numeric
|
6
|
N/A
|
Last issue number mailed.
|
|
10
|
MAIL_DATE
|
Date
|
8
|
N/A
|
Date of the last mailing.
|
|
11
|
RENEW_DATE
|
Date
|
8
|
N/A
|
Date of last renewal.
|
|
12
|
RENEW_ORDR
|
Numeric
|
8
|
N/A
|
Last order number for a renewal.
|
|
13
|
LAST_PRICE
|
Numeric
|
12
|
4
|
Price of last renewal.
|
|
14
|
LAST_ITEM
|
Character
|
20
|
N/A
|
Product code of last renewal.
|
|
15
|
ON_HOLD
|
Logical
|
1
|
N/A
|
Indicates that the subscription has been
|
|
16
|
KIT_ITEM
|
Character
|
20
|
N/A
|
RESERVED.
|
|
17
|
KIT_DATE
|
Date
|
8
|
N/A
|
RESERVED.
|
|
18
|
SUBSCRIP_ID
|
Integer
(Auto Increment)
|
4
|
N/A
|
RESERVED.
|
