Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
amount | NUMBER | 20 | 2 | Amount of the charges | |||
billing_account_id | NUMBER | 39 | 0 | Billing account ID | |||
billing_mode_id | VARCHAR2 | 32 | Billing mode of the charges | ||||
billing_schedule_id | NUMBER | 39 | 0 |
billing_schedule_id |
Billing_schedule_descriptions |
Billing schedule of the charges | |
category_0 | NUMBER | 39 | 0 | Category of the charges | |||
charge_extid | VARCHAR2 | 255 | Charge Ext ID of the charges | ||||
charge_id | NUMBER | 39 | 0 | Charge ID of the changes | |||
chargeemployee | NUMBER | 39 | 0 | Employee of the charges | |||
chargerule | NUMBER | 39 | 0 | Charge rule of the charges | |||
chargestage | VARCHAR2 | 32 | Charge stage of the charges | ||||
chargetype | NUMBER | 39 | 0 | Charge type of the charges | |||
chargeuse | VARCHAR2 | 32 | Charge use of the charges | ||||
class_0 | NUMBER | 39 | 0 | Class of the charges | |||
currency | NUMBER | 39 | 0 | Currency of the charges | |||
customer | NUMBER | 39 | 0 | Customer of the charges | |||
date_0 | TIMESTAMP | Date of the charges | |||||
date_bill | TIMESTAMP | Date of the bill of the charges | |||||
date_last_modified | TIMESTAMP | Date Last Modified | |||||
date_service_end | TIMESTAMP | Date service end of the charges | |||||
date_service_start | TIMESTAMP | Date service start of the charges | |||||
department | NUMBER | 39 | 0 | Department of the charges | |||
description | VARCHAR2 | 4000 | Description of the charges | ||||
group_order | NUMBER | 39 | 0 | Group order of the charges | |||
item | NUMBER | 39 | 0 | Item of the charges | |||
location_0 | NUMBER | 39 | 0 | Location | |||
memo | VARCHAR2 | 4000 | Memo of the charges | ||||
quantity | NUMBER | 18 | 8 | Quantity of the charges | |||
rate | NUMBER | 30 | 15 | Rate of the charges | |||
run_id | NUMBER | 39 | 0 | Run ID of the charges | |||
sales_order | NUMBER | 39 | 0 | Sales order of the charges | |||
so_line | NUMBER | 39 | 0 | Sales Order of the line item of the charges | |||
subsidiary_id | NUMBER | 39 | 0 | Subsidiary ID of the charges | |||
time_source | NUMBER | 39 | 0 | Time source of the charges | |||
unit_id | NUMBER | 39 | 0 | Unit ID of the charges |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
charges_billing_schedule_descriptions_fk | billing_schedule_id | Billing_schedule_descriptions | billing_schedule_id | 1 |