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
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 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
Ship to address book ID

Primary key

PK Column Name

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
billing_accounts_address_book_fk_1 bill_to_address_book_id Address_book address_book_id 1
billing_accounts_address_book_fk_2 ship_to_address_book_id Address_book address_book_id 1
billing_accounts_billing_schedule_descriptions_fk billing_schedule_id Billing_schedule_descriptions billing_schedule_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Billing_subscriptions_billing_accounts_fk billing_account_id Billing_subscriptions billing_account_id 1