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
item, transaction, accountingbook
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 |