Export/Import Subscription Rates

The formats of the files that are exported and imported using the Export/Import Subscription Rates option are given below. Note that, for the import, the first line of each file is ignored (because it is expected to be the column header for the fields). The export option exports the column header as the first line of data for each file.

Export/Import Subscription Rates Utility

File: Rate Code

Field #	Field	Format	Required
1	RateCodeID	x(20)	yes
2	RateType	x(8)	yes
3	StartDate	99/99/9999	yes
4	EndDate	99/99/9999	yes
5	Description	x(30)	no
6	NextRateCodeID	x(20)	yes
7	TurnoverRateCodeID	x(20)	yes
8	AllowPreviousDelivery	y/n	yes
9	MarketingTerm	x(8)	no
10	MarketingLength	>>>9-	no
11	AAMPriceLevelID	x(8)	yes
12	BalanceForwardRate	y/n	yes
13	IsRefundable	y/n	yes
14	MinPeriodRequired	y/n	yes
15	Combo ID (optional)	x(8)	no
16	Digital Restate Type	x(12)	yes. Valid options: “All Digital”, “One Digital”, “None”
17	Digital Draw Type	x(17)	yes. Valid options: “Standard”, “Best Digital Only”, “Unpaid”, “None”
18	Incld In Bonus Day	y/n	yes

File: Discount Rate Code

Field #	Field	Format	Required
1	RateCodeID	x(20)	yes
2	CompanyID	x(4)	yes
3	ProductID	x(8)	yes
4	DistribMethod	x(8)	yes
5	AAMZoneID	x(6)	yes
6	AreaID	x(8)	yes
7	RegionID	x(8)	yes
8	DistribZoneID	x(8)	yes
9	DistrictID	x(8)	yes
10	DeliveryScheduleID	x(8)	yes
11	* DiscountGLAccountID	x(40)	yes

File: Rate Terms

Field #	Field	Format	Required
1	RateCodeID	x(20)	yes
2	PaymentLength	>>>9-	yes
3	PaymentTerm	x(8)	yes. Valid options: “Year”, “Quarter”, “Month”, “Week”, “Day” (day pass only)
4	StartDate	99/99/9999	yes
5	EndDate	99/99/9999	yes
6	Amount	>>,>>>,>>9.99-	yes
7	*AmountByDay	>>,>>>.99	yes
8	*PercentByDay	>>>.999999	yes
9	*ExtraCostByDay	>>>>>.999999	yes
10	ShowOnInvoice	x(8)	yes. Valid options: “Always”, “Never”, “Previous”
11	ShowOnRenewal	x(8)
12	FullVacPacDays	>>>9	yes
13	HalfVacPacDays	>>>9	yes
14	MaximumVacPacAmount	>>,>>>,>>9.99-	yes
	* In the Discount Rate Code and Rate Terms files; these fields are defined as arrays and have array elements 1 – 7 that correspond to each day of the week: Sun – Sat (1-7). For example: DiscountGLAccountID[1], DiscountGLAccountID[2], DiscountGLAccountID[3], DiscountGLAccountID[4], DiscountGLAccountID[5], DiscountGLAccountID[6], DiscountGLAccountID[7].

File: Rate Terms By Product Mix

Field #	Field	Format	Required
1	RateCodeID	x(20)	yes
2	PaymentLength	>>>9-	yes
3	PaymentTerm	x(8)	yes
4	StartDate	99/99/9999	yes
5	EndDate	99/99/9999	yes
6	ProductID	x(8)	yes
7	DeliveryMethod	x(8)	yes
8	DeliveryScheduleID	x(8)	yes
9	*AmountByDay	>>,>>>.99	yes
	* This field is defined as an array and has array elements 1 – 7 that correspond to each day of the week: Sun – Sat (1-7). For example: AmountByDay[1], AmountByDay[2], AmountByDay[3], AmountByDay[4], AmountByDay[5], AmountByDay[6], AmountByDay[7].

File: Auto Pay Terms

Field #	Field	Format	Required
1	Auto Pay Type	x(20)	yes. This will always be “AutoRenewBillingTerm”
2	RateCodeID	x(20)	yes
3	BillLength	>>>9-	yes
4	BillTerm	x(8)	yes
5	StartDate	99/99/9999	yes
6	EndDate	99/99/9999	yes
7	Amount	>>,>>>,>>9.99-	yes

File: Auto Pay Terms By Product Mix

Field #	Field	Format	Required
1	Auto Pay Type	x(20)	yes. This will always be “AutoRenewBillingTermByPM”
2	RateCodeID	x(20)	yes
3	BillLength	>>>9-	yes
4	BillTerm	x(8)	yes
5	StartDate	99/99/9999	yes
6	EndDate	99/99/9999	yes
7	ProductID	x(8)	yes
8	DeliveryMethod	x(8)	yes
9	DeliveryScheduleID	x(8)	yes
10	Amount	>>,>>>,>>9.99-	yes

File: Rule Rate Link

Field #	Field	Format	Required
1	RulePublicationID	x(12)	yes
2	RuleSubscriptionID	x(12)	yes
3	RuleOccupantID	x(12)	yes
4	RulePaymentID	x(12)	yes
5	RuleLocationID	x(12)	yes
6	StartDate	99/99/9999	yes
7	EndDate	99/99/9999	yes
8	RateCodeID	x(20)	yes

File: Subscription Rule

Field #	Field	Format	Required
1	RuleSubscriptionID	x(12)	yes
2	DeliveryType	x(8)	yes
3	SourceCode	x(8)	yes
4	DeliveryScheduleID	x(8)	yes
5	ReasonCode	x(8)	yes
6	DaysStopped	>>>9	yes

File: Reason

Field #	Field	Format	Required
1	ReasonCode	x(8)	yes
2	StartDate	99/99/9999	yes
3	EndDate	99/99/9999	yes
4	RequireRemark	y/n	yes
5	Description	x(30)	yes
6	UpdateDraw	y/n	yes
7	PrintOnBundle	y/n	yes
8	PrintCodeOnBundle	y/n	yes

File: Location Rule

Field #	Field	Format	Required
1	RuleLocationID	x(12)	yes
2	RouteID	x(8)	yes
3	DistrictID	x(8)	yes
4	SubscriptionRateClassID	x(8)	yes
5	CensusTractID	999999.99	yes
6	DwellingTypeID	x(10)	yes
7	AAMZoneID	x(6)	yes
8	CityID	x(28)	yes
9	CountyID	x(25)	yes
10	StateID	x(3)	yes
11	CountryID	x(3)	yes
12	ZipCode	x(5)	yes
13	ZipExtension	x(4)	yes
14	DeliveryPlacementID	x(8)	yes
15	DeliveryAddressType	x(8)	yes

File: Occupant Rule

Field #	Field	Format	Required
1	RuleOccupantID	x(12)	yes
2	OccupantTypeID	x(15)	yes

File: Payment Rule

Field #	Field	Format	Required
1	RulePaymentID	x(12)	yes
2	PaymentType	x(22)	yes. Valid values: “Credit Card Auto Renew”, “Bank Draft Auto Renew”, “*”

File: Subscription Rate Class

Field #	Field	Format	Required
1	SubscriptionRateClassID	x(8)	yes
2	Description	x(30)	no

File: Rate Fixed Term

Field #	Field	Format	Required
1	RateCodeID	x(20)	yes
2	StartDate	99/99/9999	yes
3	EndDate	99/99/9999	yes
4	FixedEndDate	99/99/9999	yes
5	StopSourceCode	x(8)	yes
6	StopReasonCode	x(8)	yes
7	DonationCode	x(8)	yes

File: Rate Term Reward

Field #	Field	Format	Required
1	RateCodeID	x(20)	yes
2	PaymentLength	>>>9-	yes
3	PaymentTerm	x(8)	yes
4	RewardID	x(12)	yes
5	OfferCodeID	x(8)	yes
6	StartDate	99/99/9999	yes
7	EndDate	99/99/9999	yes
8	RewardAmount	>>>9-	yes
9	AutoRenewReward	>>>9-	yes

File: Reason Source

Field #	Field	Format	Required
1	TranTypeID	x(12)	yes
2	ReasonCode	x(8)	yes
3	SourceCode	x(8)	yes
4	StartDate	99/99/9999	yes
5	EndDate	99/99/9999	no

File: Reason Info

File: Reason Info
Field #	Field	Format	Required
1	ProductID	x(8)	yes
2	TranTypeID	x(12)	yes
3	ReasonCode	x(8)	yes
4	ZipCode	x(5)	yes
5	ZipExtension	x(4)	yes “*” is exported if field is not used with transaction type
6	AreaID	x(8)	yes “*” is exported if field is not used with transaction type
7	RegionID	x(8)	yes “*” is exported if field is not used with transaction type
8	DistribZoneID	x(8)	yes “*” is exported if field is not used with transaction type
9	DistrictID	x(8)	yes “*” is exported if field is not used with transaction type
10	StartDate	99/99/9999	yes
11	EndDate	99/99/9999	no
12	GLAccountID	x(40)	no
13	Reminder	x(30)	no
14	GenerateArrearsCCInvoice	x(12)	yes Valid values: “Before Batch”, “After Batch”, “Both”, “Never”.
15	GenerateAdvanceCCInvoice	x(12)	yes Valid values: “Before Batch”, “After Batch”, “Both”, “Never”.
16	PrintOnRenewal	x(8)	yes. Valid values: “Never”, “Summary”, “Detail”.
17	RenewalDescription	x(30)	no
18	ApplyVacationRules	y/n	yes