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) |