Order Import Mappings
The Import ERP Transaction process uses defined mappings to bring order data fields into the corresponding transaction data fields. In the Setup and Maintenance work area, use the Manage Incentive Import Mappings task.
Choose the Orders import type. The target region of the table is for the target transaction attributes. The source region is for the order data attributes. The list of source objects is from the lookup type ORA_CN_ORD_SOURCE. Here's the provided list of objects:
- Order Fulfill Lines
- Order Headers
- Order Lines
- Order Charges
- Sales Credits
- Locations
- Item Category
These attributes are for the Order Fulfill Lines object.
| Column Name | User Name |
|---|---|
| COLUMN_NAME | USER_NAME |
| ACTION_TYPE_CODE | Action Type Code |
| ACTUAL_COMPLETION_DATE | Actual Completion Date |
| ACTUAL_SHIP_DATE | Actual Ship Date |
| BILL_TO_CUSTOMER_ID | Bill to Customer |
| CANCELED_FLAG | Canceled Flag |
| CANCELED_QTY | Canceled Quantity |
| CONTRACT_END_DATE | Contract End Date |
| CONTRACT_START_DATE | Contract Start Date |
| CUSTOMER_PO_LINE_NUMBER | Customer PO Line Number |
| CUSTOMER_PO_NUMBER | Customer PO Number |
| EXTENDED_AMOUNT | Extended Number |
| FULFILLED_QTY | Fulfilled Quantity |
| FULFILLMENT_DATE | Fulfillment Date |
| FULFILLMENT_MODE | Fulfillment Mode |
| FULFILL_LINE_ID | Fulfill Line ID |
| FULFILL_LINE_NUMBER | Fulfill Line Number |
| HEADER_ID | Header ID |
| INVENTORY_ITEM_ID | Inventory Item |
| INVOICEABLE_ITEM_FLAG | Invoiceable Item Flag |
| INVOICE_ENABLED_FLAG | Invoice Enabled Flag |
| ITEM_SUB_TYPE_CODE | Item Sub Type Code |
| ITEM_TYPE_CODE | Item Type Code |
| LINE_ID | Line ID |
| LINE_TYPE_CODE | Line Type Code |
| ON_HOLD | On Hold |
| ORDERED_QTY | Ordered Quantity |
| ORDERED_UOM | Ordered UOM |
| ORG_ID | Org ID |
| ORIG_SYS_DOCUMENT_LINE_REF | Orig Sys Document Line Reference |
| ORIG_SYS_DOCUMENT_REF | Orig System Document Reference |
| PARENT_FULFILL_LINE_ID | Parent Fulfill Line Id |
| PROMISE_ARRIVAL_DATE | Promise Arrival Date |
| PROMISE_SHIP_DATE | Promise Ship Date |
| PURCHASING_UOM | Purchasing UOM |
| QUANTITY_PER_MODEL | Quantity Per Model |
| RESERVED_QTY | Reserved Quantity |
| RMA_DELIVERED_QTY | RMA Delivered Quantity |
| ROOT_PARENT_FULFILL_LINE_ID | Root Parent Fulfill Line Id |
| SALESPERSON_ID | Salesperson ID |
| SALES_PRODUCT_TYPE_CODE | Sales Product Type Code |
| SCHEDULE_ARRIVAL_DATE | Schedule Arrival Date |
| SCHEDULE_SHIP_DATE | Schedule Ship Date |
| SERVICE_CANCEL_DATE | Service Cancel Date |
| SERVICE_DURATION | Service Duration |
| SERVICE_DURATION_PERIOD_CODE | Service Duration Period Code |
| SHIPPABLE_FLAG | Shippable Flag |
| SHIPPED_QTY | Shipped Quantity |
| SHIPPED_UOM | Shipped UOM |
| SHIP_TO_CUSTOMER_ID | Ship To Customer |
| SOURCE_LINE_NUMBER | Source Line Number |
| SOURCE_ORDER_NUMBER | Source Order Number |
| SOURCE_ORDER_SYSTEM | Source Order System |
| SPLIT_FROM_FLINE_ID | Split From FLine ID |
| STATUS_CODE | Status Code |
| TOTAL_CONTRACT_AMOUNT | Total Contract Amount |
| TOTAL_CONTRACT_QUANTITY | Total Contract Quantity |
| UNIT_QUANTITY | Unit Quantity |
| UNIT_SELLING_PRICE | Unit Selling Price |
These attributes are for the Order Headers object.
| Column Name | User Name |
|---|---|
| ORDERED_DATE | Ordered Date |
| ORDER_NUMBER | Order Number |
| ORDER_TYPE_CODE | Order Type |
| STATUS_CODE | Order Status Code |
This attribute is for the Order Lines object.
| Column Name | User Name |
|---|---|
| LINE_NUMBER | Line Number |
These attributes are for the Order Charges object.
| Column Name | User Name |
|---|---|
| HEADER_CURRENCY_CODE | Header Currency Code |
| HEADER_CURRENCY_EXT_AMOUNT | Total Order Line Amount |
These attributes are for the Sales Credits object.
| Column Name | User Name |
|---|---|
| PERCENT | Percent |
| SALESPERSON_ID | Credited Salesperson ID |
| SALES_CREDIT_TYPE_ID | Credit Type |
This attribute is for the Item Category object.
| Column Name | User Name |
|---|---|
| CATEGORY_NAME | Item Category |
These attributes are for the Locations object.
| Column Name | User Name |
|---|---|
| BILL_TO_CITY | Bill to City |
| BILL_TO_COUNTRY | Bill to Country |
| BILL_TO_COUNTY | Bill to County |
| BILL_TO_POSTAL_CODE | Bill to Postal Code |
| BILL_TO_PROVINCE | Bill to Province |
| BILL_TO_STATE | Bill to State |
| SHIP_TO_CITY | Ship to City |
| SHIP_TO_COUNTRY | Ship to Country |
| SHIP_TO_COUNTY | Ship to County |
| SHIP_TO_POSTAL_CODE | Ship to Postal Code |
| SHIP_TO_PROVINCE | Ship to Province |
| SHIP_TO_STATE | Ship to State |
The import mappings for orders works very much like participant import mappings. These rules apply to order mapping:
-
Order Management must be on the same instance as Incentive Compensation.
-
You can have only one mapping for each incentive compensation business unit.
-
A target attribute can only be mapped to one source attribute.
-
Mappings must be present for any required transaction fields and required credit fields.