Glbudgetitem
The GLBudgetItem table
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | False |
Record number |
| Budgetkey | Long | False |
Budget header key |
| Budgetid | String | False |
Budget ID |
| Currency | String | False |
Currency |
| Systemgenerated | String | False |
System generated |
| Periodkey | Long | False |
Period key |
| Accountkey | Long | False |
Account key |
| Deptkey | Long | False |
Department key |
| Locationkey | Long | False |
Location key |
| Amount | Decimal | False |
Amount |
| Basedon | String | False |
Based on |
| Growby | Decimal | False |
Grow by |
| Perperiod | String | False |
Per period |
| Note | String | False |
Note |
| Acct_no | String | False |
Account number |
| Account_type | String | False |
Account type |
| Accttitle | String | False |
Account title |
| Normalbalance | Long | False |
Normal balance |
| Statistical | String | False |
Statistical |
| Dept_no | String | False |
Department |
| Deptitle | String | False |
Department title |
| Location_no | String | False |
Location number |
| Locationtitle | String | False |
Location title |
| Periodname | String | False |
Period name |
| Reportingperiodname | String | False |
Reporting period name |
| Pstartdate | Date | False |
Start date |
| Penddate | Date | False |
End date |
| Megaentitykey | Long | True |
Created at - Entity key |
| Megaentityid | String | True |
Created at - Entity ID |
| Megaentityname | String | True |
Created at - Entity name |
| Projectdimkey | Long | False |
Projectdimkey |
| Projectid | String | False |
Project |
| Projectname | String | False |
Project name |
| Customerdimkey | Long | False |
Customerdimkey |
| Customerid | String | False |
Customer |
| Customername | String | False |
Customer name |
| Vendordimkey | Long | False |
Vendordimkey |
| Vendorid | String | False |
Vendor |
| Vendorname | String | False |
Vendor name |
| Employeedimkey | Long | False |
Employeedimkey |
| Employeeid | String | False |
Employee |
| Employeename | String | False |
Employee name |
| Itemdimkey | Long | False |
Itemdimkey |
| Itemid | String | False |
Item |
| Itemname | String | False |
Item name |
| Classdimkey | Long | False |
Classdimkey |
| Classid | String | False |
Class |
| Classname | String | False |
Class name |
| Warehousedimkey | Long | False |
Warehousedimkey |
| Warehouseid | String | False |
Warehouse |
| Warehousename | String | False |
Warehouse name |
| Contractdimkey | Long | False |
Contract key |
| Contractid | String | False |
Contract |
| Contractname | String | False |
Contract name |
| Record_url | String | True |
A portable, user-independent, deep-link URL for viewing this record |
| Gldimtestegi1 | String | False | |
| Gldimtest | String | False |