Order Management Technical

Order Management Order Headers OE_ORDER_HEADERS_ALL HEADER_ID ORG_ID ORDER_NUMBER ORDER_TYPE_ID ORDER_SOURCE_ID ORIG_SYS_DOCUMENT_REF SOURCE_DOCUMENT_ID PRICE_LIST_ID ORDERED_DATE REQUEST_DATE BOOKED_DATE TRANSACTIONAL_CURR_CODE CUSTOMER_PO_NUMBER PAYMENT_TERM_ID SOLD_TO_ORG_ID SHIP_TO_ORG_ID INVOICE_TO_ORG_ID CANCELLED_FLAG OPEN_FLAG BOOKED_FLAG SALESREP_ID ORDER_CATEGORY_CODE FLOW_STATUS_CODE

OE_TRNSACTION_TYPES_ALL.TRANSACTION_TYPE_ID Order Source from OE_ORDER_SOURCES Quote Number.Version for Sales & Mkting Quote OE_ORDER_HEADERS_ALL for OM Order Header ID from which order is Copied OE_PRICE_LISTS.PRICE_LIST_ID

Mandatory id specified in Transaction Type RA_TERMS.TERM_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID

JTF_RS_SALESREPS.SALESREP_ID ORDER, RETURN, MIXED ENTERED, BOOKED, CLOSED, CANCELLED

Order Lines OE_ORDER_LINES_ALL LINE_ID ORIG_SYS_DOCUMENT_REF SOURCE_DOCUMENT_ID ORIG_SYS_LINE_REF SOURCE_DOCUMENT_LINE_ID HEADER_ID LINE_TYPE_ID LINE_NUMBER ORDERED_ITEM REQUEST_DATE PROMISE_DATE SCHEDULE_SHIP_DATE CANCELLED_QUANTITY SHIPPED_QUANTITY ORDERED_QUANTITY INVOICED_QUANITITY SHIP_FROM_ORG_ID SHIP_TO_ORG_ID INVOICE_TO_ORG_ID SOLD_TO_ORG_ID PRICE_LIST_ID INVENTORY_ITEM_ID PAYMENT_TERM_ID UNIT_SELLING_PRICE

OE_ORDER_HEADERS_ALL50479 50462 OE_ORDER_LINES_ALL59908 59893 OE_TRNSACTION_TYPES_ALL.TRANSACTION_TYPE_ID MTL_SYSTEM_ITEMS.SEGMENT1

WAREHOUSE_ID or INVENTORY ORGANIZATION ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID HZ_CUST_SITE_USES_ALL.SITE_USE_ID CUSTOMER_ID or HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID QP_LIST_HEADERS_B.PRICE_LIST_ID MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID RA_TERMS.TERM_ID

UNIT_LIST_PRICE TAX_VALUE VISIBLE_DEMAND_FLAG LINE_CATEGORY_CODE SOURCE_TYPE_CODE CANCELLED_FLAG OPEN_FLAG BOOKED_FLAG DROP_SHIP_FLAG SALESREP_ID ORDER_SOURCE_ID FLOW_STATUS_CODE SPLIT_FROM_LINE_ID

OE_PRICE_LIST_LINES ORDER, RETURN INTERNAL, EXTERNAL

JTF_RS_SALESREPS.SALESREP_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 Location HZ_LOCATIONS

LOCATION_ID

Party

Party Site

HZ_PARTY_SITES PARTY_ID PARTY_SITE_ID

LOCATION_ID Party Relationship

Person

Organization

HZ_PARTIES

PARTY_ID

PARTY_ID RA_CUSTOMERS Customer Account HZ_CUST_ACCOUNTS

CUST_ACCOUNT_ID

PARTY_SITE_ID

CUST_ACCOUNT_ID Customer Account Site HZ_CUST_ACCT_SITES_ALL

CUST_ACCT_SITE_ID

RA_SITE_USES_AL CUST_ACCCT_SITE_ID

Customer Account Site Uses HZ_CUST_SITE_USES_ALL

SITE_USE_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

PICKED_QUANTITY SHIPPED_QUANTITY UNIT_PRICE CURRENCY_CODE

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. After Ship Confirm Shipped qty. is updated

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 DEMAND_SOURCE_DELIVERY RESERVATION_QUANTITY SUBINVENTORY_CODE

Order Line ID

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 CUSTOMER_ID SHIP_METHOD_CODE DELIVERY_TYPE ORGANIZATION_ID

Delivery shipping status (OP=Open, CL=Closed, IT= In-Transit) Type of delivery - STANDARD, CONSOLIDATED

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 STATUS_CODE VEHICLE_ITEM_ID VEHICLE_NUMBER CARRIER_ID SHIP_METHOD_CODE ROUTE_ID WSH_TRIP_STOPS STOP_ID TRIP_ID

Y if Trip is planned. OP - Open, IT - In -transit, CL - Closed MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID

STOP_LOCATION_ID STATUS_CODE WSH_DELIVERY_LEGS DELIVERY_LEG_ID DELIVERY_ID PICK_UP_STOP_ID DROP_OFF_STOP_ID

WSH_NEW_DELIVERIES.DELIVERY_ID WSH_TRIP_STOPS.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 FREIGHT_CODE SHIP METHOD

Receivables Interface & Data flow from Order Management to Receivables RA_INTERFACE_LINES_ALL and RA_INTERFACE_SALESCREDITS_ALL LINE_TYPE SALES_ORDER SALES_ORDER_LINE PURCHASE_ORDER

For Sales Order Line ‘LINE’ For Freight Charges ‘FREIGHT’ For Tax ‘TAX’ OE_ORDER_HEADERS.ORDER_NUMBER OE_ORDER_LINES.LINE_NUMBER OE_ORDER_HEADERS.LINES.CUST_PO_NUMBER

INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE14

Order Type Name OE_ORDER_LINES.LINE_ID OE_ORDER_LINES.SHIP_FROM_ORD_ID OE_ORDER_LINES.shipment_number OE_ORDER_LINES.option_number OE_ORDER_LINES.service_number

Service Interface & Data flow from OM to Installed Base

Internal Order: PO_REQUISITION_HEADERS_ALL REQUISITION_HEADER_ID SEGMENT1 AUTHORIZATION_STATUS TYPE_LOOKUP_CODE TRANSFERRED_TO_OE_FLAG ORG_ID PO_REQUISITION_LINES_ALL REQUISITION_LINE_ID REQUISITION_HEADER_ID LINE_NUM UNIT_PRICE QUANTITY ITEM_DESCRIPTION ITEM_ID DESTINATION_TYPE_CODE DESTINATION_ORGANIZATION_ID DESTINATION_SUBINVENTORY DELIVER_TO_LOCATION_ID SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY SOURCE_TYPE_CODE 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

Requisition Number APPROVED, IN PROCESS, INCOMPLETE INTERNAL, PURCHASE Y

INVENTORY, EXPENSE, SHOP FLOOR Internal Location which is attached to Internal Customer INVENTORY, VENDOR

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 SOURCE_TYPE_CODE SCHEDULE_SHIP_DATE SOLD_FROM_ORG_ID PO_REQUISITIONS_INTERFACE_ALL PO_REQUISITION_HEADERS_ALL REQUISITION_HEADER_ID SEGMENT1 AUTHORIZATION_STATUS INTERFACE_SOURCE_CODE PO_REQUISITION_LINES_ALL REQUISITION_LINE_ID REQUISITION_HEADER_ID ITEM_DESCRIPTION & ITEM_ID UNIT_PRICE QUANTITY SOURCE_TYPE_CODE NEED_BY_DATE

ORDER EXTERNAL

ORDER ENTRY

VENDOR

DESTINATION_TYPE_CODE 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 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

INVENTORY

STANDARD

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 RCV_SHIPMENT_HEADERS SHIPMENT_HEADER_ID RECEIPT_SOURCE_CODE ORGANIZATION_ID RECEIPT_NUM CUSTOMER_ID

RETURN, MIXED

CUSTOMER

RCV_SHIPMENT_LINES SHPMENT_LINE_ID SHIPMENT_HEADER_ID LINE_NUM QUANTITY_RECEIVED UNIT_OF_MEASURE ITEM_DESCRIPTION ITEM_ID SHIPMENT_LINE_STATUS_CODE SOURCE_DOCUMENT_CODE DESTINATION_TYPE_CODE TO_ORGANIZATION_ID TO_SUBINVENTORY OE_ORDER_HEADER_ID OE_ORDER_LINE_ID

HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

MTL_MATERIAL_TRANSACTIONS_TEMP MTL_MATERIAL_TRANSACTIONS

OE_ORDER_LINES.INVENTORY_ITEM_ID FULLY RECEIVED, PARTIALLY RECEIVED RMA INVENTORY OE_ORDER_HEADERS.SHIP_FROM_ORG_ID

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 MUTUALLY_EXCLUSIVE_OPTION BILL_SEQUENCE_ID

1=Checked, 2=Not Checked 1=Checked, 2=Not Checked

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

LINK_TO_LINE_ID

COMPONENT_SEQUENCE_ID COMPONENT_CODE ITEM_TYPE_CODE OPTION_NUMBER ATO_LINE_ID CONFIG_HEADER_ID CONFIG_REV_NBR

LINE_ID of the Model stored for each line including for Model that is same LINE_ID. (Identifier of configuration top parent line) LINE_ID of the CLASS to which the OPTION is linked. For MODEL it is NULL. (Identifier of immediate parent component line) Bill of materials component (option) or bill (top model) Identifier of component within an exploded bill MODEL, CLASS, OPTION, CONFIG Identifier for an option or a class within a model (1,2,3,4..) 0 for CONFIG. LINE_ID of the Model stored for each line including for Model that is same LINE_ID. System-generated identifier for Oracle Configurator reference 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 PRIMARY_ITEM_ID CLASS_CODE START_QUANTITY QUANTITY_COMPLETED COMMON_BON_SEQENCE_ID BOM_REVISION COMPLETION_SUBINVENTORY STATUS_TYPE

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 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

Order LINE_ID of Item of which Item Type is CONFIG INVENTORY_ITEM_ID of Item in Order of which Item Type is CONFIG Discrete Assembly identifier used as bill of material reference for explosions of nonstandard job BOM revision for the primary assembly (Lookup Type = WIP_JOB_STATUS) 1=Unreleased 3=Released 4=Complete 12=Closed

ITEM

Pricing: Qualifiers & Modifiers: QP_LIST_HEADERS LIST_HEADER_ID CURRENCY_CODE AUTOMATIC_FLAG LIST_TYPE_CODE NAME DESCRIPTION ACTIVE_FLAG QP_LIST_LINES LIST_LINE_ID LIST_HEADER_ID LIST_LINE_TYPE_CODE MODIFIER_LEVEL_CODE ARITHMETIC_OPERATOR OPERAND QP_PRICING_ATTRIBUTES PRICING_ATTRIBUTE_ID LIST_LINE_ID LIST_HEADER_ID PRODUCT_ATTRIBUTE_CONTEXT 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

Y/N PRO

DIS, FREIGHT_CHARGE, SUR.. LINE, LINEGROUP, ORDER %, AMT, LUMPSUM, NEWPRICE, UNIT_PRICE

ITEM

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 ORIG_SYS_DOCUMENT_RE F SALESREP_ID or SALESREP INVOICING_RULE_ID or INVOICING_RULE ACCOUNTING_RULE_ID or ACCOUNTING_RULE PAYMENT_TERM_ID or PAYMENT_TERM AGREEMENT_ID

Required (C = Conditionally Required) REQUIRED

REQUIRED REQUIRED REQUIRED REQUIRED for Order Lines not Return lines 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 ORDER_TYPE_ID or ORDER_TYPE PRICE_LIST_ID or PRICE_LIST CONVERSION_RATE CONVERSION_RATE_DATE

REQUIRED

CONVERSION_TYPE_CODE CONVERSION_TYPE

Conditionally Required for Booking

REQUIRED REQUIRED REQUIRED if conversion Type is User REQUIRED if order Currency is not same as SOB Currency

CUTOMER_PO_NUMBER TAX_EXEMPT_REASON_CO DE TAX_EXEMPT_REASON RETURN_REASON_CODE

REQUIRED if Order Type Requires REQUIRED if Tax Exempt flag is Exempt Required for returns only

SOLD_FROM_ORG_ID SOLD_FROM_ORG SOLD_TO_ORG_ID SOLD_TO_ORG CUSTOMER_NAME SHIP_TO_ADDRESS1..4 SHIP_TO_CITY SHIP_TO_COUNTY SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER_NUM BER SHIP_TO_POSTAL_CODE SHIP_TO_PROVINCE SHIP_TO_SITE_INT SHIP_TO_STATE SHIP_TO_COUNTRY 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

REQUIRED for Return Lines REQUIRED for Order Lines not Return Lines These columns or Ship_to_Org_id should be provided

These columns or Invoice_To_Org_id should be

OE_LINES_IFACE_ALL Column Name ORDER_SOURCE_ID

Required (C = Conditionally Required) REQUIRED

ORIG_SYS_DOCUMENT_RE F ORIG_SYS_LINE_REF

REQUIRED

ORIG_SYS_SHIPMENT_RE F INVENTORY_ITEM_ID or INVENTORY_ITEM TOP_MODEL_LINE_REF

REQUIRED

REQUIRED

REQUIRED

REQUEST_DATE

Required for model items only Required for model items only REQUIRED

DELIVERY_LEAD_TIME

REQUIRED

DELIVERY_ID

REQUIRED

ORDERED_QUANTITY

REQUIRED

LINK_TO_LINE_REF

Conditionally Required for Booking

ORDER_QUANTITY_UOM

REQUIRED

SHIPPING_QUANTITY

REQUIRED

SHIPPING_QUANTITY_ UOM PRICING_QUANTITY

REQUIRED

PRICING_QUANTITY_ UOM SOLD_FROM_ORG_ID SOLD_FROM_ORG SOLD_TO_ORG_ID SOLD_TO_ORG SHIP_TO_ADDRESS1..4 SHIP_TO_CITY SHIP_TO_COUNTY SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER_NUM BER SHIP_TO_POSTAL_CODE SHIP_TO_PROVINCE SHIP_TO_SITE_INT SHIP_TO_STATE SHIP_TO_COUNTRY 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 PRICE_LIST_ID or PRICE_LIST INVOICING_RULE_ID or INVOICING_RULE ACCOUNTING_RULE_ID or ACCOUNTING_RULE PAYMENT_TERM_ID or PAYMENT_TERM

REQUIRED

RETURN_REASON_CODE

Required for returns only REQUIRED

REFERENCE_TYPE

REQUIRED

REQUIRED for Retunr Lines only REQUIRED for Order lines These columns or Ship_to_Org_id should be provided

These columns or Invoice_To_Org_id should be

REQUIRED REQUIRED REQUIRED REQUIRED for Order lines not for Return Lines

REFERENCE_HEADER_ID or REFERENCE_HEADER REFERENCE_LINE_ID or REFERENCE_LINE SERVICE_DURATION

REQUIRED

SERVICE_START_DATE

Should be populated only for service items Should be populated only for service items Should be populated

SERVICE_END_DATE SERVICE_COTERMINATE_

REQUIRED Should be populated only for service items

FLAG

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_RE F ORIG_SYS_LINE_REF

REQUIRED

ORIG_SYS_SHIPMENT_RE F PRICE_ADJUSTMENT_ID

REQUIRED

REQUIRED

LIST_HEADER_ID

REQUIRED for Update and Delete 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_RE F ORIG_SYS_LINE_REF

REQUIRED

ORIG_SYS_SHIPMENT_RE F

REQUIRED

REQUIRED

OE_CREDITS_IFACE_ALL PERCENT

REQUIRED

SALES_CREDIT_TYPE_ID

REQUIRED

SALES_CREDIT_TYPE OPERATION_CODE

REQUIRED

or

ORIG_SYS_DOCUMENT_RE F ORIG_SYS_LINE_REF

REQUIRED

ORIG_SYS_SHIPMENT_RE F ORIG_SYS_CREDIT_REF

REQUIRED

REQUIRED

REQUIRED

OE_LOTSERIALS_IFACE_ALL ORDER_SOURCE_ID

REQUIRED

ORIG_SYS_DOCUMENT_RE F ORIG_SYS_LINE_REF

REQUIRED

ORIG_SYS_SHIPMENT_RE F ORIG_SYS_LOTSERIAL_ REF LOT_NUMBER

REQUIRED

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

REQUIRED

REQUIRED C

OE_RESERVTNS_IFACE_ALL ORDER_SOURCE_ID

REQUIRED

ORIG_SYS_DOCUMENT_RE F ORIG_SYS_LINE_REF

REQUIRED

ORIG_SYS_SHIPMENT_RE F ORIG_SYS_RESERVATION_ REF INVENTORY_ITEM_ID

REQUIRED

SUBINVENTORY_ID

REQUIRED

QUANTITY

REQUIRED

OPERATION_CODE

REQUIRED

REQUIRED

REQUIRED REQUIRED

OE_ACTIONS_IFACE_ALL ORIG_SYS_DOCUMENT_RE F OPERATION_CODE

REQUIRED 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 LOOKUP_TYPE LOOKUP_CODE MEANING DESCRIPTION

Quick Code values

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.