File Structure - Advertising Source Keys
File Name:
ADCOSTS
File
Contents: Contains information on each advertising source key setup
in the system.
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
|
FIELDNAME
|
TYPE
|
CHARACTER LENGTH
|
NUMERIC PRECISION
|
NUMERIC SCALE
|
DESCRIPTION
|
|
1
|
ADKEY
|
Char
|
9
|
N/A
|
N/A
|
Source Key code.
|
|
2
|
ADDEPT
|
Char
|
8
|
N/A
|
N/A
|
Department/Additional key.
|
|
3
|
ADCOST
|
Numeric
|
N/A
|
10
|
2
|
Total cost of source.
|
|
4
|
ADCOSTIN
|
Numeric
|
N/A
|
9
|
2
|
Cost of Insertion.
|
|
5
|
ADCOSTPR
|
Numeric
|
N/A
|
9
|
2
|
Cost of Printing.
|
|
6
|
ADCOSTPO
|
Numeric
|
N/A
|
9
|
2
|
Cost of Postage.
|
|
7
|
ADCOSTMA
|
Numeric
|
N/A
|
9
|
2
|
Cost of Mailing.
|
|
8
|
ADIN
|
Char
|
30
|
N/A
|
N/A
|
Description of source.
|
|
9
|
ADDATE
|
Datetime
|
N/A
|
23
|
3
|
Break Date
|
|
10
|
ADPROD
|
Char
|
25
|
N/A
|
N/A
|
Product advertised.
|
|
11
|
ADSIZE
|
Char
|
25
|
N/A
|
N/A
|
Space description.
|
|
12
|
NOTE1
|
Char
|
70
|
N/A
|
N/A
|
First memo line.
|
|
13
|
NOTE2
|
Char
|
70
|
N/A
|
N/A
|
Second memo line.
|
|
14
|
NOTE3
|
Char
|
70
|
N/A
|
N/A
|
Third memo line.
|
|
15
|
ADNETTOT
|
Numeric
|
N/A
|
11
|
2
|
RESERVED.
|
|
16
|
ADMAIL
|
Numeric
|
N/A
|
10
|
0
|
RESERVED.
|
|
17
|
ADFLATRATE
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
18
|
ADFLATCOST
|
Numeric
|
N/A
|
6
|
2
|
RESERVED.
|
|
19
|
CATCODE
|
Char
|
6
|
N/A
|
N/A
|
Catalog Code to which this source belongs.
|
|
20
|
RENEW_DATE
|
Datetime
|
N/A
|
23
|
3
|
Ad renewal date.
|
|
21
|
PUBLISHER
|
Char
|
25
|
N/A
|
N/A
|
List owner/publisher.
|
|
22
|
ADRATE
|
Numeric
|
N/A
|
10
|
2
|
Rate of ad.
|
|
23
|
INSERTIONS
|
Numeric
|
N/A
|
4
|
0
|
#
of insertions.
|
|
24
|
CAMPAIGN
|
Char
|
6
|
N/A
|
N/A
|
Campaign code.
|
|
25
|
INETSITE
|
Char
|
50
|
N/A
|
N/A
|
For use with SiteLINK.
|
|
26
|
COMMENT
|
Text
|
2147483647
|
N/A
|
N/A
|
Text field containing comments about source key.
|
|
27
|
ADCOSTSID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
