Company

Comparison between versions 5.0 and 6.0

• New
  • COCONTCT
    • Fields
      • Contact ID new

        Name:	Contact ID
        Type:	AutoInc
        Domain:	CO Contact ID
        Required:	true

      • Created User Code new

        Name:	Created User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

      • Role new

        Name:	Role
        Type:	String
        Domain:	Role
        Size:	35

      • Comment new

        Name:	Comment
        Type:	String
        Domain:	Description
        Size:	60

      • Category 1 new

        Name:	Category 1
        Type:	String
        Domain:	CO Contact Category 1 Code
        Size:	8
        Upper:	true

      • Category 2 new

        Name:	Category 2
        Type:	String
        Domain:	CO Contact Category 2 Code
        Size:	8
        Upper:	true

      • Custom 1 new

        Name:	Custom 1
        Type:	String
        Domain:	CO Contact Custom 1 Text
        Size:	30

      • Custom 2 new

        Name:	Custom 2
        Type:	String
        Domain:	CO Contact Custom 2 Text
        Size:	30

      • Title new

        Name:	Title
        Type:	String
        Domain:	Contact Title
        Size:	10

      • First Name new

        Name:	First Name
        Type:	String
        Domain:	Contact Name
        Size:	20

      • Middle Name new

        Name:	Middle Name
        Type:	String
        Domain:	Contact Name
        Size:	20

      • Last Name new

        Name:	Last Name
        Type:	String
        Domain:	Contact Name
        Size:	20

      • Suffix new

        Name:	Suffix
        Type:	String
        Domain:	Contact Suffix
        Size:	10

      • Phone No new

        Name:	Phone No
        Type:	String
        Domain:	Contact Phone Number
        Size:	20

      • Phone No 2 new

        Name:	Phone No 2
        Type:	String
        Domain:	Contact Phone Number 2
        Size:	20

      • Phone No 3 new

        Name:	Phone No 3
        Type:	String
        Domain:	Contact Phone Number 3
        Size:	20

      • Company Name new

        Name:	Company Name
        Type:	String
        Domain:	Name
        Size:	60

      • Email Address new

        Name:	Email Address
        Type:	String
        Domain:	Email Address
        Size:	120

      • First Name Last Name new

        Name:	First Name Last Name
        Type:	String
        Domain:	Custom
        Size:	41

      • Last Name First Name new

        Name:	Last Name First Name
        Type:	String
        Domain:	Custom
        Size:	42

      • Table Name new

        Name:	Table Name
        Type:	String
        Domain:	Account File
        Size:	8
        Upper:	true

      • Party Code new

        Name:	Party Code
        Type:	String
        Domain:	Party Code
        Size:	16
        Upper:	true

      • Party Contact ID new

        Name:	Party Contact ID
        Type:	RowID
        Domain:	Source Contact ID

      • Inactive new

        Name:	Inactive
        Type:	Boolean

      • Modified User Code new

        Name:	Modified User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Modified Date new

        Name:	Modified Date
        Type:	Date

      • Modified Time new

        Name:	Modified Time
        Type:	Time

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Contact new

        Name:	Contact
        Unique:	true
        Parts:	Contact ID

      • ActiveContact new

        Name:	ActiveContact
        Unique:	true
        Parts:	Inactive;Contact ID

      • LastFirst new

        Name:	LastFirst
        CaseInsensitive:	true
        Parts:	Last Name First Name

      • FirstLast new

        Name:	FirstLast
        CaseInsensitive:	true
        Parts:	First Name Last Name

      • ActiveLastFirst new

        Name:	ActiveLastFirst
        CaseInsensitive:	true
        Parts:	Inactive;Last Name First Name

      • ActiveFirstLast new

        Name:	ActiveFirstLast
        CaseInsensitive:	true
        Parts:	Inactive;First Name Last Name

      • TablePartyContact new

        Name:	TablePartyContact
        Unique:	true
        Parts:	Table Name;Party Code;Party Contact ID

      • Category 1 new

        Name:	Category 1
        Parts:	Category 1

      • Category 2 new

        Name:	Category 2
        Parts:	Category 2

  • COCTWORD
    • Fields
      • Word new

        Name:	Word
        Type:	String
        Domain:	Word Text
        Size:	30
        Required:	true

      • Contact ID new

        Name:	Contact ID
        Type:	RowID
        Domain:	CO Contact ID
        Required:	true

      • Count new

        Name:	Count
        Type:	Word

    • Indices
      • Word new

        Name:	Word
        Unique:	true
        Parts:	Word;Contact ID

      • Contact new

        Name:	Contact
        Parts:	Contact ID

  • COCUSTTB
    • Fields
      • Customisation ID new

        Name:	Customisation ID
        Type:	AutoInc
        Domain:	CO Customisation ID
        Required:	true

      • Toolbar Name new

        Name:	Toolbar Name
        Type:	String
        Domain:	Event Name
        Size:	64

      • Bind ID new

        Name:	Bind ID
        Type:	RowID
        Domain:	CO Bind ID

      • User Code new

        Name:	User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Button Name new

        Name:	Button Name
        Type:	String
        Domain:	Custom
        Size:	125

      • Button Order new

        Name:	Button Order
        Type:	Integer

      • Visibility Type new

        Name:	Visibility Type
        Type:	String
        Domain:	CONavBtnVisibility
        Size:	1
        Upper:	true

      • Image Index new

        Name:	Image Index
        Type:	Integer

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Customisation new

        Name:	Customisation
        Unique:	true
        Parts:	Customisation ID

      • Toolbar User Order new

        Name:	Toolbar User Order
        Parts:	Toolbar Name;User Code;Button Order

      • User Toolbar Name Bind new

        Name:	User Toolbar Name Bind
        Unique:	true
        Parts:	User Code;Toolbar Name;Button Name;Bind ID

      • Bind new

        Name:	Bind
        Parts:	Bind ID

  • COPRTLOG
    • Fields
      • Print ID new

        Name:	Print ID
        Type:	AutoInc
        Domain:	CO Print ID
        Required:	true

      • Document Code new

        Name:	Document Code
        Type:	String
        Domain:	CO Document Code
        Size:	8
        Required:	true
        Upper:	true

      • Account File new

        Name:	Account File
        Type:	String
        Domain:	Account File
        Size:	8
        Required:	true
        Upper:	true

      • Account Code new

        Name:	Account Code
        Type:	String
        Domain:	Account Code
        Size:	28
        Required:	true
        Upper:	true

      • Destination new

        Name:	Destination
        Type:	String
        Domain:	PrintDestination
        Size:	1
        Required:	true
        Upper:	true

      • File Format new

        Name:	File Format
        Type:	String
        Domain:	PrintFileFormat
        Size:	1
        Upper:	true

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

      • Created User Code new

        Name:	Created User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Print as Copy new

        Name:	Print as Copy
        Type:	Boolean

      • Old Print Status new

        Name:	Old Print Status
        Type:	String
        Domain:	COPrintStatus
        Size:	1
        Upper:	true

      • New Print Status new

        Name:	New Print Status
        Type:	String
        Domain:	COPrintStatus
        Size:	1
        Upper:	true

    • Indices
      • Print new

        Name:	Print
        Unique:	true
        Parts:	Print ID

      • File Code Type Print new

        Name:	File Code Type Print
        Unique:	true
        Parts:	Account File;Account Code;Document Code;Print ID

      • Date Time Print new

        Name:	Date Time Print
        Unique:	true
        Parts:	Created Date;Created Time;Print ID

  • COUPLOAD
    • Fields
      • Extension new

        Name:	Extension
        Type:	String
        Domain:	File Extension
        Size:	10
        Required:	true

      • Links new

        Name:	Links
        Type:	Boolean

      • Images new

        Name:	Images
        Type:	Boolean

      • Description new

        Name:	Description
        Type:	String
        Domain:	Description
        Size:	60

      • Created User Code new

        Name:	Created User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

      • Modified User Code new

        Name:	Modified User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Modified Date new

        Name:	Modified Date
        Type:	Date

      • Modified Time new

        Name:	Modified Time
        Type:	Time

      • Record Revision new

        Name:	Record Revision
        Type:	Integer
        Domain:	Record Revision

    • Indices
      • Extension new

        Name:	Extension
        Unique:	true
        CaseInsensitive:	true
        Parts:	Extension

• Modified
  • COBIND
    • Fields
      • Created User Code new

        Name:	Created User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

      • Modified User Code new

        Name:	Modified User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Modified Date new

        Name:	Modified Date
        Type:	Date

      • Modified Time new

        Name:	Modified Time
        Type:	Time

  • COBRANCH
    • Fields
      • New
        • Phone No 2

          Name:	Phone No 2
          Type:	String
          Domain:	Account Phone Number 2
          Size:	20

        • Phone No 3

          Name:	Phone No 3
          Type:	String
          Domain:	Account Phone Number 3
          Size:	20

      • Deleted
        • Fax No
      • Modified
        • Branch Code

          Size:

          changed from

          4

          to

          8

        • Phone No

          Domain:

          changed from

          Phone Number

          to

          Account Phone Number

        • Branch Name

          Size:

          changed from

          40

          to

          60

  • COBRWORD
    • Fields
      • Branch Code modified

        Size:

        changed from

        4

        to

        8

  • COCNTRY
    • Fields
      • Country Name modified

        Size:

        changed from

        40

        to

        60

  • COCTCAT1
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • COCTCAT2
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • CODEPT
    • Fields
      • Department Code modified

        Size:

        changed from

        4

        to

        8

      • Department Name modified

        Size:

        changed from

        40

        to

        60

  • CODOCDEF
    • Fields
      • Log new

        Name:	Log
        Type:	Boolean

  • CODOMAIN
    • Fields
      • Domain Name modified

        Domain:	changed from	Custom	to	Domain Name
        Size:	changed from	108	to	40

      • Table Name modified

        Domain:

        changed from

        Custom

        to

        Long Table Name

  • CODOMUSE
    • Fields
      • Domain Name modified

        Domain:

        changed from

        Name

        to

        Domain Name

      • Table Name modified
        • New

          Upper:

          true

        • Modified

          Domain:

          changed from

          Custom

          to

          Long Table Name

  • CODPWORD
    • Fields
      • Department Code modified

        Size:

        changed from

        4

        to

        8

  • COEVENT
    • Fields
      • Event ID new

        Name:	Event ID
        Type:	AutoInc
        Domain:	CO Event ID
        Required:	true

    • Indices
      • ID new

        Name:	ID
        Unique:	true
        Parts:	Event ID

  • COFXCURR
    • Fields
      • New
        • Receipt Discount Adjustment

          Name:	Receipt Discount Adjustment
          Type:	Float
          Domain:	FX Amount

      • Modified
        • Currency Name

          Size:

          changed from

          40

          to

          60

  • COLAYLN
    • Fields
      • Table Name modified

        Domain:

        changed from

        Domain Name

        to

        Layout Table Name

  • COLAYOUT
    • Fields
      • Freeze Excel new

        Name:	Freeze Excel
        Type:	Boolean

  • COLINK
    • Fields
      • User Code modified

        Required

        deleted

      • Reference modified

        Size:

        changed from

        20

        to

        30

      • Link Type modified

        Required:

        true

    • Indices
      • New
        • Code Link

          Name:	Code Link
          Parts:	User Code;LinkID

        • Active Code Link

          Name:	Active Code Link
          Parts:	Inactive;User Code;LinkID

      • Deleted
        • Code Line
        • Active Code Line
  • COLKCAT1
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • COLKCAT2
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • COMEMO
    • Fields
      • Reference modified

        Size:

        changed from

        20

        to

        30

  • COMOCAT1
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • COMOCAT2
    • Fields
      • Description modified

        Domain:	changed from	Short Description	to	Description
        Size:	changed from	30	to	60

  • COPHONE
    • Fields
      • Phone Type modified

        Domain:

        changed from

        PhoneNoType

        to

        PhoneType

  • COREPORT
    • Fields
      • Created User Code new

        Name:	Created User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Created Date new

        Name:	Created Date
        Type:	Date

      • Created Time new

        Name:	Created Time
        Type:	Time

      • Modified User Code new

        Name:	Modified User Code
        Type:	String
        Domain:	CO User Code
        Size:	8
        Upper:	true

      • Modified Date new

        Name:	Modified Date
        Type:	Date

      • Modified Time new

        Name:	Modified Time
        Type:	Time

  • COTABLES
    • Fields
      • File Name modified

        Domain:

        changed from

        Custom

        to

        Long Table Name

  • COTAXREG
    • Fields
      • New
        • Interval Unit

          Name:	Interval Unit
          Type:	String
          Domain:	RegimeIntervalUnit
          Size:	1
          Required:	true
          Upper:	true

        • Tax Return Count

          Name:	Tax Return Count
          Type:	Word

        • Provisional Return Count

          Name:	Provisional Return Count
          Type:	Word

        • Rounded

          Name:	Rounded
          Type:	Boolean

        • GL Reconciliation Account

          Name:	GL Reconciliation Account
          Type:	String
          Domain:	GL Account Code
          Size:	8
          Upper:	true

      • Deleted
        • Tax Return Months
        • Provisional Return Months
      • Modified
        • Website

          Size:

          changed from

          120

          to

          255

        • GL Tax Adjustment Branch

          Size:

          changed from

          4

          to

          8

        • GL Tax Adjustment Department

          Size:

          changed from

          4

          to

          8

        • Payment Reference

          Size:

          changed from

          20

          to

          30

  • COUOM
    • Fields
      • Peppol UOM Code new

        Name:	Peppol UOM Code
        Type:	String
        Domain:	Peppol UOM Code
        Size:	4

  • COUSER
    • Fields
      • New
        • Image Type

          Name:	Image Type
          Type:	String
          Domain:	ImageType
          Size:	1
          Required:	true
          Upper:	true

        • Phone No 2

          Name:	Phone No 2
          Type:	String
          Domain:	Contact Phone Number 2
          Size:	20

        • Phone No 3

          Name:	Phone No 3
          Type:	String
          Domain:	Contact Phone Number 3
          Size:	20

        • Default Sales Person Code

          Name:	Default Sales Person Code
          Type:	String
          Domain:	AR Sales Person Code
          Size:	8
          Upper:	true

        • Default Store Person Code

          Name:	Default Store Person Code
          Type:	String
          Domain:	IC Store Person Code
          Size:	8
          Upper:	true

      • Deleted
        • Mobile No
      • Modified
        • Phone No

          Domain:

          changed from

          Phone Number

          to

          Contact Phone Number

        • Default Branch Code

          Size:

          changed from

          4

          to

          8

        • Default Department Code

          Size:

          changed from

          4

          to

          8

        • Password

          Size:

          changed from

          70

          to

          72

        • SMTP Password

          Domain:

          changed from

          Custom

          to

          Encrypted SMTP Password

  • COYEAR
    • Fields
      • Year Name modified

        Size:

        changed from

        40

        to

        60