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
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
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
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
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
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
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
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
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
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
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
1
RuleOccupantID
x(12)
yes
2
OccupantTypeID
x(15)
yes
File: Payment Rule
1
RulePaymentID
x(12)
yes
2
PaymentType
x(22)
yes. Valid values: “Credit Card Auto Renew”, “Bank Draft Auto Renew”, “*”
File: Subscription Rate Class
1
SubscriptionRateClassID
x(8)
yes
2
Description
x(30)
no
File: Rate Fixed Term
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
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
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
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
Last updated
