Billing_accounts

Columns

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

Primary key

PK Column Name
billing_account_id

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