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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|