Budget
The Budget table stores information for budgets in NetSuite. Each budget covers a fiscal year. In NetSuite OneWorld, budgets are specific to a subsidiary and fiscal year. If the Multi-Book Accounting feature is enabled, each budget is for an accounting book and subsidiary pair for a year.
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 book ID |
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
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 |