| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| billing_schedule_id | NUMBER | 39 | 0 | Billing schedule ID | |||
| billing_schedule_type | VARCHAR2 | 20 | Billing schedule type | ||||
| frequency | VARCHAR2 | 20 | Frequency | ||||
| name | VARCHAR2 | 40 | Name | ||||
| recurrence_count | NUMBER | 39 | 0 | Recurrence count |
| PK Column Name |
|---|
| billing_schedule_id |
| FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
|---|---|---|---|---|
| Billing_accounts_billing_schedule_descriptions_fk | billing_schedule_id | Billing_accounts | billing_schedule_id | 1 |
| Charges_billing_schedule_descriptions_fk | billing_schedule_id | Charges | billing_schedule_id | 1 |
| Customers_billing_schedule_descriptions_fk | billing_schedule_id | Customers | billing_schedule_id | 1 |
| Transaction_lines_billing_schedule_descriptions_fk | billing_schedule_id | Transaction_lines | billing_schedule_id | 1 |