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 |
|
Last updated