DW_NS_SALES_ORDER_INSIGHTS_CF
This fact provides a comprehensive summary view of the execution of sales orders. It offers insights into sales orders and associated flags/metrics derived from corresponding item fulfilments, store pickups, customer invoices, cash sales, and returns. This data will help in the derivation of diverse KPIs including order fulfilment rate, cash sale conversion rate, return rate, and many more.
Details
Module:
Key Columns
salesord_id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| salesord_id | NUMBER | 38 | 0 | True | DW_NS_SALES_ORDER_F | id | |
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. | ||||
| type | VARCHAR2 | 16 | DW_NS_STATUS_D | key | |||
| trandisplayname | VARCHAR2 | 999 | |||||
| typebaseddocumentnumber | VARCHAR2 | 512 | |||||
| trandate | TIMESTAMP | ||||||
| closedate | TIMESTAMP | ||||||
| shipdate | TIMESTAMP | ||||||
| entity | NUMBER | 38 | 0 | DW_NS_entity_D | id | ||
| subsidiary | NUMBER | 38 | 0 | DW_NS_subsidiary_D | id | ||
| class | NUMBER | 38 | 0 | DW_NS_classification_D | id | ||
| department | NUMBER | 38 | 0 | DW_NS_department_D | id | ||
| location | NUMBER | 38 | 0 | DW_NS_location_D | id | ||
| postingperiod | NUMBER | 38 | 0 | DW_NS_accountingPeriod_D | id | ||
| createdby | NUMBER | 38 | 0 | DW_NS_entity_D | id | ||
| lastmodifiedby | NUMBER | 38 | 0 | DW_NS_entity_D | id | ||
| status | VARCHAR2 | 16 | DW_NS_STATUS_D | code | |||
| currency | NUMBER | 38 | 0 | ||||
| base_currency | NUMBER | 38 | 0 | DW_NS_currency_D | id | ||
| base_exchangerate | NUMBER | ||||||
| base_total | NUMBER | ||||||
| base_estgrossprofit | NUMBER | ||||||
| foreigntotal | NUMBER | ||||||
| estgrossprofit | NUMBER | ||||||
| has_quantitybackordered | VARCHAR2 | 16 | |||||
| is_closed | VARCHAR2 | 16 | |||||
| is_fulfilled | VARCHAR2 | 16 | |||||
| first_fulfillment_date | TIMESTAMP | ||||||
| final_fulfillment_date | TIMESTAMP | ||||||
| has_split_fulfillment_lines | VARCHAR2 | 16 | |||||
| has_intercompany_fulfillment_lines | VARCHAR2 | 16 | |||||
| has_itemship | VARCHAR2 | 16 | |||||
| has_multiple_itemship | VARCHAR2 | 16 | |||||
| first_itemship_trandate | TIMESTAMP | ||||||
| latest_itemship_trandate | TIMESTAMP | ||||||
| final_itemship_trandate | TIMESTAMP | ||||||
| has_stpickup | VARCHAR2 | 16 | |||||
| has_multiple_stpickup | VARCHAR2 | 16 | |||||
| first_stpickup_trandate | TIMESTAMP | ||||||
| latest_stpickup_trandate | TIMESTAMP | ||||||
| final_stpickup_trandate | TIMESTAMP | ||||||
| is_billed | VARCHAR2 | 16 | |||||
| first_billing_date | TIMESTAMP | ||||||
| final_billing_date | TIMESTAMP | ||||||
| has_custinvc | VARCHAR2 | 16 | |||||
| has_multiple_custinvc | VARCHAR2 | 16 | |||||
| first_custinvc_trandate | TIMESTAMP | ||||||
| latest_custinvc_trandate | TIMESTAMP | ||||||
| final_custinvc_trandate | TIMESTAMP | ||||||
| has_cashsale | VARCHAR2 | 16 | |||||
| has_multiple_cashsale | VARCHAR2 | 16 | |||||
| first_cashsale_trandate | TIMESTAMP | ||||||
| latest_cashsale_trandate | TIMESTAMP | ||||||
| final_cashsale_trandate | TIMESTAMP | ||||||
| has_rtnauth | VARCHAR2 | 16 | |||||
| has_multiple_rtnauth | VARCHAR2 | 16 | |||||
| first_rtnauth_trandate | TIMESTAMP | ||||||
| latest_rtnauth_trandate | TIMESTAMP |