Skip to main content

Hello,

 

We are using IFS Applications 9. I need to generate a report and am wondering where the division and product information of pre-posting is sourced from. Could you please let me know the table or view name that contains this data? Thank you!

 

 

​@agovindarajan this info is defined in finance.

Basically in Finance you have Account and the you have other code parts from B to J that the business could user according to what they wanna track in GL.

So, your code B to J will have it’s own tables/views → CODE_B | CODE_C | …. | CODE_J

 

Now, coming to your question on CO Line preposting, the data comes from the pre_accounting view. You’ll need to join CO Line with Pre_Accounting on pre_accounting_id column.

Hi ​@agovindarajan 

 

Product

 

The Division field is generally associated with the COMPANY table, which stores company-related information, including divisions. In the context of customer orders, this information might also be referenced from the CUSTOMER_ORDER_LINE_TAB view. (This has to be check from the application)

 

Regards,

Chanuka.D

Terms & ConditionsCookie settingsAccessibility statement