Send Sales Order Service

Database Script	Description
wm_install_from_salesorder.sql	Runs all the scripts listed below, except the uninstall script.
wm_from_salesorder_vw.sql	Creates required views for Sales Order outbound transactions: WM_ORDER_HEADERS_VW WM_ORDER_LINES_VW WM_SALES_CREDITS_VW WM_HEADER_SALES_CREDIT_VW WM_PRICE_ADJ_VW WM_HEADER_PRICE_ADJ_VW WM_PRICE_ATTRIBS_VW WM_HEADER_PRICE_ATTRB_VW WM_OE_RESERVTNS_VW WM_LOTSERIALS_VW WM_OE_ACTIONS_VW WM_OE_LINE_ACTIONS_VW WM_ORDER_HEADER_QRY_VW
wm_from_salesorder_trg.sql	Creates the following trigger components to be used for writing to the WM_TRACKCHANGES table to indicate a new or updated document: WM_ORDER_HEADERS_IU_TRG WM_ORDER_LINES_IUD_TRG WM_SALES_CREDITS_IUD_TRG WM_OE_LOTSERIAL_IUD_TRG WM_OE_PRICE_ADJ_IUD_TRG WM_OE_PRICE_ATTRIBS_IUD_TRG WM_LINE_SETS_IUD_TRG
wm_drop_from_salesorder.sql	Uninstalls all components created by wm_install_from_salesorder.sql.

For These Documents...	Use the following table:
1.2 HEADER_PRICE_ATTRIB	1.1.2 PRICE_ATTRIBS (Except LINE_ID as it represents the order’s price attributes).
1.3 HEADER_PRICE_ADJ	1.1.1 PRICE_ADJ (Except LINE_ID as it represents the order’s price adjustments).
1.4 HEADER_SALES_CREDIT	1.1.4 SALES_CREDITS (Except LINE_ID as it represents the order’s price credits).
1.5 OE_ACTIONS	1.1.6 OE_LINE_ACTIONS (Except LINE_ID as it represents the order actions).

Field Name	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION_ID
DOCUMENT_TYPE			Use ORDER.
DOCUMENT_STATUS			Valid values are INSERT. UPDATE. DELETE.
HEADER_ID	OE_ORDER_ HEADERS_ALL	HEADER_ID
FLOW_STATUS_ CODE	OE_ORDER_ HEADERS_ALL	FLOW_STATUS_ CODE	Order flow status code.
ORDER_TYPE	OE_ TRANSACTION_ TYPES_TL	NAME
ORGANIZATION_ NAME	HR_ALL_ ORGANIZATION_ UNITS	NAME
ORDER_NUMBER	OE_ORDER_ HEADERS_ALL	ORDER_ NUMBER	Unique number assigned to the order.
VERSION_NUMBER	OE_ORDER_ HEADERS_ALL	VERSION_ NUMBER	Order version number.
ORDERED_DATE	OE_ORDER_ HEADERS_ALL	ORDERED_DATE	Date of the order.
ORDER_CATEGORY	OE_LOOKUPS	MEANING
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME
PRICE_LIST	QP_LIST_ HEADERS_TL	NAME
ORIG_SYS_ DOCUMENT_REF	OE_ORDER_ HEADERS_ALL	ORIG_SYS_ DOCUMENT_ REF	Original document reference for the order in the external system.
CONVERSION_ RATE	OE_ORDER_ HEADERS_ALL	CONVERSION_ RATE
CONVERSION_ RATE_DATE	OE_ORDER_ HEADERS_ALL	CONVERSION_ RATE_DATE
CONVERSION_ TYPE_CODE	OE_ORDER_ HEADERS_ALL	CONVERSION_ TYPE_CODE
CONVERSION_TYPE	GL_DAILY_ CONVERSION_ TYPES	USER_ CONVERSION_ TYPE
TRANSACTIONAL_ CURR_CODE	OE_ORDER_ HEADERS_ALL	TRANSACTIONAL_ CURR_CODE	Currency Code.
SALESREP	RA_SALESREPS_ALL	NAME	Sales representative’s name.
SALES_CHANNEL_ CODE	OE_ORDER_ HEADERS_ALL	SALES_ CHANNEL_ CODE	Sales channel through which order was placed.
SALES_CHANNEL	OE_LOOKUPS	MEANING
RETURN_REASON_ CODE	OE_ORDER_ HEADERS_ALL	RETURN_ REASON_ CODE
RETURN_REASON	FND_LOOKUP_ VALUES	MEANING
TAX_POINT_CODE	OE_ORDER_ HEADERS_ALL	TAX_POINT_CODE
TAX_POINT	OE_LOOKUPS	MEANING	Tax point description
TAX_EXEMPT_FLAG	OE_ORDER_ HEADERS_ALL	TAX_EXEMPT_FLAG	Use: S for Standard E for Exempt R for Required
TAX_EXEMPT_ NUMBER	OE_ORDER_ HEADERS_ALL	TAX_EXEMPT_ NUMBER	Tax exemption number.
TAX_EXEMPT_ REASON_CODE	OE_ORDER_ HEADERS_ALL	TAX_EXEMPT_ REASON_CODE	Tax exemption reason code.
TAX_EXEMPT_ REASON	AR_LOOKUPS	MEANING	Tax exemption reason.
AGREEMENT	OE_ AGREEMENTS_ TL	NAME
INVOICING_RULE	RA_RULES	NAME
ACCOUNTING_RULE	RA_RULES	NAME
PAYMENT_TERM	RA_TERMS_TL	NAME
DEMAND_CLASS_CODE	OE_ORDER_ HEADERS_ALL	DEMAND_ CLASS_CODE
DEMAND_CLASS	OE_FND_ COMMON_ LOOKUPS_V	MEANING
SHIPMENT_ PRIORITY_CODE	OE_ORDER_ HEADERS_ALL	SHIPMENT_ PRIORITY_ CODE
SHIPMENT_ PRIORITY	OE_LOOKUPS	MEANING
SHIPMENT_ PRIORITY_CODE_ INT	OE_ORDER_ HEADERS_ALL	SHIPMENT_ PRIORITY_ CODE
SHIPPING_ METHOD_CODE	OE_ORDER_ HEADERS_ALL	SHIPPING_ METHOD_ CODE
SHIPPING_METHOD	OE_SHIP_METHODS_V	MEANING
FREIGHT_ CARRIER_CODE	OE_ORDER_ HEADERS_ALL	FREIGHT_ CARRIER_ CODE
FREIGHT_CARRIER	ORG_FREIGHT	DESCRIPTION
FREIGHT_ TERMS_CODE	OE_ORDER_ HEADERS_ALL	FREIGHT_ TERMS_ CODE
FREIGHT_TERMS	OE_LOOKUPS	MEANING
FOB_POINT_CODE	OE_ORDER_ HEADERS_ALL	FOB_POINT_CODE	Free on Board point code.
FOB_POINT	AR_LOOKUPS	MEANING
PARTIAL_ SHIPMENTS_ ALLOWED	OE_ORDER_ HEADERS_ALL	PARTIAL_ SHIPMENTS_ ALLOWED
SHIP_ TOLERANCE_ ABOVE	OE_ORDER_ HEADERS_ALL	SHIP_ TOLERANCE_ ABOVE	Over shipment or return tolerance.
SHIP_ TOLERANCE_ BELOW	OE_ORDER_ HEADERS_ALL	SHIP_ TOLERANCE_ BELOW	Under shipment or return Tolerance.
SHIPPING_ INSTRUCTIONS	OE_ORDER_ HEADERS_ALL	SHIPPING_ INSTRUCTIONS
PACKING_ INSTRUCTIONS	OE_ORDER_ HEADERS_ALL	PACKING_ INSTRUCTIONS
ORDER_DATE_ TYPE_CODE	OE_ORDER_ HEADERS_ALL	ORDER_ DATE_ TYPE_CODE
EARLIEST_ SCHEDULE_LIMIT	OE_ORDER_ HEADERS_ALL	EARLIEST_ SCHEDULE_ LIMIT	Number of days earlier than the requested date to ship item.
LATEST_ SCHEDULE_LIMIT	OE_ORDER_ HEADERS_ALL	LATEST_ SCHEDULE_ LIMIT	Number of days later than the requested date to ship item.
CUST_PO_ NUMBER	OE_ORDER_ HEADERS_ALL	CUST_PO_ NUMBER
PAYMENT_ TYPE_CODE	OE_ORDER_ HEADERS_ALL	PAYMENT_ TYPE_CODE	Type of payment for orders such as cash, check, or credit.
PAYMENT_ AMOUNT	OE_ORDER_ HEADERS_ALL	PAYMENT_ AMOUNT	Amount of payment.
CHECK_NUMBER	OE_ORDER_ HEADERS_ALL	CHECK_ NUMBER	Check number if paid by check.
CREDIT_CARD_ CODE	OE_ORDER_ HEADERS_ALL	CREDIT_ CARD_CODE	Credit card name if paid by credit card.
CREDIT_CARD_ HOLDER_NAME	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ HOLDER_NAME	Credit card holder name if paid by credit card.
CREDIT_CARD_ NUMBER	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ NUMBER	Credit card number if paid by credit card.
CREDIT_CARD_ EXPIRATION_DATE	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ EXPIRATION_ DATE	Credit card expiration date if paid by credit card.
CREDIT_CARD_ APPROVAL_CODE	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ APPROVAL_ CODE	Credit card approval code if paid by credit card.
SOLD_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME
SOLD_TO_ORG	HZ_PARTIES	PARTY_NAME
SHIP_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME
SHIP_TO_ORG	HZ_CUST_ SITE_USES_ALL	LOCATION
SHIP_TO_ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1
SHIP_TO_ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2
SHIP_TO_ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3
SHIP_TO_ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4
SHIP_TO_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY
SHIP_TO_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY
SHIP_TO_STATE	HZ_CUST_ ACCT_SITES_ ALL	STATE
SHIP_TO_POSTAL_ CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE
SHIP_TO_PROVINCE	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE
SHIP_TO_COUNTRY	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY
SHIP_TO_ CUSTOMER_NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Ship To sales order number.
SHIP_TO_CUSTOMER	HZ_PARTIES	PARTY_NAME	Ship To sales order name.
INVOICE_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Invoice To organization.
INVOICE_ADDRESS1	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS1	Invoice To address line 1.
INVOICE_ADDRESS2	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS2	Invoice To address line 2.
INVOICE_ADDRESS3	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS3	Invoice To address line 3.
INVOICE_ADDRESS4	HZ_CUST_ ACCT_SITES_ ALL	ADDRESS4	Invoice To address line 4.
INVOICE_CITY	HZ_CUST_ ACCT_SITES_ ALL	CITY	Invoice To city.
INVOICE_COUNTY	HZ_CUST_ ACCT_SITES_ ALL	COUNTY	Invoice To county.
INVOICE_STATE	HZ_CUST_ ACCT_SITES_ ALL	STATE	Invoice To state.
INVOICE_POSTAL_ CODE	HZ_CUST_ ACCT_SITES_ ALL	POSTAL_CODE	Invoice To postal code.
INVOICE_ PROVINCE_INT	HZ_CUST_ ACCT_SITES_ ALL	PROVINCE	Invoice To province.
INVOICE_COUNTRY	HZ_CUST_ ACCT_SITES_ ALL	COUNTRY	Invoice To country.
INVOICE_CUSTOMER_ NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Invoice’s sales order number.
INVOICE_CUSTOMER	HZ_PARTIES	PARTY_NAME	Invoice’s sales order name.
DELIVER_TO_ORG	HZ_CUST_ SITE_USES_ ALL	LOCATION	Deliver To organization.
DELIVER_TO_CONTACT	OE_CONTACTS_V	NAME	Deliver To contact.
DELIVER_TO_ CUSTOMER_ NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Deliver To sales order number.
DELIVER_TO_ CUSTOMER	HZ_PARTIES	PARTY_NAME	Deliver To sales order name.
SOLD_TO_CONTACT	HZ_ORG_ CONTACTS	LAST_NAME \|\| FIRST_NAME \|\| TITLE
SHIP_TO_CONTACT_ FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME
SHIP_TO_CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME
SHIP_TO_CONTACT	HZ_ORG_ CONTACTS	LAST_NAME \|\| FIRST_NAME\|\|TITLE
INVOICE_TO_CONTACT _FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME	Invoice to contact first name.
INVOICE_TO_CONTACT _LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME	Invoice to contact last name.
INVOICE_TO_CONTACT	HZ_ORG_ CONTACTS	PERSON_ LAST_NAME \|\| PERSON_ FIRST_NAME \|\| TITLE	Invoice to contact name.
CREDIT_CARD_ APPROVAL_DATE	OE_ORDER_ HEADERS_ALL	CREDIT_CARD_ APPROVAL_ DATE
BOOKED_FLAG	OE_ORDER_ HEADERS_ALL	BOOKED_FLAG	Indicates order was booked.
CANCELLED_FLAG	OE_ORDER_ HEADERS_ALL	CANCELLED_ FLAG	Indicate orders was cancelled.
CHANGE_SEQUENCE	OE_ORDER_ HEADERS_ALL	CHANGE_ SEQUENCE
CUSTOMER_NUMBER	HZ_CUST_ ACCOUNTS	ACCOUNT_ NUMBER	Number of the sales order.
CUSTOMER_NAME	HZ_PARTIES	PARTY_NAME	Name of the sales order.
CHANGE_REQUEST_CODE			Not used for outbound transactions.
ORDERED_BY_ CONTACT_PERSON_ FIRST_NAME			Not used for outbound transactions.
ORDERED_BY_ CONTACT_PERSON_ LAST_NAME			Not used for outbound transactions.
HEADER_PO_CONTEXT			Purchase order context.Not used for outbound transactions.
PO_REVISION_DATE			Purchase order revision date. Not used for outbound transactions.
CHANGE_REASON			Not used for outbound transactions.
CHANGE_COMMENT			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
CLOSED_FLAG			Not used for outbound transactions.
REJECTED_FLAG			Not used for outbound transactions.
READY_FLAG			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.
FORCE_APPLY_FLAG			Not used for outbound transactions.

Field Name	Oracle Applications Table/View Name	Column Name	Description
LINE_ID	OE_ORDER_ LINES_ALL	LINE_ID	Order line identifier.
HEADER_ID	OE_ORDER_ LINES_ALL	HEADER_ID	Order header identifier that is the same HEADER_ID as the one on the order
LINE_NUMBER	OE_ORDER_ LINES_ALL	LINE_NUMBER	Line sequence number within the order.
FLOW_STATUS_CODE	OE_ORDER_ LINES_ALL	FLOW_STATUS_ CODE	Order line status flow.
CHANGE_SEQUENCE			Not used for outbound transactions.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
ORDER_SOURCE	OE_ORDERSOURCES	NAME
ORIG_SYS_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Identifier of line from a source system outside Oracle Order Management.
ORIG_SYS_ SHIPMENT_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ SHIPMENT_REF	Original shipment information for the order line in the external system.
SHIPMENT_NUMBER	OE_ORDER_ LINES_ALL	SHIPMENT_ NUMBER	System-generated identifier of a shipment within a line.
SPLIT_LINE_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Split line identifier of line from a source system outside Oracle Order Management.
LINE_TYPE	OE_TRANSACTION_ TYPES_TL	NAME	Line transaction type.
ITEM_TYPE_CODE	OE_ORDER_ LINES_ALL	ITEM_ TYPE_CODE
ITEM_TYPE	OE_LOOKUPS	MEANING
SOURCE_TYPE_CODE	OE_ORDER_ LINES_ALL	SOURCE_ TYPE_CODE
SOURCE_TYPE	OE_LOOKUPS	MEANING
SCHEDULE_STATUS_ CODE	OE_ORDER_ LINES_ALL	SCHEDULE_ STATUS_CODE
SCHEDULE_STATUS	OE_LOOKUPS	MEANING
INVENTORY_ITEM	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS
TOP_MODEL_ LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Top parent line.
LINK_TO_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Immediate parent component line.
ATO_LINE_REF	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	ATO configuration top model line.
EXPLOSION_DATE	OE_ORDER_ LINES_ALL	EXPLOSION_ DATE	Date when the included items were exploded and frozen.
COMPONENT_CODE	OE_ORDER_ LINES_ALL	COMPONENT_ CODE	Component within an exploded bill.
SORT_ORDER	OE_ORDER_ LINES_ALL	SORT_ORDER	Sorting sequence for a component in the ordered bill.
MODEL_GROUP_ NUMBER	OE_ORDER_ LINES_ALL	MODEL_GROUP_ NUMBER
OPTION_NUMBER	OE_ORDER_ LINES_ALL	OPTION_ NUMBER	Option or class in a model.
OPTION_FLAG	OE_ORDER_ LINES_ALL	OPTION_FLAG
SHIP_MODEL_ COMPLETE_FLAG	OE_ORDER_ LINES_ALL	SHIP_MODEL_ COMPLETE_ FLAG	Indicates the line is in ship–complete configuration.
SCHEDULE_ SHIP_DATE	OE_ORDER_ LINES_ALL	SCHEDULE_ SHIP_DATE	Date scheduled to ship item.
SCHEDULE_ ARRIVAL_DATE	OE_ORDER_ LINES_ALL	SCHEDULE_ ARRIVAL_DATE	Date scheduled for the item to arrive at the sales order site.
ACTUAL_ ARRIVAL_DATE	OE_ORDER_ LINES_ALL	ACTUAL_ ARRIVAL_DATE	Date the item actually arrived at sales order’s site
REQUEST_DATE	OE_ORDER_ LINES_ALL	REQUEST_DATE	Ordered item request date.
PROMISE_DATE	OE_ORDER_ LINES_ALL	PROMISE_DATE	Date promised to sales order to receive item.
DELIVERY_ LEAD_TIME	OE_ORDER_ LINES_ALL	DELIVERY_ LEAD_TIME
ORDERED_ QUANTITY	OE_ORDER_ LINES_ALL	ORDERED_ QUANTITY
ORDER_ QUANTITY_UOM	OE_ORDER_ LINES_ALL	ORDER_ QUANTITY_UOM	Ordered quantity unit of measurement.
SHIPPING_ QUANTITY	OE_ORDER_ LINES_ALL	SHIPPING_ QUANTITY
SHIPPING_ QUANTITY_UOM	OE_ORDER_ LINES_ALL	SHIPPING_ QUANTITY_UOM	Shipping quantity unit of measurement.
SHIPPED_ QUANTITY	OE_ORDER_ LINES_ALL	SHIPPED_ QUANTITY
CANCELLED_ QUANTITY	OE_ORDER_ LINES_ALL	CANCELLED_ QUANTITY
FULFILLED_ QUANTITY	OE_ORDER_ LINES_ALL	FULFILLED_ QUANTITY
PRICING_QUANTITY	OE_ORDER_ LINES_ALL	PRICING_QUANTITY
PRICING_ QUANTITY_UOM	OE_ORDER_ LINES_ALL	PRICING_ QUANTITY_UOM	Pricing quantity unit of measurement.
SOLD_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME
SOLD_TO_ORG	HZ_PARTIES	PARTY_NAME	Sales order to whom the item is sold.
SHIP_FROM_ORG	HR_ALL_ ORGANIZATION_ UNITS	NAME	Ship From organization
DELIVERY_NAME			Not used for outbound transactions.
SHIP_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Ship To organization.
SHIP_TO_ADDRESS1	HZ_LOCATIONS	ADDRESS1	Ship To address line 1.
SHIP_TO_ADDRESS2	HZ_LOCATIONS	ADDRESS2	Ship To address line 2.
SHIP_TO_ADDRESS3	HZ_LOCATIONS	ADDRESS3	Ship To address line 3.
SHIP_TO_ADDRESS4	HZ_LOCATIONS	ADDRESS4	Ship To address line 4.
SHIP_TO_CITY	HZ_LOCATIONS	CITY
SHIP_TO_COUNTY	HZ_LOCATIONS	COUNTY
SHIP_TO_STATE	HZ_LOCATIONS	STATE
SHIP_TO_ POSTAL_CODE	HZ_LOCATIONS	POSTAL_CODE
SHIP_TO_COUNTRY	HZ_LOCATIONS	COUNTRY
DELIVER_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Deliver To organization.
INVOICE_TO_ORG	HZ_CUST_SITE_ USES_ALL	LOCATION	Invoice To organization.
BILL_TO_ADDRESS1	HZ_LOCATIONS	ADDRESS1	Bill To address line 1.
BILL_TO_ADDRESS2	HZ_LOCATIONS	ADDRESS2	Bill To address line 2.
BILL_TO_ADDRESS3	HZ_LOCATIONS	ADDRESS3	Bill To address line 3.
BILL_TO_ADDRESS4	HZ_LOCATIONS	ADDRESS4	Bill To address line 4.
BILL_TO_CITY	HZ_LOCATIONS	CITY
BILL_TO_COUNTY	HZ_LOCATIONS	COUNTY
BILL_TO_STATE	HZ_LOCATIONS	STATE
BILL_TO_POSTAL_CODE	HZ_LOCATIONS	POSTAL_CODE
BILL_TO_COUNTRY	HZ_LOCATIONS	COUNTRY
SHIP_TO_CONTACT_ FIRST_NAME	HZ_PARTIES	PERSON_ FIRST_NAME
SHIP_TO_CONTACT_ LAST_NAME	HZ_PARTIES	PERSON_ LAST_NAME
SHIP_TO_CONTACT_ JOB_TITLE	HZ_ORG_ CONTACTS	JOB_TITLE
SHIP_TO_CONTACT	HZ_ORG_ CONTACTS	LAST_NAME\|\| FIRST_NAME\|\| TITLE
DELIVER_TO_CONTACT	OE_CONTACTS_V	NAME
INVOICE_TO_CONTACT	OE_CONTACTS_V	NAME
DROP_SHIP_FLAG			Not used for outbound transactions.
VEH_CUS_ITEM_ CUM_KEY	OE_ORDER_ LINES_ALL	VEH_CUS_ ITEM_CUM_ KEY_ID	Sales order item key.
CUST_PRODUCTION_ SEQ_NUM	OE_ORDER_ LINES_ALL	CUST_ PRODUCTION_ SEQ_NUM	Sales order production sequence number.
LOAD_SEQ_NUMBER			Load sequence number. Not used for outbound transactions.
OVER_SHIP_ REASON_CODE	OE_ORDER_ LINES_ALL	OVER_SHIP_ REASON_CODE
OVER_SHIP_ RESOLVED_FLAG	OE_ORDER_ LINES_ALL	OVER_SHIP_ RESOLVED_FLAG
AUTHORIZED_TO_ SHIP_FLAG	OE_ORDER_ LINES_ALL	AUTHORIZED_ TO_SHIP_FLAG	Indicates whether the demand lines are authorized to ship.
SHIP_TOLERANCE_ ABOVE	OE_ORDER_ LINES_ALL	SHIP_ TOLERANCE_ ABOVE	Over shipment or return tolerance.
SHIP_TOLERANCE_ BELOW	OE_ORDER_ LINES_ALL	SHIP_ TOLERANCE_ BELOW	Under shipment or return tolerance.
SHIP_SET_NAME	OE_SETS	SET_NAME
ARRIVAL_SET_NAME	OE_SETS	SET_NAME
PRICE_LIST	QP_LIST_ HEADERS_VL	NAME
PRICING_DATE	OE_ORDER_ LINES_ALL	PRICING_DATE
UNIT_LIST_PRICE	OE_ORDER_ LINES_ALL	UNIT_LIST_ PRICE
UNIT_LIST_PRICE_ PER_PQTY	OE_ORDER_ LINES_ALL	UNIT_LIST_ PRICE_PER_ PQTY
UNIT_SELLING_PRICE	OE_ORDER_ LINES_ALL	UNIT_SELLING_ PRICE
UNIT_SELLING_PRICE_ PER_PQTY	OE_ORDER_ LINES_ALL	UNIT_SELLING_ PRICE_PER_ PQTY
TAX_DATE	OE_ORDER_ LINES_ALL	TAX_DATE
TAX_CODE	OE_ORDER_ LINES_ALL	TAX_CODE
TAX_VALUE	OE_ORDER_ LINES_ALL	TAX_VALUE
CALCULATED_PRICE_ FLAG			Indicates if price is to be calculated. Not used for outbound transactions.
TAX_EXEMPT_FLAG	OE_ORDER_ LINES_ALL	TAX_EXEMPT_ FLAG	For the order line. Use: S for Standard E for Exempt R for Required
TAX_EXEMPT_NUMBER	OE_ORDER_ LINES_ALL	TAX_EXEMPT_ NUMBER	Tax exemption number.
TAX_EXEMPT_ REASON_CODE	OE_ORDER_ LINES_ALL	TAX_EXEMPT_ REASON_CODE	Tax exemption reason code.
TAX_EXEMPT_ REASON	AR_LOOKUPS	MEANING	Tax exemption reason.
TAX_POINT_CODE	OE_ORDER_ LINES_ALL	TAX_POINT_CODE
TAX_POINT	OE_LOOKUPS	MEANING
AGREEMENT	OE_AGREEMENTS_ TL	NAME
ACCOUNTING_RULE	RA_RULES	MEANING
INVOICING_RULE	RA_RULES	MEANING
PAYMENT_TERM	RA_TERMS_TL	NAME
DEMAND_CLASS_ CODE	OE_ORDER_ LINES_ALL	DEMAND_CLASS_ CODE
DEMAND_CLASS	OE_FND_COMMON_ LOOKUPS_V	MEANING
SHIPMENT_PRIORITY_ CODE	OE_ORDER_ LINES_ALL	SHIPMENT_ PRIORITY_CODE
SHIPMENT_PRIORITY	OE_LOOKUPS	MEANING
SHIPPING_METHOD_ CODE	OE_ORDER_ LINES_ALL	SHIPPING_ METHOD_CODE
SHIPPING_METHOD	OE_LOOKUPS	MEANING
FREIGHT_CARRIER_ CODE	OE_ORDER_ LINES_ALL	FREIGHT_ CARRIER_CODE
FREIGHT_CARRIER	ORG_FREIGHT	DESCRIPTION
FREIGHT_TERMS_ CODE	OE_ORDER_ LINES_ALL	FREIGHT_ TERMS_CODE
FREIGHT_TERMS	OE_LOOKUPS	MEANING
FOB_POINT_CODE	OE_ORDER_ LINES_ALL	FOB_POINT_CODE
FOB_POINT	AR_LOOKUPS	MEANING
SALESREP	RA_SALESREPS_ALL	NAME	Sales representative’s name.
SHIPPING_ INSTRUCTIONS	OE_ORDER_ LINES_ALL	SHIPPING_ INSTRUCTIONS
PACKING_ INSTRUCTIONS	OE_ORDER_ LINES_ALL	PACKING_ INSTRUCTIONS
RETURN_REASON_ CODE	OE_ORDER_ LINES_ALL	RETURN_ REASON_CODE
RETURN_REASON	FND_LOOKUP_VALUES	MEANING
REFERENCE_TYPE	OE_ORDER_ LINES_ALL	REFERENCE_ TYPE
REFERENCE_HEADER	OE_ORDER_ HEADERS_ALL	ORIG_SYS_ DOCUMENT_REF	Sales order header that the return line references.
REFERENCE_LINE	OE_ORDER_ LINES_ALL	ORIG_SYS_ LINE_REF	Sales order line that the return line references.
CREDIT_INVOICE_ NUMBER	HZ_CUST_ ACCOUNT_TRX_ALL	TRX_NUMBER
CUSTOMER_LINE_ NUMBER	OE_ORDER_ LINES_ALL	CUSTOMER_ LINE_NUMBER	Sales order line number.
CUSTOMER_PO_ NUMBER	OE_ORDER_ LINES_ALL	CUST_PO_ NUMBER	Sales order purchase number.
CUSTOMER_SHIPMENT_ NUMBER	OE_ORDER_ LINES_ALL	CUSTOMER_ SHIPMENT_ NUMBER	Sales order shipment number.
CUSTOMER_ITEM_ NAME	MTL_ CUSTOMER_ ITEMS	CUSTOMER_ ITEM_NUMBER	Sales order item name.
CUSTOMER_ITEM_ REVISION			Sales order item revision.Not used for outbound transactions.
CUSTOMER_ITEM_ NET_PRICE	OE_ORDER_ LINES_ALL	CUSTOMER_ ITEM_NET_ PRICE	Sales order item net price.
DEMAND_BUCKET_ TYPE_CODE	OE_ORDER_ LINES_ALL	DEMAND_ BUCKET_ TYPE_CODE	Demand bucket type code.
CUSTOMER_DOCK_ CODE	OE_ORDER_ LINES_ALL	CUSTOMER_ DOCK_CODE	Sales order dock code.
CUSTOMER_JOB	OE_ORDER_ LINES_ALL	CUSTOMER_ JOB	Sales order job.
CUSTOMER_ PRODUCTION_LINE	OE_ORDER_ LINES_ALL	CUSTOMER_ PRODUCTION_ LINE	Sales order production line.
CUST_MODEL_ SERIAL_NUMBER	OE_ORDER_ LINES_ALL	CUST_MODEL_ SERIAL_NUMBER	Sales order model serial number.
PROJECT	PA_PROJECTS_ ALL	NAME	Project name.
TASK	PA_TASKS	TASK_NAME	Task name.
FULFILLMENT_ SET_NAME	OE_SETS	SET_NAME	Fulfillment set name.
END_ITEM_UNIT_ NUMBER	OE_ORDER_ LINES_ALL	END_ITEM_ UNIT_NUMBER	Bill of material for building a specific mode or unit number controlled item.
ITEM_REVISION	OE_ORDER_ LINES_ALL	ITEM_REVISION	Item revision for a return line.
SCHEDULE_DATE			Not used for outbound transactions.
SHIP_TO_CONTACT_ AREA_CODE1			Ship To contact area 1. Not used for outbound transactions.
SHIP_TO_CONTACT_ AREA_CODE2			Ship To contact area 2. Not used for outbound transactions.
SHIP_TO_CONTACT_ AREA_CODE3			Ship To contact area 3. Not used for outbound transactions.
CUSTOMER_ITEM_ ID_TYPE			Sales order item type. Not used for outbound transactions.
INVOICE_SET_NAME			Invoice set name. Not used for outbound transactions.
TAX			Not used for outbound transactions.
SCHEDULE_ITEM_ DETAIL			Not used for outbound transactions.
DEMAND_STREAM			Not used for outbound transactions.
SERVICE_DURATION	OE_ORDER_ LINES_ALL	SERVICE_ DURATION
SERVICE_START_DATE	OE_ORDER_ LINES_ALL	SERVICE_ START_DATE
SERVICE_END_DATE	OE_ORDER_ LINES_ALL	SERVICE_ END_DATE
SERVICE_COTERMINATE_ FLAG	OE_ORDER_ LINES_ALL	SERVICE_ COTERMINATE_ FLAG
UNIT_SELLING_ PERCENT	OE_ORDER_ LINES_ALL	UNIT_ SELLING_ PERCENT	Percent actually charged to sales order for percent- based pricing.
UNIT_LIST_PERCENT	OE_ORDER_ LINES_ALL	UNIT_LIST_ PERCENT	Price list percentage of the item for percent–based pricing.
UNIT_PERCENT_ BASE_PRICE	OE_ORDER_ LINES_ALL	UNIT_PERCENT_ BASE_PRICE	Base price used for percent-based pricing.
SERVICE_NUMBER	OE_ORDER_ LINES_ALL	SERVICE_ NUMBER	Unique number to identify the service line.
CANCELLED_FLAG	OE_ORDER_ LINES_ALL	CANCELLED_ FLAG	Indicates whether the line was cancelled.
FULFILLED_FLAG	OE_ORDER_ LINES_ALL	FULFILLED_ FLAG	Indicates whether the line was fulfilled.
SERVICE_TXN_ REASON_CODE	OE_ORDER_ LINES_ALL	SERVICE_TXN_ REASON_CODE	Service transaction reason code.
SERVICE_TXN_ COMMENTS	OE_ORDER_ LINES_ALL	SERVICE_TXN_ COMMENTS	Service transaction comments.
CLOSED_FLAG			Indicates the line was closed. Not used for outbound transactions.
CONTRACT_PO_ NUMBER			Contract purchase order number. Not used for outbound transactions.
LINE_PO_CONTEXT			Line purchase order context. Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
CHANGE_REASON			Not used for outbound transactions.
CHANGE_COMMENTS			Not used for outbound transactions.
REJECTED_FLAG			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_PRICE_ ADJUSTMENTS	HEADER_ID	Order header identifier that is the same HEADER_ID as the one on the order.
LINE_ID	OE_PRICE_ ADJUSTMENTS	LINE_ID	Order line identifier that is the same LINE_ID as the one on the order line.
ADJUSTED_ AMOUNT	OE_PRICE_ ADJUSTMENTS	ADJUSTED_ AMOUNT	Adjusted amount at the adjustment level.
ADJUSTED_ AMOUNT_PER_PQTY	OE_PRICE_ ADJUSTMENTS	ADJUSTED_ AMOUNT_ PER_PQTY	Adjusted amount per quantity.
APPLIED_FLAG	OE_PRICE_ ADJUSTMENTS	APPLIED_FLAG	Indicates whether the adjustment has been applied to the order line. For string manual discounts, which are not yet applied by the user.
ARITHMETIC_ OPERATOR	OE_PRICE_ ADJUSTMENTS	ARITHMETIC_ OPERATOR	Qualifies the value in operand by using percentage, amount, or new price.
AUTOMATIC_FLAG	OE_PRICE_ ADJUSTMENTS	AUTOMATIC_FLAG	Indicates whether the discount was applied automatically.
CHANGE_REASON_ CODE	OE_PRICE_ ADJUSTMENTS	CHANGE_REASON_ CODE	Reason code for making a change to the adjustment value.
CHANGE_REASON_ TEXT	OE_PRICE_ ADJUSTMENTS	CHANGE_REASON_ TEXT	Description of reason code.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
CHARGE_TYPE_CODE	OE_PRICE_ ADJUSTMENTS	CHARGE_TYPE_ CODE
CHARGE_SUBTYPE_ CODE	OE_PRICE_ ADJUSTMENTS	CHARGE_SUBTYPE_ CODE
COST_TYPE	WSH_FREIGHT_ COST_TYPES	FREIGHT_COST_ TYPE_CODE	Freight cost type.
COST_UNIT_AMOUNT	WSH_FREIGHT_ COSTS	UNIT_AMOUNT	Amount for freight costs in unit.
COST_QUANTITY	WSH_FREIGHT_ COSTS	QUANTITY
COST_AMOUNT	WSH_FREIGHT_ COSTS	TOTAL_AMOUNT	The total amount of freight cost is the freight cost unit amount multiplied by the freight quantity.
COST_CURRENCY_ CODE	WSH_FREIGHT_ COSTS	CURRENCY_ CODE	Freight cost currency code.
CREDIT_OR_CHARGE_ FLAG	OE_PRICE_ ADJUSTMENTS	CREDIT_OR_ CHARGE_FLAG	Indicates whether the adjustment record is a credit or charge to a sales order.
DISCOUNT_NAME	SO_DISCOUNTS	NAME
LINE_DISCOUNT_NAME	SO_DISCOUNTS	NAME
ESTIMATED_FLAG	OE_PRICE_ ADJUSTMENTS	ESTIMATED_ FLAG	Indicates whether the charge amount is estimated or fixed.
INVOICED_FLAG	OE_PRICE_ ADJUSTMENTS	INVOICED_ FLAG	Indicates whether the charge is invoiced.
INC_IN_SALES_ PERFORMANCE	OE_PRICE_ ADJUSTMENTS	INC_IN_SALES_ PERFORMANCE	Indicates whether the charge should be included in sales performance calculation.
INCLUDE_ON_ RETURNS_FLAG	OE_PRICE_ ADJUSTMENTS	INCLUDE_ON_ RETURNS_FLAG	Indicates whether the adjustment is returnable.
LIST_NAME	QP_LIST_HEADERS_TL	NAME	Name of modifier.
LIST_LINE_TYPE_ CODE	OE_PRICE_ ADJUSTMENTS	LIST_LINE_ TYPE_CODE	Line type of the modifier.
LIST_LINE_NUMBER	OE_PRICE_ ADJUSTMENTS	LIST_LINE_NO
MODIFIED_FROM	OE_PRICE_ ADJUSTMENTS	MODIFIED_FROM	Stores the value of the upgraded item code.
MODIFIED_TO	OE_PRICE_ ADJUSTMENTS	MODIFIED_TO	Stores the value of the upgraded item code.
MODIFIER_ MECHANISM_ TYPE_CODE	OE_PRICE_ ADJUSTMENTS	MODIFIER_ MECHANISM_ TYPE_CODE
OPERAND	OE_PRICE_ ADJUSTMENTS	OPERAND	Stores the adjustment value, qualified by an arithmetic operator.
OPERAND_ PER_PQTY	OE_PRICE_ ADJUSTMENTS	OPERAND_ PER_PQTY	Operand per quantity.
OPERATION_CODE			Not used for outbound transactions.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
ORIG_SYS_ DISCOUNT_REF	OE_PRICE_ ADJUSTMENTS	ORIG_SYS_ DISCOUNT_REF	Original system discount reference.
PARENT_ ADJUSTMENT_ NAME	QP_LIST_ HEADERS_TL	NAME	Parent adjustment name.
PRICING_PHASE	QP_PRICING_ PHASES	NAME	Pricing phase name.
PERCENT	OE_PRICE_ ADJUSTMENTS	PERCENT	Percentage.
TAX_CODE	OE_PRICE_ ADJUSTMENTS	TAX_CODE	Tax code for the charges.
UPDATE_ ALLOWED	OE_PRICE_ ADJUSTMENTS	UPDATE_ ALLOWED	Indicates whether this adjustment can be overridden.
UPDATED_FLAG	OE_PRICE_ ADJUSTMENTS	UPDATED_ FLAG	Indicates whether the user has modified this row.
VERSION_NUMBER			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.
FREIGHT_CODE		COST_ID

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_ORDER_ PRICE_ATTRIBS	HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	OE_ORDER_ PRICE_ATTRIBS	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORIG_SYS_ATTS_REF	OE_ORDER_ PRICE_ATTRIBS	ORIG_SYS_ ATTS_REF	Original System Attribute Reference.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.
FLEX_TITLE	OE_ORDER_ LINES_ALL	FLEX_TITLE	Name of the pricing context’s flex structure.
PRICING_CONTEXT	OE_ORDER_ LINES_ALL	PRICING_ CONTEXT

Field Name	Oracle Applications Table/View Name	Column Name	Description
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
ORIG_SYS_ LOTSERIAL_REF	OE_LOT_ SERIAL_ NUMBERS	ORIG_SYS_ LOTSERIAL_REF	Original system lot serial reference.
LOT_NUMBER	OE_LOT_ SERIAL_ NUMBERS	LOT_NUMBER
LINE_ID	OE_LOT_ SERIAL_ NUMBERS	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
FROM_SERIAL_NUMBER	OE_LOT_ SERIAL_ NUMBERS	FROM_ SERIAL_ NUMBER	Serial number range starting number. If TO_SERIAL_NUMBER is null, then the only serial number is FROM_SERIAL_NUMBER.
TO_SERIAL_NUMBER	OE_LOT_ SERIAL_ NUMBERS	TO_SERIAL_ NUMBER	Serial number range ending number.
QUANTITY	OE_LOT_ SERIAL_ NUMBERS	QUANTITY	Lot or serial number quantity. This should match the serial number range for serial number controlled items.
CHANGE_REQUEST_CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_SALES_ CREDITS	HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	OE_SALES_ CREDITS	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORIG_SYS_ CREDIT_REF	OE_SALES_ CREDITS	ORIG_SYS_ CREDIT_REF	Original System Credit Reference.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same as the one in the order.
QUOTA_FLAG	OE_SALES_ CREDITS	QUOTA_FLAG	Indicates revenue or non-revenue based credit.
PERCENT	OE_SALES_ CREDITS	PERCENT	Indicates sales credit percentage for a sales representative.
SALESREP	RA_SALESREPS_ ALL	NAME	Sales representative’s name.
SALES_CREDIT_TYPE	OE_SALES_ CREDIT_TYPES	NAME	Sales credit type.
CHANGE_REQUEST_ CODE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	MTL_RESERVATIONS	DEMAND_ SOURCE_ HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	MTL_RESERVATIONS	DEMAND_ SOURCE_ LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORDER_SOURCE	OE_ORDER_ SOURCES	NAME	Order source name that is the same the one in the order.
REVISION	MTL_RESERVATIONS	REVISION	For revision controlled reserved item.
ITEM_CODE	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS	Reserved item.
SUBINVENTORY_ CODE	MTL_RESERVATIONS	SUBINVENTORY_ CODE	Subinventory where reserved item resides.
LOCATOR	MTL_ITEM_ LOCATIONS_KFV	CONCATENATED_ SEGMENTS	Locator where reserved item resides.
LOT_NUMBER	MTL_RESERVATIONS	LOT_NUMBER	For lot controlled reserved item.
QUANTITY	MTL_RESERVATIONS	RESERVATION_ QUANTITY	Quantity reserved.
ORIG_SYS_ RESERVATION_REF			Original System Reservation Reference. Not used for outbound.
CHANGE_SEQUENCE			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.

Field Name	Oracle Applications Table/View Name	Column Name	Description
HEADER_ID	OE_ORDER_ HEADERS_ALL	HEADER_ID	Order header identifier that is the same as the HEADER_ID in the order.
LINE_ID	OE_ORDER_ LINES_ALL	LINE_ID	Order line identifier that is the same as the LINE_ID in the order lines.
ORDER_SOURCE			Not used for outbound transactions.
CHANGE_SEQUENCE			Not used for outbound transactions.
HOLD_NAME			Not used for outbound transactions.
HOLD_TYPE_CODE			Not used for outbound transactions.
HOLD_UNTIL_DATE			Not used for outbound transactions.
RELEASE_REASON_CODE			Not used for outbound transactions.
COMMENTS			Not used for outbound transactions.
CONTEXT			Not used for outbound transactions.
OPERATION_CODE			Not used for outbound transactions.
STATUS_FLAG			Not used for outbound transactions.