Half Data
In ScopeTechnical: HALF_DATA | ID: OR-FIN-HALF_DATA-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- HALF_DATA
Field Definitions(5)
Rules & Considerations(28)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSRPK | LOCATIONRPK | LOC_TYPERPK | SUBCLASSRPK | HALF_NO | SHRINKAGE_PCT | SET_OF_BOOKS_ID | INTER_STOCKTAKE_SALES_AMT | INTER_STOCKTAKE_SHRINK_AMT |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | 1 | 1 | 1.0000 | 1 | 1.0000 | 1.0000 |
| default | 1003 | 1103 | 3 | W | 1113 | 4 | 12.5000 | 1000000003 | 12.5000 | 12.5000 |
| default | 1005 | 1105 | 5 | E | 1115 | 6 | 14.0000 | 1000000005 | 14.0000 | 14.0000 |
Example values from field definitions
- DEPTRPK
- 1
- CLASSRPK
- 1
- LOCATIONRPK
- 1
- LOC_TYPERPK
- S
- SUBCLASSRPK
- 1
- HALF_NO
- 1
- SHRINKAGE_PCT
- 1.0000
- SET_OF_BOOKS_ID
- 1
- INTER_STOCKTAKE_SALES_AMT
- 1.0000
- INTER_STOCKTAKE_SHRINK_AMT
- 1.0000
default
- DEPTRPK
- 1003
- CLASSRPK
- 1103
- LOCATIONRPK
- 3
- LOC_TYPERPK
- W
- SUBCLASSRPK
- 1113
- HALF_NO
- 4
- SHRINKAGE_PCT
- 12.5000
- SET_OF_BOOKS_ID
- 1000000003
- INTER_STOCKTAKE_SALES_AMT
- 12.5000
- INTER_STOCKTAKE_SHRINK_AMT
- 12.5000
default
- DEPTRPK
- 1005
- CLASSRPK
- 1105
- LOCATIONRPK
- 5
- LOC_TYPERPK
- E
- SUBCLASSRPK
- 1115
- HALF_NO
- 6
- SHRINKAGE_PCT
- 14.0000
- SET_OF_BOOKS_ID
- 1000000005
- INTER_STOCKTAKE_SALES_AMT
- 14.0000
- INTER_STOCKTAKE_SHRINK_AMT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 35
- Governed Rule Count
- 28