Integration Layout

This article presents the integration tables with the Demander.

If the company has an ERP integration, records must come through these tables, not the Demander screen. See Manual registration and ERP integration.

Minimal Integration with Demander

For minimal integration with the Demander it is necessary to integrate the following tables:

Table	Observation
Table 02 - Seller
Table 03 - City
Table 04 - Payment Terms
Table 06 - Payment Methods
Table 09 - List / Price Table
Table 13 - Product Price
Table 15 - Product
Table 18 - Customer

*Optional integration tables are described below

Tables that are Imported and Exported by Demander

Table	Note
Table 16 - Order
Table 17 - Order Item
Table 18 - Customers
Table 26 - Order Item Grid
Table 34 - Customer Contact
Table 91 - Events
Table 115 - Delivery Address
Table 116 - Segments
Table 350 - Order Auxiliary Fields
Table 351 - Order Auxiliary Fields Customers
Table 354 - Auxiliary fields for order items

Tables that are only exported by Demander

Table	Observation
Table 14 - Visit without Sale
Table 71 - Sales Action
Table 72 - Sales Action Detail
Table 80 - GPS Monitoring(Suspended)
Table 119 - Receipt Financial
Table 121 - B2B Virtual Store registration request
Table 300 - Photo of Orders
Table 301 - Photo of Customers
Table 302 - Photo of Events
Table 303 - Photo of Auxiliary Fields Events
Table 353 - Event Auxiliary Fields

Tables that are only imported by Demander

Table	Note
Table 01 - Layout Version
Table 02 - Sellers
Table 03 - Cities
Table 04 - Payment Terms
Table 05 - Branches
Table 06 - Payment Methods
Table 07 - Product Group
Table 08 - Brands
Table 09 - Price Lists
Table 10 - Order Status Types
Table 11 - Reason for Visit without Sale
Table 13 - Product Price
Table 15 - Products
Table 19 - Financial Title
Table 20 - Routes
Table 21 - Route Customers
Table 21D - Deleting Customers from the Route
Table 22 - Order Status Update
Table 23 - Lots of Product
Table 25 - Product Grid
Table 27 - Billing
Table 28 - Delete Order
Table 29 - Carrier
Table 31 - Commissioning Level Structure
Table 32 - Commissioning Configuration
Table 34 - Customer Contact
Table 35 - Economic Group
Table 36 - Region
Table 41 - Tax Client Types
Table 42 - Taxation Configuration
Table 45 - Customer Types
Table 46 - Sales Divisions
Table 51 - Sales Team Sales
Table 52 - Sales Team Salespeople
Table 53 - Sales Team Managers
Table 55 - Online Store Users
Table 56 - Stock by Branch
Table 57 - Ready Stock Delivery
Table 58 - Discount for Order Value
Table 60 - Sales Expectation - Perspective
Table 61 - Sales Expectation - Perspective Levels
Table 62 - Sales Expectation - Value
Table 75 - Pricing Policy Level 1
Table 75D - Exclusion of Level 1 Pricing Policy
Table 76 - Level 2 Pricing Policy
Table 76D- Exclusion Price Policy Level2
Table 77 - Price Policy Level 3
Table 77D - Exclusion Price Policy Level 3
Table 78 - Customer x Branch x Seller
Table 90 - Types of Event
Table 92 - Event Status
Table 93-2 - Product Restriction Policy
Table 93 - Product Restriction Policy(Deprecated)
Table 117 - Order Integration Observation
Table 118 - Customer Onboarding Observation
Table 130 - Discount Types
Table 131 - Company Attributes Grid
Table 132 - Grid Attribute Variations
Table 133 - Grid Segment
Table 134 - Grid Segment Shipping
Table 161 - Freight Range Detail
Table 162 - Types of Shipping
Table 163 - Shipping Policy
Table 170 - Order Note(Detailed billing)
Table 171 - Order Item Note(Detailed billing items)
Table 180 - Flex Range by Price List
Table 189 - Payment Condition Restrictions
Table 190 - Condition href=“/en/integracoes/layout/importadas/453545-tabela-230-cota-de-carregamento-por-vendedor/”>Table 230 - Loading Quota per Seller
Table 231 - Daily Loading Quota
Table 240 - Observation Policy product
Table 270 - Cities Policy by Seller
Table 280 - Order Fields Policy
Table 401 - Exclusion of Product Prices
Table 402 - Exclusion of Product Restriction Policies
Table 403 - Deletion of Product Observation Policies
Table 901 - Update of product dimensions