DW_OM_SALES_CREDITS_CF

This fact stores the sales representative and correspondng Revenue/Non revenue percentage for sales orders

Details

Module: Order Management

Key Columns

SALES_CREDIT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALES_CREDIT_ID NUMBER 38 0 True Unique identifier of the sales credit    
SOURCE_RECORD_ID VARCHAR2 256     System generated    
HEADER_ID NUMBER 38 0   Reference to the unique identifier for the orchestration order    
SALESPERSON_ID NUMBER 38 0   Sales person identifier DW_PARTY_D PARTY_ID
PERCENT NUMBER       Value to indicate sales credit percent for a sales person    
SALES_CREDIT_TYPE VARCHAR2 256     Sales credit type