Grace Owed Export

File maps used for the Grace Owed Export have a usage of “GraceOwedExp.” The following data elements are available:

Data Element	Description
FullName	Subscriber full name
FirstName	Subscriber first name
LastName	Subscriber last name
DeliveryAddressLine1	Delivery address line 1
DeliveryAddressLine2	Delivery address line 2
DeliveryAddressLine3	Delivery address line 3
DeliveryAddressLine4	Delivery address line 4
DeliveryAddressLine5	Delivery address line 5
DeliveryAddressLine6	Delivery address line 6
HouseNumber	Delivery house number
Street	Delivery street
City	Delivery city
State	Delivery state
ZIP	Delivery ZIP code
ZIPExtension	Delivery ZIP+4 extension
DeliveryPointCode	Delivery point code
BilltoName	Bill-to full name
BilltoFirstName	Bill-to first name
BilltoLastName	Bill-to last name
BillToPhone	Bill-to phone number
BilltoUnlistedPhone	Bill-to unlisted phone flag
BilltoOccEmailAddr	Bill-to email address
BilltoDeliveryAddressLine1	Bill-to delivery address line 1
BilltoDeliveryAddressLine2	Bill-to delivery address line 2
BilltoDeliveryAddressLine3	Bill-to delivery address line 3
BilltoDeliveryAddressLine4	Bill-to delivery address line 4
BilltoDeliveryAddressLine5	Bill-to delivery address line 5
BilltoDeliveryAddressLine6	Bill-to delivery address line 6
BilltoHouseNumber	Bill-to house number
BilltoStreet	Bill-to street
BilltoCity	Bill-to city
BilltoState	Bill-to state
BilltoZIP	Bill-to ZIP code
BilltoZIPExtension	Bill-to ZIP+4 extension
BilltoDeliveryPointCode	Bill-to delivery point code
Route	Subscriber route ID
SubscriptionID	Subscription ID
GraceOwedAmtInclTax	Grace owed amount including tax
GraceOwedAmtExclTax	Grace owed amount excluding tax
SalesTax	Sales tax amount
CityTaxAmount	City tax amount
CountyTaxAmount	County tax amount
StateTaxAmount	State tax amount
CountryTaxAmount	Country tax amount
SubscriberStatus	Current subscriber status
PublicationName	Publication name
RunDate	Publishing run date
ExpireDate	Subscription expiration date
NumberOfRenewalsSent	Number of renewal notices sent
GraceOwedDateRangeDetail	Grace owed date range detail container
ComboSubscriptionID	Combo subscription ID
ComboID	Combo ID
ComboDescription	Combo description
AmountDue	Amount due
SubscriptionRate	Subscription rate
SubscriptionAmount	Subscription amount
BillingMethod	Billing method
CreditStatus	Credit status
LastPaymentDate	Date of last payment
LastPaymentAmount	Amount of last payment
PaymentType	Payment type
PaymentLength	Length of last payment
PaymentTerm	Term of last payment
LastRenewalDate	Date of last renewal
FeesOwed	Fees owed
FeesOwedTax	Tax on fees owed
Phone	Subscriber phone number
UnlistedPhone	Unlisted phone flag
EmailAddr	Email address
Literal	Literal value defined in file map

GraceOwedDateRangeDetail (GraceOwedExp Usage)

The following data elements are included under the GraceOwedDateRangeDetail detail record:

Data Element	Description
DateRangeIdentifier	Identifier for the grace owed date range record.
DateRangeStartDate	Start date of the grace owed period included in the export.
DateRangeEndDate	End date of the grace owed period included in the export.