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.