Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Sales Analytics >
About the Sales Order Dates
The Order Cycle Time table (IA_SALES_CYCLNS ) store many sales-related dates, which are sourced from the IA_SALES_ORDLNS , IA_SALES_SCHLNS , IA_SALES_PCKLNS , OD_SALES_ORDHLD , and IA_SALES_IVCLNS tables. Table 52 lists all the Sales Order Date columns.
Table 52. Sales Order Date Columns
|
CREATED_ON_DK |
ORDERED_ON_DK |
BOOKED_ON_DK |
ACT_PICK_ON_DK |
ACT_SHIP_ON_DK |
INVOICED_ON_DK |
CLOSED_ON_DK |
PURCH_ORDER_DT |
ORDERED_ON_DT |
REQUIRED_BY_DT |
CUST_REQ_SHIP_DT |
CREATED_ON_DT |
PROMISED_ON_DT |
BOOKED_ON_DT |
ADDNL_BOOKED_ON_DT |
CANCELLED_ON_DT |
CSD_FIRST_PICK_DT |
CSD_LAST_PICK_DT |
CSD_FIRST_PACK_DT |
CSD_LAST_PACK_DT |
CSD_FIRST_LOAD_DT |
CSD_LAST_LOAD_DT |
CSD_FIRST_SHIP_DT |
CSD_LAST_SHIP_DT |
CSD_FIRST_DELV_DT |
CSD_LAST_DELV_DT |
ACT_FIRST_PICK_DT |
ACT_LAST_PICK_DT |
ACT_FIRST_PACK_DT |
ACT_LAST_PACK_DT |
ACT_FIRST_LOAD_DT |
ACT_LAST_LOAD_DT |
ACT_LAST_SHIP_DT |
ACT_FIRST_DELV_DT |
ACT_LAST_DELV_DT |
FIRST_INVOICE_DT |
LAST_INVOICE_DT |
|