# DW_NS_NET_SALES_ITEMS_CF

This fact table contains net sales data for items after accounting for returns if any. Sales data is sourced from Sales Orders, Cash Sales and Invoices transactions, while returns data is sourced from Return Authorizations and Cash Refund transactions. Net sales is calculated by subtracting returns from sales.

## Details

Module:

## Key Columns

transaction, item, accountingbook

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
transaction | NUMBER | 38 | 0 | True |  |  |
accountingbook | NUMBER | 38 | 0 | True |  | DW_NS_accountingBook_D | id
item | NUMBER | 38 | 0 | True |  | DW_NS_item_D | id
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. |  |
salesord_id | NUMBER | 38 | 0 |  |  | DW_NS_SALES_ORDER_F | id
custinvc_id | NUMBER | 38 | 0 |  |  | DW_NS_CUSTOMER_INVOICE_F | id
custchrg_id | NUMBER | 38 | 0 |  |  | DW_NS_STATEMENT_CHARGE_F | id
rtnauth_id | NUMBER | 38 | 0 |  |  | DW_NS_RETURN_AUTH_F | id
cashsale_id | NUMBER | 38 | 0 |  |  | DW_NS_CASH_SALE_F | id
cashrfnd_id | NUMBER | 38 | 0 |  |  | DW_NS_CASH_REFUND_F | id
type | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | key
sales_quantity | NUMBER |  |  |  |  |  |
returned_quantity | NUMBER |  |  |  |  |  |
net_sales_quantity | NUMBER |  |  |  |  |  |
is_return_adjusted | VARCHAR2 | 16 |  |  |  |  |
is_primary_accountingbook | VARCHAR2 | 16 |  |  |  |  |
subsidiary | NUMBER | 38 | 0 |  |  | DW_NS_subsidiary_D | id
itemtype | VARCHAR2 | 32 |  |  |  | DW_NS_ITEMTYPE_D | id
class | NUMBER | 38 | 0 |  |  | DW_NS_classification_D | id
location | NUMBER | 38 | 0 |  |  | DW_NS_location_D | id
department | NUMBER | 38 | 0 |  |  | DW_NS_department_D | id
terms | NUMBER | 38 | 0 |  |  | DW_NS_term_D | id
status | VARCHAR2 | 16 |  |  |  | DW_NS_STATUS_D | code
currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
employee | NUMBER | 38 | 0 |  |  | DW_NS_employee_D | id
postingperiod | NUMBER | 38 | 0 |  |  | DW_NS_accountingPeriod_D | id
otherrefnum | VARCHAR2 | 256 |  |  |  |  |
trandate | TIMESTAMP |  |  |  |  |  |
posting | VARCHAR2 | 16 |  |  |  |  |
trandisplayname | VARCHAR2 | 999 |  |  |  |  |
lastmodifiedby | NUMBER | 38 | 0 |  |  | DW_NS_entity_D | id
closedate | TIMESTAMP |  |  |  |  |  |
createdby | NUMBER | 38 | 0 |  |  | DW_NS_entity_D | id
lastmodifieddate | TIMESTAMP |  |  |  |  |  |
shipdate | TIMESTAMP |  |  |  |  |  |
typebaseddocumentnumber | VARCHAR2 | 512 |  |  |  |  |
createddate | TIMESTAMP |  |  |  |  |  |
customer | NUMBER | 38 | 0 |  |  | DW_NS_customer_D | id
base_currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
accountingbook_currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
nextbilldate | TIMESTAMP |  |  |  |  |  |
quantitycommitted | NUMBER |  |  |  |  |  |
estgrossprofit | NUMBER |  |  |  |  |  |
quantitybackordered | NUMBER |  |  |  |  |  |
netamount | NUMBER |  |  |  |  |  |
creditforeignamount | NUMBER |  |  |  |  |  |
debitforeignamount | NUMBER |  |  |  |  |  |
quantitybilled | NUMBER |  |  |  |  |  |
costestimate | NUMBER |  |  |  |  |  |
foreignamount | NUMBER |  |  |  |  |  |
credit | NUMBER |  |  |  |  |  |
debit | NUMBER |  |  |  |  |  |
accountingbook_credit | NUMBER |  |  |  |  |  |
accountingbook_debit | NUMBER |  |  |  |  |  |
accountingbook_amount | NUMBER |  |  |  |  |  |
accountingbook_netamount | NUMBER |  |  |  |  |  |
base_estgrossprofit | NUMBER |  |  |  |  |  |
base_netamount | NUMBER |  |  |  |  |  |
base_amount | NUMBER |  |  |  |  |  |
base_creditamount | NUMBER |  |  |  |  |  |
base_debitamount | NUMBER |  |  |  |  |  |
base_costestimate | NUMBER |  |  |  |  |  |
is_salesorder | VARCHAR2 | 16 |  |  |  |  |
is_cashsales | VARCHAR2 | 16 |  |  |  |  |
is_invoice | VARCHAR2 | 16 |  |  |  |  |
is_stmtcharge | VARCHAR2 | 16 |  |  |  |  |
is_returnauth | VARCHAR2 | 16 |  |  |  |  |
is_cashrefund | VARCHAR2 | 16 |  |  |  |  |
paymentmethod | NUMBER | 38 | 0 |  |  |  |

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