eBridge for Sage MAS 90/200 Overview

Description: Creates a Sales Order in the accounting system. [Supports Customer on the fly and Item on the fly creation.]

The Inbound Sales Order touchpoint includes the following fields:

Sales Order Entry: Header: Cust PO
Sales Order Entry: Order Number
Sales Order Entry: Header: Order Date
Sales Order Entry: Header: Ship Date
Sales Order Entry: Header: Customer No
Sales Order Entry: Header: Customer No
Sales Order Entry: Header: Fax No
Sales Order Entry: Header: E-mail
Sales Order Entry: Header: Whse
Sales Order Entry: Header: Ship Via
Sales Order Entry: Header: Terms Code
SO_SalesOrderHeader.CheckNoForDeposit
Sales Order Entry: Header: Sales Tax Schedule
Sales Order Entry: Total: Freight Amount
Sales Order Entry: Header: Salesperson
Sales Order Entry: Total: Discount Rate
Sales Order Entry: Total: Discount Amount
Sales Order Entry: Header: FOB
Sales Order Entry: Header: Comment
Sales Order Entry: Total: Ship Weight
Sales Order Entry: Total: Ship Zone
Sales Order Entry: Header: Status
Sales Order Entry: Total: Deposit Amount
Sales Order Entry: Header: Print Orders
Sales Order Entry: Header: Print Pick Sheets
Sales Order Entry: Address: Bill To Address: Name
Sales Order Entry: Address: Bill To Address: Address
Sales Order Entry: Address: Bill To Address: Address
Sales Order Entry: Address: Bill To Address: Address
Sales Order Entry: Address: Bill To Address: City
Sales Order Entry: Address: Bill To Address: State
Sales Order Entry: Address: Bill To Address: ZIP Code
Sales Order Entry: Address: Bill To Address: Country
Sales Order Entry: Header: Ship To Addr
Sales Order Entry: Address: Ship To Address: Name
Sales Order Entry: Address: Ship To Address: Address
Sales Order Entry: Address: Ship To Address: Address
Sales Order Entry: Address: Ship To Address: Address
Sales Order Entry: Address: Ship To Address: City
Sales Order Entry: Address: Ship To Address: State
Sales Order Entry: Address: Ship To Address: ZIP Code
Sales Order Entry: Address: Ship To Address: Country
Sales Order Entry: Lines: Item Code: Line Key
Sales Order Entry: Lines: Item Code: Item Type
Sales Order Entry: Lines: Item Code
Sales Order Entry: Lines: Item Code: Description
Sales Order Entry: Lines: Item Code: Ordered
Sales Order Entry: Lines: Item Code: Unit Of Measure
Sales Order Entry: Lines: Item Code: Warehouse
Sales Order Entry: Lines: Item Code: Unit Price
Sales Order Entry: Lines: Item Code: Disc %
Sales Order Entry: Lines: Item Code: Drop Ship
Sales Order Entry: Lines: Item Code: Comment
Sales Order Entry: Lines: Item Code: Commissionable
Sales Order Entry: Lines: Item Code: Subj To Exempt
Sales Order Entry: Lines: Item Code: Promise Date

Description: This component creates Invoice within MAS 90/200.

The Invoice Create touchpoint includes the following fields:

Invoice Data Entry: Header: Invoice No
Invoice Data Entry: Header: Invoice Date
Invoice Data Entry: Header: Sales Order Number
Invoice Data Entry: Header: Order Status
Invoice Data Entry: Header: Order Date
Invoice Data Entry: Header: ShipExpireDate
Invoice Data Entry: Header: FOB
Invoice Data Entry: Header: ShipToCode
Invoice Data Entry: Header: ShipToAddress1
Invoice Data Entry: Header: ShipToAddress2
Invoice Data Entry: Header: ShipToAddress3
Invoice Data Entry: Header: ShipToName
Invoice Data Entry: Header: ShipToCity
Invoice Data Entry: Header: ShipToState
Invoice Data Entry: Header: ShipToZipCode
Invoice Data Entry: Header: ShipToCountryCode
Invoice Data Entry: Header: BillToAddress1
Invoice Data Entry: Header: BillToAddress2
Invoice Data Entry: Header: BillToAddress3
Invoice Data Entry: Header: BillToName
Invoice Data Entry: Header: BillToCity
Invoice Data Entry: Header: BillToState
Invoice Data Entry: Header: BillToZipCode
Invoice Data Entry: Header: BillToCountryCode
Invoice Data Entry: Header: ShipToResidentialAddress
Invoice Data Entry: Header: ResidentialAddress
Invoice Data Entry: Header: Payment Type
Invoice Data Entry: Header: OtherPaymentTypeRefNo
Invoice Data Entry: Header: Deposit Amount
Invoice Data Entry: Header: Freight Amount
Invoice Data Entry: Header: Terms Code
Invoice Data Entry: Header: Comment
Invoice Data Entry: Header: Discount Amount
Invoice Data Entry: Header: Discount Rate
Invoice Data Entry: Header: Ship Via
Invoice Data Entry: Header: Number Of Packages
Customer: SortField
Invoice Data Entry: Header: CustomerNo
Invoice Data Entry: Header: CustomerPONo
Customer: CustomerName
Customer: Address1
Customer: Address2
Customer: Address3
Customer: City
Customer: State
Customer: ZipCode
Customer: CountryCode
Customer: EmailAddress
Customer: TelephoneNo
Customer: FaxNo
Customer: URLAddress
Customer: Salesperson
Customer: TermsCode
Customer: TaxSchedule
Customer: ShipMethod
Customer: ResidentialAddr
Customer: CustomerType
Customer: BillToEmailAddress
Customer: PriceLevel
Invoice Data Entry: Detail: Item Code
Invoice Data Entry: Detail: Quantity Ordered
Invoice Data Entry: Detail: Unit Price
Invoice Data Entry: Detail: Drop Ship
Invoice Data Entry: Detail: Item Code Description
Invoice Data Entry: Detail: Comment
Invoice Data Entry: Detail: Commissionable
Invoice Data Entry: Detail: Subject To Exemption
Invoice Data Entry: Detail: Discount
Invoice Data Entry: Detail: Line Discount Percent
Invoice Data Entry: Detail: Warehouse Code
CreateNewCustomer
LocateCustomerBy
ARDivisionID
SalesPersonID
TaxScheduleID
AllowDuplicatePOs

Description: This component retrieves customer data from MAS including Customer record UDFs

The Customer Export touchpoint includes the following fields:

ARDIVISIONNO
CUSTOMERNO
CUSTOMERNAME
ADDRESSLINE1
ADDRESSLINE2
ADDRESSLINE3
CITY
STATE
ZIPCODE
COUNTRYCODE
TELEPHONENO
TELEPHONEEXT
FAXNO
EMAILADDRESS
URLADDRESS
EBMENABLED
EBMCONSUMERUSERID
BATCHFAX
DEFAULTCREDITCARDPMTTYPE
CONTACTCODE
SHIPMETHOD
TAXSCHEDULE
TAXEXEMPTNO
TERMSCODE
SALESPERSONDIVISIONNO
SALESPERSONNO
COMMENT
SORTFIELD
TEMPORARYCUSTOMER
OPENITEMCUSTOMER
RESIDENTIALADDRESS
STATEMENTCYCLE
PRINTDUNNINGMESSAGE
CUSTOMERTYPE
PRICELEVEL
DATELASTACTIVITY
DATELASTPAYMENT
DATELASTSTATEMENT
DATELASTFINANCECHRG
DATELASTAGING
DEFAULTITEMCODE
CREDITHOLD
PRIMARYSHIPTOCODE
DATEESTABLISHED
ENCRYPTEDCREDITCARDNO
DEFAULTPAYMENTTYPE
EMAILSTATEMENTS
NUMBEROFINVTOUSEINCALC
AVGDAYSPAYMENTINVOICE
AVGDAYSOVERDUE
CUSTOMERDISCOUNTRATE
SERVICECHARGERATE
CREDITLIMIT
LASTPAYMENTAMT
HIGHESTSTMNTBALANCE
UNPAIDSERVICECHRG
BALANCEFORWARD
CURRENTBALANCE
AGINGCATEGORY1
AGINGCATEGORY2
AGINGCATEGORY3
AGINGCATEGORY4
OPENORDERAMT
RETENTIONCURRENT
RETENTIONAGING1
RETENTIONAGING2
RETENTIONAGING3
RETENTIONAGING4
DATECREATED
TIMECREATED
USERCREATEDKEY
DATEUPDATED
TIMEUPDATED
USERUPDATEDKEY
SHIPTOCODE
SHIPTONAME
SHIPTOADDRESS1
SHIPTOADDRESS2
SHIPTOADDRESS3
SHIPTOCITY
SHIPTOSTATE
SHIPTOZIPCODE
SHIPTOCOUNTRYCODE
TELEPHONENO
FAXNO
EMAILADDRESS
CONTACTCODE
RetrieveBy
ModifiedDate
ShipToAddress

Description: This component extracts item and total available quantity from MAS 90 for regular items in MAS.

The Outbound Inventory touchpoint includes the following fields:

Document ID
Document Date
Item Code
Quantity Available
Item Mask
Warehouses
Items Per File
Product Type
Quantity
RetrieveBy
RetrieveByCustom

Description: Extracts a Posted Invoice from the accounting system.

The Outbound Posted Invoice touchpoint includes the following fields:

A/R Invoice History Inquiry: Invoice No
A/R Invoice History Inquiry: Date
A/R Invoice History Inquiry: Main: Customer PO
A/R Invoice History Inquiry: Order No
A/R Invoice History Inquiry: Order Date
A/R Invoice History Inquiry: Order Type
A/R Invoice History Inquiry: Type
A/R Invoice History Inquiry: Tax Detail: Tax Code
A/R Invoice History Inquiry: Tax Detail: Tax Amount
A/R Invoice History Inquiry: Main: Date
A/R Invoice History Inquiry: Main: Ship Date
A/R Invoice History Inquiry: Main: Customer No
A/R Invoice History Inquiry: Main: Customer No
A/R Invoice History Inquiry: Main: Customer Name
A/R Invoice History Inquiry: Main: Confirm To
A/R Invoice History Inquiry: Main: Confirm To
A/R Invoice History Inquiry: Main: Confirm To: Telephone
A/R Invoice History Inquiry: Main: Ship To
A/R Invoice History Inquiry: Main: Ship To
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: Name
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: Address (line 1)
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: Address (line 2)
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: Address (line 3)
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: ZIP Code
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: City
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: State
A/R Invoice History Inquiry: Main: Addresses: Ship-To Address: Country
A/R Invoice History Inquiry: Main: Bill To
A/R Invoice History Inquiry: Main: Bill To
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: Name
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: Address (line 1)
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: Address (line 2)
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: Address (line 3)
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: ZIP Code
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: City
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: State
A/R Invoice History Inquiry: Main: Addresses: Bill-To Address: Country
S/O Invoice Data Entry: Header: Warehouse
S/O Invoice Data Entry: Header: Warehouse
A/R Invoice History Inquiry: Main: Ship Via
A/R Invoice History Inquiry: Main: Terms Code
A/R Invoice History Inquiry: Discount Date
A/R Invoice History Inquiry: Main: Freight
A/R Invoice History Inquiry: Main: Discount Rate
A/R Invoice History Inquiry: Main: Discount
A/R Invoice History Inquiry: Main: Comment
A/R Invoice History Inquiry: Lines: Line No
A/R Invoice History Inquiry: Lines: Line No
A/R Invoice History Inquiry: Lines: Item Code
A/R Invoice History Inquiry: Lines: Item Code
A/R Invoice History Inquiry: Lines: Item Description
A/R Invoice History Inquiry: Lines: Quantity
A/R Invoice History Inquiry: Lines: UnitOfMeasure
A/R Invoice History Inquiry: Lines: Shipped
A/R Invoice History Inquiry: Lines: UnitOfMeasure
A/R Invoice History Inquiry: Lines: Additional Fields: Warehouse
A/R Invoice History Inquiry: Lines: Additional Fields: Warehouse
A/R Invoice History Inquiry: Lines: Unit Price
A/R Invoice History Inquiry: Lines: Additional Fields: Discount %
A/R Invoice History Inquiry: Lines: Additional Fields: Amount
A/R Invoice History Inquiry: Lines: Comment

Description: This component extracts all available fields for Product from MAS 90. It supports simple and full export.

The Outbound Product touchpoint includes the following fields:

Category2
Category1
Item Code
Description
Primary Vendor No
Standard Price
Retail Price
Standard Unit Of Measure
Item Type
Extended Description Key
Use In AR
Use In SO
Use In PO
Use In BM
Calculate Commission
Drop Ship
EBM Enabled
Allow Back Orders
Returns Allowed
Price Code
Trade Discount
Print Receipt Labels
Allocate Landed Cost
Warranty Code
Sales Unit Of Measure
Purchase Unit Of Measure
Post To GL By Division
Sales Acct Key
Cost Of Goods Sold Acct Key
Inventory Acct Key
Purchase Acct Key
Manufacturing Cost Acct Key
Tax Class
Purchases Tax Class
Product Line
Product Type
Valuation
Default Warehouse Code
Primary AP Division No
Inactive Item
Image File
Setup Charge
Standard Unit Cost
Category3
Category4
Sales Promotion Code
Sales Starting Date
Sales Ending Date
Sales Method
Explode Kit Items
Ship Weight
Comment Text
Restocking Method
Next LOT Serial No
Routing No
Buyer Code
Low Level Code
Vendor Item Code
Date Updated
Time Updated
Standard Unit Price
Last Total Unit Cost
Average Unit Cost
Sales Promotion Price
Suggested Retail Price
Sales Promotion Discount Percent
Total Quantity On Hand
Average Back Order Fill Days
Commission Rate
Base Commission Amount
Purchase UM Conv Fctr
Sales UM Conv Fctr
Volume
Restocking Charge
Total Inventory Value
Document Date
Quantity Available
ItemsPerFile
From Quantity
To Quantity
ResultType
ItemMask
ProductType
Document ID
Retrieve By
Retrieve By Custom

Description: Extracts a Sales Order from the accounting system.

The Outbound Sales Order touchpoint includes the following fields:

Description: Extracts an Unposted Invoice from the accounting system.

The Outbound Unposted Invoice touchpoint includes the following fields:

Description: This component retrieves shipment information from MAS and exports it to eBridge including tracking numbers, actual shipped quantities, shipping date and carrier information.

The Shipment Export touchpoint includes the following fields:

Invoice Number
Invoice Date
Invoice Type
Sales Order Number
Order Type
Order Status
Order Date
AR Division Number
Customer Number
Bill-To Name
Bill-To Address 1
Bill-To Address 2
Bill-To Address 3
Bill-To City
Bill To State
Bill-To Zip Code
Bill-To Country Code
Ship-To Code
Ship-To Name
Ship-To Address 1
Ship-To Address 2
Ship-To Address 3
Ship-To City
Ship-To State
Ship-To Zip Code
Ship-To Country Code
Ship Date
Ship Via
Ship Zone
Ship Zone Actual
Ship Weight
Customer PO Number
F.O.B.
Warehouse Code
Confirm To
Comment
Tax Schedule
Terms Code
Tax Exempt Number
Print Invoice
Invoice Printed
Accept Cash Only
Customer Type
Residential Address
Invalid Tax Calculation
Freight Calculation Method
Check Number For Deposit
Apply To Invoice Number
Lot/Serial Lines Exist
Salesperson Division Number
Salesperson Number
Split Commissions
Invoice Due Date
Discount Due Date
Batch Number
Fax Number
Email Address
Payment Type
Payment Type Category
Other Payment Type Reference Nu
Corporate Cust ID / Purch Order
Corporate Tax Overridden
Deposit Corporate Tax Overridden
Cardholder Name
Expiration Date Year
Expiration Date Month
Encrypted Credit Card Number
Credit Card CVV2 Number
Last 4 Unencrypted Credit Card Num
Credit Card Authorization Number
Authorization Code For Deposit
Authorization Date
Authorization Time
Post Authorization Processed
Credit Card Transaction ID
Credit Card Transaction ID for Deposit
Credit Card Comment
Pay Balance By Credit Card
Order Changed In Shipping
Lines Changed In Shipping
Shipper ID
Ship Status
Job Number
RMA Number
CRM User ID
CRM Company ID
CRM Person ID
CRM Opportunity ID
Invalid Warranty Code
Taxable Subject To Discount
Non-Taxable Subject To Discount
Tax SubjectTo Disc % Of Total S
Discount Rate
Taxable Amount
Non-Taxable Amount
Sales Tax Amount
Discount Amount
Retention Amount
Total Subject To Commission
Commission Rate
Commission Amount
Override Commission Amount
Freight Amount
Cost Of Goods Sold Amount
Cost of Goods Sold Subject To Comm
Deposit Amount
Weight
Credit Card Pre-Authorization Amt
Credit Card Payment / Balance Amt
SI Shipped Lines COGS
Number Of C.O.D. Labels
Number Of Backordered Lines
Number of Shipping Labels
Last Number of Shipping Labels
Number of Packages
Deposit Corporate Sales Tax
Corporate Sales Tax
Item Code
Item Type
Item Code Description
Extended Description Key
Discount
Commissionable
Subject To Exemption
Warehouse Code
Product Line
Valuation
Price Level
Unit Of Measure
Drop Ship
Lot/Serial Fully Distributed
Sales Kit Line Key
Cost Of Goods Sold Acct Key
Sales Acct Key
Price Overridden
Order Warehouse
Exploded Kit Item
Order Line Key
Bill Revision Code
Bill Option 1
Bill Option 2
Bill Option 3
Bill Option 4
Bill Option 5
Bill Option 6
Bill Option 7
Bill Option 8
Bill Option 9
Backorder Kit Comp Line
Standard Kit Bill
Skip Print Comp Line
Alias Item No
Tax Class
SO History Detl Seq No
Customer Action
Warranty Code
Expiration Date
Expiration Overridden
Cost Overridden
Item Action
Cost Code
Cost Type
Comment Text
Promise Date
Quantity Ordered
Quantity Shipped
Quantity Backordered
Unit Price
Extension Amt
Unit Cost
Unit Of Measure Conversion Fact
CommissionAmt
Quantity Per Bill
Line Discount Percent
Line Weight
RetrieveBy