One Row For Each Department/Location/Half
In ScopeTechnical: HALF_DATA_BUDGET | ID: OR-FIN-HALF_DATA_BUDGET-HALF_DATA_BUDGET
This table is used for holding data required for budgeting and gross margin forecasting. This table contains one row for each department/location/half within the company.
See how this object fits into Finance
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- HALF_DATA_BUDGET
Field Definitions(11)
Rules & Considerations(18)
Sample Load Data(4)
| _scenario | DEPTRPK | HALF_NORPK | LOCATIONR | LOC_TYPER | SET_OF_BOOKS_IDR | CLASS | SUBCLASS | MARKDOWN_PCT | SHRINKAGE_PCT | CUM_MARKON_PCT | GROSS_MARGIN_PCT |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | 1 | 1 | 1 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
Example values from field definitions
- DEPTRPK
- 1
- HALF_NORPK
- 1
- LOCATIONR
- 1
- LOC_TYPER
- S
- SET_OF_BOOKS_IDR
- 1
- CLASS
- 1
- SUBCLASS
- 1
- MARKDOWN_PCT
- 1.0000
- SHRINKAGE_PCT
- 1.0000
- CUM_MARKON_PCT
- 1.0000
- GROSS_MARGIN_PCT
- 1.0000
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 18