Glbudgetitem
Holds detailed line item data for General Ledger (GL) budgets, facilitating granular budget analysis and tracking.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | False |
Unique record identifier for the GLBudgetItem table. |
| Budgetkey | Long | False |
Identifier for the budget header associated with this record. |
| Budgetid | String | False |
Unique ID of the budget associated with this record. |
| Currency | String | False |
Currency code for transactions related to this budget item. |
| Systemgenerated | String | False |
Indicates if the record was generated by the system automatically. |
| Periodkey | Long | False |
Key referencing the accounting period for this record. |
| Accountkey | Long | False |
Key referencing the account associated with this budget item. |
| Deptkey | Long | False |
Key referencing the department associated with this budget item. |
| Locationkey | Long | False |
Key referencing the location associated with this budget item. |
| Amount | Decimal | False |
Monetary amount specified for this budget item. |
| Basedon | String | False |
Criteria or formula used to base the budget calculations. |
| Growby | Decimal | False |
Percentage or value by which the budget is projected to grow. |
| Perperiod | String | False |
Indicates the allocation of the budget on a per-period basis. |
| Note | String | False |
Additional information or comments about the budget item. |
| Acct_no | String | False |
Account number associated with this budget item. |
| Account_type | String | False |
Type of account linked to this budget item, such as revenue or expense. |
| Accttitle | String | False |
Title or description of the account related to the budget item. |
| Normalbalance | Long | False |
The normal balance type for the account (for example, debit or credit). |
| Statistical | String | False |
Specifies if the budget item is statistical rather than monetary. |
| Dept_no | String | False |
Number identifying the department for this budget item. |
| Deptitle | String | False |
Title or name of the department associated with this budget item. |
| Location_no | String | False |
Number identifying the location associated with this budget item. |
| Locationtitle | String | False |
Title or name of the location associated with this budget item. |
| Periodname | String | False |
Name or identifier for the accounting period. |
| Reportingperiodname | String | False |
Name of the reporting period associated with the budget item. |
| Pstartdate | Date | False |
Start date of the period associated with the budget item. |
| Penddate | Date | False |
End date of the period associated with the budget item. |
| Megaentitykey | Long | True |
Key referencing the entity where the record was created. |
| Megaentityid | String | True |
Unique ID of the entity where the record was created. |
| Megaentityname | String | True |
Name of the entity where the record was created. |
| Projectdimkey | Long | False |
Key referencing the project dimension for this budget item. |
| Projectid | String | False |
Unique identifier for the project associated with this budget item. |
| Projectname | String | False |
Name or title of the project associated with this budget item. |
| Customerdimkey | Long | False |
Key referencing the customer dimension for this budget item. |
| Customerid | String | False |
Unique identifier for the customer associated with this budget item. |
| Customername | String | False |
Name or title of the customer associated with this budget item. |
| Vendordimkey | Long | False |
Key referencing the vendor dimension for this budget item. |
| Vendorid | String | False |
Unique identifier for the vendor associated with this budget item. |
| Vendorname | String | False |
Name or title of the vendor associated with this budget item. |
| Employeedimkey | Long | False |
Key referencing the employee dimension for this budget item. |
| Employeeid | String | False |
Unique identifier for the employee associated with this budget item. |
| Employeename | String | False |
Name or title of the employee associated with this budget item. |
| Itemdimkey | Long | False |
Key referencing the item dimension for this budget item. |
| Itemid | String | False |
Unique identifier for the item associated with this budget item. |
| Itemname | String | False |
Name or title of the item associated with this budget item. |
| Classdimkey | Long | False |
Key referencing the class dimension for this budget item. |
| Classid | String | False |
Unique identifier for the class associated with this budget item. |
| Classname | String | False |
Name or title of the class associated with this budget item. |
| Warehousedimkey | Long | False |
Key referencing the warehouse dimension for this budget item. |
| Warehouseid | String | False |
Unique identifier for the warehouse associated with this budget item. |
| Warehousename | String | False |
Name or title of the warehouse associated with this budget item. |
| Contractdimkey | Long | False |
Key referencing the contract dimension for this budget item. |
| Contractid | String | False |
Unique identifier for the contract associated with this budget item. |
| Contractname | String | False |
Name or title of the contract associated with this budget item. |
| Record_url | String | True |
A portable, user-independent, deep-link URL for viewing this record in the system. |
| Gldimtestegi1 | String | False |
Additional dimension or test field related to the GL item. |
| Gldimtest | String | False |
Additional dimension or test field related to the GL item. |