Default Mapping

Category

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Category	GUMU__CategoryCode__c	string	Category	(BCGCOD)
Category description	GUMU__Category_description__c	string	Category Description	(DESAXX)
Customer Type	GUMU__Customer_Type__c	string	Category type	(BCTYP)

Currency

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Currency Code	GUMU__Currency_Code__c	String	Currency	CUR
Currency Description	GUMU__Currency_Description__c	String	Title	INTDES

Import Customer

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Account Name	Name	string	Name	BPCNAM
Account Type	Type	string	Prospect	PPTflg
Billing City	BillingCity	string	City	CTY
Billing Country	BillingCountry	string	Country	CRY
Billing State/Province	BillingState	string	Region	SAT
Billing Street	BillingStreet	string	Address	ADDLIG1
Billing Zip/Postal Code	BillingPostalCode	string
Company Code	GUMU__ERP_Company_Code__c	string	Postal Code	POSCODE
Currency	GUMU__Currency__c	string	Currency	CUR
Customer Number	GUMU__ERP_Customer_Number__c	string	Customer	BPCNUM
Account Phone	Phone	string	Telephone	TEL1
Website	Website	string	Website	FCYWEB

SF TO ERP

Source Field Label	Source Field	Target Field Label	Codes
Customer Number	GUMU__ERP_Customer_Number__c	Customer	BPCNUM
Account Name	Name	Name	BPCNAM
Account Description	Description	Short Description	BPRSHO
Billing Country	BillingCountry	Country	CRY
Currency	GUMU__Currency__c	Currency	CUR
Account Site	Site	Site	FCY
Customer No.	GUMU__ERP_Customer__c	Customer	BPCFLG
Account Type	Type	Prospect	PPTFLG
Account Description	Description	Description	BPADES
Shipping Country	ShippingCountry	Country	BPACRY
Billing Street	BillingStreet	Address	ADDLIG1
Billing Street	BillingStreet	Address	ADDLIG2
Billing Street	BillingStreet	Address	ADDLIG3
Billing State/Province	BillingState	Postal Code	POSCOD
Billing City	BillingCity	City	CTY
Account Phone	Phone	Telephone	TEL1
Website	Website	Website	FCYWEB
ERP Customer Type	GUMU__ERP_Customer_Type_c	Customer Type	BPCTYP
Billing Address	BillingAddress
Shipping Address	ShippingAddress
Account Name	Name	Search key	CNTFULNAM

Customer Address

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Address1	GUMU__Ship_To_Address1__c	String	Address	ADDLIG1
Address2	GUMU__Ship_to_Address2__c	String	Address	ADDLIG2
Address3	GUMU__Ship_to_Address3__c	String	Address	ADDLIG3
City	GUMU__Ship_to_Address3__c	String	City	CTY
Country Code	GUMU__Ship_to_Country_Code__c	String	Country	BPACRY
Default ShipTo	GUMU__Default_ShipTo__c	String
Email Address	GUMU__Email_Address__c	String	Email	WEB1
Primary Address	GUMU__IsPrimary__c	String	Default	BPAADDFLG
Ship to Address	GUMU__isShipTo__c	String
Ship To Code	GUMU__Ship_To_Code__c	String	Address	CODADR
Ship To Name	GUMU__Ship_To_Name__c	String	Description	BPADES
State	GUMU__Ship_To_State__c	String	Region	SAT
Telephone Ext	GUMU__Telephone_Ext__c	String
Telephone No	GUMU__Telephone_No__c	String	Telephone	TEL1
Zip Code	GUMU__Ship_To_Zip_Code__c	String	Postal code	POSCOD
Ship To Addresses Name	Name	String	Address	CODADR
Not Promoted?	GUMU__Not_Promoted__c	String

Relationship

Target Field	Source Field	Default Value	ParentObject
GUMU__Account_Id_c	Customer(BPCNUM)		Account

Customer Contact

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Department	Department	string	Department	CNSTRV
ERP Contact Code	GUMU__ERP_Contact_Code__c	string	ERP Contact Code	CCNCRM
First Name	FirstName	string	First Name	CNTFNA
Last Name	LastName	string	Last Name	CNTLNA
Salutation	Salutation	string	Title	CNTTTL
Business Phone	Phone	string	Telephone	CNTTEL
Business Fax	Fax	string	Fax	CNTFAX
Mobile Phone	MobilePhone	string	Mobile phone	CNTMOB
Home Phone	HomePhone	string	Telephone	CNTTEL
Email	Email	string	Email	CNTWEB

Relationship

Target Field	Source Field	Default Value	Parent object
AccountId	Customer(BPCNUM)		Account

Import Product

ERP TO SF

Target Field Label	Target Field	Data Type	Source Field
ERP Product Family Code	GUMU__ERP_Product_Family_Code__c	string	Category(TCLCOD)
ERP Product Family Description	GUMU__ERP_Product_Family_Description__c	string	Title(TCLDES)

SF TO ERP

Source Field Label	Source Field	Target Field Label	Codes
Customer Number	GUMU__ERP_Customer_Number__c	Customer	BPCNUM
Account Name	Name	Name	BPCNAM
Account Description	Description	Short Description	BPRSHO
Billing Country	BillingCountry	Country	CRY
Currency	GUMU__Currency__c	Currency	CUR
Account Site	Site	Site	FCY
Customer No.	GUMU__ERP_Customer__c	Customer	BPCFLG
Account Type	Type	Prospect	PPTFLG
Account Description	Description	Description	BPADES
Shipping Country	ShippingCountry	Country	BPACRY
Billing Street	BillingStreet	Address	ADDLIG1
Billing Street	BillingStreet	Address	ADDLIG2
Billing Street	BillingStreet	Address	ADDLIG3
Billing State/Province	BillingState	Postal Code	POSCOD
Billing City	BillingCity	City	CTY
Account Phone	Phone	Telephone	TEL1
Website	Website	Website	FCYWEB
ERP Customer Type	GUMU__ERP_Customer_Type_c	Customer Type	BPCTYP
Billing Address	BillingAddress
Shipping Address	ShippingAddress
Account Name	Name	Search key	CNTFULNAM

ImportSalesOrder

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
AmtAddTax	GUMU__AmtAddTax__c	Number	Tax Includeed	ORDINVATI
AmtSubTax	GUMU__AmtSubTax__c	Number	#NAME?	ORDINNOT
Currency	GUMU__Currency__c	String	Currency	CURR
CustomerNo	GUMU__CustomerNo__c	String	Sold To	BPCORD
Document Type	GUMU__Document_Type__c	String
ERP Order Number	GUMU__ERP_Order_Number__c	String	Number	Number
ERP Order Total	GUMU__ERP_Order_Total__c	Number	Tax Includeed	ORDINVATI
LineTotal	GUMU__LineTotal__c	Number	Excl tax lines	ORDNOT
Order Start Date	EffectiveDate	String	Shipment date	Shipment date
SalesSite	GUMU__SalesSite__c	String	Sales Site	SALFCY
ShipmentSite	GUMU__ShipmentSite__c	String	Shipment Site	STOFCY
Status	Status	String
ShipToCode	GUMU__ShipToCode__c	String	Delivery Address	BPAAD

SF TO ERP

Source Field Label	Source Field	Target Field Label	Codes
SalesSite	GUMU__SalesSite__c	SalesSite
Type	Order Type	Type	SOHTYP
ERP Order Number	GUMU__ERP_Order_Number__c	Number	Number
Order Start Date	EffectiveDate	Shipment date	Shipment date
CustomerNo	GUMU__CustomerNo__c	Sold To	BPCORD
Currency	GUMU__Currency__c	Currency	CURR
ShipToCode	GUMU__ShipToCode__c	Delivery Address	BPAAD
Description	Short Description	Short Description	SHO
Order Amount	TotalAmount	% or amount	INDVTAAMT
AmtSubTax	GUMU__AmtSubTax__c	Tax Includeed	ORDINVATI
ERP Order Total	GUMU__ERP_Order_Total__c	Tax Includeed	ORDINVATI
ShipmentSite	GUMU__ShipmentSite__c	Shipment Site	STOFCY

Relationship

Target Field	Source Field	Default Value	Parent object
AccountId	Sold To(BPCORD)		Account
Pricebook2Id			Price book

Language

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Language Code	GUMU__LanguageCode__c	String	Language	LAN
Language Description	GUMU__LanguageDescription__c	String	Title	INTDES

PricebookEntry

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Category	GUMU__Category__c	String	Category	TCLCOD
List Price	UnitPrice	Number	Base Price	BASPRI

PricebookEntrySTD

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
List Price	UnitPrice	Number	Base price	BASPRI
Category	GUMU__Category__c	String	Category	TCLCOD

Product Family

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
ERP Product Family Code	GUMU__ERP_Product_Family_Code__c	String	Category	TCLCOD
ERP Product Family Description	GUMU__ERP_Product_Family_Description__c	String	Title	TCLDES

Product

ERP TO SF

Target Field label	Target Field	Data Type	Source Field
Product Name	Name	string	Item Code(ITMREF)
Product Code	ProductCode	string	Item Code(ITMREF)
Active	IsActive	checkbox
Product Description	Description	string	Item description 1(ITMDES1)

Relationship

Target Field	Source Field
GUMU_ERP_Product_Family_Id_c	Category(TCLCOD)

Prospect

Target Field label	Target Field	Data Type	Source Field	Codes
Account Name	Name	string	Name	BPCNAM
Account Type	Type	string	Prospect	PPTflg
Billing City	BillingCity	string	City	CTY
Billing Country	BillingCountry	string	Country	CRY
Billing State/Province	BillingState	string	Region	SAT
Billing Street	BillingStreet	string	Address	ADDLIG1
Billing Zip/Postal Code	BillingPostalCode	string
Company Code	GUMU__ERP_Company_Code__c	string	Postal Code	POSCODE
Currency	GUMU__Currency__c	string	Currency	CUR
Customer Number	GUMU__ERP_Customer_Number__c	string	Customer	BPCNUM
Account Phone	Phone	string	Telephone	TEL1
Website	Website	string	Website	FCYWEB

SF TO ERP

Source Field Label	Source Field	Target Field Label	Codes
Customer Number	GUMU__ERP_Customer_Number__c	Customer	BPCNUM
Account Name	Name	Name	BPCNAM
Account Description	Description	Short Description	BPRSHO
Billing Country	BillingCountry	Country	CRY
Currency	GUMU__Currency__c	Currency	CUR
Account Site	Site	Site	FCY
Customer No.	GUMU__ERP_Customer__c	Customer	BPCFLG
Account Type	Type	Prospect	PPTFLG
Account Description	Description	Description	BPADES
Shipping Country	ShippingCountry	Country	BPACRY
Billing Street	BillingStreet	Address	ADDLIG1
Billing Street	BillingStreet	Address	ADDLIG2
Billing Street	BillingStreet	Address	ADDLIG3
Billing State/Province	BillingState	Postal Code	POSCOD
Billing City	BillingCity	City	CTY
Account Phone	Phone	Telephone	TEL1
Website	Website	Website	FCYWEB
ERP Customer Type	GUMU__ERP_Customer_Type_c	Customer Type	BPCTYP
Billing Address	BillingAddress
Shipping Address	ShippingAddress
Account Name	Name	Search key	CNTFULNAM

ProspectAddress

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Address1	GUMU__Ship_To_Address1__c	String	Address	ADDLIG1
Address2	GUMU__Ship_to_Address2__c	String	Address	ADDLIG2
Address3	GUMU__Ship_to_Address3__c	String	Address	ADDLIG3
City	GUMU__Ship_to_Address3__c	String	City	CTY
Country Code	GUMU__Ship_to_Country_Code__c	String	Country	BPACRY
Default ShipTo	GUMU__Default_ShipTo__c	String
Email Address	GUMU__Email_Address__c	String	Email	WEB1
Primary Address	GUMU__IsPrimary__c	String	Default	BPAADDFLG
Ship to Address	GUMU__isShipTo__c	String
Ship To Code	GUMU__Ship_To_Code__c	String	Address	CODADR
Ship To Name	GUMU__Ship_To_Name__c	String	Description	BPADES
State	GUMU__Ship_To_State__c	String	Region	SAT
Telephone Ext	GUMU__Telephone_Ext__c	String
Telephone No	GUMU__Telephone_No__c	String	Telephone	TEL1
Zip Code	GUMU__Ship_To_Zip_Code__c	String	Postal code	POSCOD
Ship To Addresses Name	Name	String	Address	CODADR
Not Promoted?	GUMU__Not_Promoted__c	String

Relationship

Target Field	Source Field	Default Value	Parent object
GUMU_AccountId_c	Prospect(BPCNUM)		Account

ProspectContact

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Department	Department	string	Department	CNSTRV
ERP Contact Code	GUMU__ERP_Contact_Code__c	string	ERP Contact Code	CCNCRM
First Name	FirstName	string	First Name	CNTFNA
Last Name	LastName	string	Last Name	CNTLNA
Salutation	Salutation	string	Title	CNTTTL
Business Phone	Phone	string	Telephone	CNTTEL
Business Fax	Fax	string	Fax	CNTFAX
Mobile Phone	MobilePhone	string	Mobile phone	CNTMOB
Home Phone	HomePhone	string	Telephone	CNTTEL
Email	Email	string	Email	CNTWEB

Relationship

Target Field	Source Field	Default Value	Parent object
GUMU_AccountId_c	Prospect(BPCNUM)		Account

SalesOrder

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
AmtAddTax	GUMU__AmtAddTax__c	Number	Tax Includeed	ORDINVATI
AmtSubTax	GUMU__AmtSubTax__c	Number	#NAME?	ORDINNOT
Currency	GUMU__Currency__c	String	Currency	CURR
CustomerNo	GUMU__CustomerNo__c	String	Sold To	BPCORD
Document Type	GUMU__Document_Type__c	String
ERP Order Number	GUMU__ERP_Order_Number__c	String	Number	Number
ERP Order Total	GUMU__ERP_Order_Total__c	Number	Tax Includeed	ORDINVATI
LineTotal	GUMU__LineTotal__c	Number	Excl tax lines	ORDNOT
Order Start Date	EffectiveDate	String	Shipment date	Shipment date
SalesSite	GUMU__SalesSite__c	String	Sales Site	SALFCY
ShipmentSite	GUMU__ShipmentSite__c	String	Shipment Site	STOFCY
Status	Status	String
ShipToCode	GUMU__ShipToCode__c	String	Delivery Address	BPAAD

SF TO ERP

Source Field Label	Source Field	Target Field Label	Codes
SalesSite	GUMU__SalesSite__c	SalesSite
Type	Order Type	Type	SOHTYP
ERP Order Number	GUMU__ERP_Order_Number__c	Number	Number
Order Start Date	EffectiveDate	Shipment date	Shipment date
CustomerNo	GUMU__CustomerNo__c	Sold To	BPCORD
Currency	GUMU__Currency__c	Currency	CURR
ShipToCode	GUMU__ShipToCode__c	Delivery Address	BPAAD
Description	Short Description	Short Description	SHO
Order Amount	TotalAmount	% or amount	INDVTAAMT
AmtSubTax	GUMU__AmtSubTax__c	Tax Includeed	ORDINVATI
ERP Order Total	GUMU__ERP_Order_Total__c	Tax Includeed	ORDINVATI
ShipmentSite	GUMU__ShipmentSite__c	Shipment Site	STOFCY

Relationship

Target Field	Source Field	Default Value	Parent object
AccountId	Sold To(BPCORD)		Account
Pricebook2Id			Price book

SalesOrderLines

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Extension Amount	GUMU__ExtensionAmt__c	Number	Gross Price	GROPRI
Minus Tax	GUMU__MinusTax__c	Number	Line amt -tax	LINORDNOT
Plus Tax	GUMU__PlusTax__c	Number	Line amt +tax	LINORDATI
Quantity	Quantity	Number	Oredered qty	QTY
Tax Class	GUMU__TaxClass__c	String	tax Level	VACITM1
Unit Price	UnitPrice	Number	Net Price	NETPRI
UOM	GUMU__UOM__c	String	Sal	SAU
Warehouse Code	GUMU__Warehouse_Code__c	String	Ship Site	DSTOFCY
Line Description	Description	String	Description	NAMDIE

SF TO ERP

Source Field Label	Source Field	Target Field Label	Codes
Warehouse Code	GUMU__Warehouse_Code__c	Ship Site	DSTOFCY
UOM	GUMU__UOM__c	Sal	SAU
Quantity	Quantity	Oredered qty	QTY
Extension Amount	GUMU__ExtensionAmt__c	Gross Price	GROPRI
Unit Price	UnitPrice	Net Price	NETPRI
Tax Class	GUMU__TaxClass__c	tax Level	VACITM1
Minus Tax	GUMU__MinusTax__c	Line amt -tax	LINORDNOT
Plus Tax	GUMU__PlusTax__c	Line amt +tax	LINORDATI

SalesPerson

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Salesperson Code	GUMU__Salesperson_Code__c	String	Salesperson Number	REPNUM
Salesperson Description	GUMU__Salesperson_Description	String	Salesperson Name	REPNAM

Shipping

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Default ShipTo	GUMU__Default_ShipTo__c	String	Default Ship To customer	BPADADDFLG
Ship to Address	GUMU__isShipTo__c	String
Ship To Code	GUMU__Ship_To_Code__c	String	ADRR	BPAADD
Not Promoted?	GUMU__Not_Promoted__c	Checkbox

Relationship

Target Field	Source Field	Default Value	Parent object
GUMU__Account_Id_c	Customer(BPCNUM)		Account

Site

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Site Code	GUMU__Site_Code__c	String	Site	FCY
Site Description	GUMU__Site_Description__c	String	Name	FCYNAM

SyncDropdown

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Category	GUMU__CategoryCode__c	String	Category	BCGCOD
Category description	GUMU__Category_description__c	String	Category Description	DESAXX
Customer Type	GUMU__Customer_Type__c	String	Customer Type	BPCTYP

TaxRule

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Legislation	GUMU__Legislation__c	String	Legislation	LEG
Tax Rule Code	GUMU__TaxRuleCode__c	String	Tax Rule	VACBPR
Tax Rule Description	GUMU__TaxRule_Description__c	String	Description	DESAXX

TermsCode

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Condition Line	GUMU__ConditionLine__c	String	Condition Line	PTELIN
Legislation	GUMU__Legislation_	String	Legislation	LEG
Terms Code	GUMU__Terms_Code__c	String	Payment Terms	PTE
Terms Code Description	GUMU__Terms_Code_Description__c	String	Title	DESAXX

UOM

ERP TO SF

Target Field label	Target Field	Data Type	Source Field	Codes
Unit Of Measure Name	Name	String	Unit	UOM
UOM Code	GUMU__UOM_Code__c	String	Unit	UOM