Product Providers
Available since: v1.0.0
| File | Snapshot | Delta | Frequency |
|---|---|---|---|
| product_providers/product_providers_YYYY_MM_dd.csv | :white_check_mark: | :no_entry: | Daily |
| Attribute | Require? | Value | Description |
|---|---|---|---|
| ID | Yes | NUMBER | Unique identifier for entity |
| PRODUCT_ID | NUMBER | Foreign key for Products | |
| PROVIDER_ID | NUMBER | Foreign key for Payment Providers | |
| AUTORENEW_WARNING_DUE | NUMBER | Seconds before to send warning of auto renewal. | |
| AUTORENEW_WARNING_CHANNEL | NUMBER | 0 = EMAIL 1 = SMS | |
| SORT_INDEX | NUMBER | Sort index of product provider used by front ends | |
| DESCRIPTION | VARCHAR(2000 BYTE) | Description of product provider | |
| REQUIRES_AUTORENEW_WARNING | 0 or 1 | Boolean. Send warning of auto renewal? | |
| INITPRICE | Yes | NUMBER | Price for first period of subscription |
| INITPERIOD | Yes | NUMBER | Length of first period of subscription |
| ENABLED | 0 or 1 | Boolean. Is product provider enabled | |
| DETAILED_DESCRIPTION | VARCHAR2(2000 BYTE) | Detailed description of product provider | |
| PRODUCT_PROVIDER_STATUS | Yes | VARCHAR(20 BYTE) | ENABLED, DISABLED, HIDDEN |
| NO_OF_TRIAL_PERIODS | Yes | NUMBER (Between 1 and 99) | Number of trial periods for a product |