Half Data
In ScopeTechnical: HALF_DATA | ID: OR-MFCS-HALF_DATA
This table provides a history, by half, of shrinkage amounts that are maintained by RMS. This table contains one row for each department/class/subclass/location/half combination in 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
Target Structure
- Load Approach
- Table
- Target Objects
- HALF_DATA
Field Definitions(10)
Rules & Considerations(26)
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSR | HALF_NORPK | LOCATIONR | LOC_TYPER | SUBCLASSR | SET_OF_BOOKS_IDR | SHRINKAGE_PCT | INTER_STOCKTAKE_SALES_AMT | INTER_STOCKTAKE_SHRINK_AMT |
|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | 00002 | 1 | S | 1111 | 1000000001 | 11.0000 | 11.0000 | 11.0000 |
default
- DEPTRPK
- 1001
- CLASSR
- 1101
- HALF_NORPK
- 00002
- LOCATIONR
- 1
- LOC_TYPER
- S
- SUBCLASSR
- 1111
- SET_OF_BOOKS_IDR
- 1000000001
- SHRINKAGE_PCT
- 11.0000
- INTER_STOCKTAKE_SALES_AMT
- 11.0000
- INTER_STOCKTAKE_SHRINK_AMT
- 11.0000