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_id, salesord_lineid, accountingbook
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 |