| external_key
|
|
VARCHAR(255)
|
N
|
A unique string in this table.
|
| budget_ekey
|
alco_budget_line -– budget_id |
VARCHAR(255)
|
Y
|
The external key of this budget
|
| budget_name
|
alco_budget -– name |
VARCHAR(255)
|
N
|
The name of this budget.
|
| budget_description
|
alco_budget -– description |
VARCHAR(1000)
|
Y
|
The description of this budget.
|
| start_date
|
alco_budget -– start_date |
TIMESTAMP
|
N
|
The start date of this budget.
|
| end_date
|
alco_budget -– end_date |
TIMESTAMP
|
N
|
The end date of this buget.
|
| currency_ekey
|
alco_budget -– currency_id |
VARCHAR(255)
|
N
|
The currency external key of this budget.
|
| gl_code
|
alco_budget_account -– gl_code |
VARCHAR(200)
|
N
|
The gl code of the budget account.
|
| budgeted_amount
|
alco_budget_line -– budgeted_amount |
NUMERIC(20, 10)
|
N
|
The budgeted amount of the budget line.
|
| adjusted_amount
|
alco_budget_line -– adjusted_amount |
NUMERIC(20, 10)
|
Y
|
The adjusted amount of the budget line.
|
| allocated_amount
|
alco_budget_line -– allocated_amount |
NUMREIC(20, 10)
|
Y
|
The allocated amount of the budget line.
|
| committed_amount
|
alco_budget_line -– committed_amount |
NUMERIC(20, 10)
|
Y
|
The committed amount of the budget line.
|
| cost_center_ekey
|
alco_budget_line -– cost_center_id |
VARCHAR(255)
|
Y
|
The cost center external key of the budget
line.
|
| project_ekey
|
alco_budget_line - project_id |
VARCHAR(255)
|
Y
|
The project external key of the budget line.
|
| status
|
alco_budget_line - active_status |
INTEGER
|
N
|
The status of this budget.
|