Definition of table company
Micro Sage Company Profile information , Table Dump Name company

Alphabetical Field Summary

  • comp-addr: (CHAR) Company's Street address
  • comp-bug-email-addr: (CHAR) Primary email address for automated bug reports
  • comp-city: (CHAR) Company's City
  • comp-initdate: (DATE) Date of company record initialization
  • comp-mailpath: (CHAR) Path for e-mail to reach the company
  • comp-main-base-url: (CHAR) Main/base URL for companies web pages
  • comp-main-email-addr: (CHAR) Primary email address for the company for product issues
  • comp-name: (CHAR) Name of the company
  • comp-phone: (CHAR) Company Phone #
  • comp-state: (CHAR) Company's State
  • comp-zip: (CHAR) Company's Zip Code
  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created at
  • cre-user-name: (CHAR) User who created this record
  • extern-guid: (CHAR) External Global Unique ID for this record
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Time record was last updated
  • upd-user-name: (CHAR) User who last updated this record

    Alphabetical Index Summary

  • default: (PRIMARY)


    Detailed Alphabetical Field Listing
    comp-addr Data type: CHARACTER
    Format: x(40) (Initial Value: 130 South First St)
    Help: Company's Street address

    comp-bug-email-addr Data type: CHARACTER
    Format: x(40) (Initial Value: bug-report@msage.com)
    Help: Primary email address for automated bug reports

    comp-city Data type: CHARACTER
    Format: x(30) (Initial Value: Ann Arbor)
    Help: Company's City

    comp-initdate Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date of company record initialization

    comp-mailpath Data type: CHARACTER
    Format: x(64)
    Help: Path for e-mail to reach the company

    comp-main-base-url Data type: CHARACTER
    Format: x(40) (Initial Value: http://www.msage.com/)
    Help: Main/base URL for companies web pages

    comp-main-email-addr Data type: CHARACTER
    Format: x(40) (Initial Value: support@msage.com)
    Help: Primary email address for the company for product issues

    comp-name Data type: CHARACTER
    Format: x(40) (Initial Value: Micro Sage)
    Help: Name of the company

    comp-phone Data type: CHARACTER
    Format: (xxx) 999-9999 (Initial Value: 3136630444)
    Help: Company Phone #

    comp-state Data type: CHARACTER
    Format: !! (Initial Value: MI)
    Help: Company's State

    comp-zip Data type: CHARACTER
    Format: 99999 xxxx (Initial Value: 481041304)
    Help: Company's Zip Code

    cre-date Data type: DATE
    Format: 99/99/9999
    Help: Date record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was created at

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: User who created this record

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record

    upd-date Data type: DATE
    Format: 99/99/9999
    Help: Date record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was last updated

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Help: User who last updated this record

    Created on 03/01/2019 by DBHTML V1.2