Subscriber Activity Import Format

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.

Example—Subscriber Activity Import

Account Lookup Record (this record is required)

Seq - Field	Format	Max	Contents	Required
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

Solicitation Update Record

Seq - Field	Format	Max	Contents	Required
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

Start Transaction Record

Seq - Field	Format	Max	Contents	Required
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.)

Delivery Schedule Change Record

Seq - Field	Format	Max	Contents	Required
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

Restart Transaction Record

Seq - Field	Format	Max	Contents	Required
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

Billing Change Transaction Record

Seq - Field	Format	Max	Contents	Required
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

Payment Transaction Record

Seq - Field	Format	Max	Contents	Required
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

Stop Transaction Record

Seq - Field	Format	Max	Contents	Required
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

Complaint Transaction Record

Seq - Field	Format	Max	Contents	Required
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

Combo Change Transaction Record

Seq - Field	Format	Max	Contents	Required
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

Delivery Address Record

Seq - Field	Format	Max	Description	Required
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

Note: Delivery Address records are optional, and may only follow a Start or Delivery Schedule transaction record. There may be up to six Delivery Address records per transaction. The address that is specified on the Account record is considered the primary address. If there are any Delivery Address records, they are secondary delivery addresses that override the primary address for the days specified.

Move Transaction Record

Seq - Field	Format	Max	Contents	Required
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

Demographic Answer Record

Seq - Field	Format	Max	Contents	Required
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

Extra Record

Seq - Field	Format	Max	Contents	Required
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