Budget

Columns

Name	Type	Length	Precision	Scale	References	In	Description
account_id	NUMBER		39	0	account_id	Accounts	Account ID
accounting_book_id	NUMBER		39	0	accounting_book_id	Accounting_books
accounting_period_id	NUMBER		39	0	accounting_period_id	Accounting_periods	Accounting period ID
amount	NUMBER		20	2			Amount
budget_date	TIMESTAMP						Date
budget_id	NUMBER		39	0			Budget ID
category_id	NUMBER		39	0	budget_category_id	Budget_category	Budget category ID
class_id	NUMBER		39	0	class_id	Classes	Class ID
customer_id	NUMBER		39	0	customer_id	Customers	Customer Id
department_id	NUMBER		39	0	department_id	Departments	Department ID
item_id	NUMBER		39	0	item_id	Items	Item ID
location_id	NUMBER		39	0	location_id	Locations	Location ID
subsidiary_id	NUMBER		39	0	subsidiary_id	Subsidiaries	Subsidiary ID

Primary key

PK Column Name
budget_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
budget_accounting_books_fk	accounting_book_id	Accounting_books	accounting_book_id	1
budget_accounting_periods_fk	accounting_period_id	Accounting_periods	accounting_period_id	1
budget_accounts_fk	account_id	Accounts	account_id	1
budget_budget_category_fk	category_id	Budget_category	budget_category_id	1
budget_classes_fk	class_id	Classes	class_id	1
budget_customers_fk	customer_id	Customers	customer_id	1
budget_departments_fk	department_id	Departments	department_id	1
budget_items_fk	item_id	Items	item_id	1
budget_locations_fk	location_id	Locations	location_id	1
budget_subsidiaries_fk	subsidiary_id	Subsidiaries	subsidiary_id	1