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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.greytrix.com/gumu-salesforce-integration/sage100/setup/entity-setup/default-mappings.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.