File Structure - Subscriptions
File Name:
SUBSCRIP
File
Contents: Contains information on subscription items. Each
subscription is a separate record in this file.
Table Legend
The column
headings in the table include the following.
-
Position - The ordinal
position of the field in the table.
-
Field Name - The column
name used in programming the information transferred. It serves to
classify data kept in this field.
-
Type - Can be one of 6
types:
Char - Text type data
Text- a field with a large character limit.
Numeric - numbers
Int- a whole number
Datetime - a date
Bit- a logical
field. 0=False, 1=True
-
Character Length- For
Character fields only. The maximum number of character that the
field element can occupy.
-
Numeric Precision - For
numeric fields only. The maximum length for a numeric value before
the radix point.
-
Numeric Scale- For
numeric fields only. The maximum length for a decimal value after
the radix point.
-
Description of Field - A
definition of the field's contents. RESERVED signifies for M.O.M.
use only. FUTURE USE signifies that the field may be used in a
future release. UK Only signifies a field used for the UK edition
of M.O.M.
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
POINTER
|
DESCRIPTION
|
|
1
|
PUB_CODE
|
Char
|
8
|
N/A
|
N/A
|
Publication code.
|
|
2
|
CUSTNUM
|
Numeric
|
N/A
|
10
|
0
|
Subscription customer number (the person
|
|
3
|
BCUSTNUM
|
Numeric
|
N/A
|
10
|
0
|
Billing customer number (only when
|
|
4
|
JOIN_DATE
|
Datetime
|
N/A
|
23
|
3
|
Initial join date. Set to order entry date
|
|
5
|
NEW_MEMBER
|
Bit
|
N/A
|
1
|
0
|
New member status flag set to true
|
|
6
|
RENEWED
|
Bit
|
N/A
|
1
|
0
|
Set to true when a renewal takes
|
|
7
|
ISSUES_LFT
|
Numeric
|
N/A
|
4
|
0
|
Number of issues remaining on this
|
|
8
|
ISSUES_SNT
|
Numeric
|
N/A
|
4
|
0
|
Number of issues sent to date.
|
|
9
|
MAIL_ISSUE
|
Numeric
|
N/A
|
6
|
0
|
Last issue number mailed.
|
|
10
|
MAIL_DATE
|
Datetime
|
N/A
|
23
|
3
|
Date of the last mailing.
|
|
11
|
RENEW_DATE
|
Datetime
|
N/A
|
23
|
3
|
Date of last renewal.
|
|
12
|
RENEW_ORDR
|
Numeric
|
N/A
|
8
|
0
|
Last order number for a renewal.
|
|
13
|
LAST_PRICE
|
Numeric
|
N/A
|
12
|
4
|
Price of last renewal.
|
|
14
|
LAST_ITEM
|
Char
|
20
|
N/A
|
N/A
|
Product code of last renewal.
|
|
15
|
ON_HOLD
|
Bit
|
N/A
|
1
|
0
|
Indicates that the subscription has been
|
|
16
|
KIT_ITEM
|
Char
|
20
|
N/A
|
N/A
|
RESERVED.
|
|
17
|
KIT_DATE
|
Datetime
|
N/A
|
23
|
3
|
RESERVED.
|
|
18
|
SUBSCRIP_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
