| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| billing_class_id | NUMBER | 39 | 0 |
billing_class_id |
Billing_classes |
Billing class ID | |
| currency_id | NUMBER | 39 | 0 |
currency_id |
Currencies |
Currency ID | |
| date_last_modified | TIMESTAMP | Date last modified | |||||
| discount_pct | NUMBER | 5 | 2 | Discount percentage | |||
| isinactive | VARCHAR2 | 3 | Is inactive | ||||
| isonline | VARCHAR2 | 3 | Is online | ||||
| item_id | NUMBER | 39 | 0 |
item_id |
Service_items |
Item ID | |
| item_price_extid | VARCHAR2 | 255 | Item price extension ID | ||||
| item_price_id | NUMBER | 39 | 0 |
price_type_id |
Price_types |
Item price ID | |
| item_unit_price | NUMBER | 30 | 15 | Item unit price | |||
| name | VARCHAR2 | 60 | Name |
| PK Column Name |
|---|
| item_id |
| billing_class_id |
| item_price_id |
| currency_id |
| FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
|---|---|---|---|---|
| item_billing_rates_billing_classes_fk | billing_class_id | Billing_classes | billing_class_id | 1 |
| item_billing_rates_currencies_fk | currency_id | Currencies | currency_id | 1 |
| item_billing_rates_price_types_fk | item_price_id | Price_types | price_type_id | 1 |
| item_billing_rates_service_items_fk | item_id | Service_items | item_id | 1 |