File Structure - Advertising Source Keys
File Name:
ADCOSTS.DBF
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 numeric
position of the field in the table.
-
Field Name - The XBASE
field name used in programming the information transferred. It
serves to classify data kept in this field.
-
Type - Can be one of 5
types:
Character - Text type data
Numeric - numbers
Integer - a whole number
Datetime - a date
Logical - True or False
-
Width - The maximum number
of spaces that the field element can occupy.
-
Dec. - For numeric fields
only. The number of decimal places reserved for the numeric value.
This field is not applicable in Comma Delimited format.
-
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 that the field is used for the UK
Edition of M.O.M.
|
POSITION
|
FIELDNAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
ADKEY
|
Character
|
9
|
N/A
|
Source Key code.
|
|
2
|
ADDEPT
|
Character
|
8
|
N/A
|
Department/Additional key.
|
|
3
|
ADCOST
|
Numeric
|
9
|
2
|
Total cost of source.
|
|
4
|
ADCOSTIN
|
Numeric
|
9
|
2
|
Cost of Insertion.
|
|
5
|
ADCOSTPR
|
Numeric
|
9
|
2
|
Cost of Printing.
|
|
6
|
ADCOSTPO
|
Numeric
|
9
|
2
|
Cost of Postage.
|
|
7
|
ADCOSTMA
|
Numeric
|
9
|
2
|
Cost of Mailing.
|
|
8
|
ADIN
|
Character
|
30
|
N/A
|
Description of source.
|
|
9
|
ADDATE
|
Character
|
8
|
N/A
|
Break Date.
|
|
10
|
ADPROD
|
Character
|
25
|
N/A
|
Product advertised.
|
|
11
|
ADSIZE
|
Character
|
25
|
N/A
|
Space description.
|
|
12
|
NOTE1
|
Character
|
70
|
N/A
|
First memo line.
|
|
13
|
NOTE2
|
Character
|
70
|
N/A
|
Second memo line.
|
|
14
|
NOTE3
|
Character
|
70
|
N/A
|
Third memo line.
|
|
15
|
ADNETTOT
|
Numeric
|
11
|
2
|
RESERVED.
|
|
16
|
ADMAIL
|
Numeric
|
10
|
N/A
|
RESERVED.
|
|
17
|
ADFLATRATE
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
18
|
ADFLATCOST
|
Numeric
|
6
|
2
|
RESERVED.
|
|
19
|
CATCODE
|
Character
|
6
|
N/A
|
Catalog Code to which this source belongs.
|
|
20
|
RENEW_DATE
|
Datetime
|
8
|
N/A
|
Ad renewal date.
|
|
21
|
PUBLISHER
|
Character
|
25
|
N/A
|
List owner/publisher.
|
|
22
|
ADRATE
|
Numeric
|
10
|
2
|
Rate of ad.
|
|
23
|
INSERTIONS
|
Numeric
|
4
|
N/A
|
#
of insertions.
|
|
24
|
CAMPAIGN
|
Character
|
6
|
N/A
|
Campaign code.
|
|
25
|
INETSITE
|
Character
|
50
|
N/A
|
For use with SiteLINK.
|
|
26
|
COMMENT
|
Memo
|
4
|
N/A
|
Memo field containing comments about source key.
|
|
27
|
ADCOSTS_ID
|
Integer
(Auto Increment)
|
4
|
N/A
|
RESERVED.
|
|
