# 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