• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

ErpListItemMapping Table (424)

Some tooltip text!
• 1 minute to read
 • 1 minute to read

Defines a mapping of ERP to CRM fields, per connection and actor type

Fields

Name Description Type Null
erplistitemmapping_id Primary key PK
ErpFieldId Link to the Erp field (and implicitly to crm list and Erp Connection) FK ErpField
ErpItemKey The unique key in the ERP system for this list item String(254)
CrmItemKey The unique key in the CRM database for this list item (list/table is identified by the ListReference in ErpField) Int ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

ErpListItemMapping table relationship diagram

Indexes

Fields Types Description
erplistitemmapping_id PK Clustered, Unique
ErpFieldId, ErpItemKey FK, String(254) Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
ErpField Store the metadata describing the fields that belong to an actor/connection combination, as described by the Erp Connector

Replication Flags

  • None

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top