Moneris and Ipayment

Created by Freshwork RCK, Modified on Fri, 27 Feb at 4:00 PM by Freshwork RCK

Additional field mappings for FocusPoint:

SAP Field Name	FocusPoint Field Name	Entity Name	Direction	Default Value	Formula
ccPaymentProfileId	Payment.Moneris.CustomerId	OrderHeader	Outbound		GenericAttributes;Order
ccCardType	Payment.Moneris.CardType	OrderHeader	Outbound		GenericAttributes;Order
ccExp	Payment.Moneris.ExpiredDate	OrderHeader	Outbound		GenericAttributes;Order
ccTrxID	AuthorizationTransactionId	OrderHeader	Outbound
ccAuthTotal	OrderTotal	OrderHeader	Outbound
ccTimeStamp	CreatedOnUtc	OrderHeader	Outbound		yyyy-MM-dd HH:mm:ss
ccAuthRef	Id	OrderHeader	Outbound
ccGateway	Gateway	OrderHeader	Outbound	5
ccImportStatus	ImportStatus	OrderHeader	Outbound	0
ccUseCCPayment	ccUseCCPayment	OrderHeader	Outbound		CreditCardAsPayment
ccOneTimePayment	CCOneTimePayment	OrderHeader	Outbound		CCOneTimePayment
ccVersion	Version	OrderHeader	Outbound	1

Additional field mappings for SAP:

Name	Integration Direction	Mapping Object	Field Type	Focuspoint field	SAP field map	Lookup query
ccDocEntry	FP 2 SAP Query	Order iPayment Integration Table	String		U_DOCENTRY	select DocEntry from ORDR where U_MITI_WEBID = '[%OrderNumber]' as DocEntry
ccObjectType	FP 2 SAP	Order iPayment Integration Table	Constant	17	U_OBJECTTYPE
cciPayment_Identifier	FP 2 SAP	Order iPayment Integration Table	String	ccPaymentProfileId	U_CREDITIDENTIFIER
cciPayment_CardType	FP 2 SAP	Order iPayment Integration Table	String	ccCardType	U_CARDTYPE
cciPayment_ExpDate	FP 2 SAP	Order iPayment Integration Table	String	ccExp	U_EXPIRATION
cciPayment_AuthRef	FP 2 SAP	Order iPayment Integration Table	String	ccTrxID	U_AUTHREF
cciPayment_AuthAmount	FP 2 SAP	Order iPayment Integration Table	String	ccAuthTotal	U_AUTHAMOUNT
cciPayment_Gateway	FP 2 SAP	Order iPayment Integration Table	String	ccGateway	U_GATEWAY
cciPayment_Version	FP 2 SAP	Order iPayment Integration Table	String	ccVersion	U_VERSION
cciPayment_TimeStamp	FP 2 SAP	Order iPayment Integration Table	String	ccTimeStamp	U_TIMESTAMP
cciPayment_ImportStatus	FP 2 SAP	Order iPayment Integration Table	String	ccImportStatus	U_IMPORTSTATUS
cciPayment_CardName	FP 2 SAP	Order iPayment Integration Table	String	ccCardName	U_CARDNAME
cciPayment_OneTimePayment	FP 2 SAP	Order iPayment Integration Table	String	ccOneTimePayment	U_BOY_E0_ONETIMCC
cciPayment_UseCCPayment	FP 2 SAP	Order iPayment Integration Table	String	ccUseCCPayment	U_BOY_E0_CCPAYEX