DW_CXS_PRODUCT_D

This table contains product

Details

Module:

Key Columns

ORGANIZATION_ID, INVENTORY_ITEM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVENTORY_ITEM_ID NUMBER 38 0 True Inventory Item id
ORGANIZATION_ID NUMBER 38 0 True Organization id
SOURCE_RECORD_ID VARCHAR2 32 This column is for Oracle Internal use only. System generated
PRODUCT_NUMBER VARCHAR2 512 ITEM_NUMBER
INVENTORY_ITEM_STATUS_CODE VARCHAR2 32 Item status Code
PRODUCT_ELIGIBLE_TO_SELL VARCHAR2 16 Enable Flag
CREATION_DATE TIMESTAMP Created date
CREATED_BY VARCHAR2 128 Created By
PRODUCT_ELIGIBLE_TO_SERVICE VARCHAR2 32 Product Eligible to servce
PRODUCT_ENABLE_CUSTOMER_SELF_SERVICE VARCHAR2 16 Product Enable Custome Self service