Bins ODS
Bins ODS
Technical Name: 0RC_DS08
Use
The Bins ODS is used to stage the data prior to loading into the Bins InfoCube to allow for overwrite functionality to filter out multiple data loads.
InfoSources
0RC_CI_8 BINs.
Key Fields
|
Key Field |
Description |
|
0CALDAY |
Calendar day |
|
0CALWEEK |
Calendar Year / Week |
|
0RC_STORE |
Store |
|
0RC_RT_FYR |
Retail Fiscal Year |
|
0RC_RT_FMO |
Retail Fiscal Month |
|
0RC_RT_FWK |
Retail Fiscal Week |
|
0RC_RT_FDIW |
Retail Fiscal Day in Week |
|
0RC_BINID |
Bin ID |
Data Fields
|
Data Field |
Description |
|
0RC_BINAMT |
Bin Amount |
|
0CURRENCY |
Currency key |
|
0RC_BINHVAL |
Bin Hour Value |
|
0UNIT |
Unit of measure |
Update rules for Bins ODS will evaluate master data looking to determine the appropriate unit of measure for each bin and populating the unit characteristic accordingly. Additionally, the appropriate key figure will be populated (amount or quantity) depending on the unit of measure identified in Master Data.
Delta Update
This ODS object is designed for a delta update with a flat file DataSource.