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.
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
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
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].
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].
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
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
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
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
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
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
1
RuleOccupantID
x(12)
yes
2
OccupantTypeID
x(15)
yes
1
RulePaymentID
x(12)
yes
2
PaymentType
x(22)
yes. Valid values: “Credit Card Auto Renew”, “Bank Draft Auto Renew”, “*”
1
SubscriptionRateClassID
x(8)
yes
2
Description
x(30)
no
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
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
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
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