Skip to main content

Hi! All,

IFS 8,  when user enters data in Customer Order  --  Pre Posting, which table does it save in Oracle? 

 

Thanks!

Best Regards!

Hi,

You can check “System Info” section on the screen.

CUSTOMER_ORDER

CUSTOMER_ORDER_LINE

 

or

you can write select statement and write down CUST…. and then Press F6 and a list opened at the screen and you can choose one by one and look which table save this data.(PL/SQL Develepor)

Best regards.


It’s PRE_ACCOUNTING_TAB linked by column PRE_ACCOUNTING_ID in both tables.

(You know you’ve worked with IFS for too long when you know tables by heart.)


Hi,

Sorry, I couldnt see “-pre posting” :(


Hi,

You can check “System Info” section on the screen.

CUSTOMER_ORDER

CUSTOMER_ORDER_LINE

 

or

you can write select statement and write down CUST…. and then Press F6 and a list opened at the screen and you can choose one by one and look which table save this data.(PL/SQL Develepor)

Best regards.

 

When I right click on Customer Order Head and select Pre Posting, it pops up a new window. I enter data in this new page. It is not CUSTOMER_ORDER, not CUSTOMER_ORDER_LINE. And can not show view name by click “System” .

I find view name with tool “Debug”.  It is PRE_ACCOUNTING.

Thanks! 

Best Regards!

 


Reply