Order Management Technical Document

Order Management

Order Headers

OE_ORDER_HEADERS_ALL

HEADER_ID

ORG_ID

ORDER_NUMBER

ORDER_TYPE_ID OE_TRNSACTION_TYPES_ALL.TRANSACTION_TYPE_ID

ORDER_SOURCE_ID Order Source from OE_ORDER_SOURCES

ORIG_SYS_DOCUMENT_REF Quote Number.Version for Sales & Mkting Quote

OE_ORDER_HEADERS_ALL for OM

SOURCE_DOCUMENT_ID Order Header ID from which order is Copied

PRICE_LIST_ID OE_PRICE_LISTS.PRICE_LIST_ID

ORDERED_DATE

REQUEST_DATE

BOOKED_DATE

TRANSACTIONAL_CURR_CODE

CUSTOMER_PO_NUMBER Mandatory id specified in Transaction Type

PAYMENT_TERM_ID RA_TERMS.TERM_ID

SOLD_TO_ORG_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

SHIP_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID

INVOICE_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID

CANCELLED_FLAG

OPEN_FLAG

BOOKED_FLAG

SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID

ORDER_CATEGORY_CODE ORDER, RETURN, MIXED

FLOW_STATUS_CODE ENTERED, BOOKED, CLOSED, CANCELLED

Order Lines

OE_ORDER_LINES_ALL

LINE_ID

ORIG_SYS_DOCUMENT_REF OE_ORDER_HEADERS_ALL50479

SOURCE_DOCUMENT_ID 50462

ORIG_SYS_LINE_REF OE_ORDER_LINES_ALL59908

SOURCE_DOCUMENT_LINE_ID 59893

HEADER_ID

LINE_TYPE_ID OE_TRNSACTION_TYPES_ALL.TRANSACTION_TYPE_ID

LINE_NUMBER

ORDERED_ITEM MTL_SYSTEM_ITEMS.SEGMENT1

REQUEST_DATE

PROMISE_DATE

SCHEDULE_SHIP_DATE

CANCELLED_QUANTITY

SHIPPED_QUANTITY

ORDERED_QUANTITY

INVOICED_QUANITITY

SHIP_FROM_ORG_ID WAREHOUSE_ID or INVENTORY ORGANIZATION ID

SHIP_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID

INVOICE_TO_ORG_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID

SOLD_TO_ORG_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

PRICE_LIST_ID QP_LIST_HEADERS_B.PRICE_LIST_ID

INVENTORY_ITEM_ID MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID

PAYMENT_TERM_ID RA_TERMS.TERM_ID

UNIT_SELLING_PRICE

UNIT_LIST_PRICE OE_PRICE_LIST_LINES

TAX_VALUE

VISIBLE_DEMAND_FLAG

LINE_CATEGORY_CODE ORDER, RETURN

SOURCE_TYPE_CODE INTERNAL, EXTERNAL

CANCELLED_FLAG

OPEN_FLAG

BOOKED_FLAG

DROP_SHIP_FLAG

SALESREP_ID JTF_RS_SALESREPS.SALESREP_ID

ORDER_SOURCE_ID

FLOW_STATUS_CODE

SPLIT_FROM_LINE_ID

MTL_ONHAND_QUANTITIES

INVENTORY_ITEM_ID

ORGANIZATION_ID

TRANSACTION_QUANTITY

SUBINVENTORY_CODE

Order Price Adjustments & Line Price Adjustments

OE_PRICE_ADJUSTMENTS

This table is used to store price adjustments that have been applied to an order or a line. The column automatic flag indicates if the adjustment was applied automatically or manually. Manual discouts are created with applied_Flag = Y.

Order Sales Credits

OE_SALES_CREDITS

SALES_CREDIT_ID

HEADER_ID

LINE_ID

SALES_CREDIT_TYPE_ID

QUOTA_FLAG

SALESREP_ID

PERCENT

Line Sales Credits

OE_SALES_CREDITS

Order Pricing Attributes

OE_ORDER_PRICE_ATTRIBS

Line Pricing Attributes

OE_ORDER_PRICE_ATTRIBS

Order Adjustment Attributes

OE_PRICE_ADJ_ATTRIBS

Line Adjustment Attributes

OE_PRICE_ADJ_ATTRIBS

Order Adjustment Associations

OE_PRICE_ADJ_ASSOCS

Line Adjustment Associations

OE_PRICE_ADJ_ASSOCS

Lot Serial Numbers

OE_LOT_SERIAL_NUMBERS

Customer Account Site Uses HZ_CUST_SITE_USES_ALL SITE_USE_ID

Customer Account HZ_CUST_ACCOUNTS CUST_ACCOUNT_ID

Party Site HZ_PARTY_SITES PARTY_SITE_ID

Location HZ_LOCATIONS LOCATION_ID

Customer Account Site HZ_CUST_ACCT_SITES_ALL CUST_ACCT_SITE_ID

Organization

Person

Party Relationship

Party HZ_PARTIES PARTY_ID

LOCATION_ID PARTY_ID PARTY_ID PARTY_SITE_ID CUST_ACCOUNT_ID CUST_ACCCT_SITE_ID

Attachments

FND_ATTACHED_DOCUMENTS

ATTACHED_DOCUMENT_ID

DOCUMENT_ID

ENTITY_NAME OE_ORDER_LINES, OE_ORDER_HEADERS

PK1_VALUE LINE_ID, HEADER_ID

AUTOMATICALLY_ADDED_FLAG

SELECT FD.DOCUMENT_ID

,FD.DESCRIPTION

,FD.MEDIA_ID

,FDST.SHORT_TEXT

FROM FND_DOCUMENTS_TL FD

,FND_ATTACHED_DOCUMENTS FAD

,FND_DOCUMENTS_SHORT_TEXT FDST

,OE_ORDER_LINES_ALL OL

WHERE FAD.DOCUMENT_ID = FD.DOCUMENT_ID

AND FDST.MEDIA_ID = FD.MEDIA_ID

AND OL.LINE_ID = FAD.PK1_VALUE

AND OL.LINE_ID = 59851;

Demand:

VISIBLE_DEMAND_FLAG in OE_ORDER_LINES_ALL.

In Order Management Application (Release 11i), Demand Interface is no longer available. Order lines will serve as demand in Order Management Applications. Every line which has the VISIBLE_DEMAND_FLAG = 'Y', will be made available as Demanded to planning. Every line which is Scheduled will be visible to planning as Demanded. So there is no Demand Interface Program, to put the order lines in the demand tables. The table MTL_DEMAND is obsolete. Demand is a process which makes an order line visible to MRP for planning purposes. From Release 11i, Scheduling is an engine owned by MRP. OE_ORDER_LINES will have a flag called VISIBLE_DEMAND_FLAG. If set to 'Yes', the MRP can see the line, if it is set to 'No' the line will just be ignored when performing Planning. When a line is scheduled it becomes visible to MRP, if the VISIBLE_DEMAND_FLAG is set to 'Yes'.

Once the Order is saved, data goes to MTL_SALES_ORDERS table:

MTL_SALES_ORDERS exists for the purpose of mapping sales orders between other applications and Inventory. MTL_SALES_ORDERS is a key flexfield table with no structure defining column or set defining column. The flexfield code for this table is MKTS. Only one structure for the flexfield may be defined for any installation of Inventory. Inventory demand interface and demand manager will validate sales orders on segment values, and will create a new SALES_ORDER_ID when necessary.

MTL_SALES_ORDERS

SALES_ORDER_ID NOT NULL NUMBER

SEGMENT1 VARCHAR2 (40) => ORDER_NUMBER

SEGMENT2 VARCHAR2 (40) => ORDER_TYPE_ID

SEGMENT3 VARCHAR2 (40)

This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).

Shipping:

Pick Release:

WSH_PICKING_BATCHES

The information filled in the Pick Release form is inserted in this table. System creates one batch for the condition you specify in Pick Release Form.

BATCH_ID

CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

ORDER_HEADER_ID

After Pick Release records goes to WSH_DELIVERY_DETAILS for each line, which is picked or backordered. If Autocreate Deliveries is set to set ‘YES’ then record also goes to WHS_NEW_DELIVERIES and WSH_DELIVERY_ASSIGNMENTS but Pick Release is only Reserving the Items against particular Sales Order Line.

WSH_DELIVERY_DETAILS:

DELIVERY_DETAIL_ID

SOURCE_CODE ‘OE’

SOURCE_HEADER_NUMBER Order Number

SOURCE_LINE_NUMBER

SOURCE_HEADER_ID Order Header ID

SOURCE_LINE_ID Order Line ID

SOURCE_HEADER_TYPE_ID Order Type ID

SOURCE_HEADER_TYPE_NAME Order Type Name

CUST_PO_NUMBER Customer PO Number

DELIVER_TO_LOCATION_ID HZ_LOCATIONS.LOCATION_ID

SHIP_TO_LOCATION_ID HZ_LOCATIONS.LOCATION_ID

ORGANIZATION_ID

SHIP_FROM_LOCATION_ID WAREHOUSE_ID

CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

INVENTORY_ITEM_ID & ITEM_DESCRIPTION

REQUESTED_QUANTITY The qty. requested for Pick Release. If the program reserves partial qty. then it splits the Lines in the Order and also inserts two lines in WSH_DELIVERY_DETAILS. The qty. available for reservation will be REQUESTED_QUANTITY for First record and balance qty. will be REQUESTED_QUANTITY for other record.

PICKED_QUANTITY

SHIPPED_QUANTITY After Ship Confirm Shipped qty. is updated

UNIT_PRICE

CURRENCY_CODE

MOVE_ORDER_LINE_ID

SHIP_TO_SITE_USE_ID

INV_INTERFACED_FLAG

SPLIT_FROM_DELIVERY_DETAIL_ID (For Backordered Line)

ORG_ID

CUSTOMER_ITEM_ID

SHIP_METHOD_CODE

RELEASED_STATUS (B=Backordered, C=Shipped, D=Cancelled,

N=Not ready for release, R=Ready to release,

S=Released to Warehouse, X=Not Applicable, Y=Staged)

Reservations:

MTL_RESERVATIONS

This table stores reservation information. Each record is a reservation that ties and item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).

INVENTORY_ITEM_ID

ORGANIZATION_ID

DEMAND_SOURCE_LINE_ID Order Line ID

DEMAND_SOURCE_DELIVERY

RESERVATION_QUANTITY

SUBINVENTORY_CODE

Create Deliveries

After Auto creating the Delivery, records goes to WSH_NEW_DELIVERIES and WSH_DELIVERY_ASSIGNMENTS. If Autocreate Deliveries is set to set ‘YES’ then record goes to both the tables after Pick Release.

WSH_NEW_DELIVERIES: Stores the Delivery Information.

DELIVERY_ID

NAME

STATUS_CODE Delivery shipping status (OP=Open, CL=Closed,

IT= In-Transit)

CUSTOMER_ID

SHIP_METHOD_CODE

DELIVERY_TYPE Type of delivery - STANDARD, CONSOLIDATED

ORGANIZATION_ID

WSH_DELIVERY_ASSIGNMENTS: Link between WSH_DELIVERY_DETAILS & WSH_NEW_DELIVERIES. Assigns delivery details to a delivery and/or a parent delivery detail (LPN).

DELIVERY_ASSIGNMENT_ID

DELIVERY_ID Foreign Key to WSH_NEW_DELIVERIES

DELIVERY_DETAIL_ID Foreign key to WSH_DELIVERY_DETAILS

Ship Confirm

After Ship Confirm, Deliveries gets Closed i.e. STATUS_CODE in WSH_NEW_DELIVERIES changes to ‘CL’ and CONFIRMED_BY field gets updated with Apps User Name. RELEASE_STATUS in WSH_DELIVERY_DETAILS changes to ‘C’. SHIPPED_QUANTITY in WSH_DELIVERY_DETAILS and SHIPPED_QUANTITY in OL_ORDER_LINES_ALL get updated with quantity shipped.

Ship Method

SELECT LOOKUP_CODE,

MEANING,

DESCRIPTION,

START_DATE_ACTIVE,

END_DATE_ACTIVE,

ENABLED_FLAG,

LOOKUP_TYPE

FROM FND_LOOKUP_VALUES_VL

WHERE (nvl('', territory_code) = territory_code or territory_code is null)

and (LOOKUP_TYPE LIKE 'SHIP_METHOD')

and (VIEW_APPLICATION_ID=3)

and (SECURITY_GROUP_ID=0)

order by LOOKUP_CODE

Inventory Interface

Trips:

WSH_TRIPS

TRIP_ID

NAME

PLANNED_FLAG Y if Trip is planned.

STATUS_CODE OP - Open, IT - In -transit, CL - Closed

VEHICLE_ITEM_ID MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID

VEHICLE_NUMBER

CARRIER_ID

SHIP_METHOD_CODE

ROUTE_ID

WSH_TRIP_STOPS

STOP_ID

TRIP_ID

STOP_LOCATION_ID

STATUS_CODE

WSH_DELIVERY_LEGS

DELIVERY_LEG_ID

DELIVERY_ID WSH_NEW_DELIVERIES.DELIVERY_ID

PICK_UP_STOP_ID WSH_TRIP_STOPS.STOP_ID

DROP_OFF_STOP_ID

Rules

WSH_PICKING_RULES

WSH_PICK_GROUPING_RULES

WSH_PICK_SEQUENCE_RULES

Inventory Interface

Inventory Interface puts the Deliveries, which are Closed and Ship Confirmed in MTL_MATERIAL_TRANSACTIONS_TEMP. Records are processed from this table into Inventory through the transaction processor.

MTL_MATERIAL_TRANSACTIONS

TRANSACTION_ID

TRANSACTION_TYPE_ID

TRANSACTION_SOURCE_TYPE_ID

TRANSACTION_ACTION_ID

INVENTORY_ITEM_ID

SUBINVENOTRY_CODE

TRANSACTION_QUANTITY -ve Qty for Sales Order Issue

TRANSACTION_REFERENCE ORDER HEADER ID

SOURCE_LINE_ID ORDER LINE ID

PICKING_LINE_ID DELIVERY_DETAIL_ID

SHIPMENT_NUMBER DELIVERY ID

INVOICED_FLAG

SOURCE_CODE ORDER ENTRY

FREIGH_CODE SHIP METHOD

Receivables Interface & Data flow from Order Management to Receivables RA_INTERFACE_LINES_ALL and RA_INTERFACE_SALESCREDITS_ALL

LINE_TYPE For Sales Order Line ‘LINE’

For Freight Charges ‘FREIGHT’

For Tax ‘TAX’

SALES_ORDER OE_ORDER_HEADERS.ORDER_NUMBER

SALES_ORDER_LINE OE_ORDER_LINES.LINE_NUMBER

PURCHASE_ORDER OE_ORDER_HEADERS.LINES.CUST_PO_NUMBER

INTERFACE_LINE_ATTRIBUTE2 Order Type Name

INTERFACE_LINE_ATTRIBUTE6 OE_ORDER_LINES.LINE_ID

INTERFACE_LINE_ATTRIBUTE10 OE_ORDER_LINES.SHIP_FROM_ORD_ID

INTERFACE_LINE_ATTRIBUTE12 OE_ORDER_LINES.shipment_number

INTERFACE_LINE_ATTRIBUTE13 OE_ORDER_LINES.option_number

INTERFACE_LINE_ATTRIBUTE14 OE_ORDER_LINES.service_number

Service Interface & Data flow from OM to Installed Base

Internal Order:

PO_REQUISITION_HEADERS_ALL

REQUISITION_HEADER_ID

SEGMENT1 Requisition Number

AUTHORIZATION_STATUS APPROVED, IN PROCESS, INCOMPLETE

TYPE_LOOKUP_CODE INTERNAL, PURCHASE

TRANSFERRED_TO_OE_FLAG Y

ORG_ID

PO_REQUISITION_LINES_ALL

REQUISITION_LINE_ID

REQUISITION_HEADER_ID

LINE_NUM

UNIT_PRICE

QUANTITY

ITEM_DESCRIPTION

ITEM_ID

DESTINATION_TYPE_CODE INVENTORY, EXPENSE, SHOP FLOOR

DESTINATION_ORGANIZATION_ID

DESTINATION_SUBINVENTORY

DELIVER_TO_LOCATION_ID Internal Location which is attached to Internal Customer

SOURCE_ORGANIZATION_ID

SOURCE_SUBINVENTORY

SOURCE_TYPE_CODE INVENTORY, VENDOR

NEED_BY_DATE

ORG_ID

Item :

MTL_SYSTEM_ITEMS_B

PURCHASING_ITEM_FLAG

PURCHASING_ENABLED_FLAG

CUSTOMER_ORDER_FLAG

CUSTOMER_ORDER_ENABLED_FLAG

INTERNAL_ORDER_FLAG

INTERNAL_ORDER_ENABLED_FLAG

SHIPPABLE_ITEM_FLAG

INVENTORY_ITEM_FLAG

HR_LOCATIONS_ALL

LOCATION_ID

INVENTORY_ORGANIZATION_ID

PO_LOCATION_ASSOCIATIONS_ALL

LOCATION_ID

CUSTOMER_ID

ADDRESS_ID

SITE_USE_ID

ORGANIZATION_ID

PO_SYSTEM_PARAMETERS_ALL

ORDER_TYPE_ID

ORDER_SOURCE_ID

ORG_ID

OE_ORDER_HEADERS_IFACE_ALL

OE_ORDER_LINES_IFACE_ALL

Drop Shipment:

Purchase Release inserts the records in Requisition Interface tables. Purchase Release picks the records from OE_ORDER_LINES_ALL for Booked order where SOURCE_TYPE_CODE is ‘EXTERNAL’. After running the Requisition Import (this is automatically run by Workflow Background Process for the Purchase Released Orders) record is inserted in OE_DROP_SHIP_SOURCES and PO_REQUISITION_HEADERS_ALL & PO_REQUISITION_LINES_ALL. Requisition Import Submits new request “Create Releases request” which Releases the Purchase Order i.e. putting the records in PO_HEADERS_ALL and PO_LINES_ALL.

INTERFACE_SOURCE_CODE in PO_REQUISITION_HEADERS_ALL refers to ‘ORDER ENTRY’ and INTERFACE_SOURCE_LINE_ID refers to DROP_SHIP_SOURCE_ID in OE_DROP_SHIP_SOURCES. Also PO_HEADER_ID in PO_HEADERS_ALL and PO_LINE_ID in PO_LINES_ALL is stored in OE_DROP_SHIP_SOURCES creating the Purchase Order from Requisitions. Material can be received on the PO after the PO approval. Records do not directly go to Receipt Table (RCV_SHIPMENT_HEADERS & RCV_SHIPMENT_LINE). Once the PO is approved, record goes to Shipment Schedule table (RCV_LINE_LOCATIONS_ALL). The LINE_LOCATION_ID is the Primary key for this table and it is also stored in OE_DROP_SHIP_SOURCES.

After the Receipt of the Material in Logical Organization, 2 records gets inserted in MTL_MATERIAL_TRANSACTIONS. One record is of Receipt of the Material (+ve Qty.) and another record is of Sales Order Issue (-ve entry). The Order line automatically Ship Confirmed after successful receipt of the Material.

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

LINE_ID

HEADER_ID

ORDERED_QUANTITY

INVENTORY_ITEM_ID

LINE_CATEGORY_CODE ORDER

SOURCE_TYPE_CODE EXTERNAL

SCHEDULE_SHIP_DATE

SOLD_FROM_ORG_ID

PO_REQUISITIONS_INTERFACE_ALL

PO_REQUISITION_HEADERS_ALL

REQUISITION_HEADER_ID

SEGMENT1

AUTHORIZATION_STATUS

INTERFACE_SOURCE_CODE ORDER ENTRY

PO_REQUISITION_LINES_ALL

REQUISITION_LINE_ID

REQUISITION_HEADER_ID

ITEM_DESCRIPTION & ITEM_ID

UNIT_PRICE

QUANTITY

SOURCE_TYPE_CODE VENDOR

NEED_BY_DATE

DESTINATION_TYPE_CODE INVENTORY

DESTINATION_ORGANIZATION_ID

VENDOR_ID

VENDOR_SITE_ID

OE_DROP_SHIP_SOURCES

DROP_SHIP_SOURCE_ID

HEADER_ID

LINE_ID

DESTINATION_ORGANIZATION_ID

REQUISITION_HEADER_ID

REQUISITION_LINE_ID

PO_HEADER_ID

PO_LINE_ID

LINE_LOCATION_ID

PO_HEADERS_ALL

PO_HEADER_ID

TYPE_LOOKUP_CODE STANDARD

SEGMENT1

VENDOR_ID

VENDOR_SITE_ID

SHIP_TO_LOCATION_ID

BILL_TO_LOCATION_ID

CURRENCY_CODE

AUTHORIZATION_STATUS

ORG_ID

PO_LINES_ALL

PO_LINE_ID

PO_HEADER_ID

ITEM_ID

ITEM_DESCRIPTION

LIST_PRICE_PER_UNIT

LIST_PRICE

QUANTITY

ORG_ID

PO_LINE_LOCATIONS_ALL

RCV_SHIPMENT_LINES

RCV_TRANSACTIONS

select req_h.segment1 REQUISITION_NUMBER

,oh.header_id

,oh.order_number ORDER_NUMBER

,ol.line_id

,ph.segment1 PO_NUMBER

from po_requisition_headers_all req_h

,po_headers_all ph

,oe_drop_ship_sources od

,oe_order_lines_all ol

,oe_order_headers_all oh

where req_h.interface_source_code = 'ORDER ENTRY'

and req_h.interface_source_line_id = od.drop_ship_source_id

and od.po_header_id = ph.po_header_id

and od.line_id = ol.line_id

and ol.header_id = oh.header_id;

Returns:

MTL_SO_RMA_INTERFACE & MTL_SO_RMA_RECEIPTS tables are obsolete. Once the RMA is booked, material can be received on RMA if OE_ORDER_LINES_ALL.BOOKED_FLAG is ‘Y’ and OE_ORDER_LINES_LINES.FLOW_STATUS_CODE is 'AWAITING_RETURN'. Also the Receipts are stored in table RCV_SHIPMENT_HEADERS & RCV_SHIPMENT_LINES.

OE_ORDER_LINES_ALL

ORDERED_QUANTITY

SOLD_TO_ORG_ID

SHIP_TO_ORG_ID

INVOICE_TO_ORG_ID

INVENTORY_ITEM_ID

PRICE_LIST_ID

LINE_CATEGORY_CODE RETURN

RETURN_CONTEXT INVOICE, ORDER, PO,

RETURN_ATTRIBUTE1

.

.

.

RETURN_ATTRIBUTE15

RETURN_REASON_CODE

REFERENCE_HEADER_ID HEADER_ID, which is being returned

REFERENCE_LINE_ID LINE_ID, which is being returned

REFERENCE_CUSTOMER_TRX_LINE_ID

OE_ORDER_HEADERS_ALL

ORDER_CATEGORY_CODE RETURN, MIXED

RCV_SHIPMENT_HEADERS

SHIPMENT_HEADER_ID

RECEIPT_SOURCE_CODE CUSTOMER

ORGANIZATION_ID

RECEIPT_NUM

CUSTOMER_ID HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

RCV_SHIPMENT_LINES

SHPMENT_LINE_ID

SHIPMENT_HEADER_ID

LINE_NUM

QUANTITY_RECEIVED

UNIT_OF_MEADSURE

ITEM_DESCRIPTION

ITEM_ID OE_ORDER_LINES.INVENTORY_ITEM_ID

SHIPMENT_LINE_STATUS_CODE FULLY RECEIVED, PARTIALLY RECEIVED

SOURCE_DOCUMENT_CODE RMA

DESTINATION_TYPE_CODE INVENTORY

TO_ORGANIZATION_ID OE_ORDER_HEADERS.SHIP_FROM_ORG_ID

TO_SUBINVENTORY

OE_ORDER_HEADER_ID

OE_ORDER_LINE_ID

MTL_MATERIAL_TRANSACTIONS_TEMP

MTL_MATERIAL_TRANSACTIONS

RA_INTERFACE_LINES_ALL

RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_LINES_ALL

ATO Cycle:

BOM_BILL_OF_MATERIALS

BILL_SEQUENCE_ID

ASSEMBLY_ITEM_ID

ORGANIZATION_ID

BOM_INVENTORY_COMPONENTS

COMPONENT_SEQUENCE_ID

OPERATION_SEQUENCE_NUM

COMPONENT_ITEM_ID

COMPONENT_QUANTITY

OPTIONAL 1=Checked, 2=Not Checked

MUTUALLY_EXCLUSIVE_OPTION 1=Checked, 2=Not Checked

BILL_SEQUENCE_ID

OE_ORDER_HEADERS_ALL

ORDER_TYPE_ID

OE_ORDER_LINES_ALL

LINE_ID

HEADER_ID

LINE_TYPE_ID

LINE_NUMBER

ORDERED_QUANTITY

INVENTORY_ITEM_ID

UNIT_SELLING_PRICE

UNIT_LIST_PRICE

TOP_MODEL_LINE_ID LINE_ID of the Model stored for each line including for Model that is same LINE_ID.

(Identifier of configuration top parent line)

LINK_TO_LINE_ID LINE_ID of the CLASS to which the OPTION is linked. For MODEL it is NULL. (Identifier of immediate parent component line)

COMPONENT_SEQUENCE_ID Bill of materials component (option) or bill (top model)

COMPONENT_CODE Identifier of component within an exploded bill

ITEM_TYPE_CODE MODEL, CLASS, OPTION, CONFIG

OPTION_NUMBER Identifier for an option or a class within a model (1,2,3,4..) 0 for CONFIG.

ATO_LINE_ID LINE_ID of the Model stored for each line including for Model that is same LINE_ID.

CONFIG_HEADER_ID System-generated identifier for Oracle Configurator reference

CONFIG_REV_NBR System-generated identifier for Oracle Configurator reference

WSH_DELIVERY_DETAILS (After Import Delivery Lines)

DELIVERY_DETAIL_ID

TOP_MODEL_LINE_ID

ATO_LINE_ID

ITEM_ID ITEM ID of CONFIG Item.

WIP_JOB_SCHEDULE_INTERFACE

WIP_DISCRETE_JOBS

WIP_ENTITY_ID

ORGANIZATION_ID

SOURCE_LINE_ID Order LINE_ID of Item of which Item Type is CONFIG

PRIMARY_ITEM_ID INVENTORY_ITEM_ID of Item in Order of which Item Type is CONFIG

CLASS_CODE Discrete

START_QUANTITY

QUANTITY_COMPLETED

COMMON_BON_SEQENCE_ID Assembly identifier used as bill of material reference for explosions of nonstandard job

BOM_REVISION BOM revision for the primary assembly

COMPLETION_SUBINVENTORY

STATUS_TYPE (Lookup Type = WIP_JOB_STATUS)

1=Unreleased

3=Released

4=Complete

12=Closed

WIP_REQUIREMENT_OPERATIONS

INVENTORY_ITEM_ID

ORGANIZATION_ID

WIP_ENTITY_ID

OPERATION_SEQUENCE_NUM

COMPONENT_SEQUENCE_ID

WIP_SUPPLY_TYPE

REQUIRED_QUANTITY

QUANTITY_ISSUED

QUNTITY_PER_ASSEMBLY

SEGMENT1 ITEM

WIP_MOVE_TRANSACTIONS

TRANSACTION_ID

WIP_ENTITY_ID

PRIMARY_ITEM_ID

TRANSACTION_DATE

TRANSACTION_QUANTITY

WSH_DELIVERY_ASSIGNMENTS

DELIVERY_ASSIGNMENT_ID

DELIVERY_ID

DELIVERY_DETAIL_ID

WSH_NEW_DELIVERIES

DELIVERY_ID

NAME

STATUS_CODE

Pricing:

Qualifiers & Modifiers:

QP_LIST_HEADERS

LIST_HEADER_ID

CURRENCY_CODE

AUTOMATIC_FLAG Y/N

LIST_TYPE_CODE PRO

NAME

DESCRIPTION

ACTIVE_FLAG

QP_LIST_LINES

LIST_LINE_ID

LIST_HEADER_ID

LIST_LINE_TYPE_CODE DIS, FREIGHT_CHARGE, SUR..

MODIFIER_LEVEL_CODE LINE, LINEGROUP, ORDER

ARITHMETIC_OPERATOR %, AMT, LUMPSUM, NEWPRICE, UNIT_PRICE

OPERAND

QP_PRICING_ATTRIBUTES

PRICING_ATTRIBUTE_ID

LIST_LINE_ID

LIST_HEADER_ID

PRODUCT_ATTRIBUTE_CONTEXT ITEM

PRODUCT_ATTRIBUTE

PRODUCT_ATTR_VALUE

QP_QUALIFIERS

QUALIFIER_ID

LIST_HEADER_ID

LIST_LINE_ID

QUALIFIER_CONTEXT

QUALIFIER_ATTRIBUTE

QUALIFIER_ATTR_VALUE

COMPARISON_OPERATOR_CODE

LIST_TYPE_CODE AGR, CHARGES, DTL, PRL, PRO, SLT

Price Lists:

QP_LIST_HEADERS_B

This table stores the header information for all lists. List types can be, for example, Price Lists, Discount.

LIST_HEADER_ID

CURRENCY_CODE

ROUNDING_FACTOR

LIST_TYPE_CODE Price list = PRL, Promotion = PRO

PARENT_LIST_HEADER_ID

ACTIVE_FLAG

QP_LIST_HEADERS_TL

This table stores the translatable columns, name and description of the list, in each of the available languages in the database.

LIST_HEADER_ID

NAME

DESCRIPTION

QP_LIST_LINES

This table stores all list lines for lists in QP_LIST_HEADERS_B.

LIST_LINE_ID

LIST_HEADER_ID

LIST_LINE_TYPE_CODE

LIST_PRICE

LIST_PRICE_UOM_CODE

INVENTORY_ITEM_ID

ORGANIZATION_ID

Customers:

HZ_CUST_ACCOUNTS, HZ_PARTIES (RA_CUSTOMERS)

Addresses

HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS (RA_ADDRESSES_ALL)

Sites

HZ_CUST_SITE_USES_ALL (RA_SITE_USES_ALL)

Interfaces (Import Orders):

The Sales Order has been modeled as a business object that Oracle Order Management owns. The Sales Order business object comprises of several entities, namely, Header, Header Sales Credits, Header Price Adjustments, Header Pricing Attributes, Header Adjustment Attributes, Header Adjustment Associations, Lines, Line Sales Credits, Line Price Adjustments, Line Pricing Attributes, Line Adjustment Attributes, Line Adjustment Associations and Line Lot Serial Numbers.

Order Import can import new, change, and completed sales orders or returns from other applications such as a legacy system. The orders may come from any source such as EDI transactions that are processed by the Oracle e-Commerce Gateway or internal orders created for internal requisitions developed in Oracle Purchasing or returns.

Order Import features include validation and defaulting, processing constraint checks, applying and releasing of order holds, scheduling of shipments, then ultimately inserting, updating or deleting the orders in the base Order Management tables. Order Management checks all the data during the import process to ensure its validity within Order Management. Valid transactions are then converted into orders with lines, reservations, price adjustments, and sales credits in the base Order Management tables.

You can setup your defaulting rules which allow you to default columns in the same way as for orders entered online. You can pass the column value Null to Order Import if you want the defaulting rules to populate the column. However, if the column is defined as Not Null or Mandatory column and the defaulting rules fail to default the column, for any reason, Order Import displays an error message without importing the order.

Import Types:

Configurations

Order Management provides you with the ability to import ATO and PTO configurations.

Changes

You can import changes to orders that have been imported by passing all changed data through Order Import. You can update or delete orders, order lines, price adjustments, and sales credits. You can use change sequence numbers to control the sequence of changes you want to make to orders.

Order Status

You can import new, booked or closed orders. If an order is imported with an entry status of Booked (OE_HEADERS_IFACE_ALL.BOOKED_FLAG=Y) the result after import is that a Action Request of BOOK_ORDER is initiated. You may also pass the Action Request to BOOK_ORDER; both methods are supported.

Workflows

You can import an order within any valid order workflow activity. The order must be at the initial activity of Entered, Booked, or Closed. Orders imported using Order Import cannot be in the middle of a workflow activity.

Manual and Automatic Pricing

Pricing in process order API can be controlled using flag calculate_price_flag on order line record. When set to ‘Y ‘the process order API fetches the list price and applies adjustments and charges. When set to N, the process order API would fetch a list price if the list price is not passed and no adjustments would be applied. When set to P, all the modifiers which are associated with phases having override freeze flag set to Y are applied. That mainly includes freight charges.

Scheduling

Order Import allows you to reserve orders as they are imported, using the same rules as online order entry. If the scheduling request is unsuccessful on an imported order, the order will still be imported, and the scheduling exceptions can be viewed in the Error Messages of the Order Import Corrections window. You can use Schedule, Unschedule, Reserve or Unreserve as values for scheduling actions.

Return Lines

Process order can be used to create and update return lines also. To create a return line, you can either pass in the line category of RETURN on the order line record and the line type would default to the inbound line type of the order type. Alternatively, you can also provide a line type of the type Return on the order line record. Additionally, if you want to specify a reference for the return line, you can pass in the return flexfields (return_context, return_attribute1-2). Column Return_Context can have the following values to determine the reference

type:

Sales Order

Customer PO

Invoice

Serial Number

Process Order Application Open Interface Return_Attribute1... Return_Attribute2 can have the following values depending on the reference type:

1. Sales Order

return_Attribute1: Header ID

return_Attribute2: Line ID

2. Customer PO

return_Attribute1: Header ID

return_Attribute2: Line ID

3. Invoice

return_Attribute1: Invoice Header ID

return_Attribute2: Invoice Line ID

4. Serial Number

return_Attribute1: Inventory Item ID

return_Attribute2: Serial Number

If you wish to import an order as booked, you must set the OPERATION_CODE column

in the actions interface table OE_ACTIONS_IFACE_ALL with a value of "BOOK_ORDER".

Do not use the BOOKED_FLAG column in the OE_HEADERS_IFACE_ALL table. This will

cause the order header to show as booked, but not the order lines. The order

lines will not progress through workflow to the Pick Release/Shipping actions.

OE_CUSTOMER_INFO_IFACE_ALL

OE_HEADERS_IFACE_ALL

Column Name	Required (C = Conditionally Required)	Conditionally Required for Booking
ORIG_SYS_DOCUMENT_REF	REQUIRED
SALESREP_ID or SALESREP		REQUIRED
INVOICING_RULE_ID or INVOICING_RULE		REQUIRED
ACCOUNTING_RULE_ID or ACCOUNTING_RULE		REQUIRED
PAYMENT_TERM_ID or PAYMENT_TERM		REQUIRED for Order Lines not Return lines
AGREEMENT_ID		REQURIED if order type requires
CREATED_BY	REQUIRED
CREATION_DATE	REQUIRED
LAST_UPDATED_BY	REQUIRED
LAST_UPDATE_DATE	REQUIRED
OPERATION_CODE	REQUIRED
ORDER_SOURCE_ID or ORDER_SOURCE	REQUIRED
ORDER_TYPE_ID or ORDER_TYPE	REQUIRED
PRICE_LIST_ID or PRICE_LIST		REQUIRED
CONVERSION_RATE CONVERSION_RATE_DATE		REQUIRED if conversion Type is User
CONVERSION_TYPE_CODE CONVERSION_TYPE		REQUIRED if order Currency is not same as SOB Currency
CUTOMER_PO_NUMBER		REQUIRED if Order Type Requires
TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON	REQUIRED if Tax Exempt flag is Exempt
RETURN_REASON_CODE	Required for returns only
SOLD_FROM_ORG_ID SOLD_FROM_ORG		REQUIRED for Return Lines
SOLD_TO_ORG_ID SOLD_TO_ORG CUSTOMER_NAME		REQUIRED for Order Lines not Return Lines
SHIP_TO_ADDRESS1..4 SHIP_TO_CITY SHIP_TO_COUNTY SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER_NUMBER SHIP_TO_POSTAL_CODE SHIP_TO_PROVINCE SHIP_TO_SITE_INT SHIP_TO_STATE SHIP_TO_COUNTRY		These columns or Ship_to_Org_id should be provided
INVOICE_ADDRESS1..4 INVOICE _TO_CITY INVOICE _TO_COUNTY INVOICE _TO_CUSTOMER INVOICE _TO_CUSTOMER_NUMBER INVOICE _TO_POSTAL_CODE INVOICE _TO_PROVINCE INVOICE _TO_SITE_INT INVOICE _TO_STATE INVOICE _TO_COUNTRY		These columns or Invoice_To_Org_id should be

OE_LINES_IFACE_ALL

Column Name	Required (C = Conditionally Required)	Conditionally Required for Booking
ORDER_SOURCE_ID	REQUIRED
ORIG_SYS_DOCUMENT_REF	REQUIRED
ORIG_SYS_LINE_REF	REQUIRED
ORIG_SYS_SHIPMENT_REF	REQUIRED
INVENTORY_ITEM_ID or INVENTORY_ITEM	REQUIRED
TOP_MODEL_LINE_REF	Required for model items only
LINK_TO_LINE_REF	Required for model items only
REQUEST_DATE	REQUIRED
DELIVERY_LEAD_TIME	REQUIRED
DELIVERY_ID	REQUIRED
ORDERED_QUANTITY	REQUIRED
ORDER_QUANTITY_UOM	REQUIRED
SHIPPING_QUANTITY	REQUIRED
SHIPPING_QUANTITY_ UOM	REQUIRED
PRICING_QUANTITY	REQUIRED
PRICING_QUANTITY_ UOM	REQUIRED
SOLD_FROM_ORG_ID SOLD_FROM_ORG		REQUIRED for Retunr Lines only
SOLD_TO_ORG_ID SOLD_TO_ORG		REQUIRED for Order lines
SHIP_TO_ADDRESS1..4 SHIP_TO_CITY SHIP_TO_COUNTY SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER_NUMBER SHIP_TO_POSTAL_CODE SHIP_TO_PROVINCE SHIP_TO_SITE_INT SHIP_TO_STATE SHIP_TO_COUNTRY		These columns or Ship_to_Org_id should be provided
INVOICE_ADDRESS1..4 INVOICE _TO_CITY INVOICE _TO_COUNTY INVOICE _TO_CUSTOMER INVOICE _TO_CUSTOMER_NUMBER INVOICE _TO_POSTAL_CODE INVOICE _TO_PROVINCE INVOICE _TO_SITE_INT INVOICE _TO_STATE INVOICE _TO_COUNTRY		These columns or Invoice_To_Org_id should be
PRICE_LIST_ID or PRICE_LIST		REQUIRED
INVOICING_RULE_ID or INVOICING_RULE		REQUIRED
ACCOUNTING_RULE_ID or ACCOUNTING_RULE		REQUIRED
PAYMENT_TERM_ID or PAYMENT_TERM		REQUIRED for Order lines not for Return Lines
RETURN_REASON_CODE	Required for returns only
REFERENCE_TYPE	REQUIRED
REFERENCE_HEADER_ID or REFERENCE_HEADER	REQUIRED
REFERENCE_LINE_ID or REFERENCE_LINE	REQUIRED
SERVICE_DURATION		Should be populated only for service items
SERVICE_START_DATE	Should be populated only for service items
SERVICE_END_DATE	Should be populated only for service items
SERVICE_COTERMINATE_ FLAG	Should be populated only for service items
REQUEST_ID	REQUIRED
CREATED_BY	REQUIRED
CREATION_DATE	REQUIRED
LAST_UPDATED_BY	REQUIRED
LAST_UPDATE_DATE	REQUIRED

OE_PRICE_ADJS_IFACE_ALL

CREATED_BY	REQUIRED
CREATION_DATE	REQUIRED
LAST_UPDATED_BY	REQUIRED
LAST_UPDATE_DATE	REQUIRED
OPERATION_CODE	REQUIRED
ORIG_SYS_DOCUMENT_REF	REQUIRED
ORIG_SYS_LINE_REF	REQUIRED
ORIG_SYS_SHIPMENT_REF	REQUIRED
PRICE_ADJUSTMENT_ID	REQUIRED for Update and Delete
LIST_HEADER_ID	Only for Tax Records
LIST_LINE_ID	Only for Tax Records

OE_PRICE_ATTRS_IFACE_ALL

CREATED_BY	REQUIRED
CREATION_DATE	REQUIRED
LAST_UPDATED_BY	REQUIRED
LAST_UPDATE_DATE	REQUIRED
OPERATION_CODE	REQUIRED
ORIG_SYS_DOCUMENT_REF	REQUIRED
ORIG_SYS_LINE_REF	REQUIRED
ORIG_SYS_SHIPMENT_REF	REQUIRED

OE_CREDITS_IFACE_ALL

PERCENT	REQUIRED
SALES_CREDIT_TYPE_ID or SALES_CREDIT_TYPE	REQUIRED
OPERATION_CODE	REQUIRED
ORIG_SYS_DOCUMENT_REF	REQUIRED
ORIG_SYS_LINE_REF	REQUIRED
ORIG_SYS_SHIPMENT_REF	REQUIRED
ORIG_SYS_CREDIT_REF	REQUIRED

OE_LOTSERIALS_IFACE_ALL

ORDER_SOURCE_ID	REQUIRED
ORIG_SYS_DOCUMENT_REF	REQUIRED
ORIG_SYS_LINE_REF	REQUIRED
ORIG_SYS_SHIPMENT_REF	REQUIRED
ORIG_SYS_LOTSERIAL_ REF	REQUIRED
LOT_NUMBER	C
FROM_SERIAL_NUMBER	C
TO_SERIAL_NUMBER	C
QUANTITY	REQUIRED
CREATED_BY	REQUIRED
CREATION_DATE	REQUIRED
LAST_UPDATED_BY	REQUIRED
LAST_UPDATE_DATE	REQUIRED
LAST_UPDATE_LOGIN	REQUIRED
OPERATION_CODE	REQUIRED

OE_RESERVTNS_IFACE_ALL

ORDER_SOURCE_ID	REQUIRED
ORIG_SYS_DOCUMENT_REF	REQUIRED
ORIG_SYS_LINE_REF	REQUIRED
ORIG_SYS_SHIPMENT_REF	REQUIRED
ORIG_SYS_RESERVATION_REF	REQUIRED
INVENTORY_ITEM_ID	REQUIRED
SUBINVENTORY_ID	REQUIRED
QUANTITY	REQUIRED
OPERATION_CODE	REQUIRED

OE_ACTIONS_IFACE_ALL

ORIG_SYS_DOCUMENT_REF	REQUIRED
OPERATION_CODE	REQUIRED

Setups

Transaction Types

OE_TRANSACTION_TYPES_ALL

OE_TRANSACTION_TYPES_TL

This is a mult-lingual table for OE_TRANSACTION_TYPES_ALL table

SELECT OH.ORDER_NUMBER,OTTA.ORDER_CATEGORY_CODE,OTTA.ORG_ID,OTTL.NAME

FROM OE_ORDER_HEADERS_ALL OH

,OE_TRANSACTION_TYPES_ALL OTTA

,OE_TRANSACTION_TYPES_TL OTTL

WHERE OH.ORDER_TYPE_ID = OTTA.TRANSACTION_TYPE_ID

AND OTTA.TRANSACTION_TYPE_ID = OTTL.TRANSACTION_TYPE_ID

AND order_number = 1130100008;

OE_WORKFLOW_ASSIGNMENTS

This table associates assignments to order types and line types.

ORDER_TYPE_ID

LINE_TYPE_ID

PROCESS_NAME

ASSIGNMENT_ID

Document Sequence

For Document Sequence record stores in FND_DOCUMENT_SEQUENCES. After creating the Transaction Type, automatically the Document Category gets created and record goes to table FND_DOCUMENT_CATEGORIES.

FND_DOCUMENT_SEQUENCES

DOCUMENT_SEQUENCE_ID

NAME

INITIAL_VALUE

TABLE_NAME OE_TRANSACTION_TYPES_ALL

FND_DOCUMENT_CATEGORIES

APPLICATION_ID

CODE

NAME TRANSACTION TYPE NAME

DESCRIPTION

TABLE_NAME OE_TRANSACTION_TYPES_ALL

FND_DOCUMENT_CATEGORIES

DOC_SEQUENCE_ASSIGNMENT_ID

APPLICATION_ID

DOCUMENT_SEQUENCE_ID

CATEGORY_ID

SET_OF_BOOKS_ID

Order Import Sources

OE_ORDER_SOURCES

ORDER_SOURCE_ID

NAME

DESCRIPTION

ENABLED_FLAG

Payment terms

RA_TERMS

TERM_ID

NAME

DESCRIPTION

BASE_AMOUNT

RA_TERMS_LINES

TERM_ID

SEQUENCE_NUM

RELATIVE_AMOUNT

DUE_DAYS

Holds

OE_ORDER_HOLDS_ALL

This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.

HOLD_SOURCE_ID

HEADER_ID

LINE_ID

ORG_ID

RELEASED_FLAG

OE_HOLD_AUTHORIZATIONS

Stores information about who has the authority to apply and release holds.– Retrofitted

OE_HOLD_DEFINITIONS

This table stores information about hold name and its validity period.

OE_HOLD_RELEASES

This tables stores information about all the holds that has been released.

Lookups

FND_LOOKUP_VALUES Quick Code values

LOOKUP_TYPE

LOOKUP_CODE

MEANING

DESCRIPTION

Sales Person

JTF_RS_SALESREPS (RA_SALESREPS_ALL)

Territories

RA_TERRITORIES

TERRITORY_ID

NAME

DESCRIPTION

SEGMENT1

SEGMENT2

.

.

.

SEGEMNT20

REGION_ID

Sales Credit Types

SELECT CR.SALES_CREDIT_ID

,SREP.NAME

,CR_TYPE.NAME

,CR.PERCENT

FROM OE_SALES_CREDITS CR

,JTF_RS_SALESREPS SREP

,OE_ORDER_HEADERS_ALL OH

,OE_SALES_CREDIT_TYPES CR_TYPE

WHERE CR.SALESREP_ID = SREP.SALESREP_ID

AND CR.HEADER_ID = OH.HEADER_ID

AND OH.ORG_ID = SREP.ORG_ID

AND CR_TYPE.SALES_CREDIT_TYPE_ID = CR.SALES_CREDIT_TYPE_ID

AND OH.ORDER_NUMBER = 1130100005;

Profiles

Credit Check Rules

OE_CREDIT_CHECK_RULES This table stores information about the credit check rules.

PO_DISTRIBUTIONS_ALL Purchase order distributions

PO_HEADERS_ALL Document headers (for purchase orders, purchase agreements, quotations, RFQs)

PO_INTERFACE_ERRORS Requisition import interface errors

PO_LINES_ALL Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)

PO_LINE_LOCATIONS_ALL Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)

PO_REQUISITIONS_INTERFACE_ALL Requisition Import interface table

PO_REQUISITION_HEADERS_ALL Requisition headers

PO_REQUISITION_LINES_ALL Requisition lines

PO_REQ_DISTRIBUTIONS_ALL Requisition distributions

Pricing

QP_ATTRIBUTE_DEFNS QP_ATTRIBUTE_DEFNS is the table on which the Qualifier

and Pricing Attribute Descriptive Flexfields are based. It is used for the entity and attribute definiton in attribute sourcing.

QP_COUPONS QP_COUPONS stores any Coupons which have been issued.

QP_EVENT_PHASES QP_EVENT_PHASES stores the mapping between pricing events and pricing phases.

QP_LIST_HEADERS_B QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount

QP_LIST_HEADERS_TL QP_LIST_HEADERS_TL stores the translatable columns, name and description of the list, in each of the available languages in the database.

QP_LIST_LINES QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. QP_PRICE_FORMULAS_B QP_PRICE_FORMULAS_B stores the pricing formula header information.

QP_PRICE_FORMULAS_TL This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database.

QP_PRICE_FORMULA_LINES QP_PRICE_FORMULA_LINES stores each component that makes up the formula.

QP_PRICE_REQ_SOURCES QP_PRICE_REQ_SOURCES stores the mapping between Pricing Request Types and Source Systems.

QP_PRICING_ATTRIBUTES QP_PRICING_ATTRIBUTES stores product information and pricing attributes.

QP_PRICING_PHASES QP_PRICING_PHASES stores all pricing phases.

QP_QUALIFIERS QP_QUALIFIERS stores qualifier attribute information.

QP_QUALIFIER_RULES QP_QUALIFIER_RULES stores the header information for all qualifier rules

QP_RLTD_MODIFIERS QP_RLTD_MODIFIERS stores the relationship between modifier lines. QP_UPGRADE_ERRORS QP_UPGRADE_ERRORS holds details of the errors which occured in upgrading pricing data.