Table level Data flow for Order to Cash Flow


In this blog I have highlight some of the KEY tables involved in Order to Cash table. There are lot of database table involves in this flow , but I have highlighted the key table and link between these tables.It help the consultant while desiging the reports &queries.


These tables are

1. OE_ORDER_HEADERS_ALL

2. OE_ORDER_LINES_ALL

3. WSH_DELIVERY_DETAILS

4. WSH_DELIVERY_ASSIGNMENTS

5. WSH_NEW-DELIVERIES

6. WSH_DELIVERY_LEGS

7. WSH_TRIP_STOPS

8. WSH_TRIPS

9. M TL_TRX_REQUEST_LINES

10. MTL_MATERIAL_TRANSACTION_TEMP

11. OE_SETS

12. OE_LINE_SETS

13. O_LINES_ALL

14. MTL_RESERVATIONS

15. MTL_MATERIAL_TRANSACTIONS_ALL
[OrdertoCash.bmp]

Advertisements

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s