Company

Comparison between versions 2.7 and 3.0

New

COCNTRY

Fields

Country Code new

Name:	Country Code
Type:	String
Domain:	CO Country Code
Size:	2
Required:	true
Upper:	true

Country Name new

Name:	Country Name
Type:	String
Domain:	Name
Size:	35
Required:	true

Currency Code new

Name:	Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Required:	true
Upper:	true

Indices

Code new

Name:	Code
Unique:	true
Parts:	Country Code

Name new

Name:	Name
Parts:	Country Name

COFXCURR

Fields

Currency Code new

Name:	Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Required:	true
Upper:	true

Currency Name new

Name:	Currency Name
Type:	String
Domain:	Name
Size:	35

Currency Symbol new

Name:	Currency Symbol
Type:	String
Domain:	CO Currency Symbol
Size:	8

Minimum Rate new

Name:	Minimum Rate
Type:	Float
Domain:	Exchange Rate

Maximum Rate new

Name:	Maximum Rate
Type:	Float
Domain:	Exchange Rate

Amount Decimals new

Name:	Amount Decimals
Type:	Smallint

Cost Price Decimals new

Name:	Cost Price Decimals
Type:	Smallint

Sell Price Decimals new

Name:	Sell Price Decimals
Type:	Smallint

Decimal Symbol new

Name:	Decimal Symbol
Type:	String
Domain:	FXDecimalSymbol
Size:	1
Upper:	true

Grouping Symbol new

Name:	Grouping Symbol
Type:	String
Domain:	FXGroupingSymbol
Size:	1
Upper:	true

GL Unrealised Gain Loss Code new

Name:	GL Unrealised Gain Loss Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Realised Gain Loss Code new

Name:	GL Realised Gain Loss Code
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Unrealised Variation Code new

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

Inactive new

Name:	Inactive
Type:	Boolean

Symbol Position new

Name:	Symbol Position
Type:	String
Domain:	FXSymbolPos
Size:	1
Upper:	true

Cash Rounding new

Name:	Cash Rounding
Type:	String
Domain:	FX Cash Rounding
Size:	9
Required:	true

Shipment Discrepancy new

Name:	Shipment Discrepancy
Type:	Float
Domain:	FX Amount

Major Singular new

Name:	Major Singular
Type:	String
Domain:	AmountWord
Size:	20

Major Plural new

Name:	Major Plural
Type:	String
Domain:	AmountWord
Size:	20

Minor Singular new

Name:	Minor Singular
Type:	String
Domain:	AmountWord
Size:	20

Minor Plural new

Name:	Minor Plural
Type:	String
Domain:	AmountWord
Size:	20

Indices

Currency new

Name:	Currency
Unique:	true
Parts:	Currency Code

ActiveCurrency new

Name:	ActiveCurrency
Parts:	Inactive;Currency Code

COFXRATE

Fields

From Currency Code new

Name:	From Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Required:	true
Upper:	true

To Currency Code new

Name:	To Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Required:	true
Upper:	true

Rate Type new

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

Effective Date new

Name:	Effective Date
Type:	Date
Required:	true

Expiry Date new

Name:	Expiry Date
Type:	Date

Exchange Rate new

Name:	Exchange Rate
Type:	Float
Domain:	Exchange Rate
Required:	true

Indices

CurrencyRateTypeDate new

Name:	CurrencyRateTypeDate
Unique:	true
Parts:	From Currency Code;To Currency Code;Rate Type;Effective Date

CurrencyDate new

Name:	CurrencyDate
Parts:	From Currency Code;To Currency Code;Effective Date

COFXTYPE

Fields

Code new

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

Description new

Name:	Description
Type:	String
Domain:	Short Description
Size:	30

Inactive new

Name:	Inactive
Type:	Boolean

Indices

Rate Type new

Name:	Rate Type
Unique:	true
Parts:	Code

Active Rate Type new

Name:	Active Rate Type
Unique:	true
Parts:	Inactive;Code

COLKCAT1

Fields

Code new

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

Description new

Name:	Description
Type:	String
Domain:	Short Description
Size:	30

Indices

Category new

Name:	Category
Unique:	true
Parts:	Code

COLKCAT2

Fields

Code new

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

Description new

Name:	Description
Type:	String
Domain:	Short Description
Size:	30

Indices

Category new

Name:	Category
Unique:	true
Parts:	Code

COMOCAT1

Fields

Code new

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

Description new

Name:	Description
Type:	String
Domain:	Short Description
Size:	30

Indices

Category new

Name:	Category
Unique:	true
Parts:	Code

COMOCAT2

Fields

Code new

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

Description new

Name:	Description
Type:	String
Domain:	Short Description
Size:	30

Indices

Category new

Name:	Category
Unique:	true
Parts:	Code

Modified

COADDR

Fields

Delivery Country Code new

Name:	Delivery Country Code
Type:	String
Domain:	CO Country Code
Size:	2
Upper:	true

Delivery Post Code new

Name:	Delivery Post Code
Type:	String
Domain:	Post Code
Size:	10

COBIND

Fields

New

Bind ID

Name:	Bind ID
Type:	AutoInc
Required:	true

Bind Type

Name:	Bind Type
Type:	String
Domain:	BindType
Size:	1
Required:	true
Upper:	true

Modified

Script Path

New

Domain:

File Path

Modified

Size:

changed from

250

255

Button Hint

Domain:

Custom

Tab Name

Domain:

Custom

Folder Name

New

Domain:

Custom

Modified

Size:

changed from

255

Indices

Bind ID new

Name:	Bind ID
Unique:	true
Parts:	Bind ID

COBRANCH

Fields

New

Created User Code

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

Created Date

Name:	Created Date
Type:	Date

Created Time

Name:	Created Time
Type:	Time

Modified User Code

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

Modified Date

Name:	Modified Date
Type:	Date

Modified Time

Name:	Modified Time
Type:	Time

Modified

Branch Name

Domain:

Name

Custom 1

Domain:

Short Custom Text

Custom 2

Domain:

Short Custom Text

COCTRL
- Fields
  - Name modified
    
    Domain: Control Name

COCUSTOM

Fields

Dataset Name modified

Domain: Custom

Field Name modified

New

Domain:

Table Field Name

Modified

Size:

changed from

Display Label modified

Domain: Display Label

CODEPT

Fields

New

Created User Code

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

Created Date

Name:	Created Date
Type:	Date

Created Time

Name:	Created Time
Type:	Time

Modified User Code

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

Modified Date

Name:	Modified Date
Type:	Date

Modified Time

Name:	Modified Time
Type:	Time

Modified

Department Name

Domain:

Name

Custom 1

Domain:

Short Custom Text

Custom 2

Domain:

Short Custom Text

CODOCDEF

Fields

New

Default Email Document

Name:	Default Email Document
Type:	String
Domain:	File Path
Size:	255

Modified

Default Code

Domain:

CO Document Code

Default Document

Domain:

File Path

COEVENT

Fields

New

Inactive

Name:	Inactive
Type:	Boolean

Modified

Event

Domain:

Event Name

Script Path

New

Domain:

File Path

Modified

Size:

changed from

250

255

COGST

Fields

Gst Code modified

Domain:

changed from

Character

CO Gst Code

Description modified

New

Domain:

Short Description

Modified

Size:

changed from

COLAYLN

Fields

Table Name modified

Domain: Table Name

Type modified

Domain:	LayoutLineType
Upper:	true

Data modified

Domain: Custom

COLAYOUT

Fields

New

Zero As Blank

Name:	Zero As Blank
Type:	Boolean

Expression

Name:	Expression
Type:	String
Domain:	Custom
Size:	255

Format

Name:	Format
Type:	String
Domain:	Custom
Size:	64

Modified

Table Name

Domain:

Table Name

Field Name

Domain:

Table Field Name

Display Label

New

Domain:

Display Label

Modified

Size:

changed from

COMEDIA

Fields

New

Bank Through

Name:	Bank Through
Type:	Boolean

Modified

Media Name

Domain:

Short Description

Media Type

Domain:

changed from

Character

MediaType

COMEMO

Fields

New

Memo Time

Name:	Memo Time
Type:	Time
Required:	true

Subject

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

Memo Type

Name:	Memo Type
Type:	String
Domain:	MemoType
Size:	1
Required:	true
Upper:	true

Action On Time

Name:	Action On Time
Type:	Time

Target User Code

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

Category 1

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

Category 2

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

Custom 1

Name:	Custom 1
Type:	String
Domain:	Short Custom Text
Size:	30

Custom 2

Name:	Custom 2
Type:	String
Domain:	Short Custom Text
Size:	30

Inactive

Name:	Inactive
Type:	Boolean

Created User Code

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

Created Date

Name:	Created Date
Type:	Date

Created Time

Name:	Created Time
Type:	Time

Modified User Code

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

Modified Date

Name:	Modified Date
Type:	Date

Modified Time

Name:	Modified Time
Type:	Time

Deleted
- Memo Or Alarm
- User Code

Modified

Account File

Domain:

Account File

Account Code

Domain:

Account Code

Reference

New

Domain:

Reference

Modified

Size:

changed from

Indices

New

Active File Code Type Memo

Name:	Active File Code Type Memo
Unique:	true
Parts:	Inactive;Account File;Account Code;Memo Type;Memo ID

Active Type ActionDateTime

Name:	Active Type ActionDateTime
Parts:	Inactive;Memo Type;Action On Date;Action On Time

File Type Code Memo

Name:	File Type Code Memo
Unique:	true
Parts:	Account File;Memo Type;Account Code;Memo ID

Active File Type Code Memo

Name:	Active File Type Code Memo
Unique:	true
Parts:	Inactive;Account File;Memo Type;Account Code;Memo ID

Type File Code Memo

Name:	Type File Code Memo
Unique:	true
Parts:	Memo Type;Account File;Account Code;Memo ID

Active Type File Code Memo

Name:	Active Type File Code Memo
Unique:	true
Parts:	Inactive;Memo Type;Account File;Account Code;Memo ID

Modified

File Code Type Memo

Parts:

changed from

Account File;Account Code;Memo Or Alarm;Memo ID

Account File;Account Code;Memo Type;Memo ID

COMEMOLN
- Fields
  - Line Text modified
    
    Domain: Memo Line Text
COMODULE
- Fields
  - Module Code modified
    
    Domain: Long Module Code
COMPANY
- Fields
  - Long Name modified
    
    Domain: Custom
  - Directory modified
    
    Domain: Short File Path

COPERIOD

Fields

New

Gst Rate

Name:	Gst Rate
Type:	Float
Domain:	Tax Rate

Modified

Period Status

Domain:

changed from

Character

PeriodStatus

Gst Basis

Domain:

changed from

Character

GstBasis

IC Valuation Basis

Domain:

changed from

Character

ICValuationBasis

JC Work In Progress Basis

Domain:

changed from

Character

JCWorkInProgressBasis

COPRICE

Fields

New

Currency Code

Name:	Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Required:	true
Upper:	true

Markup Price Code

Name:	Markup Price Code
Type:	String
Domain:	CO Price Code
Size:	8
Upper:	true

Rounding Direction

Name:	Rounding Direction
Type:	String
Domain:	RoundingDirection
Size:	1
Required:	true
Upper:	true

Rounding Unit

Name:	Rounding Unit
Type:	Float
Domain:	FX Sell Price

Line No

Name:	Line No
Type:	Integer

Modified

Price List Name

Domain:

Short Description

Price List Gst Basis

Domain:

changed from

Character

InclExcl

Indices

Currency Price new

Name:	Currency Price
Unique:	true
Parts:	Currency Code;Price Code

Line new

Name:	Line
Unique:	true
Parts:	Line No

COREPORT

Fields

New

User Code Type

Name:	User Code Type
Type:	String
Domain:	COReportUserCode
Size:	1
Required:	true
Upper:	true

Modified

Report Code

Domain:

Report Code

Report Title

Domain:

Report Title

Layout Name

Domain:

Layout Name

Filter

Domain:

Custom

Indices

New

Report Layout

Name:	Report Layout
Parts:	Report Code;Layout Name

Deleted
- Report User Layout

COTABLES

Fields

Deleted
- Extends

Modified

File Name

Domain:

Custom

COTEXT
- Fields
  - Text Code modified
    
    Domain: CO Text Code
  - Description modified
    
    Domain: Short Description

COTEXTLN

Fields

Text Code modified

Domain:	CO Text Code
Upper:	true

Line Text modified

Domain: Description

COUSER

Fields

New

Inactive

Name:	Inactive
Type:	Boolean

Modified

User Name

Domain:

Short Description

Password

Domain:	Password
Unviewable:	true

Indices

Active User new

Name:	Active User
Unique:	true
Parts:	Inactive;User Code

Group User new

Name:	Group User
Unique:	true
Parts:	Member Of Group;User Code