Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
address_book_id |
NUMBER |
|
39 |
0 |
|
|
Address book ID |
bill_to_address_book_id |
NUMBER |
|
39 |
0 |
address_book_id
|
Address_book
|
Bill to address book ID |
billing_account_extid |
VARCHAR2 |
255 |
|
|
|
|
Billing account external ID |
billing_account_id |
NUMBER |
|
39 |
0 |
|
|
Billing account ID |
billing_account_memo |
VARCHAR2 |
400 |
|
|
|
|
Billing account memo |
billing_account_name |
VARCHAR2 |
60 |
|
|
|
|
Billing account name |
billing_account_number |
VARCHAR2 |
60 |
|
|
|
|
Billing account number |
billing_schedule_id |
NUMBER |
|
39 |
0 |
billing_schedule_id
|
Billing_schedule_descriptions
|
Billing schedule ID |
class_id |
NUMBER |
|
39 |
0 |
|
|
Class ID |
currency_id |
NUMBER |
|
39 |
0 |
|
|
Currency ID |
customer_id |
NUMBER |
|
39 |
0 |
|
|
Customer ID |
date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
date_last_actual_bill |
TIMESTAMP |
|
|
|
|
|
Date of last actual bill |
date_last_bill_cycle |
TIMESTAMP |
|
|
|
|
|
Date of last bill cycle |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
date_next_bill_cycle |
TIMESTAMP |
|
|
|
|
|
Date of next bill cycle |
date_start |
TIMESTAMP |
|
|
|
|
|
Start date |
department_id |
NUMBER |
|
39 |
0 |
|
|
Department ID |
has_off_cycle_bill_request |
VARCHAR2 |
3 |
|
|
|
|
Whether off-cycle billing is used |
is_customer_default |
VARCHAR2 |
3 |
|
|
|
|
Whether the customer is default |
is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Whether the account is inactive |
location_id |
NUMBER |
|
39 |
0 |
|
|
Location ID |
ship_to_address_book_id |
NUMBER |
|
39 |
0 |
address_book_id
|
Address_book
|
Ship to address book ID |