Tuesday, 24 July 2012

order management tables and its details

This is available in metalink and many internet sites. Since I felt it handy reference, I have reproduced the contents.

Order Management Tables. Entered
oe_order_headers_all 1 record created in header table
oe_order_lines_all Lines for particular records
oe_price_adjustments When discount gets applied
oe_order_price_attribs If line has price attributes then populated
oe_order_holds_all If any hold applied for order like credit check etc.
oe_order_headers_all Booked_flag=Y Order booked.
wsh_delivery_details Released_status Ready to release
Pick Released
wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)
wsh_picking_batches After batch is created for pick release.
mtl_reservations This is only soft reservations. No physical movement of stock
Full Transaction
mtl_material_transactions No records in mtl_material_transactions
wsh_delivery_details Released to warehouse.
wsh_new_deliveries if Auto-Create is Yes then data populated.
wsh_delivery_assignments deliveries get assigned
Pick Confirmed
wsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock
Ship Confirmed
wsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged
mtl_material_transactions On the ship confirm form, check Ship all box
wsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped
oe_order_lines_all Shipped_quantity get populated.
wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
oe_order_headers_all If all the lines get shipped then only flag N
wsh_delivery_details Released_status=I Need to run workflow background process.
ra_interface_lines_all Data will be populated after wkfw process.
ra_customer_trx_all After running Autoinvoice Master Program for
ra_customer_trx_lines_all specific batch transaction tables get populated
Price Details
qp_list_headers_b To Get Item Price Details.
Items On Hand Qty
mtl_onhand_quantities TO check On Hand Qty Items.

Payment Terms
ra_terms Payment terms

AutoMatic Numbering System
ar_system_parametes_all you can chk Automactic Numbering is enabled/disabled.
Customer Information
hz_parties Get Customer information include name,contacts,Address and Phone
Document Sequence
fnd_document_sequences Document Sequence Numbers
Default rules for Price List
oe_def_attr_def_rules Price List Default Rules
End User Details
csi_t_party_details To capture End user Details

Sales Credit Sales Credit Information(How much credit can get)

Attaching Documents
fnd_attached_documents Attched Documents and Text information

Blanket Sales Order
oe_blanket_headers_all Blanket Sales Order Information.

Processing Constraints
oe_pc_assignments Sales order Shipment schedule Processing Constratins
Sales Order Holds
oe_hold_definitions Order Hold and Managing Details.

Hold Relaese
oe_hold_releases_all Hold released Sales Order.

Credit Chk Details
oe_credit_check_rules To get the Credit Check Againt Customer.
Cancel Orders
oe_order_lines_all Cancel Order Details.
Step Order Header Status Order Line Status Order Flow Workflow Status (Order Header) Line Flow Workflow Status (Order Line)
1. Enter an Order Entered Entered Book Order Manual Enter – Line
2. Book the Order Booked Awaiting Shipping Close Order Schedule ->Create Supply ->Ship – Line
3. Pick the Order Booked Picked Close Order Ship – Line
4. Ship the Order Booked Shipped Close Order Fulfill – Deferred
Booked Closed Close Order Fulfill ->Invoice Interface ->Close Line -> End
5. Close the Order Closed Closed End End

No comments:

Post a Comment