# Default Mappings

## Sage100 - ARDivision

ERP to  SF

| Target Field Label      | Target Field                           | Data Type | Source Field                    |
| ----------------------- | -------------------------------------- | --------- | ------------------------------- |
| AR Division Code        | GUMU\_\_AR\_Division\_Code\_\_c        | string    | ARDivisionNo (ARDivisionNo)     |
| AR Division Description | GUMU\_\_AR\_Division\_Description\_\_c | string    | ARDivisionDesc (ARDivisionDesc) |

## Sage100 - ARItemProducts

ERP to  SF

<table data-full-width="false"><thead><tr><th width="180">Target Field Label</th><th>Target Field</th><th>Data Type</th><th>Source Field</th><th>Default Value</th></tr></thead><tbody><tr><td>Product Name</td><td>Name</td><td>string</td><td>ItemCode (ItemCode)</td><td></td></tr><tr><td>Product Code</td><td>ProductCode</td><td>string</td><td>ItemCode (ItemCode)</td><td></td></tr><tr><td>Product Description</td><td>Description</td><td>string</td><td>ItemCodeDesc (ItemCodeDesc)</td><td></td></tr><tr><td>Product Family</td><td>Family</td><td>string</td><td>ItemType (ItemType)</td><td></td></tr><tr><td>Active</td><td>Family</td><td>CheckBox</td><td></td><td>TRUE</td></tr></tbody></table>

## Sage100 - Contact

**ERP to SF**

<table><thead><tr><th>Target Field Label</th><th width="209">Target Field</th><th>Data Type</th><th>Source Field</th><th>Default Value</th></tr></thead><tbody><tr><td>ERP Contact Code</td><td>GUMU__ERP_Contact_Code__c</td><td>string</td><td>ContactCode</td><td>TRUE</td></tr><tr><td>Last Name</td><td>LastName</td><td>string</td><td>ContactName</td><td>TRUE</td></tr><tr><td>Mailing City</td><td>MailingCity</td><td>string</td><td>City</td><td>TRUE</td></tr><tr><td>Mailing Country</td><td>MailingCountry</td><td>string</td><td>CountryCode</td><td>TRUE</td></tr><tr><td>Mailing State/Province</td><td>MailingState</td><td>string</td><td>State</td><td>TRUE</td></tr><tr><td>Mailing Street</td><td>MailingStreet</td><td>string</td><td>AddressLine1</td><td>TRUE</td></tr><tr><td>Mailing Zip/Postal Code</td><td>MailingPostalCode</td><td>string</td><td>ZipCode</td><td>TRUE</td></tr><tr><td>Salutation</td><td>Salutation</td><td>string</td><td>Salutation</td><td>TRUE</td></tr><tr><td>Title</td><td>Title</td><td>string</td><td>ContactTitle</td><td>TRUE</td></tr><tr><td>Business Phone</td><td>Phone</td><td>string</td><td>TelephoneNo1</td><td>TRUE</td></tr><tr><td>Business Fax</td><td>Fax</td><td>string</td><td>FaxNo</td><td>TRUE</td></tr><tr><td>Home Phone</td><td>HomePhone</td><td>string</td><td>TelephoneNo2</td><td>TRUE</td></tr><tr><td>Email</td><td>Email</td><td>string</td><td>EmailAddress</td><td>TRUE</td></tr></tbody></table>

**SF to ERP**

| Source Field Label      | Source Field                    | Target Field Label | Default Value |
| ----------------------- | ------------------------------- | ------------------ | ------------- |
| ERP Contact Code        | GUMU\_\_ERP\_Contact\_Code\_\_c | ContactCode        |               |
| Last Name               | LastName                        | ContactName        |               |
| Mailing City            | MailingCity                     | City               |               |
| Mailing Country         | MailingCountry                  | CountryCode        |               |
| Mailing State/Province  | MailingState                    | State              |               |
| Mailing Street          | MailingStreet                   | AddressLine1       |               |
| Mailing Street          | MailingStreet                   | AddressLine2       |               |
| Mailing Street          | MailingStreet                   | AddressLine3       |               |
| Mailing Zip/Postal Code | MailingPostalCode               | ZipCode            |               |
| Salutation              | Salutation                      | Salutation         |               |
| Title                   | Title                           | ContactTitle       |               |
| Business Phone          | Phone                           | TelephoneNo1       |               |
| Business Fax            | Fax                             | FaxNo              |               |
| Email                   | Email                           | EmailAddress       |               |
| Mobile                  | MobilePone                      | TelephoneNo2       |               |

**Relationship**

| Target Field | Source Field                | Default Value | Parent Object |
| ------------ | --------------------------- | ------------- | ------------- |
| AccountId    | ARDivisionNo (ARDivisionNo) |               | Account       |
| AccountId    | CustomerNo (CustomerNo)     |               | Account       |

## Sage100 - Customer

**ERP to SF**

<table><thead><tr><th width="165">Target Field Label</th><th width="183">Target Field</th><th width="119">Data Type</th><th width="143">Source Field</th><th>Default Value</th></tr></thead><tbody><tr><td>Account Name</td><td>Name</td><td>string</td><td>CustomerName</td><td></td></tr><tr><td>Account Type</td><td>Type</td><td>string</td><td></td><td>Customer</td></tr><tr><td>AR DivisonNo</td><td>GUMU__AR_DivisonNo__c</td><td>string</td><td>AR DivisonNo</td><td></td></tr><tr><td>Billing City</td><td>BillingCity</td><td>string</td><td>City</td><td></td></tr><tr><td>Billing Country</td><td>BillingCountry</td><td>string</td><td>CountryCode</td><td></td></tr><tr><td>Billing State/Province</td><td>BillingState</td><td>string</td><td>State</td><td></td></tr><tr><td>Billing Street</td><td>BillingStreet</td><td>string</td><td>AddressLine1</td><td></td></tr><tr><td>Billing Zip/Postal Code</td><td>BillingPostalCode</td><td>string</td><td>ZipCode</td><td></td></tr><tr><td>Company Code</td><td>GUMU__ERP_Company_Code__c</td><td>string</td><td></td><td>ABC</td></tr><tr><td>Customer Number</td><td>GUMU__ERP_Customer_Number__c</td><td>string</td><td>CustomerNo</td><td></td></tr><tr><td>Account Phone</td><td>Phone</td><td>string</td><td>TelephoneNo</td><td></td></tr><tr><td>Account Fax</td><td>Fax</td><td>string</td><td>FaxNo</td><td></td></tr><tr><td>Website</td><td>Website</td><td>string</td><td>URLAddress</td><td></td></tr></tbody></table>

**SF to ERP**

| Source Field Label      | Source Field                       | Target Field Label | Default Value |
| ----------------------- | ---------------------------------- | ------------------ | ------------- |
| Account Name            | Name                               | CustomerName       |               |
| AR DivisonNo            | GUMU\_\_AR\_DivisonNo\_\_c         | ARDivisonNo        |               |
| Billing City            | BillingCity                        | City               |               |
| Billing Country         | BillingCountry                     | Country            |               |
| Billing State/Province  | BillingState                       | State              |               |
| Billing Street          | BillingStreet                      | AddressLine1       |               |
| Billing Street          | BillingStreet                      | AddressLine2       |               |
| Billing Street          | BillingStreet                      | AddressLine3       |               |
| Billing Zip/Postal Code | BillingPostalCode                  | ZipCode            |               |
| Customer Number         | GUMU\_\_ERP\_Customer\_Number\_\_c | CustomerNo         |               |
| Account Phone           | Phone                              | TelephoneNo        |               |
| Account Fax             | Fax                                | FaxNo              |               |
| Website                 | Website                            | URLAddress         |               |

**Real-time Fields**

<table><thead><tr><th>Sections</th><th width="176">Data Page Field Label</th><th>Data Page Field API Name</th><th>Data Type</th></tr></thead><tbody><tr><td>Main</td><td>ShipMethod</td><td>Ship Method</td><td>Text</td></tr><tr><td></td><td>CreditHold</td><td>Credit Hold</td><td>Checkbox</td></tr><tr><td></td><td>TaxSchedule</td><td>Tax Schedule</td><td>Text</td></tr><tr><td></td><td>ARDivisionNo</td><td>AR Division</td><td>Text</td></tr><tr><td></td><td>CustomerNo</td><td>Customer Number</td><td>Text</td></tr><tr><td></td><td>SalespersonNo</td><td>Sales person</td><td>Text</td></tr><tr><td></td><td>CustomerName</td><td>Customer Name</td><td>Text</td></tr><tr><td></td><td>TermsCode</td><td>Terms Code</td><td>Text</td></tr><tr><td>Additional</td><td>Customer Type</td><td>CustomerType</td><td>Text</td></tr><tr><td></td><td>Finance Charge Rate(%)</td><td>ServiceChargeRate</td><td>Decimal</td></tr><tr><td></td><td>Customer Status</td><td>CustomerStatus</td><td>Text</td></tr><tr><td></td><td>Statement Cycle</td><td>StatementCycle</td><td>Text</td></tr><tr><td></td><td>Open Item Customer</td><td>OpenItemCustomer</td><td>Checkbox</td></tr><tr><td></td><td>Default Payment Type</td><td>DefaultPaymentType</td><td>Text</td></tr><tr><td></td><td>Sort</td><td>SortField</td><td>Text</td></tr><tr><td></td><td>Comment</td><td>Comment</td><td>Text</td></tr><tr><td></td><td>Batch Fax</td><td>BatchFax</td><td>Checkbox</td></tr><tr><td></td><td>Print Dun message</td><td>PrintDunningmessage</td><td>Text</td></tr><tr><td></td><td>Price level</td><td>Pricelevel</td><td>Text</td></tr><tr><td>Statistics</td><td>Last Statement Date</td><td>DateLastStatement</td><td>Date</td></tr><tr><td></td><td>Date Established</td><td>DateEstablished</td><td>Date</td></tr><tr><td></td><td>Average Days to Pay</td><td>AvgDaysPaymentInvoice</td><td>Text</td></tr><tr><td></td><td>Date Of Last Activity</td><td>DateLastActivity</td><td>Date</td></tr><tr><td></td><td>Last Payment Amount</td><td>LastpaymentAmt</td><td>Decimal</td></tr><tr><td></td><td>Highest Balance</td><td>HigheststmntBalance</td><td>Decimal</td></tr><tr><td></td><td>Last Finance Charge Date</td><td>DateLastFinanceChrg</td><td>Date</td></tr><tr><td></td><td>Average Days Overdue</td><td>AvgDaysOverDue</td><td>Text</td></tr><tr><td></td><td>Unpaid Finance Charges</td><td>UnpaidServicechrg</td><td>Decimal</td></tr><tr><td></td><td>Last Payment Date</td><td>DateLastPayment</td><td>Date</td></tr><tr><td></td><td>Unpaid Finance Charges</td><td>UnpaidServicechrg</td><td>Decimal</td></tr><tr><td></td><td>Last Payment Date</td><td>DateLastPayment</td><td>Date</td></tr></tbody></table>

## **Sage100 - DefaultShipTo**

ERP to SF

| Target Field Label | Target Field                 | Data Type | Default Value |
| ------------------ | ---------------------------- | --------- | ------------- |
| Default ShipTo     | GUMU\_\_Default\_ShipTo\_\_c | string    | Yes           |
| Ship to Address    | GUMU\_\_isShipTo\_\_c        | string    | Yes           |

**Relationship**

| Target Field             | Source Field | Parent Object |
| ------------------------ | ------------ | ------------- |
| GUMU\_\_Account\_Id\_\_c | ARDivisionNo | Account       |
|                          | CustomerNo   | Account       |

## **Sage100 - Order**

**ERP to SF**

<table><thead><tr><th width="163">Target Field Label</th><th width="222">Target Field</th><th width="148">Data Type</th><th width="195">Source Field</th><th width="96">Default Value</th></tr></thead><tbody><tr><td>ARDivisionNo</td><td>GUMU__ARDivisionNo__c</td><td>string</td><td>ARDivisionNo</td><td></td></tr><tr><td>Batch Fax No</td><td>GUMU__Batch_Fax_No__c</td><td>CheckBox</td><td>BatchFax</td><td></td></tr><tr><td>Billing City</td><td>BillingCity</td><td>string</td><td>BillToCity</td><td></td></tr><tr><td>Billing Country</td><td>BillingCountry</td><td>string</td><td>BillToCountryCode</td><td></td></tr><tr><td>Billing State/Province</td><td>BillingState</td><td>string</td><td>BillToState</td><td></td></tr><tr><td>Billing Street</td><td>BillingStreet</td><td>string</td><td>BillToAddress1</td><td></td></tr><tr><td>Billing Zip/Postal Code</td><td>BillingPostalCode</td><td>string</td><td>BillToZipCode</td><td></td></tr><tr><td>CustomerNo</td><td>GUMU__CustomerNo__c</td><td>string</td><td>CustomerNo</td><td></td></tr><tr><td>FOB</td><td>GUMU__FOB__c</td><td>string</td><td>FOB</td><td></td></tr><tr><td>DiscountAmt</td><td>GUMU__DiscountAmt__c</td><td>Number</td><td>DiscountAmt</td><td></td></tr><tr><td>FreightAmt</td><td>GUMU__FreightAmt__c</td><td>Number</td><td>FreightAmt</td><td></td></tr><tr><td>Non taxable Amount</td><td>GUMU__Non_taxable_Amount__c</td><td>Number</td><td>NonTaxableAmt</td><td></td></tr><tr><td>DiscountPC</td><td>GUMU__DiscountPC__c</td><td>Number</td><td>DiscountRate</td><td></td></tr><tr><td>Document Type</td><td>GUMU__Document_Type__c</td><td>string</td><td></td><td>Order</td></tr><tr><td>ERP Order Number</td><td>GUMU__ERP_Order_Number__c</td><td>string</td><td>SalesOrderNo</td><td></td></tr><tr><td>Taxable Amount</td><td>GUMU__Taxable_Amount__c</td><td>Number</td><td>TaxableAmt</td><td></td></tr><tr><td>Shipping Zip/Postal Code</td><td>ShippingPostalCode</td><td>string</td><td>ShipToZipCode</td><td></td></tr><tr><td>ShipToCode</td><td>GUMU__ShipToCode__c</td><td>string</td><td>ShipToCode</td><td></td></tr><tr><td>ShipToName</td><td>GUMU__ShipToName__c</td><td>string</td><td>ShipToName</td><td></td></tr><tr><td>ShipVia</td><td>GUMU__ShipVia__c</td><td>string</td><td>ShipVia</td><td></td></tr><tr><td>Status</td><td>Status</td><td>string</td><td></td><td>Draft</td></tr><tr><td>Tax Schedule</td><td>GUMU__Tax_Schedule__c</td><td>string</td><td>TaxSchedule</td><td></td></tr><tr><td>TaxGroup</td><td>GUMU__TaxGroup__c</td><td>string</td><td>TaxClass</td><td></td></tr><tr><td>TermsCode</td><td>GUMU__TermsCode__c</td><td>string</td><td>TermsCode</td><td></td></tr><tr><td>Warehouse</td><td>GUMU__Warehouse__c</td><td>string</td><td>WarehouseCode</td><td></td></tr><tr><td>DiscountType</td><td>GUMU__DiscountType__c</td><td>string</td><td></td><td>Percentage</td></tr><tr><td>Order Start Date</td><td>EffectiveDate</td><td>Date</td><td>OrderDate</td><td></td></tr><tr><td>SalesTaxAmt</td><td>GUMU__SalesTaxAmt__c</td><td>Number</td><td>SalesTaxAmt</td><td></td></tr><tr><td>Order Type</td><td>Type</td><td>string</td><td>OrderType</td><td></td></tr><tr><td>Shipping Street</td><td>ShippingStreet</td><td>string</td><td>ShipToAddress1</td><td></td></tr><tr><td>Payment Type</td><td>GUMU__Payment_Type__c</td><td>string</td><td>PaymentType</td><td></td></tr><tr><td>Print Order</td><td>GUMU__Print_Order__c</td><td>CheckBox</td><td>PrintSalesOrders</td><td></td></tr><tr><td>Print Picking Sheets</td><td>GUMU__Print_Picking_Sheets__c</td><td>CheckBox</td><td>PrintPickingSheets</td><td></td></tr><tr><td>Sales Person</td><td>GUMU__Sales_Person__c</td><td>string</td><td>SalespersonNo</td><td></td></tr><tr><td>Ship Expire Date</td><td>GUMU__Ship_Expire_Date__c</td><td>Date</td><td>ShipExpireDate</td><td></td></tr><tr><td>Shipping City</td><td>ShippingCity</td><td>string</td><td>ShipToCity</td><td></td></tr><tr><td>Shipping Country</td><td>ShippingCountry</td><td>string</td><td>ShipToCountryCode</td><td></td></tr><tr><td>Shipping State/Province</td><td>ShippingState</td><td>string</td><td>ShipToState</td><td></td></tr></tbody></table>

**SF to ERP**

<table><thead><tr><th width="157">Source Field Label</th><th width="207">Source Field</th><th width="154">Target Field Label</th></tr></thead><tbody><tr><td>ARDivisionNo</td><td>GUMU__ARDivisionNo__c</td><td>ARDivisionNo</td></tr><tr><td>OrderStartDate</td><td>EffectiveDate</td><td>OrderDate</td></tr><tr><td>ShipExpireDate</td><td>GUMU__Ship_Expire_Date__c</td><td>ShipExpireDate</td></tr><tr><td>CustomerNo</td><td>GUMU__CustomerNo__c</td><td>CustomerNo</td></tr><tr><td>FOB</td><td>GUMU__FOB__c</td><td>FOB</td></tr><tr><td>OrderType</td><td>Type</td><td>OrderType</td></tr><tr><td>DiscountAmt</td><td>GUMU__DiscountAmt__c</td><td>DiscountAmt</td></tr><tr><td>FreightAmt</td><td>GUMU__FreightAmt__c</td><td>FreightAmt</td></tr><tr><td>PrintPickingSheets</td><td>GUMU__Print_Picking_Sheets__c</td><td>PrintPickingSheets</td></tr><tr><td>PrintOrders</td><td>GUMU__Print_Order__c</td><td>PrintSalesOrders</td></tr><tr><td>TermsCode</td><td>GUMU__TermsCode__c</td><td>TermsCode</td></tr><tr><td>Sales Person</td><td>GUMU__Sales_Person__c</td><td>SalespersonNo</td></tr><tr><td>PaymentType</td><td>GUMU__Payment_Type__c</td><td>PaymentType</td></tr><tr><td>TaxSchedule</td><td>GUMU__Tax_Schedule__c</td><td>TaxSchedule</td></tr><tr><td>Warehouse</td><td>GUMU__Warehouse__c</td><td>WarehouseCode</td></tr><tr><td>ShipVia</td><td>GUMU__ShipVia__c</td><td>ShipVia</td></tr><tr><td>ShippingCountry</td><td>ShippingCountry</td><td>ShippingToCountryCode</td></tr><tr><td>Shipping Zip/Postal Code</td><td>ShippingPostalCode</td><td>ShipToZipCode</td></tr><tr><td>ShippingState/Province</td><td>ShippingState</td><td>ShipToState</td></tr><tr><td>Shipping City</td><td>ShippingCity</td><td>ShipToCity</td></tr><tr><td>Shipping Street</td><td>ShippingStreet</td><td>ShipToAddress1</td></tr><tr><td>Shipping Street</td><td>ShippingStreet</td><td>ShipToAddress2</td></tr><tr><td>Shipping Street</td><td>ShippingStreet</td><td>ShipToAddress3</td></tr><tr><td>Ship ToCode</td><td>GUMU__ShipToCode__c</td><td>ShipToCode</td></tr><tr><td>Ship ToName</td><td>GUMU__ShipToName__c</td><td>ShipToName</td></tr><tr><td>Billing Country</td><td>BillingCountry</td><td>BillingToCountryCode</td></tr><tr><td>Billing Zip/PostalCode</td><td>BillingPostalCode</td><td>BillToZipCode</td></tr><tr><td>Billing State/Province </td><td>BillingState</td><td>BillingToState</td></tr><tr><td>Billing City</td><td>BillingCity</td><td>BillingToCity</td></tr><tr><td>Billing Street</td><td>BillingStreet</td><td>BillToAddress1</td></tr><tr><td>Billing Street</td><td>BillingStreet</td><td>BillToAddress2</td></tr><tr><td>Billing Street</td><td>BillingStreet</td><td>BillToAddress3</td></tr><tr><td>Batch Fax No</td><td>GUMU__Batch_Fax_No__c</td><td>BatchFax </td></tr><tr><td>Order Reference Number</td><td>OrderReferenceNumber</td><td>CustomerPONo</td></tr><tr><td>DepositAmt</td><td>GUMU__DepositAmt__c</td><td>DepositAmt</td></tr><tr><td>Check Number</td><td>GUMU__Check_Number_ext__c</td><td>CheckNoForDeposit</td></tr></tbody></table>

**Relationship**

<table><thead><tr><th width="157">Target Field</th><th width="207">Source Field</th><th width="154">Default Value</th><th width="142">Parent Object</th></tr></thead><tbody><tr><td>Account</td><td>ARDivisionNo</td><td></td><td>Account</td></tr><tr><td>Account</td><td>CustomerNo</td><td></td><td>Account</td></tr><tr><td>Pricebook2</td><td></td><td></td><td>Pricebook2</td></tr></tbody></table>

**Real-time Fields**

<table><thead><tr><th width="163">Sections</th><th width="222">Data Page Field Label</th><th width="148">Data Page Field API Name</th><th width="195">Data Type</th></tr></thead><tbody><tr><td>Order Header</td><td>Order No</td><td>SalesOrderNo</td><td>Text</td></tr><tr><td></td><td>Order Date</td><td>OrderDate</td><td>Date</td></tr><tr><td></td><td>Order Type</td><td>OrderType</td><td>Text</td></tr><tr><td></td><td>Master / Repeating Order No.</td><td>MasterRepeatingOrderNo</td><td>Text</td></tr><tr><td></td><td>Division</td><td>ARDivisionNo</td><td>Text</td></tr><tr><td></td><td>Customer No</td><td>CustomerNo</td><td>Text</td></tr><tr><td></td><td>Customer PO No.</td><td>CustomerPoNo</td><td>Text</td></tr><tr><td></td><td>Ship Expire Date</td><td>ShipExpiredate</td><td>Date</td></tr><tr><td></td><td>Terms Code</td><td>TermsCode</td><td>Text</td></tr><tr><td></td><td>Confirm To</td><td>ConfirmTo</td><td>Text</td></tr><tr><td></td><td>Tax Schedule</td><td>TaxSchedule</td><td>Text</td></tr><tr><td></td><td>Warehouse Code</td><td>WarehouseCode</td><td>Text</td></tr><tr><td></td><td>Ship Via</td><td>ShipVia</td><td>Text</td></tr><tr><td></td><td>FOB</td><td>FOB</td><td>Text</td></tr><tr><td></td><td>Sales Person</td><td>SalespersonNo</td><td>Text</td></tr><tr><td></td><td>Comment</td><td>Comment</td><td>Text</td></tr><tr><td></td><td>Bill To Name</td><td>BillToName</td><td>Text</td></tr><tr><td></td><td>Ship To Name</td><td>ShipToName</td><td>Text</td></tr><tr><td></td><td>Split Commissions</td><td>SplitCommissions</td><td>Checkbox</td></tr><tr><td>Line Items</td><td>Item Code</td><td>ItemCode</td><td>Text</td></tr><tr><td></td><td>Description</td><td>ItemCodeDesc</td><td>Text</td></tr><tr><td></td><td>Warehouse Code</td><td>WarehouseCode</td><td>Text</td></tr><tr><td></td><td>Unit of Measure</td><td>UnitOfMeasure</td><td>Text</td></tr><tr><td></td><td>Quantity Ordered</td><td>QuantityOrdered</td><td>Decimal</td></tr><tr><td></td><td>Quantity Shipped</td><td>QuantityShipped</td><td>Decimal</td></tr><tr><td></td><td>Back Ordered</td><td>QuantityBackordered</td><td>Decimal</td></tr><tr><td></td><td>Unit Price</td><td>UnitPrice</td><td>Decimal</td></tr><tr><td>Order Totals</td><td>Taxable Subject To Discount</td><td>TaxableSubjectToDiscount</td><td>Decimal</td></tr><tr><td></td><td>Non Taxable Subject To Discount</td><td>NonTaxableSubjectToDiscount</td><td>Decimal</td></tr><tr><td></td><td>Discount Rate (%)</td><td>DiscountRate</td><td>Decimal</td></tr><tr><td></td><td>Discount Amount</td><td>DiscountAmt</td><td>Decimal</td></tr><tr><td></td><td>Taxable Amount(Discount Included)</td><td>TaxableAmt</td><td>Decimal</td></tr><tr><td></td><td>Non-Taxable Amount(Discount Included)</td><td>NonTaxableAmt</td><td>Decimal</td></tr><tr><td></td><td>Ship Zone</td><td>ShipZone</td><td>Text</td></tr><tr><td></td><td>Ship Weight</td><td>ShipWeight</td><td>Text</td></tr><tr><td></td><td>Freight Amount</td><td>FreightAmt</td><td>Decimal</td></tr><tr><td></td><td>Sales Tax Amount</td><td>SalesTaxAmt</td><td>Decimal</td></tr></tbody></table>

## **Sage100 - OrdersLines**

**ERP to SF**

<table><thead><tr><th width="139">Target Field Label</th><th width="222">Target Field</th><th width="125">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Comments</td><td>GUMU__Comments__c</td><td>string</td><td>CommentText</td></tr><tr><td>Discount</td><td>GUMU__Discount__c</td><td>Number</td><td>LineDiscountPercent</td></tr><tr><td>Drop Ship</td><td>GUMU__Drop_Ship__c</td><td>string</td><td>DropShip</td></tr><tr><td>Extension Amount</td><td>GUMU__ExtensionAmt__c</td><td>Number</td><td>ExtensionAmt</td></tr><tr><td>Line Description</td><td>Description</td><td>string</td><td>ItemCodeDesc</td></tr><tr><td>Quantity</td><td>Quantity</td><td>Number</td><td>QuantityOrdered</td></tr><tr><td>Tax Class</td><td>GUMU__TaxClass__c</td><td>string</td><td>TaxClass</td></tr><tr><td>Unit Price</td><td>UnitPrice</td><td>Number</td><td>UnitPrice</td></tr><tr><td>UOM</td><td>GUMU__UOM__c</td><td>string</td><td>UnitOfMeasure</td></tr><tr><td>Warehouse Code</td><td>GUMU__Warehouse_Code__c</td><td>string</td><td>WarehouseCode</td></tr><tr><td>Commissionable</td><td>GUMU__Commissionable__c</td><td>string</td><td>Commissionable</td></tr><tr><td>Item Type</td><td>GUMU__ItemType__c</td><td>string</td><td>ItemType</td></tr></tbody></table>

**SF to ERP**

<table><thead><tr><th width="139">Source Field Label</th><th width="222">Source Field</th><th width="125">Target Field Label</th></tr></thead><tbody><tr><td>Comments</td><td>GUMU__Comments__c</td><td>CommentText</td></tr><tr><td>Discount</td><td>GUMU__Discount__c</td><td>LineDiscountPercent</td></tr><tr><td>Drop Ship</td><td>GUMU__Drop_Ship__c</td><td>DropShip</td></tr><tr><td>Extension Amount</td><td>GUMU__ExtensionAmt__c</td><td>ExtensionAmt</td></tr><tr><td>Quantity</td><td>Quantity</td><td>QuantityOrdered</td></tr><tr><td>Tax Class</td><td>GUMU__TaxClass__c</td><td>TaxClass</td></tr><tr><td>Unit Price</td><td>UnitPrice</td><td>UnitPrice</td></tr><tr><td>UOM</td><td>GUMU__UOM__c</td><td>UnitOfMeasure</td></tr><tr><td>Warehouse Code</td><td>GUMU__Warehouse_Code__c</td><td>WarehouseCode</td></tr><tr><td>Commissionable</td><td>GUMU__Commissionable__c</td><td>Commissionable</td></tr></tbody></table>

**Relationship**

<table><thead><tr><th width="180">Target Field</th><th width="174">Source Field</th><th width="96">Default Value</th><th width="152">Parent Object</th></tr></thead><tbody><tr><td>OrderId</td><td>SalesOrderNo</td><td></td><td>Order</td></tr><tr><td>PricebookEntryId</td><td>ItemCode</td><td></td><td>PricebookEntry</td></tr></tbody></table>

## Sage100 - PaymentType

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="240">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Payment Method</td><td>GUMU__Payment_Method__c</td><td>string</td><td>PaymentType</td></tr><tr><td>Payment Type Code</td><td>GUMU__Payment_Type_Code__c</td><td>string</td><td>PaymentType</td></tr><tr><td>Payment Type Description</td><td>GUMU__Payment_Type_Description__c</td><td>string</td><td>PaymentDesc</td></tr></tbody></table>

## Sage100 - PricebookEntry

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="240">Target Field</th><th width="110">Data Type</th></tr></thead><tbody><tr><td>List Price</td><td>UnitPrice</td><td>Number</td></tr><tr><td>Category</td><td>GUMU__Category__c</td><td>string</td></tr></tbody></table>

**Relationship**

<table><thead><tr><th width="123">Target Field</th><th width="131">Source Field</th><th width="96">Default Value</th><th width="96">Parent Object</th></tr></thead><tbody><tr><td>Product2Id</td><td>ItemCode</td><td></td><td>Product</td></tr><tr><td>Pricebook2Id</td><td></td><td></td><td>Price Book</td></tr></tbody></table>

## Sage100 - PricebookEntrySTD

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="240">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>List Price</td><td>UnitPrice</td><td>Number</td><td>StandardUnitPrice</td></tr><tr><td>Category</td><td>GUMU__Category__c</td><td>string</td><td> Category1</td></tr></tbody></table>

**Relationship**

<table><thead><tr><th width="123">Target Field</th><th width="131">Source Field</th><th width="96">Default Value</th><th width="162">Parent Object</th></tr></thead><tbody><tr><td>Product2Id</td><td>ItemCode</td><td></td><td>Product</td></tr><tr><td>Pricebook2Id</td><td></td><td></td><td>Price Book</td></tr></tbody></table>

## Sage100 - ProductFamily

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="274">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>ERP Product Family Code</td><td>GUMU__ERP_Product_Family_Code__c</td><td>string</td><td>ProductLine</td></tr><tr><td>ERP Product Family Description</td><td>GUMU__ERP_Product_Family_Description__c</td><td>string</td><td>ProductLineDesc</td></tr></tbody></table>

**Relationship**

<table><thead><tr><th width="123">Target Field</th><th width="131">Source Field</th><th width="96">Default Value</th><th width="185">Parent Object</th></tr></thead><tbody><tr><td>Product2Id</td><td>ItemCode</td><td></td><td>Product</td></tr><tr><td>Pricebook2Id</td><td></td><td></td><td>Price Book</td></tr></tbody></table>

## Sage100 - Products

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="274">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th><th width="96">Default Value</th></tr></thead><tbody><tr><td>Product Name</td><td>Name</td><td>string</td><td>ItemCode</td><td></td></tr><tr><td>Product Code</td><td>ProductCode</td><td>string</td><td>ItemCode</td><td></td></tr><tr><td>Product Description</td><td>Description</td><td>string</td><td>ItemCodeDesc</td><td></td></tr><tr><td>Product Family</td><td>Family</td><td>string</td><td>ItemType</td><td></td></tr><tr><td>Active</td><td>IsActive</td><td>CheckBox</td><td></td><td>TRUE</td></tr></tbody></table>

**Relationship**

<table><thead><tr><th width="300">Target Field</th><th width="131">Source Field</th><th width="147">Default Value</th><th width="96">Parent Object</th></tr></thead><tbody><tr><td>GUMU__ERP_Product_family_Id__C</td><td>ProductLine</td><td></td><td></td></tr></tbody></table>

## Sage100 - SalesPerson

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="274">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>AR Division Code</td><td>GUMU__AR_Division_Code__c</td><td>string</td><td>SalespersonDivisionNo</td></tr><tr><td>Salesperson Code</td><td>GUMU__Salesperson_Code__c</td><td>string</td><td>SalespersonNo</td></tr><tr><td>Salesperson Description</td><td>GUMU__Salesperson_Description__c</td><td>string</td><td>SalespersonName</td></tr><tr><td>Email</td><td>GUMU__Email__c</td><td>string</td><td>EmailAddress</td></tr></tbody></table>

## Sage100 - ShipMethod

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="274">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Ship Code</td><td>GUMU__Ship_Code__c</td><td>string</td><td>ShippingCode</td></tr><tr><td>Ship Code Description</td><td>GUMU__Ship_Code_Description__c</td><td>string</td><td>ShippingCodeDesc</td></tr></tbody></table>

## Sage100 - ShipTo

**ERP to SF**

<table><thead><tr><th width="159">Target Field Label</th><th width="250">Target Field</th><th width="125">Data Type</th><th width="171">Source Field</th><th width="96">Default Value</th></tr></thead><tbody><tr><td>Address1</td><td>GUMU__Ship_To_Address1__c</td><td>string</td><td>ShipToAddress1</td><td></td></tr><tr><td>Address2</td><td>GUMU__Ship_to_Address2__c</td><td>string</td><td>ShipToAddress2</td><td></td></tr><tr><td>Address3</td><td>GUMU__Ship_to_Address3__c</td><td>string</td><td>ShipToAddress3</td><td></td></tr><tr><td>City</td><td>GUMU__Ship_to_City__c</td><td>string</td><td>ShipToCity</td><td></td></tr><tr><td>Country Code</td><td>GUMU__Ship_to_Country_Code__c</td><td>string</td><td>ShipToCountryCode</td><td></td></tr><tr><td>Email Address</td><td>GUMU__Email_Address__c</td><td>string</td><td>EmailAddress</td><td></td></tr><tr><td>Fax No</td><td>GUMU__Fax_No__c</td><td>string</td><td>FaxNo</td><td></td></tr><tr><td>Salesperson No</td><td>GUMU__Salesperson_No__c</td><td>string</td><td>SalespersonNo</td><td></td></tr><tr><td>Ship To Addresses  Name</td><td>Name</td><td>string</td><td>ShipToCode</td><td></td></tr><tr><td>Ship To Code</td><td>GUMU__Ship_To_Code__c</td><td>string</td><td>ShipToCode</td><td></td></tr><tr><td>Ship To Name</td><td>GUMU__Ship_To_Name__c</td><td>string</td><td>ShipToName</td><td></td></tr><tr><td>State</td><td>GUMU__Ship_To_State__c</td><td>string</td><td>ShipToState</td><td></td></tr><tr><td>Tax Schedule</td><td>GUMU__Tax_Schedule__c</td><td>string</td><td>TaxSchedule</td><td></td></tr><tr><td>Telephone Ext</td><td>GUMU__Telephone_Ext__c</td><td>string</td><td>TelephoneExt</td><td></td></tr><tr><td>Telephone No</td><td>GUMU__Telephone_No__c</td><td>string</td><td>TelephoneNo</td><td></td></tr><tr><td>Warehouse Code</td><td>GUMU__Warehouse_Code__c</td><td>string</td><td>WarehouseCode</td><td></td></tr><tr><td>Zip Code</td><td>GUMU__Ship_To_Zip_Code__c</td><td>string</td><td>ShipToZipCode</td><td></td></tr><tr><td>Default ShipTo</td><td>GUMU__Default_ShipTo__c</td><td>string</td><td></td><td>No</td></tr><tr><td>Ship to Address</td><td>GUMU__isShipTo__c</td><td>string</td><td></td><td>Yes</td></tr><tr><td>Primary Address</td><td>GUMU__IsPrimary__c</td><td>string</td><td></td><td>No</td></tr><tr><td>Not Promoted?</td><td>GUMU__Not_Promoted__c</td><td>CheckBox</td><td></td><td>FALSE</td></tr></tbody></table>

**Relationship**

<table><thead><tr><th width="224">Target Field</th><th width="167">Source Field</th><th width="144">Default Value</th><th width="162">Parent Object</th></tr></thead><tbody><tr><td>GUMU__Account_Id__c</td><td>ARDivisionNo</td><td></td><td>Account</td></tr><tr><td>GUMU__Account_Id__c</td><td>CustomerNo</td><td></td><td>Account</td></tr></tbody></table>

## Sage100 - ShipVia

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="274">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Ship via Name</td><td>Name</td><td>string</td><td>ShippingCode</td></tr><tr><td>Ship Via Code</td><td>GUMU__Ship_Via_Code__c</td><td>string</td><td>ShippingCode</td></tr><tr><td>Ship Via Description</td><td>GUMU__Ship_Via_Description__c</td><td>string</td><td>ShippingCodeDesc</td></tr></tbody></table>

## Sage100 - TaxClass

**ERP to SF**

<table><thead><tr><th width="154">Target Field Label</th><th width="291">Target Field</th><th width="123">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Tax Class Code</td><td>GUMU__Tax_Class_Code__c</td><td>string</td><td>TaxClass</td></tr><tr><td>Tax Class Description</td><td>GUMU__Tax_Class_Description__c</td><td>string</td><td>TaxClassDesc</td></tr></tbody></table>

## Sage100 - TaxSchedule

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="274">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Tax Schedule Code</td><td>GUMU__Tax_Schedule_Code__c</td><td>string</td><td>TaxSchedule</td></tr><tr><td>Tax Schedule Description</td><td>GUMU__Tax_Schedule_Description__c</td><td>string</td><td>TaxScheduleDesc</td></tr></tbody></table>

## Sage100 - TermsCode

**ERP to SF**

<table><thead><tr><th width="144">Target Field Label</th><th width="304">Target Field</th><th width="110">Data Type</th><th width="142">Source Field</th></tr></thead><tbody><tr><td>Terms Code</td><td>GUMU__Terms_Code__c</td><td>string</td><td>TaxCode</td></tr><tr><td>Terms Code Description</td><td>GUMU__Terms_Code_Description__c</td><td>string</td><td>TaxCodeDesc</td></tr></tbody></table>

## Sage100 - UOM

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="274">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Unit Of Measure Name</td><td>Name</td><td>string</td><td>UnitOfMeasure</td></tr><tr><td>UOM Code</td><td>GUMU__UOM_Code__c</td><td>string</td><td>UnitOfMeasure</td></tr><tr><td>Conversion Factor</td><td>GUMU__Conversion_Factor__c</td><td>Number</td><td>ConversionFactor1</td></tr></tbody></table>

## Sage100 - Warehouse

**ERP to SF**

<table><thead><tr><th width="157">Target Field Label</th><th width="307">Target Field</th><th width="110">Data Type</th><th width="195">Source Field</th></tr></thead><tbody><tr><td>Warehouse Code</td><td>GUMU__Warehouse_Code__c</td><td>string</td><td>WarehouseCode</td></tr><tr><td>Warehouse Description</td><td>GUMU__Warehouse_Description__c</td><td>string</td><td>WarehouseDesc</td></tr></tbody></table>

## Sage100 - Sales Invoice

<table><thead><tr><th width="213">Data Page Field Label</th><th width="220">Data Page Field API Name</th><th width="167">Data Type</th></tr></thead><tbody><tr><td>Invoice Number</td><td>InvoiceNo</td><td>Text</td></tr><tr><td>Customer PO No.</td><td>CustomerPONo</td><td>Text</td></tr><tr><td>Invoice Type</td><td>InvoiceType</td><td>Text</td></tr><tr><td>Source</td><td>ModuleCode</td><td>Text</td></tr><tr><td>Division Number</td><td>ARDivisionNo</td><td>Text</td></tr><tr><td>Customer Number</td><td>CustomerNo</td><td>Text</td></tr><tr><td>Invoice Date</td><td>InvoiceDate</td><td>Date</td></tr><tr><td>Due Date</td><td>InvoiceDueDate</td><td>Date</td></tr><tr><td>Terms Code</td><td>TermsCode</td><td>Text</td></tr><tr><td>Ship Via</td><td>ShipVia</td><td>Text</td></tr><tr><td>Sales Person No.</td><td>SalespersonNo</td><td>Text</td></tr><tr><td>Tax Schedule</td><td>TaxSchedule</td><td>Text</td></tr><tr><td>Comment</td><td>Comment</td><td>Text</td></tr><tr><td>Sales Order No</td><td>SalesOrderNo</td><td>Text</td></tr><tr><td>Item Code</td><td>ItemCode</td><td>Text</td></tr><tr><td>Description</td><td>ItemCodeDesc</td><td>Text</td></tr><tr><td>Amount</td><td>ExtensionAmt</td><td>Decimal</td></tr><tr><td>Sales Tax Class</td><td>TaxClass</td><td>Text</td></tr><tr><td>Quantity</td><td>QuantityShipped</td><td>Decimal</td></tr><tr><td>Price</td><td>UnitPrice</td><td>Decimal</td></tr><tr><td>Cost</td><td>UnitCost</td><td>Decimal</td></tr><tr><td>Freight</td><td>FreightAmt</td><td>Decimal</td></tr><tr><td>Deposit Amount</td><td>DepositAmt</td><td>Decimal</td></tr><tr><td>Discount Amount</td><td>DiscountAmt</td><td>Decimal</td></tr><tr><td>Discount Rate</td><td>DiscountRate</td><td>Decimal</td></tr><tr><td>Taxable Sales Amount</td><td>TaxableSalesAmt</td><td>Decimal</td></tr><tr><td>Sales Tax Amount</td><td>SalesTaxAmt</td><td>Decimal</td></tr><tr><td>Non Taxable Amount</td><td>NonTaxableSalesAmt</td><td>Decimal</td></tr></tbody></table>

## Sage100 - Shipments

<table><thead><tr><th width="178">Data Page Field Label</th><th width="189">Data Page Field API Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Invoice No</td><td>InvoiceNo</td><td>Text</td></tr><tr><td>Customer No</td><td>CustomerNo</td><td>Text</td></tr><tr><td>SalesOrder No</td><td>SalesOrderNo</td><td>Text</td></tr><tr><td>ARDivision No</td><td>ARDivisionNo</td><td>Text</td></tr><tr><td>Multiple SO Applied</td><td>MultipleSalesOrdersApplied</td><td>Text</td></tr><tr><td>Multiple PO Nos</td><td>MultipleCustomerPONos</td><td>Text</td></tr><tr><td>Ship Date</td><td>ShipDate</td><td>Text</td></tr><tr><td>Ship Via</td><td>ShipVia</td><td>Text</td></tr><tr><td>Shipper ID</td><td>ShipperID</td><td>Text</td></tr><tr><td>Freight Amt</td><td>FreightAmt</td><td>Text</td></tr><tr><td>Invoice Total</td><td>InvoiceTotal</td><td>Text</td></tr><tr><td>Date Updated</td><td>DateUpdated</td><td>Text</td></tr></tbody></table>

## Sage100 - AR Open Invoice

<table><thead><tr><th width="205">Data Page Field Label</th><th width="161">Data Page Field API Name</th><th width="124">Data Type</th></tr></thead><tbody><tr><td>Invoice Number</td><td>InvoiceNo</td><td>Text</td></tr><tr><td>Invoice Type</td><td>InvoiceType</td><td>Text</td></tr><tr><td>Customer PO No.</td><td>CustomerPONo</td><td>Text</td></tr><tr><td>Source</td><td>ModuleCode</td><td>Text</td></tr><tr><td>Division Number</td><td>ARDivisionNo</td><td>Text</td></tr><tr><td>Customer Number</td><td>CustomerNo</td><td>Text</td></tr><tr><td>Invoice Date</td><td>InvoiceDate</td><td>Date</td></tr><tr><td>Due Date</td><td>InvoiceDueDate</td><td>Date</td></tr><tr><td>Terms Code</td><td>TermsCode</td><td>Number</td></tr><tr><td>Ship Via</td><td>ShipVia</td><td>Text</td></tr><tr><td>Sales Person No.</td><td>SalespersonNo</td><td>Text</td></tr><tr><td>Tax Schedule</td><td>TaxSchedule</td><td>Text</td></tr><tr><td>Comment</td><td>Comment</td><td>Text</td></tr><tr><td>Sales Order No</td><td>salesOrderNo</td><td>Text</td></tr><tr><td>Item Code</td><td>ItemCode</td><td>Text</td></tr><tr><td>Description</td><td>ItemCodeDesc</td><td>Text</td></tr><tr><td>Amount</td><td>ExtensionAmt</td><td>Decimal</td></tr><tr><td>Sales Tax Class</td><td>TaxClass</td><td>Text</td></tr><tr><td>Quantity</td><td>QuantityOrdered</td><td>Decimal</td></tr><tr><td>Price</td><td>UnitPrice</td><td>Decimal</td></tr><tr><td>Cost</td><td>UnitCost</td><td>Decimal</td></tr><tr><td>Freight</td><td>FreightAmt</td><td>Decimal</td></tr><tr><td>Discount Amount</td><td>DiscountAmt</td><td>Decimal</td></tr><tr><td>Sales Tax Amount</td><td>SalesTaxAmt</td><td>Decimal</td></tr><tr><td>Non Taxable Amount</td><td>NonTaxableAmt</td><td>Decimal</td></tr></tbody></table>