DBA Data[Home] [Help] [Dependency Information]

TABLE: DDR.DDR_S_RTL_INV_ITEM

Object Details
Object Name: DDR_S_RTL_INV_ITEM
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


Staging table for data processed from DDR_I_RTL_INV_ITEM


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Unique Record ID per Transaction for Error Handling
TRANS_DT DATE
Yes The date for which the value is being reported
MFG_ORG_CD VARCHAR2 (30)
Manufacturer Organization Code
RTL_ORG_CD VARCHAR2 (30)
Natural Key Code for a Retailer Organization
ORG_BSNS_UNIT_ID NUMBER

Business Unit ID
RTL_BSNS_UNIT_CD VARCHAR2 (30)
Global identifier for the location (typically a retail store or distribution center) - Business Unit
GLBL_ITEM_ID VARCHAR2 (30)
Universally Unique Global Item ID for an SKU for Mapping Manufacturer SKU to Retailer SKU: Example - 14-digit Global Trade Item Number (GTIN) assigned by the GS1 standards organization
RTL_SKU_ITEM_ID NUMBER

Unique Retailer Level SKU Item ID
RTL_SKU_ITEM_NBR VARCHAR2 (30)
Unique Retailer proprietary SKU Item Number
DAY_CD VARCHAR2 (30)
Day level information for which the value is being reported
GLBL_ITEM_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global item number. By default, the value is "GTIN" if unspecified
INV_LOC_TYP_CD VARCHAR2 (30)
Inventory Location Type Code
INV_LOC_ID NUMBER

Inventory Location ID
INV_LOC_CD VARCHAR2 (30)
Inventory Location Code
UOM_CD VARCHAR2 (30)
Unit of measure code for the transaction
UOM_CD_PRMRY VARCHAR2 (30)
Primary unit of measure code
UOM_CD_ALT VARCHAR2 (30)
Alternate unit of measure code
CRNCY_CD VARCHAR2 (30)
Currency specified for the retailer organization
ON_HAND_QTY NUMBER

Day End On Hand Quantity in transaction UOM specified
ON_HAND_QTY_PRMRY NUMBER

Day End On Hand Quantity in terms of primary UOM
ON_HAND_QTY_ALT NUMBER

Day End On Hand Quantity in terms of alternate UOM
RECVD_QTY NUMBER

Day End Received Quantity in terms of UOM Specified
RECVD_QTY_PRMRY NUMBER

Day End Received Quantity in terms of primary UOM
RECVD_QTY_ALT NUMBER

Day End Received Quantity in terms of alternative UOM
IN_TRANSIT_QTY NUMBER

Day End In Transition Quantity in terms of transaction UOM specified
IN_TRANSIT_QTY_PRMRY NUMBER

Day End In Transition Quantity in terms of Primary UOM
IN_TRANSIT_QTY_ALT NUMBER

Day End In Transition Quantity in terms of Alternative UOM
BCK_ORDR_QTY NUMBER

Day End Back Order Quantity in transaction UOM specified
BCK_ORDR_QTY_PRMRY NUMBER

Day End Back Order Quantity in terms of primary UOM
BCK_ORDR_QTY_ALT NUMBER

Day End Back Order Quantity in terms of alternative UOM
QLTY_HOLD_QTY NUMBER

Inventory quantity on quality hold in transaction UOM specified
QLTY_HOLD_QTY_PRMRY NUMBER

Inventory quantity on quality hold in terms of primary UOM
QLTY_HOLD_QTY_ALT NUMBER

Inventory quantity on quality hold in terms of alternate UOM
ON_HAND_NET_COST_AMT NUMBER

Retail value of On hand Net Cost Amount in Retailer's Reporting Currency
ON_HAND_NET_COST_AMT_LCL NUMBER

Retail value of On Hand Net Cost Amount in Local Currency (not supported)
ON_HAND_NET_COST_AMT_RPT NUMBER

Retail value of On Hand Net Cost Amount in Reporting Currency
RECVD_NET_COST_AMT NUMBER

Day End Received Net Cost Amount in Retailers Reporting Currency
RECVD_NET_COST_AMT_LCL NUMBER

Day End Received Net Cost Amount in Local Currency (not supported)
RECVD_NET_COST_AMT_RPT NUMBER

Day End Received Net Cost Amount in Reporting Currency
IN_TRANSIT_NET_COST_AMT NUMBER

Day End In Transition Net Cost Amount in Retailers Reporting Currency
IN_TRANSIT_NET_COST_AMT_LCL NUMBER

Day End In Transition Net Cost Amount in Local Currency (not supported)
IN_TRANSIT_NET_COST_AMT_RPT NUMBER

Day End In Transition Net Cost Amount in Reporting Currency
BCKORDR_NET_COST_AMT NUMBER

Day End Back Order Net Cost Amount in Retailers Reporting Currency
BCKORDR_NET_COST_AMT_LCL NUMBER

Day End Back Order Net Cost Amount in Local Currency (not supported)
BCKORDR_NET_COST_AMT_RPT NUMBER

Day End Back Order Net Cost Amount in Reporting Currency
QLTY_HOLD_NET_COST_AMT NUMBER

Inventory quantity on quality hold in Retailers Reporting Currency
QLTY_HOLD_NET_COST_AMT_LCL NUMBER

Inventory quantity on quality hold in Local Currency (not supported)
QLTY_HOLD_NET_COST_AMT_RPT NUMBER

Inventory quantity on quality hold in Reporting Currency
ON_HAND_RTL_AMT NUMBER

Retail value of on hand inventory in retailers reporting currency
ON_HAND_RTL_AMT_LCL NUMBER

Retail value of on hand inventory in local currency (not supported)
ON_HAND_RTL_AMT_RPT NUMBER

Retail value of on hand inventory in reporting currency
RECVD_RTL_AMT NUMBER

Received Retail Amount in Retailers Reporting Currency
RECVD_RTL_AMT_LCL NUMBER

Received Retail Amount in Local Currency (not supported)
RECVD_RTL_AMT_RPT NUMBER

Received Retail Amount in Reporting Currency
IN_TRANSIT_RTL_AMT NUMBER

Day End In Transition Amount in Retailers Reporting Currency that Retailer already paidIn Transit Retailer Amount
IN_TRANSIT_RTL_AMT_LCL NUMBER

Day End In Transition Amount in Local Currency (not supported)
IN_TRANSIT_RTL_AMT_RPT NUMBER

Day End In Transition Amount in Reporting Currency that Retailer already paid
BCKORDR_RTL_AMT NUMBER

Day End Back Order Amount in Retailers Reporting Currency hat Retailer already paid
BCKORDR_RTL_AMT_LCL NUMBER

Day End Back Order Amount in Local Currency (not supported)
BCKORDR_RTL_AMT_RPT NUMBER

Day End Back Order Amount in Reporting Currency hat Retailer already paid
QLTY_HOLD_RTL_AMT NUMBER

Inventory quantity on quality hold in Retailers Reporting Currency that retailer already paid
QLTY_HOLD_RTL_AMT_LCL NUMBER

Inventory quantity on quality hold in Local Currency (not supported)
QLTY_HOLD_RTL_AMT_RPT NUMBER

Inventory quantity on quality hold in Reporting Currency that retailer already paid
SRC_SYS_IDNT VARCHAR2 (40) Yes Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT DATE
Yes The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
LOAD_ID NUMBER
Yes Load ID is required for supporting All or None Mode
ITM_TYP VARCHAR2 (1)
Item Type , whether manufacturer or competitor
MFG_SKU_ITEM_ID NUMBER

Unique Manufacturer Level SKU Item ID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REC_ID
,      TRANS_DT
,      MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      RTL_BSNS_UNIT_CD
,      GLBL_ITEM_ID
,      RTL_SKU_ITEM_ID
,      RTL_SKU_ITEM_NBR
,      DAY_CD
,      GLBL_ITEM_ID_TYP
,      INV_LOC_TYP_CD
,      INV_LOC_ID
,      INV_LOC_CD
,      UOM_CD
,      UOM_CD_PRMRY
,      UOM_CD_ALT
,      CRNCY_CD
,      ON_HAND_QTY
,      ON_HAND_QTY_PRMRY
,      ON_HAND_QTY_ALT
,      RECVD_QTY
,      RECVD_QTY_PRMRY
,      RECVD_QTY_ALT
,      IN_TRANSIT_QTY
,      IN_TRANSIT_QTY_PRMRY
,      IN_TRANSIT_QTY_ALT
,      BCK_ORDR_QTY
,      BCK_ORDR_QTY_PRMRY
,      BCK_ORDR_QTY_ALT
,      QLTY_HOLD_QTY
,      QLTY_HOLD_QTY_PRMRY
,      QLTY_HOLD_QTY_ALT
,      ON_HAND_NET_COST_AMT
,      ON_HAND_NET_COST_AMT_LCL
,      ON_HAND_NET_COST_AMT_RPT
,      RECVD_NET_COST_AMT
,      RECVD_NET_COST_AMT_LCL
,      RECVD_NET_COST_AMT_RPT
,      IN_TRANSIT_NET_COST_AMT
,      IN_TRANSIT_NET_COST_AMT_LCL
,      IN_TRANSIT_NET_COST_AMT_RPT
,      BCKORDR_NET_COST_AMT
,      BCKORDR_NET_COST_AMT_LCL
,      BCKORDR_NET_COST_AMT_RPT
,      QLTY_HOLD_NET_COST_AMT
,      QLTY_HOLD_NET_COST_AMT_LCL
,      QLTY_HOLD_NET_COST_AMT_RPT
,      ON_HAND_RTL_AMT
,      ON_HAND_RTL_AMT_LCL
,      ON_HAND_RTL_AMT_RPT
,      RECVD_RTL_AMT
,      RECVD_RTL_AMT_LCL
,      RECVD_RTL_AMT_RPT
,      IN_TRANSIT_RTL_AMT
,      IN_TRANSIT_RTL_AMT_LCL
,      IN_TRANSIT_RTL_AMT_RPT
,      BCKORDR_RTL_AMT
,      BCKORDR_RTL_AMT_LCL
,      BCKORDR_RTL_AMT_RPT
,      QLTY_HOLD_RTL_AMT
,      QLTY_HOLD_RTL_AMT_LCL
,      QLTY_HOLD_RTL_AMT_RPT
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      LOAD_ID
,      ITM_TYP
,      MFG_SKU_ITEM_ID
FROM DDR.DDR_S_RTL_INV_ITEM;

Dependencies

[top of page]

DDR.DDR_S_RTL_INV_ITEM does not reference any database object

DDR.DDR_S_RTL_INV_ITEM is referenced by following:

SchemaAPPS
SynonymDDR_S_RTL_INV_ITEM