Receive Sales Order Service

Field Name	Maps to Column	Description
HEADER_ID		Not used for inbound transactions.
FLOW_STATUS_ CODE		Order flow status code. Not used for inbound transactions.
ORDER_TYPE	ORDER_TYPE_ID	Required. Get TRANSACTION_TYPE_ID using OE_TRANSACTION_TYPES_TL.NAME where LANGUAGE is the user language.
ORGANIZATION_ NAME		Not used for inbound transactions.
ORDER_NUMBER	ORDER_NUMBER
VERSION_NUMBER	VERSION_NUMBER	Order version number.
ORDERED_DATE	ORDERED_DATE	Date of the order.
ORDER_CATEGORY	ORDER_CATEGORY
ORDER_SOURCE	ORDER_SOURCE_ID	Required. Use OE_ORDER_SOURCES.NAME to get ORDER_SOURCE_ID.
PRICE_LIST	PRICE_LIST	Required.
ORIG_SYS_ DOCUMENT_REF	ORIG_SYS_ DOCUMENT_ REF	Required. Original document reference for the order in external system.
CONVERSION_RATE	CONVERSION_ RATE	Required. Either CONVERSION_RATE or CONVERSION_RATE_DATE must be populated.
CONVERSION_ RATE_DATE	CONVERSION_ RATE_DATE	Conversion rate Date. You must use either CONVERSION_RATE or CONVERSION_RATE_DATE.
CONVERSION_ TYPE_CODE	CONVERSION_ TYPE_CODE	Required. Either CONVERSION_TYPE_CODE or CONVERSION_TYPE must be populated.
CONVERSION_TYPE	CONVERSION_TYPE	You must use either CONVERSION_TYPE_CODE or CONVERSION_TYPE.
TRANSACTIONAL_ CURR_CODE	TRANSACTIONAL_ CURR_CODE
SALESREP	SALESREP_ID	Sales representative’s name. Get the SALESREP_ID using RA_SALESREPS_ALL.NAME.
SALES_CHANNEL_ CODE	SALES_CHANNEL_ CODE	Sales channel through which order was placed.
SALES_CHANNEL	SALES_CHANNEL
RETURN_REASON_ CODE	RETURN_ REASON_CODE	Required for return orders.
RETURN_REASON		Not used for inbound transactions.
TAX_POINT_CODE	TAX_POINT_CODE
TAX_POINT	TAX_POINT
TAX_EXEMPT_FLAG	TAX_EXEMPT_FLAG	Use: S for Standard E for Exempt R for Required
TAX_EXEMPT_NUMBER	TAX_EXEMPT_ NUMBER
TAX_EXEMPT_ REASON_CODE	TAX_EXEMPT_ REASON_CODE	Required. You must use either TAX_EXEMPT_REASON_CODE or TAX_EXEMPT_REASON.
TAX_EXEMPT_REASON	TAX_EXEMPT_ REASON	You must use TAX_EXEMPT_REASON_CODE or TAX_EXEMPT_REASON.
AGREEMENT	AGREEMENT
INVOICING_RULE	INVOICING_RULE
ACCOUNTING_RULE	ACCOUNTING_RULE
PAYMENT_TERM	PAYMENT_TERM
DEMAND_CLASS_CODE	DEMAND_CLASS_CODE
DEMAND_CLASS	DEMAND_CLASS
SHIPMENT_ PRIORITY_ CODE	SHIPMENT_ PRIORITY_ CODE
SHIPMENT_ PRIORITY	SHIPMENT_ PRIORITY
SHIPMENT_ PRIORITY_ CODE_INT
SHIPPING_ METHOD_CODE	SHIPPING_ METHOD_CODE
SHIPPING_METHOD	SHIPPING_ METHOD
FREIGHT_ CARRIER_CODE	FREIGHT_ CARRIER_CODE
FREIGHT_CARRIER		Not used for inbound transactions.
FREIGHT_TERMS_CODE	FREIGHT_ TERMS_CODE
FREIGHT_TERMS	FREIGHT_TERMS
FOB_POINT_CODE	FOB_POINT_CODE	Free on Board point code.
FOB_POINT	FOB_POINT	Free on Board point.
PARTIAL_SHIPMENTS_ ALLOWED	PARTIAL_ SHIPMENTS_ ALLOWED
SHIP_TOLERANCE_ ABOVE	SHIP_TOLERANCE_ ABOVE	Over shipment/return tolerance.
SHIP_TOLERANCE_ BELOW	SHIP_TOLERANCE_ BELOW	Under shipment/return tolerance.
SHIPPING_ INSTRUCTIONS	SHIPPING_ INSTRUCTIONS
PACKING_ INSTRUCTIONS	PACKING_ INSTRUCTIONS
ORDER_DATE_ TYPE_CODE	ORDER_DATE_ TYPE_CODE
EARLIEST_SCHEDULE_ LIMIT	EARLIEST_ SCHEDULE_ LIMIT	The limit on the number of days earlier than the requested date when the item can be shipped.
LATEST_SCHEDULE_ LIMIT	LATEST_ SCHEDULE_ LIMIT	The limit on the number of days later than the requested date when the item can be shipped.
CUST_PO_NUMBER	CUST_PO_ NUMBER	Customer Purchase Order number.
PAYMENT_TYPE_ CODE	PAYMENT_ TYPE_CODE	Type of payment for orders, such as cash, check, or credit.
PAYMENT_AMOUNT	PAYMENT_AMOUNT
CHECK_NUMBER	CHECK_NUMBER	Check number, if applicable.
CREDIT_CARD_ CODE	CREDIT_CARD_ CODE	Credit card name, if applicable.
CREDIT_CARD_ HOLDER_NAME	CREDIT_CARD_ HOLDER_NAME	Credit card holder name, if applicable.
CREDIT_CARD_ NUMBER	CREDIT_CARD_ NUMBER	Credit card number, if applicable.
CREDIT_CARD_ EXPIRATION_ DATE	CREDIT_CARD_ EXPIRATION_ DATE	Credit card expiration date, if applicable.
CREDIT_CARD_ APPROVAL_CODE	CREDIT_CARD_ APPROVAL_CODE	Credit card approval code, if applicable
SOLD_FROM_ORG	SOLD_TO_ORG_ID	Required. Sold from organization name. Use HR_ALL_ORGANIZATION_ UNITS.NAME.
SOLD_TO_ORG	SOLD_TO_ORG	Required. Sold to organization name. Either SOLD_TO_ORG or PARTY_NAME must be given.
SHIP_FROM_ORG	SHIP_FROM_ORG_ ID	Ship from organization. Use HR_ALL_ORGANIZATION_ UNITS.NAME.
SHIP_TO_ORG SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS4 SHIP_TO_CITY SHIP_TO_COUNTY SHIP_TO_STATE SHIP_TO_POSTAL_CODE SHIP_TO_PROVINCE SHIP_TO_COUNTRY	SHIP_TO_ORG_ID	Required. Ship to organization. Can be derived using HZ_CUST_SITE_USES_ALL and RA_ADDRESSES_USES_ALL along with the details provided to get the SITE_USE_ID where SITE_USE_CODE = SHIP_TO.
SHIP_TO_ CUSTOMER_ NUMBER	SHIP_TO_ CUSTOMER_ NUMBER
SHIP_TO_CUSTOMER	SHIP_TO_ CUSTOMER
INVOICE_TO_ORG INVOICE_ADDRESS1 INVOICE_ADDRESS2 INVOICE_ADDRESS2 INVOICE_ADDRESS3 INVOICE_ADDRESS4 INVOICE_CITY INVOICE_COUNTY INVOICE_STATE INVOICE_POSTAL_CODE INVOICE_PROVINCE_INT INVOICE_COUNTRY	INVOICE_TO_ ORG_ID	Required. Invoice to organization. Derived from HZ_CUST_SITE_USES_ALL and HZ_CUST_ACCT_SITES_ALL, along with the details provided to get the SITE_USE_ID where SITE_USE_CODE = BILL_TO.
INVOICE_ CUSTOMER_NUMBER	INVOICE_ CUSTOMER_ NUMBER
INVOICE_ CUSTOMER	INVOICE_ CUSTOMER	Invoicing customer name.
DELIVER_TO_ORG	DELIVER_TO_ ORG	Deliver to organization.
DELIVER_TO_ CONTACT	DELIVER_TO_ CONTACT
DELIVER_TO_ CUSTOMER_NUMBER	DELIVER_TO_ CUSTOMER_ NUMBER
DELIVER_TO_ CUSTOMER	DELIVER_TO_ CUSTOMER	Deliver to customer name.
SOLD_TO_ CONTACT	SOLD_TO_ CONTACT	Sold to contact name.
SHIP_TO_ CONTACT_ FIRST_NAME	SHIP_TO_ CONTACT_ FIRST_NAME
SHIP_TO_ CONTACT_ LAST_NAME	SHIP_TO_ CONTACT_ LAST_NAME
SHIP_TO_ CONTACT	SHIP_TO_ CONTACT
INVOICE_TO_ CONTACT_PERSON_ FIRST_NAME	INVOICE_TO_ CONTACT_PERSON_ FIRST_NAME
INVOICE_TO_ CONTACT_PERSON_ LAST_NAME	INVOICE_TO_ CONTACT_PERSON_ LAST_NAME
INVOICE_TO_ CONTACT	INVOICE_TO_ CONTACT
CREDIT_CARD_ APPROVAL_DATE	CREDIT_CARD_ APPROVAL_DATE
BOOKED_FLAG	BOOKED_FLAG	Indicates whether order is booked.
CANCELLED_FLAG	CANCELLED_FLAG	Indicates whether order is cancelled.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
PARTY_NAME	PARTY_NAME	Name of the customer on the order. Either SOLD_TO_ORG or PARTY_NAME must be given.
ACCOUNT_NUMBER	ACCOUNT_NUMBER	Number of the customer on the order.
CHANGE_REQUEST_ CODE	CHANGE_REQUEST_ CODE
ORDERED_BY_ CONTACT_PERSON_ FIRST_NAME	ORDERED_BY_ CONTACT_PERSON_ FIRST_NAME
ORDERED_BY_ CONTACT_PERSON_ LAST_NAME	ORDERED_BY_ CONTACT_PERSON_ LAST_NAME
HEADER_PO_ CONTEXT	HEADER_PO_ CONTEXT	Purchase order context.
PO_REVISION_DATE	PO_REVISION_DATE	Purchase order revision date.
CHANGE_REASON	CHANGE_REASON
CHANGE_COMMENT	CHANGE_COMMENT
OPERATION_CODE	OPERATION_CODE	Required. Valid values are: INSERT. CREATE. UPDATE. DELETE.
CLOSED_FLAG	CLOSED_FLAG
REJECTED_FLAG	REJECTED_FLAG	Indicates whether to reject any record during import.
READY_FLAG	READY_FLAG
STATUS_FLAG	STATUS_FLAG
FORCE_APPLY_FLAG	FORCE_APPLY_ FLAG

Field Name	Maps to Column	Description
LINE_ID		Order line identifier. Not used for inbound transactions.
HEADER_ID		Order header identifier. Not used for inbound transactions.
LINE_NUMBER	LINE_NUMBER	Line sequence number within the order.
FLOW_STATUS_CODE		Order line status flow. Not used for inbound transactions.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
CHANGE_REQUEST_CODE	CHANGE_REQUEST_ CODE
ORDER_SOURCE	ORDER_SOURCE_ID	Required. Get the ID using OE_ORDER_SOURCES.
ORIG_SYS_LINE_REF	ORIG_SYS_LINE_REF	Required. Identifier of line from a source system outside of Oracle Order Management.
ORIG_SYS_ SHIPMENT_REF	ORIG_SYS_ SHIPMENT_REF	Required. Original shipment information for the line of the order in external system.
SHIPMENT_NUMBER	SHIPMENT_ NUMBER	System generated identifier of a shipment within a line.
SPLIT_LINE_LINE_REF	SPLIT_FROM_LINE_ ID	Split line identifier of line from a source system outside of Oracle Order Management. Get the SPLIT_FROM_LINE_ID using OE_ORDER_LINES_ALL table where ORIG_SYS_LINE_REF is the same as the given SPLIT_LINE_LINE_REF.
LINE_TYPE	LINE_TYPE_ID	Line transaction type. Use OE_TRANSACTION_TYPES_TL.
ITEM_TYPE_CODE	ITEM_TYPE_CODE
ITEM_TYPE		Not used for inbound transactions.
SOURCE_TYPE_CODE	SOURCE_TYPE_ CODE
SOURCE_TYPE		Not used for inbound transactions.
SCHEDULE_ STATUS_CODE	SCHEDULE_ STATUS_CODE
SCHEDULE_STATUS		Not used for inbound transactions.
INVENTORY_ITEM	INVENTORY_ITEM	Required.
TOP_MODEL_LINE_REF	TOP_MODEL_ LINE_REF	Required for model items. Top parent line.
LINK_TO_LINE_REF	LINK_TO_LINE_REF	Required for model items. Immediate parent component line.
ATO_LINE_REF	ATO_LINE_ID	ATO configuration top model line. Get the ATO_LINE_ID using OE_ORDER_LINES_ALL table where ORIG_SYS_LINE_REF is the same as the given ATO_LINE_REF.
EXPLOSION_DATE	EXPLOSION_ DATE	Date when the included items were exploded and frozen.
COMPONENT_CODE	COMPONENT_ CODE	Component within an exploded bill.
SORT_ORDER	SORT_ORDER	Sorting sequence for a component within an ordered bill.
MODEL_GROUP_ NUMBER	MODEL_GROUP_ NUMBER
OPTION_NUMBER	OPTION_NUMBER	Option or a class within a model.
OPTION_FLAG	OPTION_FLAG
SHIP_MODEL_ COMPLETE_FLAG	SHIP_MODEL_ COMPLETE_FLAG	Indicates line is in ship– complete configuration.
SCHEDULE_SHIP_DATE	SCHEDULE_ SHIP_DATE	Date scheduled to ship item.
SCHEDULE_ ARRIVAL_DATE	SCHEDULE_ ARRIVAL_DATE	Date scheduled for the item to arrive at the customer site.
ACTUAL_ARRIVAL_DATE	ACTUAL_ARRIVAL_ DATE	Date the item actually arrived at customer’s site.
REQUEST_DATE	REQUEST_DATE	Required. Ordered item request date.
PROMISE_DATE	PROMISE_DATE	Date promised to customer to receive item.
DELIVERY_LEAD_TIME	DELIVERY_ LEAD_TIME	Required.
ORDERED_QUANTITY	ORDERED_ QUANTITY	Required.
ORDER_QUANTITY_ UOM	ORDER_ QUANTITY_ UOM	Required. Ordered quantity unit of measurement.
SHIPPING_QUANTITY	SHIPPING_ QUANTITY	If this field is populated, then both SHIPPING_QUANTITY and SHIPPING_QUANTITY_UOM must be populated.
SHIPPING_QUANTITY_UOM	SHIPPING_ QUANTITY_ UOM	Shipping quantity unit of measurement. If this field is populated, then both SHIPPING_QUANTITY and SHIPPING_QUANTITY_UOM must be populated.
SHIPPED_QUANTITY	SHIPPED_ QUANTITY
CANCELLED_QUANTITY	CANCELLED_ QUANTITY
FULFILLED_QUANTITY	FULFILLED_ QUANTITY
PRICING_QUANTITY	PRICING_ QUANTITY	If this field is populated, then both PRICING_QUANTITY and PRICING_QUANTITY_UOM must be populated.
PRICING_QUANTITY_ UOM	PRICING_ QUANTITY_ UOM	Pricing quantity unit of measurement. If this field is populated, then both PRICING_QUANTITY and PRICING_QUANTITY_UOM must be populated.
SOLD_FROM_ORG	SOLD_TO_ORG_ID	Required. Selling organization. Value is HR_ALL_ORGANIZATION_UNITS.
SOLD_TO_ORG	SOLD_TO_ORG	Customer to whom the item is sold.
SHIP_FROM_ORG	SHIP_FROM_ ORG_ID	Ship from organization. Valid is HR_ALL_ORGANIZATION_UNITS.
DELIVERY_NAME	DELIVERY_ID	Required. Derive this delivery name using WSH_NEW_DELIVERIES.
SHIP_TO_ORG SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS4 SHIP_TO_CITY SHIP_TO_COUNTY SHIP_TO_STATE SHIP_TO_POSTAL_CODE SHIP_TO_COUNTRY	SHIP_TO_ORG_ID	Required. Ship to organization, which can be derived using HZ_CUST_SITE_USES_ALL and HZ_CUST_ACCT_SITES_ALL along with the details provided to get the SITE_USE_ID where SITE_USE_CODE = SHIP_TO.
DELIVER_TO_ORG	DELIVER_TO_ORG	Deliver to organization.
INVOICE_TO_ORG BILL_TO_ADDRESS1 BILL_TO_ADDRESS2 BILL_TO_ADDRESS3 BILL_TO_ADDRESS4 BILL_TO_CITY BILL_TO_COUNTY BILL_TO_STATE BILL_TO_POSTAL_CODE BILL_TO_COUNTRY	INVOICE_TO_ORG_ID	Required. Derive invoice to organization by using HZ_CUST_SITE_USES_ALL and RA_ADDRESSES_USES_ALL with the given details to get the SITE_USE_ID where SITE_USE_CODE = BILL_TO.
SHIP_TO_CONTACT_ FIRST_NAME	SHIP_TO_ CONTACT_ FIRST_NAME
SHIP_TO_CONTACT_ LAST_NAME	SHIP_TO_ CONTACT_ LAST_NAME
SHIP_TO_CONTACT_ JOB_TITLE	SHIP_TO_ CONTACT_ JOB_TITLE
SHIP_TO_CONTACT	SHIP_TO_ CONTACT
DELIVER_TO_CONTACT	DELIVER_TO_ CONTACT
INVOICE_TO_CONTACT	INVOICE_TO_ CONTACT
DROP_SHIP_FLAG	DROP_SHIP_FLAG	Not used for outbound transactions.
VEH_CUS_ITEM_ CUM_KEY	VEH_CUS_ ITEM_CUM_ KEY_ID	Customer item key.
CUST_PRODUCTION_ SEQ_NUM	CUST_ PRODUCTION_ SEQ_NUM	Customer production sequence number.
LOAD_SEQ_NUMBER	LOAD_SEQ_NUMBER	Load sequence number. Not used for outbound transactions.
OVER_SHIP_REASON_ CODE	OVER_SHIP_ REASON_CODE	Over shipment reason code.
OVER_SHIP_RESOLVED_ FLAG	OVER_SHIP_ RESOLVED_FLAG	Over shipment reason.
AUTHORIZED_TO_ SHIP_FLAG	AUTHORIZED_ TO_SHIP_FLAG	Indicates whether the demand lines are authorized to ship.
SHIP_TOLERANCE_ ABOVE	SHIP_ TOLERANCE_ ABOVE	Over shipment/return tolerance.
SHIP_TOLERANCE_ BELOW	SHIP_ TOLERANCE_ BELOW	Under shipment/return tolerance.
SHIP_SET_NAME	SHIP_SET_NAME
ARRIVAL_SET_NAME	ARRIVAL_SET_NAME
PRICE_LIST	PRICE_LIST	Required. Price List Name.
PRICING_DATE	PRICING_DATE
UNIT_LIST_PRICE	UNIT_LIST_PRICE
UNIT_LIST_PRICE_ PER_PQTY	UNIT_LIST_ PRICE_PER_PQTY	Unit list price per quantity.
UNIT_SELLING_PRICE	UNIT_SELLING_PRICE
UNIT_SELLING_PRICE_ PER_PQTY	UNIT_SELLING_ PRICE_PER_PQTY	Unit selling price per quantity.
TAX_DATE	TAX_DATE
TAX_CODE	TAX_CODE
TAX_VALUE	TAX_VALUE
CALCULATED_PRICE_ FLAG	CALCULATED_ PRICE_FLAG	Indicates whether price is to be calculated. Not used for outbound transactions.
TAX_EXEMPT_FLAG	TAX_EXEMPT_ FLAG	Indicates tax handling for the order line. Use: S for Standard E for Exempt R for Required
TAX_EXEMPT_NUMBER	TAX_EXEMPT_ NUMBER
TAX_EXEMPT_REASON_ CODE	TAX_EXEMPT_ REASON_CODE
TAX_EXEMPT_REASON	TAX_EXEMPT_ REASON
TAX_POINT_CODE	TAX_POINT_ CODE
TAX_POINT	TAX_POINT
AGREEMENT	AGREEMENT
ACCOUNTING_RULE	ACCOUNTING_RULE	Required.
INVOICING_RULE	INVOICING_RULE
PAYMENT_TERM	PAYMENT_TERM	Required.
DEMAND_CLASS_CODE	DEMAND_CLASS_ CODE	Required. You must use Demand Class Code or Demand Class.
DEMAND_CLASS	DEMAND_CLASS	You must use Demand Class Code or Demand Class.
SHIPMENT_PRIORITY_ CODE	SHIPMENT_ PRIORITY_ CODE
SHIPMENT_PRIORITY	SHIPMENT_ PRIORITY
SHIPPING_METHOD_ CODE	SHIPPING_ METHOD_CODE
SHIPPING_METHOD	SHIPPING_ METHOD
FREIGHT_CARRIER_CODE	FREIGHT_ CARRIER_ CODE
FREIGHT_CARRIER		Not used for inbound transactions.
FREIGHT_TERMS_ CODE	FREIGHT_ TERMS_CODE
FREIGHT_TERMS	FREIGHT_TERMS
FOB_POINT_CODE	FOB_POINT_CODE	Free on Board point code.
FOB_POINT	FOB_POINT	Free on Board point.
SALESREP	SALESREP	Sales representative name.
SHIPPING_ INSTRUCTIONS	SHIPPING_ INSTRUCTIONS
PACKING_ INSTRUCTIONS	PACKING_ INSTRUCTIONS
RETURN_ REASON_CODE	RETURN_ REASON_CODE	Must be populated for returns.
RETURN_REASON		Not used for inbound transactions.
REFERENCE_TYPE	REFERENCE_ TYPE	Must be populated to populate the REFERENCE_HEADER or REFERENCE_LINE.
REFERENCE_HEADER	REFERENCE_ HEADER	Sales order header the return line references.
REFERENCE_LINE	REFERENCE_ LINE	Sales order line the return line references.
CREDIT_INVOICE_ NUMBER	CREDIT_ INVOICE_LINE_ID	Credit Invoice Number. Use tables HZ_CUST_ACCOUNT_TRX_LINES_ALL RCTL and HZ_CUST_ACCOUNT_TRX_ALL RCT. Get RCTL.CUSTOMER_TRX_LINE_ID where RCTL.ORG_ID = Current Organization AND RCT.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID AND where RCT.TRX_NUMBER = given Credit Invoice number.
CUSTOMER_LINE_ NUMBER	CUSTOMER_ LINE_NUMBER
CUSTOMER_PO_ NUMBER	CUSTOMER_ PO_NUMBER	Customer purchase order number.
CUSTOMER_SHIPMENT_ NUMBER	CUSTOMER_ SHIPMENT_ NUMBER
CUSTOMER_ITEM_ NAME	CUSTOMER_ ITEM_NAME
CUSTOMER_ITEM_ REVISION	CUSTOMER_ ITEM_REVISION	Not used in outbound transactions.
CUSTOMER_ITEM_ NET_PRICE	CUSTOMER_ ITEM_NET_PRICE
DEMAND_BUCKET_ TYPE_CODE	DEMAND_ BUCKET_ TYPE_CODE
CUSTOMER_ DOCK_CODE	CUSTOMER_ DOCK_CODE
CUSTOMER_JOB	CUSTOMER_JOB
CUSTOMER_PRODUCTION_ LINE	CUSTOMER_ PRODUCTION_ LINE
CUST_MODEL_SERIAL_ NUMBER	CUST_MODEL_ SERIAL_NUMBER	Customer model serial number.
PROJECT	PROJECT	Project name.
TASK	TASK	Task name.
FULFILLMENT_SET_ NAME	FULFILLMENT_ SET_NAME
END_ITEM_UNIT_ NUMBER	END_ITEM_ UNIT_NUMBER	Bill of material to be used for building a specific Model or Unit Number effectively controlled Item.
ITEM_REVISION	ITEM_REVISION	Item revision for a return line.
SCHEDULE_DATE	SCHEDULE_DATE
SHIP_TO_CONTACT_ AREA_CODE1	SHIP_TO_ CONTACT_ AREA_CODE1
SHIP_TO_CONTACT_ AREA_CODE2	SHIP_TO_ CONTACT_ AREA_CODE2
SHIP_TO_CONTACT_ AREA_CODE3	SHIP_TO_ CONTACT_ AREA_CODE3
CUSTOMER_ITEM_ID_TYPE	CUSTOMER_ ITEM_ID_TYPE
INVOICE_SET_NAME	INVOICE_SET_NAME
TAX	TAX
SCHEDULE_ITEM_DETAIL	SCHEDULE_ ITEM_DETAIL
DEMAND_STREAM	DEMAND_STREAM
SERVICE_DURATION	SERVICE_ DURATION	Required for service items.
SERVICE_START_DATE	SERVICE_ START_DATE	Required for service items.
SERVICE_END_DATE	SERVICE_ END_DATE	Required for service items.
SERVICE_COTERMINATE_ FLAG	SERVICE_ COTERMINATE_ FLAG	Required for service items. Indicates whether the service can be co-terminated.
UNIT_SELLING_PERCENT	UNIT_SELLING_ PERCENT	For percentage-based pricing only. The percentage charged to the customer.
UNIT_LIST_PERCENT	UNIT_LIST_ PERCENT	For percent-based pricing only. Price list percent of the item.
UNIT_PERCENT_BASE_ PRICE	UNIT_PERCENT_ BASE_PRICE	For percent-based pricing.
SERVICE_NUMBER	SERVICE_ NUMBER	Unique number to identify the service line(s).
CANCELLED_FLAG	CANCELLED_ FLAG	Indicates whether line is cancelled.
FULFILLED_FLAG	FULFILLED_ FLAG	Indicates whether line is fulfilled.
SERVICE_TXN_REASON_ CODE	SERVICE_TXN_ REASON_CODE	Service transaction reason code.
SERVICE_TXN_COMMENTS	SERVICE_TXN_ COMMENTS	Service transaction comments.
CONTRACT_PO_NUMBER	CONTRACT_PO_ NUMBER	Contract purchase order number.
LINE_PO_CONTEXT	LINE_PO_CONTEXT	Line purchase order context
OPERATION_CODE	OPERATION_CODE	Use values such as INSERT. CREATE. UPDATE. DELETE.
CHANGE_REASON	CHANGE_REASON
CHANGE_COMMENTS	CHANGE_COMMENTS
CLOSED_FLAG	CLOSED_FLAG
REJECTED_FLAG	REJECTED_FLAG	Indicates whether any record were rejected during import.
STATUS_FLAG	STATUS_FLAG

Field Name	Maps to Column	Description
HEADER_ID		Order header identifier. Not used for inbound transactions.
LINE_ID		Order line identifier. Not used for inbound transactions.
ADJUSTED_AMOUNT	ADJUSTED_ AMOUNT	Adjusted amount at the adjustment level.
ADJUSTED_AMOUNT_ PER_PQTY	ADJUSTED_ AMOUNT_ PER_PQTY	Adjusted amount per quantity.
APPLIED_FLAG	APPLIED_FLAG	For string manual discounts not yet applied by the user. Indicates whether the adjustment has been applied to the order line.
ARITHMETIC_OPERATOR	ARITHMETIC_ OPERATOR	Qualifies the value in operand such as percentage, amount, or a new price.
AUTOMATIC_FLAG	AUTOMATIC_ FLAG	Required. Indicates whether the discount was applied automatically.
CHANGE_REASON_CODE	CHANGE_ REASON_CODE	Reason code for making a change to the adjustment value.
CHANGE_REASON_TEXT	CHANGE_ REASON_TEXT	Text for reason change was made to the adjustment value.
CHANGE_SEQUENCE	CHANGE_ SEQUENCE	Not used for outbound transactions.
CHANGE_REQUEST_CODE	CHANGE_ REQUEST_CODE	Not used for outbound transactions.
CHARGE_TYPE_CODE	CHARGE_ TYPE_CODE
CHARGE_SUBTYPE_CODE	CHARGE_ SUBTYPE_CODE
COST_TYPE	COST_ID	Get the cost using WSH_FREIGHT_COSTS and WSH_FREIGHT_COST_TYPES. Use the WSH_FREIGHT_COST_TYPES table to get the FREIGHT_COST_TYPE_ID. Then get the FREIGHT_COST_ID using the following cost type and the given information: Amount for freight costs in unit Quantity Total amount Freight cost Currency code Freight Code
COST_UNIT_AMOUNT
COST_QUANTITY
COST_AMOUNT
COST_CURRENCY_CODE
CREDIT_OR_CHARGE_ FLAG	CREDIT_OR_ CHARGE_FLAG	Indicates whether the adjustment record is a credit or charge to a customer.
DISCOUNT_NAME	DISCOUNT_NAME
LINE_DISCOUNT_NAME	DISCOUNT_LINE_ID	Line Discount Name. Get the ID using SO_DISCOUNTS.
ESTIMATED_FLAG	ESTIMATED_FLAG	Indicates whether the charge amount is estimated or fixed.
INVOICED_FLAG	INVOICED_FLAG	Indicates whether the charge is invoiced.
INC_IN_SALES_ PERFORMANCE	INC_IN_SALES_ PERFORMANCE	Indicates whether the charge should be included in Sales Performance calculation.
INCLUDE_ON_ RETURNS_FLAG	INCLUDE_ON_ RETURNS_FLAG	Indicates whether the adjustment is returnable.
LIST_NAME	LIST_NAME	Name of modifier header.
LIST_LINE_TYPE_CODE	LIST_LINE_TYPE_CODE	Line type of the modifier.
LIST_LINE_NUMBER	LIST_LINE_NUMBER	List line number.
MODIFIED_FROM	MODIFIED_FROM	Stores the value of the item code, which was upgraded.
MODIFIED_TO	MODIFIED_TO	Stores the value of the item code, to which an item was upgraded
MODIFIER_ MECHANISM_ TYPE_CODE	MODIFIER_ MECHANISM_ TYPE_CODE	Modifier mechanism type code.
OPERAND	OPERAND	Stores the adjustment value, qualified by the arithmetic operator.
OPERAND_PER_PQTY	OPERAND_ PER_PQTY	Operand per quantity.
OPERATION_CODE	OPERATION_ CODE	Required. Use values such as: INSERT. CREATE. UPDATE. DELETE.
ORDER_SOURCE	ORDER_ SOURCE_ID	Order source name. Use OE_ORDER_SOURCES.
ORIG_SYS_ DISCOUNT_REF	ORIG_SYS_ DISCOUNT_REF	Required. Original system discount reference.
PARENT_ADJUSTMENT_ NAME	PARENT_ ADJUSTMENT_ID	Parent adjustment Name. Use: OE_PRICE_ADJUSTMENTS_V where ADJUSTMENT_NAME is the given parent adjustment name. LINE_ID, HEADER_ID is the same as that obtained from ORIG_SYS_DOCUMENT_REF. ORIG_SYS_LINE_REF using OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL.
PRICING_PHASE	PRICING_PHASE_ID	Pricing Phase Name. Use QP_PRICING_PHASES.NAME
PERCENT	PERCENT
TAX_CODE	TAX_CODE	Tax code for the charges.
UPDATE_ALLOWED	UPDATE_ALLOWED	Indicates whether this adjustment can be overridden.
UPDATED_FLAG	UPDATED_FLAG	Indicates whether the user has changed this row.
VERSION_NUMBER	VERSION_NUMBER
STATUS_FLAG	STATUS_FLAG
FREIGHT_CODE	COST_ID	Freight code.

Field Name	Maps to Column	Description
HEADER_ID		Order header identifier. Not used for inbound transactions.
LINE_ID		Order line identifier. Not used for inbound transactions.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
CHANGE_REQUEST_CODE	CHANGE_REQUEST_ CODE
OPERATION_CODE	OPERATION_CODE	Required. Use values such as: INSERT, CREATE, UPDATE, or DELETE.
ORDER_SOURCE	ORDER_SOURCE_ID	Order Source Name. Use OE_ORDER_SOURCES.
ORIG_SYS_ATTS_REF	ORIG_SYS_ATTS_REF	Required. Original system attribute reference.
STATUS_FLAG	STATUS_FLAG
PRICING_CONTEXT	PRICING_CONTEXT
FLEX_TITLE	FLEX_TITLE

Field Name	Maps to Column	Description
HEADER_ID		Order header identifier. Not used for inbound transactions.
LINE_ID		Order line identifier. Not used in for inbound transactions.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
CHANGE_REQUEST_CODE	CHANGE_REQUEST_CODE
OPERATION_CODE	OPERATION_CODE	Required. Use values such as: INSERT. CREATE. UPDATE. DELETE.
ORDER_SOURCE	ORDER_SOURCE_ID	Required. Order source name. Use OE_ORDER_SOURCES.
ORIG_SYS_CREDIT_REF	ORIG_SYS_CREDIT_REF	Required. Original system credit reference.
QUOTA_FLAG	QUOTA_FLAG	Indicates revenue or non- revenue base credit.
PERCENT	PERCENT	Required. Indicates sales credit percent for a salesperson.
SALESREP	SALESREP	Salesperson’s name.
SALES_CREDIT_TYPE	SALES_CREDIT_TYPE	Required.

Field Name	Maps to Column	Description
LINE_ID		Order line identifier. Not used for inbound transactions.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
CHANGE_REQUEST_CODE	CHANGE_REQUEST_CODE
OPERATION_CODE	OPERATION_CODE	Required. Values are: INSERT CREATE UPDATE DELETE.
ORDER_SOURCE	ORDER_SOURCE_ID	Required. Order source name. Use OE_ORDER_SOURCES.
ORIG_SYS_LOTSERIAL_REF	ORIG_SYS_LOTSERIAL_REF	Required. Original system lot serial reference.
LOT_NUMBER	LOT_NUMBER
FROM_SERIAL_NUMBER	FROM_SERIAL_NUMBER	Serial number range starting number. If TO_SERIAL_NUMBER is null, then this field is the only serial number.
TO_SERIAL_NUMBER	TO_SERIAL_NUMBER	Serial number range ending number.
QUANTITY	QUANTITY	Required. Lot or serial number quantity. This field should match the serial number range for the serial number controlled item.

Field Name	Maps to Column	Description
LINE_ID		Order line identifier. Not used for inbound transactions.
HEADER_ID		Order header identifier. Not used for inbound transactions.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
OPERATION_CODE	OPERATION_CODE	Required. Use values such as: INSERT. CREATE. UPDATE. DELETE.
ORDER_SOURCE	ORDER_SOURCE_ID	Required. Order source name. Use OE_ORDER_SOURCES.
REVISION	REVISION	Revision of revision- controlled reserved item.
ITEM_CODE	INVENTORY_ITEM_ID	Required. Reserved Item. Use MTL_SYSTEM_ITEMS_B_KFV for the current organization.
SUBINVENTORY_CODE	SUBINVENTORY_CODE	Subinventory in which reserved item resides.
LOCATOR	LOCATOR_ID	Locator in which reserved item resides. Use MTL_ITEM_LOCATIONS_KFV.
LOT_NUMBER	LOT_NUMBER	Lot number of lot-controlled reserved item.
QUANTITY	QUANTITY	Required. Quantity reserved.
ORIG_SYS_RESERVATION_REF	ORIG_SYS_RESERVATION_ REF	Required. Original system reservation reference.

Field Name	Maps to Column	Description
LINE_ID		Order line identifier. Not used for inbound transactions.
HEADER_ID		Order header identifier. Not used for inbound transactions.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
OPERATION_CODE	OPERATION_CODE	Required. Valid values are: BOOK_ORDER APPLY_HOLD RELEASE_HOLD APPLY_AUTOMATIC_ ATCHMT DELINK_CONFIG MATCH_AND_RESERVE
ORDER_SOURCE	ORDER_SOURCE_ID	Order source name. Use OE_ORDER_SOURCES.
HOLD_NAME	HOLD_ID	Hold name. Use OE_HOLD_DEFINITIONS.
HOLD_TYPE_CODE	HOLD_TYPE_CODE
HOLD_UNTIL_DATE	HOLD_UNTIL_DATE
RELEASE_REASON_CODE	RELEASE_REASON_ CODE
COMMENTS	COMMENTS
CONTEXT	CONTEXT
STATUS_FLAG	STATUS_FLAG

Field Name	Maps to Column	Description
HEADER_ID		Order header identifier. Not used for inbound transactions.
CHANGE_SEQUENCE	CHANGE_SEQUENCE
CHANGE_REQUEST_CODE	CHANGE_REQUEST_ CODE
OPERATION_CODE	OPERATION_CODE	Required. Use values such as INSERT. CREATE. UPDATE. DELETE.
ORDER_SOURCE	ORDER_SOURCE_ID	Order source name. Use OE_ORDER_SOURCES.
ORIG_SYS_ATTS_REF	ORIG_SYS_ATTS_REF	Required. Original system attribute reference.
STATUS_FLAG	STATUS_FLAG
PRICING_CONTEXT	PRICING_CONTEXT
FLEX_TITLE	FLEX_TITLE

Field Name	Maps to Column	Description
HEADER_ID		Order header identifier. Not used for inbound transactions.
ADJUSTED_AMOUNT	ADJUSTED_AMOUNT	Adjusted amount at the adjustment level.
ADJUSTED_AMOUNT_ PER_PQTY	ADJUSTED_AMOUNT_ PER_PQTY	Adjusted amount per quantity.
APPLIED_FLAG	APPLIED_FLAG	Indicates whether the adjustment has been applied to the order line. For string manual discounts not yet applied by the user.
ARITHMETIC_OPERATOR	ARITHMETIC_OPERATOR	Qualifies the value in operand for percentage, amount, or new price.
AUTOMATIC_FLAG	AUTOMATIC_FLAG	Required. Indicates whether the discount was applied automatically.
CHANGE_REASON_CODE	CHANGE_REASON_CODE	Reason code for making a change to the adjustment value.
CHANGE_REASON_TEXT	CHANGE_REASON_TEXT	Text for the reason code
CHANGE_SEQUENCE	CHANGE_SEQUENCE	Not used for outbound transactions.
CHANGE_REQUEST_CODE	CHANGE_REQUEST_CODE	Not used for outbound transactions.
CHARGE_TYPE_CODE	CHARGE_TYPE_CODE
CHARGE_SUBTYPE_CODE	CHARGE_SUBTYPE_CODE
COST_TYPE	COST_ID	Get the cost using WSH_FREIGHT_COSTS and WSH_FREIGHT_COST_TYPES. Then use the WSH_FREIGHT_COST_TYPES table to get the FREIGHT_COST_TYPE_ID. Then get the FREIGHT_COST_ID using this cost type and the following information: Amount for freight costs in unit: Quantity. Total amount. Freight cost Currency code. Freight Code.
COST_UNIT_AMOUNT
COST_QUANTITY
COST_AMOUNT
COST_CURRENCY_CODE
CREDIT_OR_CHARGE_ FLAG	CREDIT_OR_CHARGE_ FLAG	Indicates whether the adjustment record is a credit or charge to a customer.
DISCOUNT_NAME	DISCOUNT_NAME
LINE_DISCOUNT_NAME	DISCOUNT_LINE_ID	Line discount name. Get the ID using SO_DISCOUNTS.
ESTIMATED_FLAG	ESTIMATED_FLAG	Indicates whether the charge amount is estimated or fixed.
INVOICED_FLAG	INVOICED_FLAG	Indicates whether the charge is invoiced.
INC_IN_SALES_ PERFORMANCE	INC_IN_SALES_ PERFORMANCE	Indicates whether the charge should be included in the Sales Performance calculation.
INCLUDE_ON_RETURNS_ FLAG	INCLUDE_ON_ RETURNS_FLAG	Indicates whether the adjustment is returnable.
LIST_NAME	LIST_NAME	Name of modifier header.
LIST_LINE_TYPE_CODE	LIST_LINE_TYPE_CODE	Line type of the modifier.
LIST_LINE_NUMBER	LIST_LINE_NUMBER
MODIFIED_FROM	MODIFIED_FROM	Stores the value of the item code, which was upgraded.
MODIFIED_TO	MODIFIED_TO	Stores the value of the item code, to which an item was upgraded.
MODIFIER_MECHANISM_ TYPE_CODE	MODIFIER_ MECHANISM_ TYPE_CODE
OPERAND	OPERAND	Stores the adjustment value, qualified by arithmetic operator.
OPERAND_PER_PQTY	OPERAND_PER_PQTY	Operand per quantity
OPERATION_CODE	OPERATION_CODE	Required. Valid values are INSERT. CREATE. UPDATE. DELETE.
ORDER_SOURCE	ORDER_SOURCE_ID	Order Source Name. Use OE_ORDER_SOURCES.
ORIG_SYS_DISCOUNT_REF	ORIG_SYS_DISCOUNT_REF	Required. Original system discount reference.
PARENT_ADJUSTMENT_NAME	PARENT_ADJUSTMENT_ID	Parent adjustment name. Use: OE_PRICE_ADJUSTMENTS_V where ADJUSTMENT_NAME is the given parent adjustment name and LINE_ID and HEADER_ID are the same as the ORIG_SYS_DOCUMENT_REF and ORIG_SYS_LINE_REF using OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL.
PRICING_PHASE	PRICING_PHASE_ID	Pricing Phase Name. Use QP_PRICING_PHASES.NAME.
PERCENT	PERCENT	Percentage.
TAX_CODE	TAX_CODE	Tax code defined for the charges.
UPDATE_ALLOWED	UPDATE_ALLOWED	Indicates whether this adjustment can be overridden.
UPDATED_FLAG	UPDATED_FLAG	Indicates whether the user has changed this row.
VERSION_NUMBER	VERSION_NUMBER
STATUS_FLAG	STATUS_FLAG
FREIGHT_CODE

Database Script	Description
wm_install_into_salesorder.sql	Runs the scripts listed below, except the uninstall script.
wm_into_salesorder_pkg.sql	Installs WM_ORDER_IMP_HANDLER_PKG. WM_HANDLE_ORDER_IMPORT, which calls the WM_CONC_REQUEST. WM_REQUEST_SUBMIT procedure to submit the sales order import process.
wm_drop_into_salesorder.sql	Uninstalls all components created by wm_install_into_salesorder.sql.