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

AmountClass Table (225)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

AmountClass MDO list item table. Amount Class list for SuperOffice Sales Intelligence (Saint) - used to group sales by amounts, into bins (low --> high) called amount classes. More information regarding SuperOffice Sales Intelligence on http;//techdoc.superoffice.com

Fields

Name Description Type Null
AmountClass_Id Primary key PK
name The list item String(239)
rank Rank order UShort ●
tooltip Tooltip or other description String(254) ●
deleted 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists UShort ●
amountFrom Lower limit of this amount class Double ●
amountTo Upper limit of this amount class Double ●
currencyId Currency the limits in this amount class refer to. Mixing currencies between classes can give rise to overlapping intervals and thus unpredictable classifications. FK Currency ●
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

AmountClass table relationship diagram

Indexes

Fields Types Description
AmountClass_Id PK Clustered, Unique
name String(239) Unique
amountFrom Double Index
amountTo Double Index

Relationships

Table Description
AmountClassGroupLink User group link table for AmountClass, for MDO item hiding
AmountClassHeadingLink Heading link table for AmountClass, for MDO headers
associate Employees, resources and other users - except for External persons
CounterValue Visible for rights
Currency Currency list table

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

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