# 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

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 |  |  |  |  |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.