Hi! All,
IFS 8, when user enters data in Customer Order -- Pre Posting, which table does it save in Oracle?
Thanks!
Best Regards!
Solved
Table name of Customer Order Pre Posting
Best answer by AussieAnders
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,
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,
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.