Glbudgetheader
Summarizes metadata and high-level information for General Ledger (GL) budget headers, supporting financial planning.
Table Specific Information
Insert
Insert is only supported when UseLegacy=False.
The following example illustrates how to insert into GLBudgetHeader table:
INSERT INTO Glbudgetheader (Budgetid, Description, Itemaggregate) VALUES ('MyBudgetId3', 'My description', '<GLBUDGETITEM><acct_no>1000</acct_no><periodname>Year 2023</periodname><amount>500000</amount></GLBUDGETITEM>');
Note: Inserts are not supported with the Legacy API.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | True |
Unique record number for the budget entry. |
| Budgetid [KEY] | String | False |
Identifier for the budget, used as a unique key. |
| Description | String | False |
Descriptive name or details for the budget. |
| Systemgenerated | String | False |
Indicates whether the budget was generated by the system (true or false). |
| Default_budget | Bool | False |
Indicates if this budget is the default budget (true or false). |
| User | String | False |
The user who last modified the budget. |
| Status | String | False |
Current status of the budget, either active or inactive. |
| Whencreated | Datetime | True |
Timestamp indicating when the budget was created. |
| Whenmodified | Datetime | True |
Timestamp indicating when the budget was last modified. |
| Createdby | Long | True |
Identifier of the user who created the budget. |
| Modifiedby | Long | True |
Identifier of the user who last modified the budget. |
| Isconsolidated | Bool | False |
Indicates if the budget is consolidated to a single currency (true or false). |
| Currency | String | False |
Currency used for the consolidated budget. |
| Ispabudget | Bool | False |
Indicates if the budget is associated with a project estimate (true or false). |
| Ispcnbudget | Bool | False |
Indicates if the budget is associated with a project contract (true or false). |
| Megaentitykey | Long | True |
Internal key for the entity where the budget was created. |
| Megaentityid | String | True |
Identifier of the entity where the budget was created. |
| Megaentityname | String | True |
Name of the entity where the budget was created. |
| Budget_custom | String | False |
Custom field for additional budget metadata. |
| Field_after | String | False |
Additional field for sorting or referencing. |
| Record_url | String | True |
A user-independent, deep-link URL for accessing the budget record. |