Circulation Status

The current status of the subscription.

• B = Billing Suspend, credit card declined

• C = Customer Requested Cancellation

• E = Expired

• G = Gracing this status status allows Advantage to fulfill the customer and recoups the sent issues when the renewal has taken place by decreasing the new term with number of grace issues sent. 

• N = Non-Pay Cancel, card declined and invoice has been closed due to non-payment. This generally occurs 45-90 days after a billing suspension is done.

• P = Perpetual, lifetime complimentary

• R = Regular, Receiving (Active) Subscription

• S = Indefinite Suspension

• T = Temporary Suspension

• U = Undeliverable

• W = Future Start

• X = Folded Subscription, no longer active

Billing Status

The current billing status of the subscription.

• A = On Approval

• B = Billed

• C = Complimentary

• M = Cancellation Credit Memo

• P = Paid Up

• R = Reinstated Subscription

Subscription Type

Used for offers that include multiple levels to identify levels of a subscription. For example, if a subscription can be lifetime or not, it may be blank for regular subscribers but LIFE for lifetime customers. This is often used by affiliates to grant or restrict content on websites.

Membership Organization

Used for subscriptions that are part of a membership to identify the organization they are a part of.

Membership Category

Used for subscriptions that are part of a membership to identify the category they are a part of. 

Duplicate Subscription Ref

Populated when a customer has 2 concurrent subscriptions running under the same customer number. These are a result of duplicate account consolidations where the customer had 2 of the same subscriptions on 2 different accounts that have since been consolidated.

Promotion Code

Promotion code used for the selected term of the subscription. Codes starting with an A are associated with a term that was created automatically through an auto-renewal.

Current Term Issues To Go

Number of issues left in the current term

Total Issues To Go

Number of issues left total for the subscription including advanced early renewals. 

Rate

Price of the subscription.

Billing Currency

Currency the rate is associated with.

Term Length

Number of issues the customer will receive for the term.

Customer purchase order

The order number a customer sees on their confirmation of an order placed online via the Opium E-Commerce system. Note that web orders that are associated with affiliate shopping carts may not be populated.

Renewal Flag

Determines how the subscription will be renewed.

• D = Discontinue Auto-Renewal, customer was on auto-renew and cancelled

• Z = Abbreviated Renewal, customer was a Y flag but requested to stop receiving special renewal notices

• N = No – Do not renew, customer will not receive renewal notices

• A = Automatic Renewal, automatically renews with no charge for lifetime subscriptions

• C =  Automatic Renewal with Auto-Charge, auto renews and charges credit card on file

• Y = Subscribers receive renewal offers, will not automatically renew

Final Expiration Date

Date of last issue for the subscription including advanced early renewals.

Remaining Liability

Calculation of the number of issues to go for the term / rate of the term. This is used in determining the amount of a refund, however it does not reflect the refund policy.

Promotion Choice

The choice selected with the promotion code for the term.

Credit Policy Code

A credit policy which defines how credits are created when a sub is cancelled.

Original Sales Rep

The salesperson getting credit for orders from this customer.

Sales Rep

The Sales Rep associated with the subscription order.

Last Modified Order Number

The current order number associated with the subscription. Note that if the customer placed an order and then had a modification done on the subscription, this number would reflect the order number for the last modification performed.

Delivery Code

How the subscription is being sent to the customer

• ML = Mail

• ME = Mail and Email

• EM = Email

• FX = Fax                                               

• EF = Email and Fax

• WB = Web Online Delivery

• PO = Mail (Used by London Affiliates)

• PE = Mail and Email (Used by London Affiliates)

Last Issue Sent

Date of issue the customer last was pulled to receive.

Current Term Start

Date of first issue for the current selected term.

Current Term Expires

Date of last issue for the current term.

First Issue Sent

Date of first issue ever sent to the customer including previous terms.

Term Number

Number associated with the amount of times a customer has renewed/ordered a subscription. For example, the first time the customer orders, the Term Number is 1. When the term renews, that new term is term 2.

Times Renewed

The number of times the customer has renewed their subscription.

Original Order Number

Order number associated with the selected term for when the order was created.

Original Control Group Date

Date of the control group from the original order.

Original Control Group

ID of the control group from the original order.

• O = Online

• C or T = Customer Service & Telesales

• M = Mail

• A, Z = System created

Last Modified Order Number

Order number associated with the last modification performed for the subscription. If no modifications have been performed, the last modified order number and original order number will be the same.

Last Modified Control Group Date

Date of the control group associated with the last modification performed for the subscription. If no modifications have been performed, the last modified order control group date and original control group date will be the same.

Number of Decline Notifications

The number of notifications sent to the customer about a declined credit card payment.

Last Decline Notice Sent

The date of the last notification sent to the customer about a declined credit card payment.

Order Source

Source associated with orders that come in from outside of Advantage directly. These are orders that are processed through Order Stream.

Payment Type

The type of payment used for the order. Generally this is Credit Card or Check.

Cancel Reason

Used to identify the reason for a subscription cancellation. This will only show a value if the subscription is a Cancelled status.

Number of Renewal Reminders

The number of renewal reminders that have been sent to a customer. For a customer not on auto-renew, this would show the regular renewal series information for how many renewal reminders have been sent. For a customer on auto-renew, this would show the number of reminders sent about the upcoming automatic charge, generally 1.

Last Renewal Effort Sent

The date the last renewal effort was sent to the customer.

Advance Renewals

Number of renewals on the subscription that have not been fulfill.

Last Renewal Promo Code

The promotion code associated with the last renewal reminder sent to the customer.

Auto Renew Chain

Used for when a subscription is ordered with an auto renew chain associated with the promotion code. When available, this will show up as a hyperlink that you can click on for more details on what the chain is.

Chain Sequence

Associated with the Auto Renew Chain. This is the sequence the customer is on for the selected term.

Installment Billing Code

Used for when a subscription is ordered with an installment bill code associated with either the promotion code or used at payment screen.

Package Number

The Package Number identifies a group of items.

Package Group ID

The Package ID field is a last number that is used to group package components of a publication set.

Authentication ID

Unique identifier of the login.

Auth Group Description

The authentication group associated with the subscription's login. Some affiliates have one auth group for their site, while others have multiple auth groups setup based on their infrastructure of their website.

Auth Type

Displays the field to determine where the username/password will be displayed:

Auth Type Description

Description field related to the Authentication Type field. Denotes whether it is a customer's email address or a authentication value as the username.

Authentication Value

If the Auth Type is L, this is the username for the website login.

Email Address

If the Auth Type is E, this is the username for the website login.

Record Status

The status of the login.

• A = Active

• I = Inactive

Last Login

Shows the date and time of the last login the customer did on the website.

Last Updated

Shows the last date the information was edited.

Last Updated By Description

Displays the name/identity of the last user to update the login record.

Trans. Date

Date of the transaction.

Trans. Nbr

Order number of debit number of the transaction.

Applied to

The order number or debit number the transaction was applied to.

Source

The system name the transaction is associated with.

• CIR = Circulation or Subscription

• PRO = Product

• CEM = Conference

• AMB = Agreement

• ARP = Accounts Receivable/Payable

Trans. Type

The type of transaction.

• I = Invoiced

• P = Paid

• B = Billed

• C = Credit

• W = Write Off

Transaction Status Description

The status of the transaction.

Total Amt.

The amount debited/credited.

Remaining Amt.

The amount remaining that has not been paid/credited.

Billing Currency

The currency the order was billed in.

Payment Code

The type of credit card used for the transaction.

Payment Nbr

The credit card number used for the transaction. This field is masked to only display the last 4 digits. If the payment is by check, the check number will display here.

Credit or Debit

Shows if the transaction was a debit or credit.

Posted

Displays if the transaction has been posted.

Debit Fully Paid

Displays a Y if the debit is fully paid. N if not fully paid.

Due Date

The date the payment is due. This is primarily used for when payments are spread out with installment billing.

Payment Type

The type of payment used. CC = Credit Card. CK = Check.

Sequence

Unique identifier of the email address.

Email Address

The email address on file for the subscription.

Delivery Code

The delivery code associated with the subscription. If a customer's delivery code is set to ML and they are wondering why they are not receiving emails, the delivery code should be updated to reflect an option that includes email fulfillment.

Circulation Status

The status of the subscription. If a customer's status is not active and they are wondering why they are not receiving emails, the subscription needs to be updated to be active.

Email Valid

Displays if the email address is a valid email. This flag changes if bounces are received from emails sent to that address.

Email Status Description

The status of the email address.

• A = Active

• I = Inactive

• X = Permanently Inactive

• S = Not Receiving

• B = Not Receiving

Unique ID

Unique identifier of the email sent.

Email Address

The email address on file for the subscription.

Date Sent

Date the email was originally sent to the customer.

Time Sent

Time the email was originally sent to the customer.

Status Description

The status of the email sent.

• Delivered

• Bounced

Bounce Reason Description

The reason for the bounce - currently all are recorded as Bounce.

Email Subject

Description from Message Central of the email sent to the customer. Not necessarily the subject line of the email, this is controlled by what is entered in Message Central.

Term Number

Term number associated with the transaction.

Order Number

Order number of the transaction.

Operation Code Description

Description of the transaction event.

Operation Code

Code associated with the operation of the transaction event.

Control Group Date

Date of the control group, or batch, of the transaction.

Control Group ID

ID of the control group from the original order.

• C or T = Customer Service & Telesales

• A, Z, OP = System created

Term Number

Number associated with the amount of times a customer has renewed/ordered a subscription. For example, the first time the customer orders, the Term Number is 1. When the term renews, that new term is term 2.

Circulation Status Description

The status of the term.

• B = Billing Suspend

• C = Customer Requested Cancellation

• E = Expired

• N = Non-Pay Cancel

• X = Folded Subscription

Orig Ctrl Group Date

The date of the original control group associated with the term.

Aggress Code

The address code associated with the shipment of the issues.

Sub Reference

Unique identifier of the subscription record.

Subscription Type

Used for offers that include multiple levels to identify levels of a subscription. For example, if a subscription can be lifetime or not, it may be blank for regular subscribers but LIFE for lifetime customers.

Term Number

Number associated with the amount of times a customer has renewed/ordered a subscription. For example, the first time the customer orders, the Term Number is 1. When the term renews, that new term is term 2.

Circulation Status Description

The status of the term.

• B = Billing Suspend

• C = Customer Requested Cancellation

• E = Expired

• N = Non-Pay Cancel

• X = Folded Subscription

Orig Ctrl Group Date

The date of the original control group associated with the term.

Aggress Code

The address code associated with the shipment of the issues.

Sub Reference

Unique identifier of the subscription record.

Subscription Type

Used for offers that include multiple levels to identify levels of a subscription. For example, if a subscription can be lifetime or not, it may be blank for regular subscribers but LIFE for lifetime customers.

Issue Date

Date of the issue. If a monthly publication, this will always be the 1st of the month.

Date Sent

Date issue has been sent.

Delivery Code

How the subscription is being sent to the customer

• ML = Mail

• ME = Mail and Email

• EM = Email

• FX = Fax                                               

• EF = Email and Fax

• WB = Web Online Delivery

Term Number

The term number associated with the generated welcome package premium.

Fulfilled Premium Order Number

The order number associated with the fulfillment of the welcome package.

Item Number Description

Description of the welcome package item.

Item Number

Item number associated with welcome package

Earned At

When the premium was earned.

• DAYS = Responded within n days

• FIRST= One of the first n responses

• PAYMNT = Order is n% paid

• PRMHLD = Premium Hold

• RESPON = At response time

• RETURN = Product is returned.

Address Code

The address code associated with the shipment of the welcome package premium.

Suspend Date

Date of the issue when the subscription was suspended.

Suspend Resume Date

For temporary suspensions, the date of the issue when the subscription will resume.

Completed

Displays if the service break has been completed.

Last Updated By

Name/identity of the last user to update the record.

Last Updated

The date and time of the last update to the record.

Type

Suspension Type

• IND = Indefinite

• TMP = Temporary

Item Number

Item Number associated with the order line.

Title…

The description, or name, of the product or subscription associated with the order line.

Qty Ordered

The quantity ordered of the line item.

Qty Shipped

The quantity shipped of the line item. For subscriptions, this should always match the quantity ordered.

Unit Price

Price per unit.

Item Gross

Price x Quantity Ordered.

Ship-to Customer

The customer number the order line was shipped to.

Address Type

The address code associated to the customer number the order line was shipped to.

Cross-sell/Upsell

Indicates if the line item was part of an upsell or cross sell offer. This is only applicable for phone orders.