Expense Budget Domain
The domains consists of the following columns (NOTE: Column names could be renamed so you might see different names based on your side configuration, so the following names are the base names of the system)
Column ID | Column Name (From DBLabels.properties) | Data Type | Description |
---|---|---|---|
BUDGET_NAME | Budget Name | String | Budget Name |
BUDGET_TYPE | Budget Type ID | String | Budget Type ID |
BUDGET_TYPE_NAME | Budget Type Name | String | Budget Type Name |
EMPLY_ID | Employee ID | String | Employee Id |
ENTERED_BY | Entered by | String | Employee ID of person who entered the expense |
EXP_TYPE_NAME | Expense Type | String | Expense Type Name Charge |
GRP_EXP_NAME | Expense Type Group | String | Expense Type Group Name for the charge Expense Type |
LAST_FIRST | Full Name (Last, First) | String | Employee/User Last Name, First Name |
LEVEL1_CODE | Level1 Code | String | WBS Level1 Code |
LEVEL1_NAME | Level 1 | String | WBS Level1 Name |
LEVEL2_CODE | Level2 Code | String | WBS Level2 Code |
LEVEL2_NAME | Level 2 | String | WBS Level2 Name |
LEVEL3_CODE | Level3 Code | String | WBS Level3 Code |
LEVEL3_NAME | Level 3 | String | WBS Level3 Name |
LEVEL4_CODE | Level4 Code | String | WBS Level4 Code |
LEVEL4_NAME | Level 4 | String | WBS Level4 name |
NOTE | Note | String | Note |
REPORTING_TYPE_DESCR | Period Type Name | String | Report Period Type Name |
REPORTING_TYPE_ID | Period Type ID | String | Reporting Period Type ID |
WORK_DEPT_CODE | Worked Department Code | String | Worked Department Code |
WORK_DEPT_NAME | Worked Department | String | Worded Department Name |
WORK_OPT_CODE | Worked Operating Unit Code | String | Worked Operating Unit Code |
WORK_OPT_NAME | Worked Operating Unit | String | Worked Operating Unit Name |
ACTUAL_AMOUNT | Actual Amount | Decimal | Actual Amount Used |
BUDGETED_AMOUNT | Budgeted Amount | Decimal | Budgeted Amount |
BUDGET_END_DATE | Budget End Date | Date | Budget End Date |
BUDGET_START_DATE | Budget Start Date | Date | Budget Start Date |
DTSTAMP | DateTime Stamp | DateTime | DateTime Stamp |
PERIOD_END_DATE | Period End Date | Date | Reporting Period Start Date |
PERIOD_START_DATE | Period Start Date | Date | Reporting Period End Date |
2024 DATABASICS, Inc