Data Structure of Oracle Order Entry

Data Structure of  Oracle Order Entry

So_headers_all

: Orders, Returns > Orders, Returns

This table stores the orders and returns information.

The s1 to s30 and s1_date to s30_date relates to the order cycle status.

Some columns of interest includes :

·         Order_category (I, P. S, R, RMA)

·         Order_number

·         Purchase_order_num

·         Original_system_source_code (for imported orders from an external source)

·         Original_system_reference (for imported orders from an external source)

·         Order_type_id (link to so_order_types_all for order type)

·         Date_ordered

·         S1 to s30

·         S1_date to s30_date

So_lines_all

: Orders, Returns > Orders, Returns

This table stores the orders and returns line information.

The s1 to s30 and s1_date to s30_date relates to the order line cycle status.

Some columns of interest includes :

·         Line_type_code (DETAIL, PARENT, REGULAR, RETURN)

·         Ordered_quantity

·         Cancelled_quantity

·         Selling_price

·         Price_list_id (links to so_price_lists for price list)

·         Schedule_date

·         Promise_date

So_line_details

: Orders, Returns > Orders, Returns

This table stores order scheduling information.

Some columns of interest includes :

·         Released_flag

·         Quantity

·         Schedule_date

·         Delivery (link to mtl_demand for reservation details)

So_picking_batches_all

: Shipping > Release Sales Orders or Shipping > Release Sales Orders, SRS

This table stores the batch of orders that have been pick released.

The header_count column indicates the number of picking headers are contained in a picking batch.

So_picking_headers_all

: Shipping > Release Sales Orders or Shipping > Release Sales Orders, SRS

This table stores the picking headers within a picking batch.

Some columns of interest includes :

·         Status_code (BACKORDERED, BACKORDER RELEASE, CLOSED, OPEN, PENDING, IN PROGRESS)

·         Pick_slip_number

·         Picked_by (link to per_people_f for picked by user)

·         Date_released

·         Date_confirmed

·         Date_shipped

So_picking_lines_all

: Shipping > Release Sales Orders or Shipping > Release Sales Orders, SRS

This table stores the picking lines for a picking header. 

Some columns of interest includes :

·         Requested_quantity

·         shipped_quantity

·         Date_requested

·         Cancelled_quantity

So_picking_line_details

: Shipping > Release Sales Orders or Shipping > Release Sales Orders, SRS

This table stores the location for the picking lines that have been reserved.

Some columns of interest includes :

·         Requested_quantity

·         Serial_number

Wsh_departure

: Shipping > Departure Planning> Departure Planning or Shipping > Departure Planning > New Departures

This table stores departure information for departure planning.

Some columns of interest includes :

·         Name

·         Planned_departure_date

·         Actual_depature_date

Wsh_delivery

: Shipping > Departure Planning> Departure Planning or Shipping > Departure Planning > New Deliveries

This table stores delivery information within a departure.

 Some columns of interest includes :

·         Name

·         Planned_departure_date

·         Actual_depature_date

·         Waybill