On This Page
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) |