Quote to Order (Validate) Mappings sheet
This sheet contains the following tables:
Header Siebel Quote to Siebel Order (Integration Object Instance)
Item (Siebel Quote to Siebel Order)
Header (Siebel Order to Siebel Quote)
Item (Siebel Order to Siebel Quote)
Credit Card Component (Siebel Order to Siebel Quote)
Schedule Line (Siebel Order to Siebel Quote)
Integration Objects: SAP 4x Quote Used for Quote Query
SAP 4x Quote(Sync) Used for Quote Synchronization
SAP 4x Order (Quote) Copy of SAP 4x Order (Sync) but modified for Quote Data Flows
SAP 4x Order (Sync)
Transaction Description: Validates Siebel Quote from SAP (First Populates Siebel Order Integration Object Instance and then uses Order Simulate Mappings to Validate from SAP). For Siebel Order to SAP Order Mappings, refer to Order Create Mappings.
Workflow: Quote To Order SAP 4x Validate
Business Service (Name): Order - SAP 4x Maps
Business Service (Display Name): SAP 4x Mapping - Order
Map Functions: QuoteToOrder Refer to Order Simulate mappings for Siebel Order to SAP Order part.
OrderToQuote
Siebel View: Quotes > All Quotes >Line Items(SAP)
Siebel View: Orders > All Sales Orders > Line Items(SAP)
Header Siebel Quote to Siebel Order (Integration Object Instance)
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 Integration Id/Account S_DOC_QUOTE.TARGET_OU_ID --> S_ORG_EXT NAME Order Entry - SAP 4x order Form Applet Account Order Entry - Orders Account Integration Id/Account S_ORDER.ACCNT_ID -> S_ORG_EXT NAME
Quote Entry - SAP 4x Applet Bill To Account Quote Bill To Account Integration 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 Integration Id/Bill To Account S_ORDER.BL_OU_ID  -> S_ORG_EXT NAME
Quote Entry - SAP 4x Applet Ship To Account Quote Ship To Account Integration 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 Integration Id/Ship To Account S_ORDER.SHIP_OU_ID -> S_ORG_EXT NAME
N/A N/A Quote Payer Account Integration Id S_DOC_QUOTE.PAY_OU_ID --> S_ORG_EXT NAME N/A N/A Order Entry - Orders Payer Account Integration 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 Quote Contact First Name S_DOC_QUOTE.CON_PER_ID --> S_CONTACT FST_NAME Order Entry - Order Form Applet First Name Order Entry - Orders Contact First Name S_ORDER.CON_ID -> S_CONTACT FST_NAME
Quote Entry - SAP 4x Applet Last Name Quote Contact Last Name S_DOC_QUOTE.CON_PER_ID --> S_CONTACT LAST_NAME Order Entry - Order Form Applet Last Name Order Entry - Orders Contact Last Name S_ORDER.CON_ID -> S_CONTACT LAST_NAME
N/A N/A Quote Contact Work Phone # S_DOC_QUOTE.CON_PER_ID --> S_CONTACT WORK_PH_NUM N/A N/A Order Entry - Orders Contact Work Phone # S_ORDER.CON_ID -> S_CONTACT WORK_PH_NUM Not Exposed in UI
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
N/A 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
Shown in SAP Sales Area view SAP Sales Organization Order Entry - Orders SAP Sales Organization (MO) S_ORDER.BU_ID -> S_ORG_EXT. --> S_ORG_EXT SALES_ORG_CD Shown in SAP Sales Area view SAP Sales Organization Order Entry - Orders SAP Sales Organization (MO) S_ORDER.ACCNT_ID -> S_ORG_EXT.BU_ID --> S_ORG_EXT SALES_ORG_CD
Shown in SAP Sales Area view SAP Distribution Channel Order Entry - Orders SAP Distribution Channel (MO) S_ORDER.ACCNT_ID -> S_ORG_EXT.BU_ID --> S_ORG_EXT DIST_CHANNEL_CD Shown in SAP Sales Area view SAP Distribution Channel Order Entry - Orders SAP Distribution Channel (MO) S_ORDER.ACCNT_ID -> S_ORG_EXT.BU_ID --> S_ORG_EXT DIST_CHANNEL_CD
Shown in SAP Sales Area view SAP Division Code Order Entry - Orders SAP Division (MO) S_ORDER.ACCNT_ID -> S_ORG_EXT DIVN_CD Shown in SAP Sales Area view SAP Division Code Order Entry - Orders SAP Division (MO) S_ORDER.ACCNT_ID -> S_ORG_EXT DIVN_CD
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 Id S_DOC_QUOTE ROW_ID Order Entry - Order Form Applet (Sales) Quote Id Order Entry - Orders Quote Id S_ORDER QUOTE_ID
Quote Payment Form Applet Expiration Month Quote Credit Card Expiration Month S_DOC_ORDER CRDT_CRD_EXP_MO_CD N/A N/A Order Entry - Orders Credit Card Expiration Month S_ORDER CRDT_CRD_EXP_MO_CD
Quote Payment Form Applet Expiration Year Quote Credit Card Expiration Year S_DOC_ORDER CRDT_CRD_EXP_YR_CD N/A N/A Order Entry - Orders Credit Card Expiration Year S_ORDER CRDT_CRD_EXP_YR_CD
Quote Payment Form Applet Card Holder Quote Credit Card Holder S_DOC_ORDER CRDHOLDER_NAME N/A N/A Order Entry - Orders Credit Card Holder S_ORDER CRDHOLDER_NAME
Quote Payment Form Applet Card Type Quote Credit Card Name S_DOC_ORDER CRDT_CRD_NAME N/A N/A Order Entry - Orders Credit Card Name S_ORDER CRDT_CRD_NAME
Quote Payment Form Applet Credit Card # Quote Credit Card Number S_DOC_ORDER CC_NUMBER N/A N/A Order Entry - Orders Credit Card Number S_ORDER CC_NUMBER
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 - SAP 4x List Applet Comments Quote Item Description S_QUOTE_ITEM DESC_TEXT Order Entry - SAP 4x Line Item List Applet (Sales) Comments Order Entry - Line Items Description S_ORDER_ITEM DESC_TEXT
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
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 Integration Id S_QUOTE_ITEM.PROD_ID --> S_PROD_INT INTEGRATION_ID Order Entry - SAP 4x Line Item List Applet (Sales) Product Order Entry - Line Items Product Integration Id S_ORDER_ITEM.PROD_ID --> S_PROD_INT INTEGRATION_ID Integration Id holds the SAP Material no for Siebel Product and is used to tranfer Product value from Siebel to SAP instead of Product field
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 Location S_QUOTE_ITEM.SRC_INVLOC_ID --> S_INVLOC NAME Order Entry - SAP 4x Line Item List Applet (Sales) Delivering Plant Order Entry - Line Items Source Inventory Location S_ORDER_ITEM.SRC_INVLOC_ID --> S_INVLOC NAME Not Exposed in Quote UI
Quote Item - SAP 4x List Applet U/M Quote Item Sales Unit of Measurement S_QUOTE_ITEM.PROD_ID --> S_PROD_INT_BU + Constrain on BU_ID UNIT_PRI Order Entry - SAP 4x Line Item List Applet (Sales) U/M Order Entry - Line Items Sales Unit of Measurement S_ORDER_ITEM.PROD_ID --> S_PROD_INT_BU + Constrain on BU_ID UNIT_PRI Unit of Measure which is stored in S_PROD_INT_BU and is equivalent of Sales UOM of SAP
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
Quote Item - SAP 4x List Applet Net Price Quote Item Item Price N/A N/A Order Entry - SAP 4x Line Item List Applet (Sales) Net Price Order Entry - Line Items Item Price N/A N/A
Header (Siebel Order to Siebel Quote)
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
N/A N/A Quote Billing Block S_DOC_ORDER BLOCK_BL_CD Order Entry - SAP 4x order Form Applet Billing Block Order Entry - Orders Billing Block S_ORDER BLOCK_BL_CD Not Exposed in Quote UI
N/A N/A Quote Delivery Block S_DOC_ORDER BLOCK_BL_CD Order Entry - SAP 4x order Form Applet Delivery Block Order Entry - Orders Delivery Block S_ORDER BLOCK_DLVRY_CD Not exposed in Quote UI
Quote Entry - SAP 4x Applet Credit Status Quote Credit Check Passed Flag S_DOC_ORDER CRDT_CHK_PASSD_FLG Order Entry - SAP 4x order Form Applet Credit Status Order Entry - Orders Credit Status S_ORDER CRDT_CHK_PASSD_FLG
Quote Entry Applet Currency Quote Currency Code S_DOC_QUOTE CURCY_CD Order Entry - Order Form Applet (Sales) Currency Order Entry - Orders Currency Code S_ORDER CURCY_CD
Quote Entry - SAP 4x Applet Message (SAP) Quote EAI Error Message S_DOC_ORDER EAI_ERROR_TEXT Order Entry - SAP 4x order Form Applet Message (SAP) Order Entry - Orders Back Office Error Text S_ORDER EAI_ERROR_TEXT
N/A N/A Quote Credit Card Transaction Time S_DOC_ORDER CRDT_CRD_TXN_DT Order Payment Applet Transaction Time Order Entry - Orders Credit Card Transaction Time S_ORDER CRDT_CRD_TXN_DT
N/A N/A Quote Credit Card Transaction ID S_DOC_ORDER PAY_AUTH_NUM Order Payment Applet Transaction ID Order Entry - Orders Credit Card Transaction ID S_ORDER PAY_AUTH_NUM
N/A N/A Quote Credit Card Authorization Code S_DOC_ORDER CRDT_CRD_APPR_CD Order Payment Applet Approval Code Order Entry - Orders Credit Card Approval Code S_ORDER CRDT_CRD_APPR_CD
Quote Terms Form Applet Credit Card # Quote Credit Card Number S_DOC_ORDER CC_NUMBER Order Payment Applet Card Number Order Entry - Orders Credit Card Number S_ORDER CC_NUMBER
N/A N/A Quote Credit Card Transaction Amount S_DOC_ORDER CRDT_CRD_TXN_AMT Order Payment Applet Transaction Amount Order Entry - Orders Credit Card Transaction Amount S_ORDER CRDT_CRD_TXN_AMT
N/A N/A Quote Credit Card Transaction Status S_DOC_ORDER CRDTCD_TXN_STAT_CD Order Payment Applet Payment Status Order Entry - Orders Credit Card Transaction Status S_ORDER CRDTCD_TXN_STAT_CD
Quote Entry - SAP 4x Applet Status As Of Quote Last Validated SAP Date S_DOC_QUOTE EAI_SYNC_DT N/A N/A N/A Timestamp() N/A N/A Time Stamp is Copied
Item (Siebel Order to Siebel Quote)
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 - SAP 4x List Applet Line Quote Item Line Number S_QUOTE_ITEM LN_NUM Order Entry - Line Item List Applet (Sales) Line # Order Entry - Line Items Line Number S_ORDER_ITEM LN_NUM
Quote Item - SAP 4x List Applet Qty Req Quote Item Quantity Requested S_QUOTE_ITEM QTY_REQ Order Entry - Line Item List Applet (Sales) Qty Req Order Entry - Line Items Quantity Requested S_ORDER_ITEM QTY_REQ
N/A N/A Quote Item Net Price S_QUOTE_ITEM NET_PRI N/A N/A Order Entry - Line Items SAP 4x Net Price N/A N/A Calculated field : SAP 4x Net Price = [SAP 4x Unit Net Price] * [Quantity Requested]
Quote Item - SAP 4x List Applet Start Price Quote Item Adjusted List Price S_QUOTE_ITEM UNIT_PRI N/A N/A Order Entry - Line Items SAP 4x Unit Net Price S_ORDER_ITEM NET_PRI If Siebel Pricer = "Y"
Quote Item - SAP 4x List Applet Freight Quote Item Freight Amount S_QUOTE_ITEM FRGHT_AMT Order Entry - Line Item List Applet (Sales) Freight (SAP) Order Entry - Line Items Freight Amount S_ORDER_ITEM FRGHT_AMT
Quote Item - SAP 4x List Applet Tax Quote Item Tax Amt S_QUOTE_ITEM TAX_AMT Order Entry - Line Item List Applet (Sales) Tax Order Entry - Line Items Tax Amount S_ORDER_ITEM TAX_AMT
Credit Card Component (Siebel Order to Siebel Quote)
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
N/A N/A Quote Credit Card Transaction Time S_DOC_ORDER CRDT_CRD_TXN_DT Payment Detail - Credit Card Transaction Time Payments Authorization Date S_SRC_PAYMENT PERFORM_DT
N/A N/A Quote Credit Card Transaction ID S_DOC_ORDER PAY_AUTH_NUM Payment Detail - Credit Card Transaction ID Payments Transaction ID S_SRC_PAYMENT PAYMENT_NUM
Quote Payment Form Applet Authorization Code Quote Credit Card Authorization Code S_DOC_ORDER CRDT_CRD_APPR_CD Payment Detail - Credit Card Approval Code Payments Authorization Code S_SRC_PAYMENT CRDT_CRD_APPR_CD
Quote Payment Form Applet Credit Card # Quote Credit Card Number S_DOC_ORDER CC_NUMBER Payment Detail - Credit Card Card Number Payments Account Number S_SRC_PAYMENT CC_NUM
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
Schedule Line (Siebel Order to Siebel Quote)
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 Schedule Line List Applet Required Delivery Date Quote - SAP 4x Schedule Line Item Required Delivery Date S_QUOTE_ITM_DTL DLVRY_DT Order Entry - SAP 4x Schedule Line List Applet Required Delivery Date Order Entry - Line Item Actions Planned Start Date S_ORDPART_MVMT PLAN_START_DT
Quote Entry - SAP 4x Schedule Line List Applet Confirmed Date Quote - SAP 4x Schedule Line Item Confirmed Date S_QUOTE_ITM_DTL CONFIRMED_DT Order Entry - SAP 4x Schedule Line List Applet Confirmed Date Order Entry - Line Item Actions Actual Start Date S_ORDPART_MVMT ACTL_START_DT
Quote Entry - SAP 4x Schedule Line List Applet Required Qty Quote - SAP 4x Schedule Line Item Required Qty S_QUOTE_ITM_DTL QTY Order Entry - SAP 4x Schedule Line List Applet Quantity Required Order Entry - Line Item Actions Quantity S_ORDPART_MVMT QTY
Quote Entry - SAP 4x Schedule Line List Applet Confirmed Qty Quote - SAP 4x Schedule Line Item Confirmed Qty S_QUOTE_ITM_DTL CONFIRMED_QTY Order Entry - SAP 4x Schedule Line List Applet Confirmed Qty Order Entry - Line Item Actions Confirmed Qty S_ORDPART_MVMT CONFIRMED_QTY