Subscriber Activity Import Format
Last updated
Last updated
File type: Pipe delimited.
Location: /dti/exchange/cm/secure. The file name is user-defined.
The Account Lookup Record, which is required, must be followed by transaction data that starts on a separate line. The following is an example of how the file might look if you were importing billing change transactions.
1 - Record Type
character
10
“Account”
Yes
2 - Subscription ID
integer
10
Occupant’s subscription ID
No
3 - Address ID
integer
10
Occupant’s address ID
No
4 - Occupant ID
integer
10
Occupant ID
No
5 - First Name
character
12
Occupant’s first name
No
6 - Middle Initial
character
1
Occupant’s middle initial
No
7 - Last Name
character
30
Occupant’s last name
Yes
8 - Name Suffix
character
12
Occupant’s name suffix * Required if name suffix records have been set up in Circulation.
Yes*
9 - Area Code
character
6
Area code of occupant’s phone
No
10 - Phone Number
character
8
Phone number of occupant
Yes
11 - House Number
character
10
House number of address
Yes
12 - House Number Modifier
character
3
House number modifier
No
13 - Predirectional
character
2
Address predirectional (N,S,E,W,NE,NW,SE or SW)
No
14 - Street Name
character
28
Address street name
Yes
15 - Street Suffix
character
7
Address street suffix
No
16 - Post Directional
character
2
Address post directional (N,S,E,W,NE,NW,SE or SW)
No
17 - Complex
character
20
Address complex
No
18 - Building
character
20
Address building
No
19 - Unit Designator
character
6
Address unit (Apt, Suite, etc.)
No
20 - Unit Number
character
8
Address unit number
No
21 - City
character
28
City name of address
Yes
22 - State
character
3
State of address
Yes
23 - ZIP Code
character
10
ZIP code for address
Yes
24 - ZIP Extension
character
4
ZIP extension for address
No
25 - Product / Combo ID
character
8
Subscriber’s publication
Yes
26 - Delivery Method
character
6
This will be Route, Mail, or Online. Must be blank for combo subscriptions.
Yes
27 - External Account ID
character
16
Subscription alternate key
No
28 - Level Designator
character
6
Address level (Bldg, Floor, etc.)
No
29 - Level Number
character
6
Address level number
No
30 - Salutation ID
character
8
Occupant salutation (Dr., Ms., etc.)
No
31 - County
character
25
County of the delivery address
No
32 - Country
character
3
Country of the delivery address
No
33 - Email Address
character
30
Occupant email address for Digital Sales
No
34 - Address.IsOnline
character
Digital Sales Workflow address. Default is no if it is not identified in the Subscriber Activity Import file.
No
1 - Record Type
character
10
“Solicit”
Yes
2 - Solicitation code #1
character
8
First solicitation code to update
No
3 - Solicitation code #2
character
8
Second solicitation code to update
No
1 - Record Type
character
10
“Start”
Yes
2 - Unlisted Phone
logical
1
Will be Y or N, to indicate if occupant’s phone number is unlisted
Yes
3 - Occupant Type
character
15
Occupant’s occupant type
No
4 - Credit Status
character
11
Occupant’s credit status
No
5 - E-mail Address
character
30
Occupant’s e-mail address
No
6 - Delivery Request
character
30
Occupant delivery requests
No
7 - Delivery Directions
character
30
Directions to address
No
8 - Delivery Schedule
character
8
Valid delivery schedule. Must be blank for combo subscriptions.
Yes
9 - Delivery Placement
character
8
Valid newspaper delivery placement
No
10 - Copies by Weekday[1]
character
3
Copies by day of week
Yes
11 - Copies by Weekday[2]
character
3
Copies by day of week
Yes
12 - Copies by Weekday[3]
character
3
Copies by day of week
Yes
13 - Copies by Weekday[4]
character
3
Copies by day of week
Yes
14 - Copies by Weekday[5]
character
3
Copies by day of week
Yes
15 - Copies by Weekday[6]
character
3
Copies by day of week
Yes
16 - Copies by Weekday[7]
character
3
Copies by day of week
Yes
17 - Source
character
8
Source code for start
Yes
18 - Sub source
character
8
Sub source code for start (required only if source requires a subsource)
Yes
19 - Reason
character
8
Valid reason code for start
Yes
20 - Effective Date
mm/dd/yyyy
10
Effective date for transaction; may be dd/mm/yyyy, depending on the startup parameter used.
Yes
21 - Merchandise Code
character
8
Merchandise awarded with start
No
22 - Billing Method
character
15
Billing method: Carrier Collect, Office Pay, Paid Comp, or UnPaid Comp
Yes
23 - Send Invoice
logical
1
Will be Y or N
Yes
24 - Send Renewal
logical
1
Will be Y or N
Yes
25 - AAM Zone
character
6
Subscription’s AAM Zone
No
26 - AAM Column Override
character
8
AAM column for subscriber, if different from route
No
27 - Rate Code
character
20
Rate for new start
No
28 - PO Number
character
15
Purchase order number
No
29 - City Tax Exempt Reason
character
8
Subscriber’s city tax exempt reason code
No
30 - County Tax Exempt Reason
character
8
Subscriber’s county tax exempt reason code
No
31 - State Tax Exempt Reason
character
8
Subscriber’s state tax exempt reason code
No
32 - Country Tax Exempt Reason
character
8
Subscriber’s country tax exempt reason code
No
33 - Renewal Delivery Override
character
4
“Mail”, “eBill”, or leave blank
No
34 - Renewal Delivery Override Code
character
8
Override code (if field above is not blank); can be blank for Digital Sales addresses
No
35 - Remarks
character
30
Remarks for the start
No
36 - Bill-To Address ID
character
10
If there is a bill-to occupant, the bill-to’s address ID
No
37 - Bill-To First Name
character
12
If there is a bill-to occupant, the bill-to’s first name
No
38 - Bill-To Middle Initial
character
1
If there is a bill-to occupant, the bill-to’s middle initial
No
39 - Bill-To Last Name
character
30
If there is a bill-to occupant, the bill-to’s last name
No
40 - Bill-To Name Suffix
character
12
If there is a bill-to occupant, the bill-to’s name suffix (honorific)
No
41 - Bill-To Area Code
character
6
Area code of bill-to occupant
No
42 - Bill-To Phone Number
character
8
Phone number of bill-to occupant
No
43 - Bill-To Unlisted Phone
logical
1
Will be Y or N to indicate whether bill-to phone is unlisted
Yes
44 - Bill-To Occupant Type
character
15
Bill-to’s occupant type
No
45 - Bill-To Occupant Credit Status
character
11
Bill-to occupant’s credit status
No
46 - Bill-To Occupant e-mail address
character
30
Bill-to occupant’s e-mail address
No
47 - Bill-To House Number
character
10
Bill-to address house number
No
48 - Bill-To House Number Modifier
character
3
Bill-to address house number modifier
No
49 - Bill-To Pre Directional
character
2
Bill-to address predirectional
No
50 - Bill-To Street Name
character
28
Bill-to address street name
No
51 - Bill-To Street Suffix
character
7
Bill-to address street suffix
No
52 - Bill-To Post Directional
character
2
Bill-to address post directional
No
53 - Bill-To Complex
character
20
Bill-to address complex
No
54 - Bill-To Building
character
20
Bill-to address building
No
55 - Bill-To Unit Designator
character
6
Bill-to address unit type
No
56 - Bill-To Unit Number
character
8
Bill-to address unit number
No
57 - Bill-To City
character
28
Bill-to city name
No
58 - Bill-To State
character
3
Bill-to state
No
59 - Bill-To Zip Code
character
10
Bill-to Zip code
No
60 - Bill-To Zip Extension
character
4
Bill-to Zip extension
No
61 - Previous Weekday Delivery
logical
1
Will be Y or N to indicate whether a previous day’s paper should be delivered. Must be N for combo subscriptions.
Yes
62 - Bonus Day Delivery
logical
1
Will be Y or N to indicate whether the subscriber qualifies for bonus days
Yes
63 - Auto Renewal Subscription
logical
1
Will be Y or N to indicate whether the start is auto renew
Yes
64 - Auto Renewal Type
character
10
The type of auto renew: CreditCard, BankDraft, or PayPal. Only required for auto renew starts
Yes
65 - Auto Renew Credit Card Number
character
20
Auto-renew credit card number. Only required for credit card auto-renew starts when credit card information is stored on the premises.
Yes
66 - Auto Renew Credit Card Expires
mmyy
4
Auto renew credit card expiration date (format mmyy). Only required for credit card auto renew starts. Optional if credit card information is stored off-site.
Yes
67 - Auto Renew Credit Card Authorization Number
character
8
This field is no longer used and should be left blank
No
68 - Auto Renew Bank Client Type
character
8
“Business” or “Personal”. Only required if start is an auto renew to bank draft and Business Rules are set to use Client Type
Yes
69 - Auto Renew Bank Account Type
character
8
“Checking” or “Savings”. Only required if start is an auto renew to bank draft
Yes
70 - Auto Renew Bank Number
character
9
Bank number for auto renew to bank draft. Only required for bank draft auto renew starts
Yes
71 - Auto Renew Payment Account Number
character
20
Checking account number for auto renew to bank draft. Only required for bank draft auto renew starts
Yes
72 - Auto Renew Subscription Length
integer
3
Length of the auto renew subscription term. Only required for auto renew starts
Yes
73 - Auto Renew Subscription Term
character
8
Subscription term: Year, Quarter, Month, Week, or Day. Only required for auto renew starts
Yes
74 - Auto Renew Tip Amount
decimal
9
Carrier tip amount for auto renew (format 99,999.99)
No
75 - Auto Renew Subscription Payment Adjustment Code (1)
character
8
Adjustment code if auto renew payment contains an adjustment
No
76 - Auto Renew Subscription Payment Adjustment Amount (1)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
77 - Auto Renew Subscription Payment Adjustment Code (2)
character
8
Adjustment code if auto renew payment contains an adjustment
No
78 - Auto Renew Subscription Payment Adjustment Amount (2)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
79 - Auto Renew Subscription Payment Adjustment Code (3)
character
8
Adjustment code if auto renew payment contains an adjustment
No
80 - Auto Renew Subscription Payment Adjustment Amount (3)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
81 - Auto Renew Subscription Payment Adjustment Code (4)
character
8
Adjustment code if auto renew payment contains an adjustment
No
82 - Auto Renew Subscription Payment Adjustment Amount (4)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
83 - Auto Renew Subscription Payment Adjustment Code (5)
character
8
Adjustment code if auto renew payment contains an adjustment
No
84 - Auto Renew Subscription Payment Adjustment Amount (5)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
85 - Send Statement
logical
1
Will be Y or N to indicate whether an auto renew statement should be sent.
Yes
86 - Auto Renew Billing Group
character
8
Only required for bank draft auto-renew starts.
Yes
87 - Expiration Date
mm/dd/yyyy
10
Expiration date for third party starts. Not used for other billing methods.
Yes, for third party starts
88 - Auto Renew Account Holder Name
character
30
Payer name. Only required for auto-renew starts.
Yes
89 - Bill-to Level Designator
character
6
Bill-to address level (Bldg, Floor, etc.)
No
90 - Bill-to Level Number
character
6
Bill-to address level number
No
91 - Bill-to Salutation ID
character
8
Occupant salutation (Dr., Ms., etc.)
No
92 - Auto Renew Vault ID
character
32
Auto-renew credit card vault ID. Only required for credit card auto-renew starts when credit card information is stored off-site, or for PayPal auto-renew starts.
Yes
93 - Auto Renew Masked Credit Card Number
character
20
Auto-renew masked credit card number ( digits replaced with “*”). Optional; only used when credit card information is stored off-site.
No
94 - Auto Renew Credit Card Type
character
11
Auto-renew credit card type. Optional; only used when credit card information is stored off-site and the type cannot be derived from the masked credit card number. Valid values are Am Express, AmEx, DC, Diners Club, Disc, Discover, Master Card, MasterCard, MC, and Visa.
No
95 - Auto Renew Credit Card Vault Customer ID
character
32
Auto-renew credit card vault customer ID. Required only for credit card auto-renew starts when credit card information is stored off-site using Dow Jones CCCP.
Yes
96 - Delivery Fee Code
character
8
Delivery fee code for start
No
97 - Bill-to County
character
25
County of the bill-to address
No
98 - Bill-to Country
character
3
Country of the bill-to address
No
99 - Route ID
character
8
The route that should be used instead of the route provided by the router. Must be blank for combo subscriptions. Must also be blank in a multi-map environment because only one route ID can be supplied in the file.
No
100 - Reassign Reason
character
8
If the route ID is populated, optionally indicate a valid “reroute” reason for the route reassignment.
No
101 - Campaign Code
character
30
The campaign ID. When this is included, the delivery schedule, source code, reason code, and rate code are not required, as this information will be taken from the campaign.
No
102 - eBill E-Mail Address
character
30
The e-mail address to use for eBill, if an office pay subscriber’s renewal notice should be delivered electronically.
No
103 - ActivationFeeWaiveReason
character
8
The reason for waiving off Activation Fees while creating a new start
No
104 - PrintedBillFeeOptOutReason
character
8
The reason for waiving off Printed Bill Fees while creating a new start
No
105 - BillToHIN
character
11
HIN (House Index number) for the bill-to address.
No
106 - BillToGNAF-PID
character
14
G-NAF PID (Geocoded National Address File Address Persistent Identifier) for the bill-to address.
No
107 - Auto Renew PayPal E-Mail Address
character
30
The e-mail address used for PayPal auto renew. Only required for PayPal auto renew starts.
No
108 - Trial
logical
1
Indicates whether the subscription is on trial.
Note: If no value has been entered for the Trial field or left blank, the subscription will be automatically considered not on trial.
No
109 - Trial Length
Integer
3
Length of the Trial.
Yes (only if the 108-Trial flag is "yes"; otherwise, No.)
110 - Trial Term
character
8
Term of the Trial.
Yes (only if the 108-Trial flag is "yes"; otherwise, No.)
1 - Record Type
character
10
“DelivSched”
Yes
2 - Delivery Schedule
character
8
Valid delivery schedule
Yes
3 - Copies by Weekday[1]
character
3
Copies by weekday
Yes
4 - Copies by Weekday[2]
character
3
Copies by weekday
Yes
5 - Copies by Weekday[3]
character
3
Copies by weekday
Yes
6 - Copies by Weekday[4]
character
3
Copies by weekday
Yes
7 - Copies by Weekday[5]
character
3
Copies by weekday
Yes
8 - Copies by Weekday[6]
character
3
Copies by weekday
Yes
9 - Copies by Weekday[7]
character
3
Copies by weekday
Yes
10 - Source
character
8
Source code for delivery schedule change
Yes
11 - Sub source
character
8
Sub source code for delivery schedule change (required only if source requires a subsource)
Yes
12 - Reason
character
8
Valid reason code for delivery schedule change
Yes
13 - Effective Date
mm/dd/yyyy
10
Effective date for transaction; may be dd/mm/yyyy, depending on the startup parameter used.
Yes
14 - Merchandise Code
character
8
Merchandise awarded with delivery schedule change
No
15 - Rate Code ID
character
20
Rate code for delivery schedule change
No
16 - Remarks
character
30
Remarks for delivery schedule change
No
17 - Previous Weekday Delivery
logical
1
Will be Y or N to indicate whether a previous day’s paper should be delivered
Yes
1 - Record Type
character
10
“Restart”
Yes
2 - Restart Date
mm/dd/yyyy
10
Date subscriber should begin receiving the paper again; may be dd/mm/yyyy, depending on the startup parameter used.
Yes
3 - Source
character
8
Source code for restart
Yes
4 - Sub source
character
8
Sub source code for restart (required only if source requires a subsource)
Yes
5 - Reason
character
8
Valid reason code for restart
Yes
6 - Donation Code
character
8
Donation code (if making donation with restart). Code determines donation type
No
7 - Donate All Days
logical
1
Will be Y or N to indicate whether all of a subscriber’s temp stop days should be donated
Yes
8 - Donation Days
integer
5
If there is a donation and the above field is “N”, the number of days to be donated
No
9 - Carrier Account
character
8
Carrier account for donation, if donation type is “Ask for carrier”
No
10 - Company
character
4
Company of carrier account, if donation type is “Ask for carrier”
No
11 - Bill Source
character
10
Bill source of carrier account, if donation type is “Ask for carrier”
No
12 - Remarks
character
30
Remarks for the restart.
No
13 - Previous Weekday Delivery
logical
1
Will be Y or N to indicate whether a previous day’s paper should be delivered
Yes
1 - Record Type
character
10
“BillingChg”
Yes
2 - Occupant Type
character
15
Occupant’s occupant type
No
3 - Credit Status
character
11
Occupant’s credit status
No
4 - E-mail address
character
30
Occupant’s e-mail address
No
5 - Source
character
8
Source code for billing change
Yes
6 - Sub source
character
8
Sub source code for billing change (required only if source requires a subsource)
Yes
7 - Reason
character
8
Valid reason code for billing change
Yes
8 - Effective Date
mm/dd/yyyy
10
Effective date for transaction; may be dd/mm/yyyy, depending on the startup parameter used.
Yes
9 - Billing Method
character
15
Billing method: Carrier Collect, Office Pay, Paid Comp, UnPaid Comp, Third Party, or Balance Forward.
Yes
10 - Send Invoice
logical
1
Will be Y or N
Yes
11 - Send Renewal
logical
1
Will be Y or N
Yes
12 - Last Renewal Sent
integer
1
Number of last renewal sent
No
13 - Last Renewal Date
mm/dd/yyyy
10
Date of last renewal; may be dd/mm/yyyy, depending on the startup parameter used.
No
14 - AAM Column Override
character
8
AAM column for subscriber, if different from route
No
15 - Rate Code
character
20
Rate code for billing change
No
16 - PO Number
character
15
Purchase order number
No
17 - City Tax Exempt Reason
character
8
Subscriber’s city tax exempt reason code
No
18 - County Tax Exempt Reason
character
8
Subscriber’s county tax exempt reason code
No
19 - State Tax Exempt Reason
character
8
Subscriber’s state tax exempt reason code
No
20 - Country Tax Exempt Reason
character
8
Subscriber’s country tax exempt reason code
No
21 - Renewal Delivery Override
character
4
“Mail”, “eBill”, or leave blank
No
22 - Renewal Delivery Override Code
character
8
Override code (if field above is not blank); can be blank for Digital Sales addresses
No
23 - Remarks
character
30
Remarks for the billing change
No
24 - Bill-To Address ID
character
10
If there is a bill-to occupant, the bill-to’s address ID
No
25 - Bill-To First Name
character
12
If there is a bill-to occupant, the bill-to’s first name
No
26 - Bill-To Middle Initial
character
1
If there is a bill-to occupant, the bill-to’s middle initial
No
27 - Bill-To Last Name
character
30
If there is a bill-to occupant, the bill-to’s last name
No
28 - Bill-To Name Suffix
character
12
If there is a bill-to occupant, the bill-to’s name suffix
No
29 - Bill-To Area Code
character
6
Area code of bill-to occupant
No
30 - Bill-To Phone Number
character
8
Phone number of bill-to occupant
No
31 - Bill-To Unlisted Phone
logical
1
Will be Y or N to indicate whether bill-to phone is unlisted
Yes
32 - Bill-To Occupant Type
character
15
Bill-to’s occupant type
No
33 - Bill-To Occupant Credit Status
character
11
Bill-to occupant’s credit status
No
34 - Bill-To Occupant e-mail address
character
30
Bill-to occupant’s e-mail address
No
35 - Bill-To House Number
character
10
Bill-to address house number
No
36 - Bill-To House Number Modifier
character
3
Bill-to address house number modifier
No
37 - Bill-To Pre Directional
character
2
Bill-to address predirectional
No
38 - Bill-To Street Name
character
28
Bill-to address street name
No
39 - Bill-To Street Suffix
character
7
Bill-to address street suffix
No
40 - Bill-To Post Directional
character
2
Bill-to address post directional
No
41 - Bill-To Complex
character
20
Bill-to address complex
No
42 - Bill-To Building
character
20
Bill-to address building
No
43 - Bill-To Unit Designator
character
6
Bill-to address unit type
No
44 - Bill-To Unit Number
character
8
Bill-to address unit number
No
45 - Bill-To City
character
28
Bill-to city name
No
46 - Bill-To State
character
3
Bill-to state
No
47 - Bill-To ZIP Code
character
10
Bill-to ZIP code
No
48 - Bill-To ZIP Extension
character
4
Bill-to ZIP extension
No
49 - Bonus Day Delivery
logical
1
Will be Y or N to indicate whether the subscriber qualifies for bonus days
Yes
50 - Auto Renewal Subscription
logical
1
Will be Y or N to indicate whether the billing change is to auto renew
Yes
51 - Auto Renewal Type
character
10
The type of auto renew: CreditCard, BankDraft, PayPal, or None. Only required for auto-renew billing changes.
Yes
52 - Auto Renew Credit Card Number
character
20
Auto renew credit card number. Only required for credit card auto-renew billing changes when credit card information is stored on the premises.
Yes
53 - Auto Renew Credit Card Expires
mmyy
4
Auto renew credit card expiration date (format mmyy). Only required for credit card auto renew billing changes. Optional if credit card information is stored off-site.
Yes
54 - Auto Renew Credit Card Authorization Number
character
8
This field is no longer used and should be left blank
No
55 - Auto Renew Bank Client Type
character
8
“Business” or “Personal”. Only required if billing change is auto renew to bank draft and Business Rules are set to use Client Type
Yes
56 - Auto Renew Bank Account Type
character
8
“Checking” or “Savings”. Only required if billing change is auto renew to bank draft.
Yes
57 - Auto Renew Bank Number
character
9
Bank number for auto renew to bank draft. Only required for bank draft auto renew billing changes.
Yes
58 - Auto Renew Payment Account Number
character
20
Checking account number for auto renew to bank draft. Only required for bank draft auto renew billing changes.
Yes
59 - Auto Renew Subscription Length
integer
3
Length of the auto renew subscription term. Only required for auto renew billing changes.
Yes
60 - Auto Renew Subscription Term
character
8
Subscription term: Year, Quarter, Month, Week, or Day. Only required for auto renew billing changes.
Yes
61 - Auto Renew Tip Amount
decimal
9
Carrier tip amount for auto renew (format 99,999.99)
No
62 - Auto Renew Subscription Payment Adjustment Code (1)
character
8
Adjustment code if auto renew payment contains an adjustment
No
63 - Auto Renew Subscription Payment Adjustment Amount (1)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
64 - Auto Renew Subscription Payment Adjustment Code (2)
character
8
Adjustment code if auto renew payment contains an adjustment
No
65 - Auto Renew Subscription Payment Adjustment Amount (2)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
66 - Auto Renew Subscription Payment Adjustment Code (3)
character
8
Adjustment code if auto renew payment contains an adjustment
No
67 - Auto Renew Subscription Payment Adjustment Amount (3)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
68 - Auto Renew Subscription Payment Adjustment Code (4)
character
8
Adjustment code if auto renew payment contains an adjustment
No
69 - Auto Renew Subscription Payment Adjustment Amount (4)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
70 - Auto Renew Subscription Payment Adjustment Code (5)
character
8
Adjustment code if auto renew payment contains an adjustment
No
71 - Auto Renew Subscription Payment Adjustment Amount (5)
decimal
9
Adjustment amount if auto renew payment contains an adjustment
No
72 - Send Statement
logical
1
Will be Y or N to indicate whether an auto renew statement should be sent (if subscriber is auto-renew)
Yes
73 - Auto Renew Billing Group
character
8
Only required for bank draft auto-renew billing changes.
Yes
74 - Auto Renew Account Holder Name
character
30
Payer name. Only required for auto-renew billing changes.
Yes
75 - Bill-to Level Designator
character
6
Bill-to address level (Bldg, Floor, etc.)
No
76 - Bill-to Level Number
character
6
Bill-to address level number
No
77 - Bill-to Salutation ID
character
8
Occupant salutation (Dr., Ms., etc.)
No
78 - Auto Renew Vault ID
character
32
Auto-renew credit card vault ID. Only required for credit card auto-renew billing changes when credit card information is stored off-site, or for Paypal auto-renew billing changes.
Yes
79 - Auto Renew Masked Credit Card Number
character
20
Auto-renew masked credit card number (digits replaced with “*”). Optional; only used when credit card information is stored off-site.
No
80 - Auto Renew Credit Card Type
character
11
Auto-renew credit card type. Optional; only used when credit card information is stored off-site and the type cannot be derived from the masked credit card number. Valid values are Am Express, AmEx, DC, Diners Club, Disc, Discover, Master Card, MasterCard, MC, and Visa.
No
81 - Auto Renew Credit Card Vault Customer ID
character
32
Auto-renew credit card vault customer ID. Required only for credit card auto-renew billing changes when credit card information is stored off-site using Dow Jones CCCP.
Yes
82 - Bill-To County
character
25
County of the bill-to address
No
83 - Bill-To Country
character
3
Country of the bill-to address
No
84 - eBill E-Mail Address
character
30
The e-mail address to use for eBill, if an office pay subscriber’s renewal notice should be delivered electronically.
No
85 - Auto Renew PayPal E-Mail Address
character
30
The e-mail address used for PayPal auto renew. Only required for PayPal auto renew starts.
No
1 - Record Type
character
10
“Payment”
Yes
2 - Payment Type
character
11
Type of payment: Cash, Check, Credit Card, Bank Draft
Yes
3 - Check Number
character
8
Check number. Only required if payment is by check
Yes
4 - Credit Card Number
character
20
Credit card number. Only required if payment is by credit card and credit card information is stored on the premises.
Yes
5 - Credit Card Expires
mmyy
4
Credit card expiration date (format mmyy). Only required if payment is by credit card. Optional if credit card information is stored off-site.
Yes
6 - Credit Card Authorization Number
character
8
Authorization number for credit card payment
No
7 - Bank Client Type
character
8
"Business" or "Personal". Only required if payment is to bank draft and Business Rules are set to use Client Type
Yes
8 - Bank Account Type
character
8
"Checking" or "Savings". Only required if payment is to bank draft
Yes
9 - Bank Number
character
9
Subscriber’s bank number. Only required if payment is bank draft
Yes
10 - Bank Account Number
character
20
Subscriber’s bank account number. Only required if payment is bank draft
Yes
11 - Payment Amount
decimal
9
Payment amount (format 99,999.99)
Yes
12 - Coupon Amount
decimal
9
Coupon amount (format 99,999.99) if payment has a coupon
No
13 - Tip Amount
decimal
9
Tip amount to carrier (format 99,999.99)
No
14 - Source
character
8
Source code for payment
Yes
15 - Reason
character
8
Valid reason code for payment
Yes
16 - Payment Date
mm/dd/yyyy
10
Date of the payment; may be dd/mm/yyyy, depending on the startup parameter used.
Yes
17 - Remarks
character
30
Remarks about the payment.
No
18 - Subscription Payment Adjustment Code (1)
character
8
Adjustment code if payment contains an adjustment
No
19 - Subscription Payment Adjustment Amount (1)
decimal
9
Adjustment amount if payment contains an adjustment
No
20 - Subscription Payment Adjustment Code (2)
character
8
Adjustment code if payment contains an adjustment
No
21 - Subscription Payment Adjustment Amount (2)
decimal
9
Adjustment amount if payment contains an adjustment
No
22 - Subscription Payment Adjustment Code (3)
character
8
Adjustment code if payment contains an adjustment
No
23 - Subscription Payment Adjustment Amount (3)
decimal
9
Adjustment amount if payment contains an adjustment
No
24 - Subscription Payment Adjustment Code (4)
character
8
Adjustment code if payment contains an adjustment
No
25 - Subscription Payment Adjustment Amount (4)
decimal
9
Adjustment amount if payment contains an adjustment
No
26 - Subscription Payment Adjustment Code (5)
character
8
Adjustment code if payment contains an adjustment
No
27 - Subscription Payment Adjustment Amount (5)
decimal
9
Adjustment amount if payment contains an adjustment
No
28 - Account Holder Name
character
30
Payer name.
Yes
29 - Credit Card Vault ID
character
32
Credit card vault ID. Only required if payment is by credit card and credit card information is stored off-site.
Yes
30 - Masked Credit Card Number
character
20
Masked credit card number (digits replaced with “*”). Optional; only used when credit card information is stored off-site.
No
31 - Credit Card Type
character
11
Credit card type. Optional; only used when credit card information is stored off-site and the type cannot be derived from the masked credit card number. Valid values are Am Express, AmEx, DC, Diners Club, Disc, Discover, Master Card, MasterCard, MC, and Visa.
No
32 - Credit Card Vault Customer ID
character
32
Credit card vault customer ID. Required only if payment is by credit card and credit card information is stored off-site using Dow Jones CCCP.
Yes
33 - Transaction ID
character
16
Credit card or bank draft transaction ID.
No
1 - Record Type
character
10
“Stop”
Yes
2 - Stop Date
mm/dd/yyyy
10
Subscription stop date; may be dd/mm/yyyy, depending on the startup parameter used.
Yes
3 - Source
character
8
Source code for stop
Yes
4 - Sub source
character
8
Sub source code for stop (required only if source requires a subsource)
Yes
5 - Reason
character
8
Valid reason code for stop
Yes
6 - Restart Date
mm/dd/yyyy
10
Date subscriber should begin receiving the paper again; may be dd/mm/yyyy, depending on the startup parameter used.
No
7 - Restart Reason
character
8
Valid reason code for restart (required only if restart date is entered)
Yes
8 - Previous Weekday Delivery
logical
1
Will be Y or N to indicate whether a previous day’s paper should be delivered
Yes
9 - Vacation Pack
logical
1
Will be Y or N to indicate whether papers should be held during the stop period and delivered upon restart
Yes
10 - Refund Requested
logical
1
Will be Y or N to indicate whether subscriber requested a refund. Only valid with perm stop
Yes
11 - Donation Code
character
8
Donation code (if making donation with stop). Code determines donation type. Only valid for perm stops or temp stops with restart date and no vac pack
No
12 - Donate All Days
logical
1
Will be Y or N to indicate whether all of a subscriber’s temp stop days should be donated
Yes
13 - Donation Days
integer
5
If there is a donation and the above field is “N”, the number of days to be donated
No
14 - Carrier Account
character
8
Carrier account for donation, if donation type is “Ask for carrier”
No
15 - Company
character
4
Company of carrier account, if donation type is “Ask for carrier”
No
16 - Bill Source
character
10
Bill source of carrier account, if donation type is “Ask for carrier”
No
17 - Remarks
character
30
Remarks for the stop
No
1 - Record Type
character
10
“Complaint”
Yes
2 - Incident Date
mm/dd/yyyy
10
Complaint incident date; may be dd/mm/yyyy, depending on the startup parameter used.
Yes
3 - Source
character
8
Source code for complaint
Yes
4 - Reason
character
8
Valid reason code for complaint
Yes
5 - Complaint Text
character
60
Description of complaint
No
6 - Days to Extend
integer
5
Number of days to extend the subscription expire date due to complaint
No
7 - Redelivery
logical
1
Will be Y or N to indicate whether paper should be redelivered
Yes
8 - Redelivery Instructions
character
60
Redelivery instructions, such as directions to the house
No
9 - Charge Carrier
logical
1
Will be Y or N to indicate whether carrier should be charged for complaint
Yes
10 - Dispatch
logical
1
Will be Y or N to indicate whether complaint should appear in Dispatching
Yes
11 - Urgent
logical
1
Will be Y or N to indicate whether complaint should be marked as “urgent” in Dispatching
Yes
1 - Record Type
character
10
“ComboChange”
Yes
2 - ComboID
character
8
ID of combo subscription is converting to
Yes
3 - SourceCode
character
8
Source code for combo change
Yes
4 - SubSource
character
8
Subsource for combo change
No
5 - ReasonCode
character
8
Valid reason code for combo change
Yes
6 - TranDate
mm/dd/yyyy
10
Effective date of combo change transaction
Yes
7 - Rate Code
character
20
Rate code for combo subscription
Yes
8 - Remarks
character
30
Remarks for the combo change
No
9 - Renewal Delivery Override
character
4
“Mail”, “eBill”, or leave blank
No
10 - Renewal Delivery Override Code
character
8
Override code (if field above is not blank); can be blank for Digital Sales addresses
No
11 - eBill E-mail Address
character
30
The e-mail address to use for eBill, if an office pay subscriber’s renewal notice should be delivered electronically.
No
1 - Record Type
character
10
“DelivAddr”
Yes
2 - Sunday Delivery Day
logical
1 (y/n)
Will be Y or N to indicate if this address is a delivery day on this day of week.
Yes
3 - Monday Delivery Day
logical
1
Will be Y or N to indicate if this address is a delivery day on this day of week.
Yes
4 - Tuesday Delivery Day
logical
1
Will be Y or N to indicate if this address is a delivery day on this day of week.
Yes
5 - Wednesday Delivery Day
logical
1
Will be Y or N to indicate if this address is a delivery day on this day of week.
Yes
6 - Thursday Delivery Day
logical
1
Will be Y or N to indicate if this address is a delivery day on this day of week.
Yes
7 - Friday Delivery Day
logical
1
Will be Y or N to indicate if this address is a delivery day on this day of week.
Yes
8 - Saturday Delivery Day
logical
1
Will be Y or N to indicate if this address is a delivery day on this day of week.
Yes
9 - Delivery Address ID
integer
10
Address ID of an address record already in the system
No
10 - House Number
character
10
House number of address
Yes
11 - House Number Modifier
character
3
House number modifier
No
12 - Predirectional
character
2
Address predirectional (N,S,E,W,NE,NW,SE or SW)
No
13 - Street Name
character
28
Address street name
Yes
14 - Street Suffix
character
7
Address street suffix
No
15 - Post Directional
character
2
Address post directional (N,S,E,W,NE,NW,SE or SW)
No
16 - Complex
character
20
Address complex
No
17 - Building
character
20
Address building
No
18 - Level Designator
character
6
Address level
No
19 - Level Number
character
8
Address level number
No
20 - Unit Designator
character
6
Address unit (Apt, Suite, etc.)
No
21 - Unit Number
character
8
Address unit number
No
22 - City
character
28
City name of address
Yes
23 - State
character
3
State of address
Yes
24 - ZIP Code
character
10
ZIP code of address
Yes
25 - ZIP Extension
character
4
ZIP extension of address
No
26 - County
character
25
County of the delivery address
No
27 - Country
character
3
Country of the delivery address
No
1 - Record Type
character
4
“Move”
Yes
2 - Move In Address ID
integer
10
ID of the move-in address
Either the Address ID or address components are required.
3 - Move In House Number
character
10
The house number for this address, such as “103” for the address “103 Main Street”.
Either the Address ID or address components are required.
4 - Move In House Number Modifier
character
3
Modifier of the house number, like “½” in the address “103 ½ Main St”.
Either the Address ID or address components are required.
5 - Move In Predirectional
character
2
Address predirectional (N,S,E,W,NE,NW,SE or SW)
Either the Address ID or address components are required.
6 - Move In Street Name
character
28
Address street name
Either the Address ID or address components are required.
7 - Move In Street Suffix
character
7
Address street suffix
Either the Address ID or address components are required.
8 - Move In Postdirectional
character
2
Address post directional (N,S,E,W,NE,NW,SE or SW)
Either the Address ID or address components are required.
9 - Move In Complex
character
20
The name of the complex, such as “Oak Park Apartments”.
Either the Address ID or address components are required.
10 - Move In Building
character
20
Address building
Either the Address ID or address components are required.
11 - Move In Unit Designator
character
6
Address unit (Apt, Suite, etc.)
Either the Address ID or address components are required.
12 - Move In Unit Number
character
8
Address unit number
Either the Address ID or address components are required.
13 - Move In City
character
28
City name of address
Either the Address ID or address components are required.
14 - Move In State
character
2
State of address
Either the Address ID or address components are required.
15 - Move In ZIP Code
character
10
ZIP code for address
Either the Address ID or address components are required.
16 - Move In ZIP Extension
character
4
ZIP extension for address
Either the Address ID or address components are required.
17 - Move Primary Only
logical
1
Determines whether the subscriber’s secondary address, if applicable, will also be moved to the new address.
Yes
18 - New Area Code
integer
6
Area code of occupant’s phone
No
19 - New Phone
integer
8
Phone number of occupant
No
20 - New Phone Unlisted
logical
1
Phone number unlisted setting (yes/no).
Yes
21 - Move Out Date
date
10
Date the subscriber will move out of the old address, mm/dd/yyyy
Yes
22 - Move In Date
date
10
Date the subscriber will move into the new address, mm/dd/yyyy
Yes
23 - Source Code
character
8
Source code for the move
Yes
24 - Reason Code
character
8
Valid reason code for move
Yes
25 - New Delivery Method
character
5
This will be Route or Mail
Yes
26 - New Billing Method
character
15
Billing method: Carrier Collect, Office Pay, Paid Comp, or UnPaid Comp
No
27 - New Delivery Schedule
character
8
Valid delivery schedule
No
28 - New Copies By Day [1]
integer
3
Copies for Sunday
No
29 - New Copies By Day [2]
integer
3
Copies for Monday
No
30 - New Copies By Day [3]
integer
3
Copies for Tuesday
No
31 - New Copies By Day [4]
integer
3
Copies for Wednesday
No
32 - New Copies By Day [5]
integer
3
Copies for Thursday
No
33 - New Copies By Day [6]
integer
3
Copies for Friday
No
34 - New Copies By Day [7]
integer
3
Copies for Saturday
No
35 - New Delivery Placement
character
8
Valid newspaper delivery placement
No
36 - New AAM Zone
character
6
Subscription’s AAM Zone
No
37 - New Rate Code ID
character
20
Rate code for the move
No
38 - New City Tax Exempt Reason
character
8
Subscriber’s city tax exempt reason code
No
39 - New County Tax Exempt Reason
character
8
Subscriber’s county tax exempt reason code
No
40 - New State Tax Exempt Reason
character
8
Subscriber’s state tax exempt reason code
No
41 - New Country Tax Exempt Reason
character
8
Subscriber’s country tax exempt reason code
No
42 - Remarks
character
30
Remarks for the move
No
43 - County
character
25
County of the delivery address
No
44 - Country
character
3
Country of the delivery address
No
1 - Record Type
character
10
“DemoAnswer”
Yes
2 - Replace
logical
1
Will be Y or N. If a demographic answer already exists for this subscriber or address, the Replace field indicates whether the demographic answer in the import file should replace the existing answer.
Yes
3 - Demographic ID
character
20
A valid address, occupant, or subscription demographic.
Yes
4 - Demographic Answer
character
30
A valid answer for the demographic. Although the format of this field is character, you can store answers of any data type (character, integer, decimal, logical, or date). The data type must match the Answer Type that was set up for this demographic.
Yes
1 - Record Type
character
10
“Extra”
Yes
2 - Order Code
character
8
Not used in import; used in output file
no
3 - Character fields
character
40 [5]
Extra character fields (5 fields)
Yes
4 - Integer fields
integer
8 [5]
Extra integer fields (5 fields)
Yes
5 - Decimal fields
decimal
11 [5]
Extra decimal fields (5 fields, format 99999999.99)
No
6 - Logical fields
logical
1 [5]
Extra logical fields (5 fields, will be Y or N)
Yes
7 - Date fields
mm/dd/yyyy
10 [5]
Extra date fields (5 fields); may be dd/mm/yyyy, depending on the startup parameter used.
Yes
