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