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.
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
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
ChargeCarrier
ReasonCode (required)
ComplaintDate (required)
Redeliver
ComplaintText
RedeliverInstructions
DaysAdjust
SourceCode (required)
Dispatch
Urgent
Filler
ComboID (required)
Remarks
TranDate (required)
SourceCode (required)
RateCodeID (required)
SubsourceID
ReasonCode (required)
EbillEmailAddress
RenewalDeliveryMethod
RenewalOverrideCode
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
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]
Answer (required)
DemographicID (required)
Filler
Replace
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
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
AccountID
PreviousDeliveryRequested
BillSourceID
ReasonCode (required)
CompanyID
Remarks
DonateAllDays
SourceCode
DonationCode
SubSourceID (required)
DonationDays
TranDate (required)
Filler
VacationPack
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
AccountID
Filler
RestartReasonCode
BillSourceID
PreviousDeliveryRequested
SourceCode (required)
CompanyID
ReasonCode (required)
StopDate (required)
DonateAllDays
RefundRequested
SubSourceID
DonationCode
Remarks
VacationPack
DonationDays
RestartDate