| Quote to Order (Place Order) Mappings sheet | ||||||||||||
| This sheet contains the following tables: | ||||||||||||
| Header (Siebel Quote to Siebel Order) | ||||||||||||
| Item (Siebel Quote to Siebel Order) | ||||||||||||
| Credit Card Component (Siebel Quote to Siebel Order) | ||||||||||||
| Integration Objects: | SAP 4x Quote | |||||||||||
| SAP 4x Order (Sync) | Copy of SAP 4x Order (Sync) but modified for Quote Place Order Data Flow. | |||||||||||
| Transaction Description: | Creates Siebel Order from Siebel Quote (and then Submit to SAP Using 7.x Order Create Mappings). | For Siebel Order to SAP Order Mappings, refer to Order Create Mappings. | ||||||||||
| Workflow: | Quote To Order SAP 4x Submit | |||||||||||
| Business Service (Name): | Order - SAP 4x Maps | |||||||||||
| Business Service (Display Name): | SAP 4x Mapping - Order | |||||||||||
| Map Functions: | QuoteToOrderSubmit | |||||||||||
| Siebel View: | Quotes > All Quotes > Line Items(SAP) | |||||||||||
| Siebel View: | Orders > All Sales Orders > Line Items(SAP) | |||||||||||
| Header (Siebel Quote to Siebel Order) | ||||||||||||
| Siebel Quote | Siebel Order | |||||||||||
| Siebel Client | Siebel Object Manager | Siebel Schema | Siebel Client | Siebel Object Manager | Siebel Schema | |||||||
| Applet | Field | Business Component | Field | Table | Column | Applet | Field | Business Component | Field | Table | Column | Comments |
| Quote Entry - SAP 4x Applet | Account | Quote | Account Id/Account | S_DOC_QUOTE.TARGET_OU_ID --> S_ORG_EXT | NAME | Order Entry - SAP 4x order Form Applet | Account | Order Entry - Orders | Account Id | S_ORDER.ACCNT_ID -> S_ORG_EXT | NAME | |
| Quote Entry - SAP 4x Applet | Bill To Account | Quote | Bill To Account Id/Bill To Account | S_DOC_QUOTE.BL_OU_ID --> S_ORG_EXT | NAME | Order Entry - SAP 4x order Form Applet | Bill To Account | Order Entry - Orders | Bill To Account Id | S_ORDER.BL_OU_ID -> S_ORG_EXT | NAME | |
| Quote Entry - SAP 4x Applet | Ship To Account | Quote | Ship To Account Id/Ship To Account | S_DOC_QUOTE.SHIP_OU_ID --> S_ORG_EXT | NAME | Order Entry - SAP 4x order Form Applet | Ship To Account | Order Entry - Orders | Ship To Account Id | S_ORDER.SHIP_OU_ID -> S_ORG_EXT | NAME | |
| N/A | N/A | Quote | Payer Account Id | S_DOC_QUOTE.PAY_OU_ID --> S_ORG_EXT | PAY_OU_ID | N/A | N/A | Order Entry - Orders | Payer Account Id | S_ORDER.PAY_OU_ID -> S_ORG_EXT | ||
| N/A | N/A | Quote | 'Y' | N/A | N/A | Order Entry - Order Form Applet | Active | Order Entry - Orders | Active | S_ORDER | ACTIVE_FLG | |
| Quote Entry - SAP 4x Applet | First Name + Last Name | Quote | Contact Id | S_DOC_QUOTE.CON_PER_ID --> S_CONTACT | FST_NAME/LAST_NAME | Order Entry - Order Form Applet | First Name + Last Name | Order Entry - Orders | Contact Id | S_ORDER.CON_ID -> S_CONTACT | FST_NAME + LAST_NAME | |
| Quote Terms Form Applet | Shipping Charges | Quote | Freight | S_DOC_ORDER | FRGHT_AMT | Order Entry - Order Terms Form Applet | Shipping Charges | Order Entry - Orders | Freight | S_ORDER | FRGHT_AMT | |
| Quote Terms Form Applet | Shipping Terms | Quote | Freight Terms | S_DOC_ORDER | FRGHT_TERMS_CD | Order Entry - Order Terms Form Applet | Shipping Terms | Order Entry - Orders | Freight Terms | S_ORDER | FRGHT_TERMS_CD | |
| Quote Terms Form Applet | Shipping Info | Quote | Freight Terms Info | S_DOC_ORDER | FRGHT_TERMS_INFO | Order Entry - Order Terms Form Applet | Shipping Info | Order Entry - Orders | Freight Terms Info | S_ORDER | FRGHT_TERMS_INFO | |
| Quote Entry Applet | Currency | Quote | Currency Code | S_DOC_QUOTE | CURCY_CD | Order Entry - Order Form Applet | Currency | Order Entry - Orders | Currency Code | S_ORDER | CURCY_CD | |
| N/A | N/A | N/A | 'Sales Order; | N/A | N/A | Order Entry - Order Form Applet | Type | Order Entry - Orders | Order Type | S_ORDER.ORDER_TYPE_ID -> S_ORDER_TYPE | NAME | |
| Quote Entry Applet | Organization | Quote | Primary Organization Id | S_DOC_QUOTE | BU_ID | Order Entry - Order Form Applet | Organization | Order Entry - Orders | Primary Organization Id | S_ORDER | BU_ID | |
| N/A | N/A | N/A | Null | N/A | N/A | Order Entry - SAP 4x order Form Applet | Order # | Order Entry - Orders | Integration Id | S_ORDER | INTEGRATION_ID | |
| N/A | N/A | Quote | Partial Ship | S_DOC_ORDER | ALW_PART_SHIP_FLG | Order Entry - SAP 4x order Form Applet | Partial Ship | Order Entry - Orders | Partial Ship | S_ORDER | ALW_PART_SHIP_FLG | |
| Quote Terms Form Applet | Payment Terms | Quote | Payment Term | S_DOC_QUOTE.PAYMENT_TERM_ID --> S_PAYMENT_TERM | NAME | Order Entry - Order Terms Form Applet | Payment Terms | Order Entry - Orders | Payment Term | S_ORDER.PAYMENT_TERM_ID -> S_PAYMENT_TERM | NAME | |
| Quote Entry - SAP 4x Applet | Price List | Quote | Price List / Price List Id | S_DOC_QUOTE | PRI_LST_ID | Order Entry - Order Form Applet | Price List / Price List Id | Order Entry - Orders | Price List Id | S_ORDER | PRI_LST_ID | |
| Quote Entry - SAP 4x Applet | Req Delivery Date | Quote | Requested Ship Date | S_DOC_ORDER | REQ_DLVRY_DT | Order Entry - Order Form Applet (Sales) | Requested Ship | Order Entry - Orders | Requested Ship Date | S_ORDER | REQ_SHIP_DT | |
| N/A | N/A | Quote | Purchase order Number | S_DOC_ORDER | PO_NUM | Order Entry - SAP 4x order Form Applet | Account Order # | Order Entry - Orders | Account Order Number | S_ORDER | ACCNT_ORDER_NUM | If PO Number is null then defualt Quote No |
| N/A | N/A | Quote | Id | S_DOC_QUOTE | ROW_ID | Order Entry - Order Form Applet (Sales) | Quote Id | Order Entry - Orders | Quote Id | S_ORDER | QUOTE_ID | |
| Item (Siebel Quote to Siebel Order) | ||||||||||||
| Siebel Quote | Siebel Order | |||||||||||
| Siebel Client | Siebel Object Manager | Siebel Schema | Siebel Client | Siebel Object Manager | Siebel Schema | |||||||
| Applet | Field | Business Component | Field | Table | Column | Applet | Field | Business Component | Field | Table | Column | Comments |
| Quote Item List Applet | Covered Product | Quote Item | Covered Product | S_QUOTE_ITEM.SQ_ITEM_PROD_ID --> S_PROD_INT | NAME | Order Entry - Line Item List Applet (Sales) | Covered Product | Order Entry - Line Items | Covered Product | S_ORDER_ITEM.PROD_ID -> S_PROD_INT | NAME | |
| N/A | N/A | Quote Item | Base Price | S_QUOTE_ITEM | BASE_UNIT_PRI | N/A | N/A | Order Entry - Line Items | Base Price | S_ORDER_ITEM | BASE_UNIT_PRI | |
| Quote Item - SAP 4x List Applet | Comments | Quote Item | Description | S_QUOTE_ITEM | DESC_TEXT | N/A | N/A | Order Entry - Line Items | Description | S_ORDER_ITEM | DESC_TEXT | |
| Quote Item - SAP 4x List Applet | Disc Amount | Quote Item | Discount Amount | S_QUOTE_ITEM | DISCNT_AMT | Order Entry - SAP 4x Line Item List Applet (Sales) | Discount Amount | Order Entry - Line Items | Discount Amount | S_ORDER_ITEM | DISCNT_AMT | |
| Quote Item - SAP 4x List Applet | Disc % | Quote Item | Discount Percent | S_QUOTE_ITEM | DISCNT_PERCENT | Order Entry - SAP 4x Line Item List Applet (Sales) | Discount % | Order Entry - Line Items | Discount Percent | S_ORDER_ITEM | DISCNT_PERCENT | |
| Quote Item - SAP 4x List Applet | Req Delivery Date | Quote Item | Requested Delivery Date | S_QUOTE_ITEM | REQ_DLVRY_DT | Order Entry - SAP 4x Line Item List Applet (Sales) | Req Del Date | Order Entry - Line Items | Due Date | S_ORDER_ITEM | REQ_SHIP_DT | |
| N/A | N/A | Quote Item | Period Id | S_QUOTE_ITEM | EFF_PRI_PERIOD_ID | N/A | N/A | Order Entry - Line Items | Effective Pricing Period Id | S_ORDER_ITEM | EFF_PRI_PERIOD_ID | |
| Quote Item - SAP 4x List Applet | Freight | Quote Item | Freight Amount | S_QUOTE_ITEM | FRGHT_AMT | Order Entry - SAP 4x Line Item List Applet (Sales) | Freight (SAP) | Order Entry - Line Items | Freight Amount | S_ORDER_ITEM | FRGHT_AMT | |
| Quote Item - SAP 4x List Applet | Start Price | Quote Item | Adjusted List Price | S_QUOTE_ITEM | ADJ_UNIT_PRI | Order Entry - SAP 4x Line Item List Applet (Sales) | Start Price | Order Entry - Line Items | Adjusted List Price | S_ORDER_ITEM | ADJ_UNIT_PRI | Calculated Field |
| Quote Item - SAP 4x List Applet | Line | Quote Item | Line Number | S_QUOTE_ITEM | LN_NUM | Order Entry - SAP 4x Line Item List Applet (Sales) | Line # | Order Entry - Line Items | Line Number | S_ORDER_ITEM | LN_NUM | |
| Quote Item List Applet | Customer Note | Quote Item | Note | S_QUOTE_ITEM | LINE_NOTE | Order Entry - SAP 4x Line Item List Applet (Sales) | Customer Note | Order Entry - Line Items | Note | S_ORDER_ITEM | LINE_NOTE | |
| Quote Item - SAP 4x List Applet | Partial Ship Flag | Quote Item | Partial Ship | S_QUOTE_ITEM | ALW_PART_SHIP_FLG | Order Entry - SAP 4x Line Item List Applet (Sales) | Partial Ship | Order Entry - Line Items | Partial Ship | S_ORDER_ITEM | ALW_PART_SHIP_FLG | |
| Quote Item - SAP 4x List Applet | Pricing Comments | Quote Item | Pricing Comments | S_QUOTE_ITEM | PRICING_COMMENT | Order Entry - SAP 4x Line Item List Applet (Sales) | Pricing comments | Order Entry - Line Items | Pricing Comments | S_ORDER_ITEM | PRICING_COMMENT | |
| Quote Item - SAP 4x List Applet | Product | Quote Item | Product Id | S_QUOTE_ITEM | PROD_ID | Order Entry - SAP 4x Line Item List Applet (Sales) | Product | Order Entry - Line Items | Product Id | S_ORDER_ITEM | PROD_ID | Product Id field instead of Product field is used to improve performance |
| Quote Item - SAP 4x List Applet | Qty Req | Quote Item | Quantity Requested | S_QUOTE_ITEM | QTY_REQ | Order Entry - SAP 4x Line Item List Applet (Sales) | Qty Req | Order Entry - Line Items | Quantity Requested | S_ORDER_ITEM | QTY_REQ | |
| N/A | N/A | Quote Item | Source Inventory Loc Id | S_QUOTE_ITEM | SRC_INVLOC_ID | Order Entry - SAP 4x Line Item List Applet (Sales) | Delivering Plant | Order Entry - Line Items | Source Inventory Loc Id | S_ORDER_ITEM | SRC_INVLOC_ID | Source Inventory Loc Id field instead of Source Inventory field is used to improve performance |
| Quote Item - SAP 4x List Applet | Discount Price | Quote Item | Unit Price | S_QUOTE_ITEM | UNIT_PRI | Order Entry - SAP 4x Line Item List Applet (Sales) | Discount Price | Order Entry - Line Items | Unit Price | S_ORDER_ITEM | UNIT_PRI | |
| Credit Card Component (Siebel Quote to Siebel Order) | ||||||||||||
| Siebel Quote | Siebel Order | |||||||||||
| Siebel Client | Siebel Object Manager | Siebel Schema | Siebel Client | Siebel Object Manager | Siebel Schema | |||||||
| Applet | Field | Business Component | Field | Table | Column | Applet | Field | Business Component | Field | Table | Column | Comments |
| Quote Payment Form Applet | Authorization Code | Quote | Credit Card Authorization Code | S_DOC_ORDER | CRDT_CRD_APPR_CD | Payment Detail - Credit Card | Authorization Code | Payments | Authorization Code | S_SRC_PAYMENT | CRDT_CRD_APPR_CD | |
| Quote Payment Form Applet | Transaction Amount | Quote | Credit Card Transaction Amount | S_DOC_ORDER | CRDT_CRD_TXN_AMT | Payment Detail - Credit Card | Transaction Amount | Payments | Transaction Amount | S_SRC_PAYMENT | PAY_AMT | |
| Quote Payment Form Applet | Transaction Status | Quote | Credit Card Transaction Status | S_DOC_ORDER | CRDTCD_TXN_STAT_CD | Payment Detail - Credit Card | Payment Status | Payments | Payment Status | S_SRC_PAYMENT | PAY_STAT_CD | |
| Quote Payment Form Applet | Expiration Month | Quote | Credit Card Expiration Month | S_DOC_ORDER | CRDT_CRD_EXP_MO_CD | Payment Detail - Credit Card | Expiration Month | Payments | Expiration Month | S_SRC_PAYMENT | CRDT_CRD_EXP_MO_CD | |
| Quote Payment Form Applet | Expiration Year | Quote | Credit Card Expiration Year | S_DOC_ORDER | CRDT_CRD_EXP_YR_CD | Payment Detail - Credit Card | Expiration Year | Payments | Expiration Year | S_SRC_PAYMENT | CRDT_CRD_EXP_YR_CD | |
| Quote Payment Form Applet | Cardholder's Name | Quote | Credit Card Holder | S_DOC_ORDER | CRDHOLDER_NAME | Payment Detail - Credit Card | Credit Card Holder | Payments | Card Holder | S_SRC_PAYMENT | CC_HOLDER_NAME | |
| Quote Payment Form Applet | Credit Card Type | Quote | Credit Card Name | S_DOC_ORDER | CRDT_CRD_NAME | Payment Detail - Credit Card | Payment Type | Payments | Payment Type | S_SRC_PAYMENT | TYPE_CD | |
| Quote Payment Form Applet | Credit Card # | Quote | Credit Card Number | S_DOC_ORDER | CC_NUMBER | Payment Detail - Credit Card | Credit Card # | Payments | Account Number | S_SRC_PAYMENT | CC_NUM | |
| N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Payments | Payment Method | S_SRC_PAYMENT | PAY_TYPE_CD | |