Recurring Billing Fields

Recurring Billing Fields
Field Name
Description
Data Type (Length)
BillingPeriodLength
Length of the billing period.
VARCHAR2(50 CHAR) NOT NULL
BillingPeriodUnit
Billing period unit. For example:
day
,
week
,
month
.
VARCHAR2(1 CHAR) NOT NULL
PlanPeriodLength
Length of the plan.
VARCHAR2(50 CHAR)
PlanPeriodUnit
Plan period unit. For example:
day
,
week
,
month
.
VARCHAR2(1 CHAR)
PlanDescription
Description of the plan.
VARCHAR2(300 CHAR)
PlanCurrency
Currency of the plan.
VARCHAR2(10 CHAR) NOT NULL
PlanID
Unique identifier of the plan.
VARCHAR2(100 CHAR)
PlanCode
Unique code of the plan.
VARCHAR2(20 CHAR)
SetupFee
Fee for setting up the subscription.
NUMBER
SubscriptionStatus
Current status of the subscription. For example,
active
or
inactive
.
VARCHAR2(20 CHAR) NOT NULL
SubscriptionID
Unique identifier of the plan.
NUMBER NOT NULL
SubscriptionCode
Unique code of the subscription.
VARCHAR2(20 CHAR) NOT
SubscriptionName
Unique name of the subscription.
VARCHAR2(100 CHAR) NOT NULL
SubscriptionNextPaymentDate
Date of the next payment for this subscription.
DATE
SubscriptionSuccessfulPayments
Number of successful payments for this subscription.
NUMBER NOT NULL
SubscriptionRetryCount
Number of times a failed payment has been retried.
NUMBER
SubscriptionStartDate
Date the subscription starts.
DATE NOT NULL
SubscriptionPaymentAmount
Amount paid for this subscription.
NUMBER NOT NULL
TMSCustomerID
Unique customer ID of a
TMS
customer in the
Cybersource
system.
VARCHAR2(100 CHAR) NOT NULL
TMSPaymentInstrumentID
Unique payment instrument ID of a
TMS
customer in the
Cybersource
system.
VARCHAR2(100 CHAR) NOT NULL
TMSShippingID
Unique shipping ID of a
TMS
customer in the
Cybersource
system.
VARCHAR2(100 CHAR)