Default Mapping
AccountSets
ERP TO SF
Account Set Description
GUMU__Account_Set_Description__c
string
Description (Description)
Account Set Code
GUMU__Account_Set_Code__c
string
AccountSetKey(AccountSetKey)
Account Set Name
Name
string
AccountSetKey(AccountSetKey)
ARDistributionCode
ERP TO SF
Distribution Code Name
Name
string
DistributionCodeKey
Description
GUMU__Description__c
string
Description
Status
GUMU__Status__c
string
Description
ARItems
ERP TO SF
Item Type
GUMU__Item_Type__c
string
ARItem
Product Name
Name
string
ItemNumber(ItemNumber)
Product Description
Description
string
Description(Description)
Product Code
Product Code
string
ItemNumber(ItemNumber)
Active
IsActive
CheckBox
TRUE
ARPricebookEntry
ERP TO SF
List Price
UnitPrice
Number
0
Relationship
Product2Id
ItemNumber(ItemNumber)
Product
Pricebook2id
PriceBook
ARPricebookEntrySTD
ERP To SF
List Price
UnitPrice
Number
0
Relationship
Product2Id
ItemNumber(ItemNumber)
Product
ARUOM
ERP To SF
UOM Code
GUMU__UOM_Code__c
string
UnitesOfMeasureKey(UnitesOfMeasureKey)
Unit Of Measure Name
Name
string
UnitesOfMeasureKey(UnitesOfMeasureKey)
Contact
ERP To SF
Is Primary Contact
GUMU__Sage300_Contact__c
CheckBox
TRUE
string
ContactsEmail(ContactsEmail)
Business Fax
Fax
string
ContactsFax(ContactsFax)
Business Phone
Phone
string
ContactsPhone(ContactsPhone)
Last Name
LastName
string
ContactName(ContactName)
SF To ERP
Name
Name
ContactName(ContactName)
Phone
Phone
ContactsPhone(ContactPhone)
Fax
Fax
ContactsFax(ContactFax)
ContactsEmail(ContactEmail)
Category
ERP To SF
Category description
GUMU__Category_description__c
string
Description(Description)
Category
GUMU__CategoryCode__c
string
GroupCode(GroupCode)
Currency
ERP To SF
Currency Description
GUMU__Currency_Description__c
string
Description(Description)
Currency Code
GUMU__Currency_Code__c
string
Currency CodeKey(Currency CodeKey)
Customer
ERP To SF
ERP Customer Type
GUMU__ERP_Customer_Type__c
string
CustomerDiscountType(CustomerDiscountType)
Customer Number
GUMU__ERP_Customer_Number__c
string
CustomerNumber(CustomerNumber)
Currency
GUMU__Currency__c
string
CurrencyCode(CurrencyCode)
Account Type
Type
string
Customer
Account Name
Name
string
CustomerName(CustomerName)
SF To ERP
Customer Number
GUMU__ERP_Customer_Number__c
Customer Number(Customer Number)
Account Name
Name
CustomerName(CustomerName)
Billing Address
BillingStreet
AddressLine1(AddressLine1)
Billing Address
BillingStreet
AddressLine2(AddressLine2)
Billing Address
BillingStreet
AddressLine3(AddressLine3)
Billing City
BillingCity
City (City)
Billing State/Province
BillingState
StateProvince(StateProvince)
Billing Zip/Postal Code
BillingPostalCode
ZipPostalCode(ZipPostalCode)
Billing Country
BillingCountry
Country (Country)
Account Phone
Phone
PhoneNumber (PhoneNumber)
Account Fax
Fax
FaxNumber (FaxNumber)
Website
Website
Website(Website)
Location
ERP To SF
Warehouse Description
GUMU__Warehouse_Description__c
string
Name (Name)
Warehouse Code
GUMU__Warehouse_Code__c
string
LocationKey(LocationKey)
PricebookEntry
ERP To SF
Active
IsActive
CheckBox
TRUE
UOM
GUMU__UOM__c
string
StockingUnitOfMeasure(StockingUnitOfMeasure)
List Price
UnitPrice
Number
0
Category
GUMU__Category__c
string
Category (Category )
Relationship
Product2Id
UnformattedItemNumber(UnformattedItemNumber)
Product
Pricebook2id
PriceBook
PricebookEntrySTD
ERP To SF
Active
IsActive
CheckBox
TRUE
UOM
GUMU__UOM__c
string
StockingUnitOfMeasure(StockingUnitOfMeasure)
List Price
UnitPrice
Number
0
Category
GUMU__Category__c
string
Category (Category)
ItemPricelist
ERP To SF
Price_List Name
Name
string
PriceListCodeKey(PriceListCodeKey)
Price List Description
GUMU__Price_List_Description__c
string
Description(Description)
Price List Code
GUMU__Price_List_Code__c
string
PriceListCodeKey(PriceListCodeKey)
ProductCode
ERP To SF
Product Family
Family
string
Category(Category)
Active
IsActive
CheckBox
TRUE
Product Description
Description
string
Description(Description)
Product Code
ProductCode
string
ItemNumber(ItemNumber)
Product Name
Name
string
ItemNumber(ItemNumber)
ProductFamily
ERP To SF
ERP Product Family Description
GUMU__ERP_Product_Family_Description__c
string
Description(Description)
ERP Product Family Code
GUMU__ERP_Product_Family_Code__c
string
CategoryCode(CategoryCode)
SalesOrder
ERP To SF
AccountSet
GUMU__AccountSet__c
string
CustomerAccountSet(CustomerAccountSet)
Billing City
BillingCity
string
BillToCity(BillToCity)
Billing Country
BillingCountry
string
BillToCountry(BillToCountry)
Billing State/Province
BillingState
string
BillToStateProvince(BillToStateProvince)
Billing Street
BillingStreet
string
CustomerNo
GUMU__CustomerNo__c
string
CustomerNumber(CustomerNumber)
Description
Description
string
OrderDescription(OrderDescription)
DiscountAmt
GUMU__DiscountAmt__c
Number
OrderDiscountAmount(OrderDiscountAmount)
DiscountPC
GUMU__DiscountPC__c
Number
OrderDiscountPercentage(OrderDiscountPercentage)
DiscountType
GUMU__DiscountType__c
string
Percentage
Document Type
GUMU__Document_Type__c
string
Order
ERP Order Number
GUMU__ERP_Order_Number__c
string
Order Number(Order Number)
ERP Order Total
GUMU__ERP_Order_Total__c
Number
OrderTotal(OrderTotal)
Order Reference Number
Order Reference Number
string
PurchaseOrderNumber(PurchaseOrderNumber)
Order Start Date
EffectiveDate
Date
Orderdate(Orderdate)
Order Type
Type
string
OrderType(OrderType)
Sales Person
GUMU__Sales_Person__c
string
Salesperson1(Salesperson1)
SalesTaxAmt
GUMU__SalesTaxAmt__c
Number
TotalTaxAmount(TotalTaxAmount)
Shipping City
ShippingCity
string
ShipToCity(ShipToCity)
Shipping State/Province
ShippingState
string
ShipToStateProvince(ShipToStateProvince)
Shipping Zip/Postal Code
ShippingPostalCode
string
ShipToZipPostalCode(ShipToZipPostalCode)
ShipToCode
GUMU__ShipToCode__c
string
ShipToLocationCode(ShipToLocationCode)
ShipVia
GUMU__ShipVia__c
string
ShipViaCode(ShipViaCode)
Status
Status
string
Draft
TaxGroup
GUMU__TaxGroup__c
string
TaxGroup(TaxGroup)
TermsCode
GUMU__TermsCode__c
string
TermsCode(TermsCode)
Warehouse
GUMU__Warehouse__c
string
Location(Location)
SF To ERP
Order Start Date
EffectiveDate
OrderDate(OrderDate)
Ship To Code
GUMU__ShipToCode__c
ShipToLocationCode(ShipToLocationCode)
Terms Code
GUMU__TermsCode__c
TermsCode(TermsCode)
Tax Group
GUMU__TaxGroup__c
TaxGroup(TaxGroup)
Account Set
GUMU__AccountSet__c
CustomerAccountSet(CustomerAccountSet)
Ship Via
GUMU__ShipVia__c
ShipViaCode(ShipViaCode)
Warehouse
GUMU__Warehouse__c
DefaultLocationCode(DefaultLocationCode)
Description
Description
OrderDescription(OrderDescription)
Order Reference Number
OrderReferenceNumber
OrderReference(OrderReference)
Billing Address
BillingStreet
BillToAddressLine1(BillToAddressLine1)
Billing Address
BillingStreet
BillToAddressLine2(BillToAddressLine2)
Billing Address
BillingStreet
BillToAddressLine3(BillToAddressLine3)
Billing City
BillingCity
BillToCity(BillToCity)
Billing State/Province
BillingState
BillToStateProvince(BillToStateProvince)
Billing Zip/Postal Code
BillingPostalCode
BillToZipPostalCode(BillToZipPostalCode)
Billing Country
BillingCountry
BillToCountry(BillToCountry)
Shipping Address
ShippingStreet
ShipTo AddressLine1(ShipTo AddressLine1)
Shipping Address
ShippingStreet
ShipTo AddressLine2(ShipTo AddressLine2)
Shipping Address
ShippingStreet
ShipTo AddressLine3(ShipTo AddressLine3)
Shipping City
ShippingCity
ShipToCity(ShipToCity)
Shipping State/Province
ShippingState
ShipToStateProvince(ShipToStateProvince)
Shipping Zip/Postal Code
ShippingPostalCode
ShipToZipPostalCode(ShipToZipPostalCode)
Shipping Country
ShippingCountry
ShipToCountry(ShipToCountry)
Relationship
AccountId
CustomerNumber(CustomerNumber)
Account
Pricebook2Id
Price Book
SalesOrderDetails
ERP To SF
Discount
GUMU__Discount__c
Number
DiscountPercent(DiscountPercent)
Extension Amount
GUMU__ExtensionAmt__c
Number
ExtendedAmount(ExtendedAmount)
Item Type
GUMU__ItemType__c
string
Category(Category)
Line Description
Description
string
Net Detail Discount
GUMU__Net_Detail_Discount__c
Number
ExtendedDiscountPrice(ExtendedDiscountPrice)
Price_List
GUMU__Price_List__c
string
DefaultPriceListCode(DefaultPriceListCode)
Quantity
Quantity
Number
QuantityOrdered(QuantityOrdered)
Quantity Committed
Quantity_Committed__c
string
QuantityCommitted(QuantityCommitted)
Unit Price
UnitPrice
Number
PricingUnitPrice(PricingUnitPrice)
UOM
GUMU__UOM__c
string
OrderUnitOfMeasure(OrderUnitOfMeasure)
Warehouse Code
GUMU__Warehouse_Code__c
string
Location(Location)
SF To ERP
Line Description
Description
Warehouse Code
GUMU__Warehouse_Code__c
Location(Location)
Price_List
GUMU__Price_List__c
PriceList(PriceList)
UOM
GUMU__UOM__c
OrderUnitOfMeasure(OrderUnitOfMeasure)
Quantity
Quantity
QuantityOrdered(QuantityOrdered)
Unit Price
UnitPrice
OrderUnitPrice(OrderUnitPrice)
Net Detail Discount
GUMU__Net_Detail_Discount__c
OrderDiscountAmount(OrderDiscountAmount)
Extension Amount
GUMU__ExtensionAmt__c
ExtensionAmount(ExtensionAmount)
Item Type Code
GUMU__ItemTypeCode__c
Category(Category)
Quantity Committed
Quantity_Committed__c
QuantityCommitted(QuantityCommitted)
Relationship
OrderId
OrderUniquifier(OrderUniquifier)
Order
PrcebookEntryId
UnformattedItemNumber(UnformattedItemNumber)
Price Book Entry
ShipToLocation
ERP To SF
Zip Code
GUMU__Ship_To_Zip_Code__c
string
ZipPostalCode(ZipPostalCode)
Address1
GUMU__Ship_To_Address1__c
string
AddressLine1(AddressLine1)
Territory
GUMU__Territory__c
string
TerritoryCode(TerritoryCode)
State
GUMU__Ship_To_State__c
string
StateProvince(StateProvince)
Ship To Name
GUMU__Ship_To_Name__c
string
Description(Description)
Ship To Code
GUMU__Ship_To_Code__c
string
ShipToLocationKey(ShipToLocationKey)
Ship To Address Name
Name
string
ShipToLocationKey(ShipToLocationKey)
Ship to Address
GUMU__isShipTo__c
string
yes
Country Code
GUMU__Ship_to_Country_Code__c
string
Country(Country)
City
GUMU__Ship_to_City__c
string
City(City)
Address3
GUMU__Ship_to_Address3__c
string
AddressLine3(AddressLine3)
Address2
GUMU__Ship_to_Address2__c
string
AddressLine2(AddressLine2)
ShipVia
ERP To SF
Ship Via Description
GUMU__Ship_Via_Description__c
string
Name(Name)
Ship Via Code
GUMU__Ship_Via_Code__c
string
Code(Code)
Name
Name
string
Name(Name)
TaxGroup
ERP To SF
Tax Group Code
GUMU__Tax_Group_code__c
string
TaxGroupKey(TaxGroupKey)
Tax Group Description
GUMU__Tax_Group_Description__c
string
Description(Description)
Tax Group Name
Name
string
TaxGroupKey(TaxGroupKey)
TermsCode
ERP To SF
Terms Code
GUMU__Terms_Code__c
string
TermsCode(TermsCode)
Terms Code Description
GUMU__Terms_Code_Description__c
string
Description(Description)
UOM
ERP To SF
Conversion Factor
GUMU__Conversion_Factor__c
Number
DefaultConversionFactor(DefaultConversionFactor)
UOM Code
GUMU__UOM_Code__c
string
UnitsOfMeasureKey(UnitsOfMeasureKey)
Unit Of Measure Name
Name
string
UnitsOfMeasureKey(UnitsOfMeasureKey)
Last updated
Was this helpful?