Hello,
Is there an IFS data dictionary available for the source tables which tells us the data type, data definition, required fields, etc.?
When writing a query (SQL Query/Query Builder), it would be really helpful to have something to reference.
Thank you!
Question
IFS Data Dictionary for Source Tables
+1
+5Hi
With this query, you can check the data types of the columns of all tables and views in the database and whether they can be empty or not.
select * from all_tab_columns a where a.table_name LIKE '%TABLE OR VIEW NAME%' AND NULLABLE='N'
-- CHECK NULLABLE CLOUMN
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.