Subscriber Activity Import

The following data elements can be used with the “SubActivityImprt” usage. Data elements marked with an asterisk (*) contain detail elements that are listed in a separate table. Note that either a SubscriptionID must be supplied, or enough occupant and address data to match or create a subscription. Also note that elements listed in one of the Detail Element tables must be defined in the format as sub-elements under that detail element. For example, the reason code for a payment must be imported with the ReasonCode element within the PaymentDetail element.

“SubActivityImprt” Data Elements

AddressID	DateField[3]	IntegerField[2]	Phone
AddressLine	DateField[4]	IntegerField[3]	PostDirectional
AreaCode	DateField[5]	IntegerField[4]	PreDirectional
BillingChangeDetail*	DecimalField[1]	IntegerField[5]	ProductID (required)
Building	DecimalField[2]	LastName	RecordIdentifier
CharacterField[1]	DecimalField[3]	LevelDesignatorID	RestartDetail*
CharacterField[2]	DecimalField[4]	LevelNumber	SolicitationCodeID[1]
CharacterField[3]	DecimalField[5]	LogicalField[1]	SolicitationCodeID[2]
CharacterField[4]	DeliveryAddressDetail*	LogicalField[2]	StartDetail*
CharacterField[5]	DeliveryMethod	LogicalField[3]	StateID
CityID	DeliveryScheduleChangeDetail*	LogicalField[4]	StopDetail*
CityStateLine	DemographicAnswerDetail*	LogicalField[5]	StreetName
ComplaintDetail*	ExternalSubscriptionID	MiddleInitial	StreetSuffixID
Complex	Filler	MoveDetail*	SubscriptionID
ComboChangeDetail*	FirstName	NameLine	UnitDesignatorID
CountryID	HonorificID	OccupantID	UnitNumber
CountyID	HouseNumber	OccupantSalutationID	ZipCode
DateField[1]	HouseNumberModifier	OrderCode	ZipExtension
DateField[2]	IntegerField[1]	PaymentDetail*
DigitalAddress	EmailAddress	GNAF-PID	HIN
ReasonCode	SourceCode	StreetNameAndSuffixLine	TranDate
TranTypeID	Trial	Trial Length	Trial Term

Billing Change Detail Elements

AAMColumnID	BillToCityID	BillToStreetSuffixID	RenewalDeliveryMethod
AccountHolderName	BillToComplex	BillToUnitDesignatorID	RenewalOverrideCode
AccountNumber	BillToCountryID	BillToUnitNumber	SendInvoice
AccountType	BillToCountyID	BillToZipCode	SendRenewal
AdjustmentAmount[1]	BillToCreditStatusID	BillToZipExtension	SendStatement
AdjustmentAmount[2]	BillToEMailAddress	CreditCardExpires	SourceCode (required)
AdjustmentAmount[3]	BillToFirstName	CreditCardNumber	SubAdjustCodeID[1]
AdjustmentAmount[4]	BillToHonorificID	CreditCardTypeID	SubAdjustCodeID[2]
AdjustmentAmount[5]	BillToHouseNumber	CreditStatusID	SubAdjustCodeID[3]
AuthorizationNumber	BillToHouseNumberModifier	DateLastRenewalSent	SubAdjustCodeID[4]
AutoRenew	BillToLastName	EbillEmailAddress	SubAdjustCodeID[5]
AutoRenewLength	BillToLevelDesignatorID	EMailAddress	SubSourceID
AutoRenewTerm	BillToLevelNumber	Filler	TaxExemptReason[City]
AutoRenewType	BillToMiddleInitial	MaskedCreditCardNumber	TaxExemptReason[Country]
BankClientType	BillToOccupantTypeID	NumberOfRenewalsSent	TaxExemptReason[County]
BankNumber	BillToPhone	OccupantTypeID	TaxExemptReason[State]
BillingGroupID	BillToPhoneUnlisted	PurchaseNumber	TipAmount
BillingMethod	BillToPostDirectional	RateCodeID	TranDate (required)
BillToAddressID	BillToPreDirectional	ReasonCode (required)	VaultCustomerID
BillToAreaCode	BillToStateID	ReceiveBonusDays	VaultID
BillToBuilding	BillToStreetName	Remarks
AutoRenewPayPalEmailAddress	EffectiveDate

Complaint Detail Element

ChargeCarrier	ReasonCode (required)
ComplaintDate (required)	Redeliver
ComplaintText	RedeliverInstructions
DaysAdjust	SourceCode (required)
Dispatch	Urgent
Filler

Combo Change Detail Element

ComboID (required)	Remarks
TranDate (required)	SourceCode (required)
RateCodeID (required)	SubsourceID
ReasonCode (required)
EbillEmailAddress	RenewalDeliveryMethod
RenewalOverrideCode

Delivery Address Detail Elements

AddressID (required)	LevelDesignatorID	ValidDeliveryDay[1] (at least 1 ValidDeliveryDay required)
Building	LevelNumber	ValidDeliveryDay[2]
CityID	PostDirectional	ValidDeliveryDay[3]
Complex	PreDirectional	ValidDeliveryDay[4]
CountryID	StateID	ValidDeliveryDay[5]
CountyID	StreetName	ValidDeliveryDay[6]
Filler	StreetSuffixID	ValidDeliveryDay[7]
HouseNumber	UnitDesignatorID	ZipCode
HouseNumberModifier	UnitNumber	ZipExtension
GNAF-PID	HIN

Delivery Schedule Change Detail Elements

Copies[1] (at least Copies field required)	Copies[7]	ReasonCode (required)
Copies[2]	DeliveryScheduleID (required)	Remarks
Copies[3]	Filler	SourceCode (required)
Copies[4]	MerchandiseCode	SubSourceID
Copies[5]	PreviousDeliveryRequested	TranDate (required)
Copies[6]	RateCodeID
NewDeliveryMethod	NewLabelGroupID	NewRouteID[1]
NewRouteID[2]	NewRouteID[3]	NewRouteID[4]
NewRouteID[5]	NewRouteID[6]	NewRouteID[7]

Demographic Answer Detail Elements

Answer (required)
DemographicID (required)
Filler
Replace

Move Detail Elements

AAMZoneID	Copies[5]	MoveInDate (required)	StateID
AddressID (required)	Copies[6]	MoveOutDate (required)	StreetName
AreaCode	Copies[7]	MovePrimaryOnly	StreetSuffixID
BillingMethod	CountryID	Phone	TaxExemptReason[City]
Building	CountyID	PhoneUnlisted	TaxExemptReason[Country]
CityID	DeliveryMethod	PostDirectional	TaxExemptReason[County]
Complex	DeliveryPlacementID	PreDirectional	TaxExemptReason[State]
Copies[1]	DeliveryScheduleID	RateCodeID	UnitDesignatorID
Copies[2]	Filler	ReasonCode (required)	UnitNumber
Copies[3]	HouseNumber	Remarks	ZipCode
Copies[4]	HouseNumberModifier	SourceCode (required)	ZipExtension

Payment Detail Element

AccountHolderName	BankClientType	MaskedCreditCardNumber	SubAdjustCodeID[3]
AccountNumber	BankNumber	PaymentAmount (required)	SubAdjustCodeID[4]
AccountType	CheckNumber	PaymentType (required)	SubAdjustCodeID[5]
AdjustmentAmount[1]	CouponAmount	ReasonCode (required)	TipAmount
AdjustmentAmount[2]	CreditCardExpires	Remarks	TranDate (required)
AdjustmentAmount[3]	CreditCardNumber	SourceCode (required)	TransactionID
AdjustmentAmount[4]	CreditCardTypeID	SubAdjustCodeID[1]	VaultCustomerID
AdjustmentAmount[5]	Filler	SubAdjustCodeID[2]	VaultID
AuthorizationNumber

Restart Detail Elements

AccountID	PreviousDeliveryRequested
BillSourceID	ReasonCode (required)
CompanyID	Remarks
DonateAllDays	SourceCode
DonationCode	SubSourceID (required)
DonationDays	TranDate (required)
Filler	VacationPack

Start Detail Elements

AAMColumnID	BillToCreditStatusID	Copies[3]	ReasonCode (required)
AAMZoneID	BillToEMailAddress	Copies[4]	ReassignReasonCode
AccountHolderName	BillToFirstName	Copies[5]	ReceiveBonusDays
AccountNumber	BillToHonorificID	Copies[6]	Remarks
AccountType	BillToHouseNumber	Copies[7]	RenewalDeliveryMethod
AdjustmentAmount[1]	BillToHouseNumberModifier	CreditCardExpires	RenewalOverrideCode
AdjustmentAmount[2]	BillToLastName	CreditCardNumber	RouteID
AdjustmentAmount[3]	BillToLevelDesignatorID	CreditCardTypeID	SendInvoice
AdjustmentAmount[4]	BillToLevelNumber	CreditStatusID	SendRenewal
AdjustmentAmount[5]	BillToMiddleInitial	DeliveryFeeCode	SendStatement
AuthorizationNumber	BillToOccupantTypeID	DeliveryInstructions	SourceCode (required)
AutoRenew	BillToPhone	DeliveryPlacementID	SubAdjustCodeID[1]
AutoRenewLength	BillToPhoneUnlisted	DeliveryScheduleID (required)	SubAdjustCodeID[2]
AutoRenewTerm	BillToPostDirectional	DirectionsToAddress	SubAdjustCodeID[3]
AutoRenewType	BillToPreDirectional	EbillEmailAddress	SubAdjustCodeID[4]
BankClientType	BillToStateID	EMailAddress	SubAdjustCodeID[5]
BankNumber	BillToStreetName	ExpireDate	SubSourceID
BillingGroupID	BillToStreetSuffixID	Filler	TaxExemptReason[City]
BillingMethod (required)	BillToUnitDesignatorID	MaskedCreditCardNumber	TaxExemptReason[Country]
BillToAddressID	BillToUnitNumber	MerchandiseCode	TaxExemptReason[County]
BillToAreaCode	BillToZipCode	OccupantTypeID	TaxExemptReason[State]
BillToBuilding	BillToZipExtension	PhoneUnlisted	TipAmount
BillToCityID	CampaignCode	PreviousDeliveryRequested	TranDate (required)
BillToComplex	Copies[1] (at least 1 Copies field required)	PurchaseNumber	VaultCustomerID
BillToCountryID	Copies[2]	RateCodeID	VaultID
BillToCountyID
AutoRenewPayPalEmailAddress	BillToGNAF-PID	BillToHIN

Stop Detail Elements

AccountID	Filler	RestartReasonCode
BillSourceID	PreviousDeliveryRequested	SourceCode (required)
CompanyID	ReasonCode (required)	StopDate (required)
DonateAllDays	RefundRequested	SubSourceID
DonationCode	Remarks	VacationPack
DonationDays	RestartDate