This fact stores the sales representative and correspondng Revenue/Non revenue percentage for sales orders
Module: Order Management
SALES_CREDIT_ID
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 |