# DW_NS_SALES_ORDER_LINES_INSIGHTS_CF

This fact provides a comprehensive summary view of the execution of sales orders at line level. It offers insights into sales orders line items 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 at line item level.

## Details

Module:

## Key Columns

salesord_lineid, salesord_id, accountingbook

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
salesord_id | NUMBER | 38 | 0 | True |  | DW_NS_SALES_ORDER_LINES_F | transaction
salesord_lineid | NUMBER | 38 | 0 | True |  | DW_NS_SALES_ORDER_LINES_F | id
accountingbook | NUMBER | 38 | 0 | True |  | DW_NS_SALES_ORDER_LINES_F | accountingbook
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 |  |  |  |  |
customer | NUMBER | 38 | 0 |  |  | DW_NS_customer_D | id
trandate | TIMESTAMP |  |  |  |  |  |
closedate | 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
memo | VARCHAR2 | 999 |  |  |  |  |
posting | VARCHAR2 | 16 |  |  |  |  |
postingperiod | NUMBER | 38 | 0 |  |  | DW_NS_accountingPeriod_D | id
createddate | TIMESTAMP |  |  |  |  |  |
createdby | NUMBER | 38 | 0 |  |  | DW_NS_entity_D | id
lastmodifiedby | NUMBER | 38 | 0 |  |  | DW_NS_entity_D | id
linelastmodifieddate | TIMESTAMP |  |  |  |  |  |
transactiondiscount | VARCHAR2 | 16 |  |  |  |  |
itemfulfillmentchoice | NUMBER | 38 | 0 |  |  | DW_NS_fulfillmentChoice_D | key
inventorylocation | NUMBER | 38 | 0 |  |  | DW_NS_location_D | id
inventorysubsidiary | NUMBER | 38 | 0 |  |  | DW_NS_subsidiary_D | id
status | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | code
mainline | VARCHAR2 | 16 |  |  |  |  |
taxline | VARCHAR2 | 16 |  |  |  |  |
dropship | VARCHAR2 | 16 |  |  |  |  |
donotdisplayline | VARCHAR2 | 16 |  |  |  |  |
fulfillable | VARCHAR2 | 16 |  |  |  |  |
item | NUMBER | 38 | 0 |  |  | DW_NS_item_D | id
itemtype | VARCHAR2 | 32 |  |  |  | DW_NS_ITEMTYPE_D | id
quantity | NUMBER |  |  |  |  |  |
quantitycommitted | NUMBER |  |  |  |  |  |
quantityallocated | NUMBER |  |  |  |  |  |
quantityshiprecv | NUMBER |  |  |  |  |  |
quantitybackordered | NUMBER |  |  |  |  |  |
quantityrequestedtofulfill | NUMBER |  |  |  |  |  |
quantitypicked | NUMBER |  |  |  |  |  |
quantitybilled | NUMBER |  |  |  |  |  |
units | NUMBER | 38 | 0 |  |  |  |
expenseaccount | NUMBER | 38 | 0 |  |  | DW_NS_account_D | id
account | NUMBER | 38 | 0 |  |  | DW_NS_account_D | id
currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
rate | NUMBER |  |  |  |  |  |
credit | NUMBER |  |  |  |  |  |
debit | NUMBER |  |  |  |  |  |
creditforeignamount | NUMBER |  |  |  |  |  |
debitforeignamount | NUMBER |  |  |  |  |  |
netamount | NUMBER |  |  |  |  |  |
foreignamount | NUMBER |  |  |  |  |  |
estgrossprofit | NUMBER |  |  |  |  |  |
base_currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
base_exchangerate | NUMBER |  |  |  |  |  |
base_rate | NUMBER |  |  |  |  |  |
is_ratepercent | VARCHAR2 | 16 |  |  |  |  |
base_creditamount | NUMBER |  |  |  |  |  |
base_debitamount | NUMBER |  |  |  |  |  |
base_amount | NUMBER |  |  |  |  |  |
base_netamount | NUMBER |  |  |  |  |  |
base_estgrossprofit | NUMBER |  |  |  |  |  |
accountingbook_currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
accountingbook_exchangerate | NUMBER |  |  |  |  |  |
accountingbook_credit | NUMBER |  |  |  |  |  |
accountingbook_debit | NUMBER |  |  |  |  |  |
accountingbook_amount | NUMBER |  |  |  |  |  |
accountingbook_netamount | NUMBER |  |  |  |  |  |
isclosed | VARCHAR2 | 16 |  |  |  |  |
is_fulfilled | VARCHAR2 | 16 |  |  |  |  |
first_fulfillment_date | TIMESTAMP |  |  |  |  |  |
final_fulfillment_date | TIMESTAMP |  |  |  |  |  |
has_split_fulfillment | VARCHAR2 | 16 |  |  |  |  |
has_intercompany_fulfillment | 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.