Hi all,
I simply want to include additional questions raised by previous user.
- How can I find out data from different tabs and their queries?
- How can I find out data from each section of the page? Looks like this page has three different sections.
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.
Userlevel 4
+7
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.