Integration Layout

This article presents the integration tables with the Demander.

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=“/pt/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