Which SQL Table/View for Any Form/tabs?

Hi

In IFS Cloud You need to open Debug console. There are tabs Page Info and Server Invoke where You can find views linked to each tab and queries sent to the database as well.

Hi Julian,

if you want a vast list of customer order related views and tables, see below:

We did a BI model with a FACT_Sales containing FACT_CustomerInvoiceLines, FACT_CustomerOrderLines, etc.

The COL has the following ORACLE objects (imported to MS SQL Server with extr_IFS_ präfix)

extr_IFS_CUSTOMER_ORDER_TAB                CO
extr_IFS_CUSTOMER_ORDER_LINE_TAB        COL  -- joined via ORDER_NO
extr_IFS_SHIPMENT_LINE_TAB                SL
extr_IFS_SHIPMENT_TAB                    SP
extr_IFS_CUST_ORDER_LINE_DISCOUNT_TAB    COLDg
extr_IFS_CUST_ORDER_LINE_DISCOUNT_TAB    COLDf
extr_IFS_CUST_ORDER_LINE_DISCOUNT_TAB    COLDv
extr_IFS_CUST_ORDER_LINE_DISCOUNT_TAB    COLDO   
sql_grouped_orderline_disounts

extr_IFS_ORDER_LINE_COMMISSION_TAB        OLCOM
extr_IFS_PAYMENT_TERM_TAB                PT
extr_IFS_PAYMENT_TERM_DISC_TAB            PTDI
extr_IFS_PAYMENT_TERM_DETAILS_TAB        PTDI
FACT_OrderQuotationLines                OQL
DIM_Customer                            C
hlp_Sum_ShipmentLines                    ITH
sql_hlp_SPL_SPF                            FC        -- FreightCharges
 

Just to give you ideas! :-)

All the best

Michael