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

PhoneFormat Table (251)

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

Formatting information for telephone numbers

Fields

Name Description Type Null
PhoneFormat_id Primary key PK
countryId Country this format record is valid for FK country
prefix Prefix that triggers this format String(39)
dontFormat If 1, do not apply any formatting to this number Bool
areaCodeLength Length of area code (can be interval) String(39)
localLength Length of local part of telephone number (can be interval) String(39)
mask Formatting mask to be applied String(39)
description Description of this format String(254)
isBuiltIn Does this row come from SuperOffice priming data Bool
isActive Is this format record active (handy for experimenting) Bool ●
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

PhoneFormat table relationship diagram

Indexes

Fields Types Description
PhoneFormat_id PK Clustered, Unique
prefix, countryId String(39), FK Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
country Country information

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