Company

Comparison between versions 4.0 and 5.0

New

COBNKCHG

Fields

Change ID new

Name:	Change ID
Type:	AutoInc
Domain:	CO Bank Change ID
Required:	true

Change Type new

Name:	Change Type
Type:	String
Domain:	ChangeType
Size:	1
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

Source Module new

Name:	Source Module
Type:	String
Domain:	Module Code
Size:	2
Required:	true
Upper:	true

Old Bank Account No new

Name:	Old Bank Account No
Type:	String
Domain:	Bank Account No
Size:	34

New Bank Account No new

Name:	New Bank Account No
Type:	String
Domain:	Bank Account No
Size:	34

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

Indices

Change new

Name:	Change
Unique:	true
Parts:	Change ID

Date Time Change new

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

Type Change new

Name:	Type Change
Unique:	true
Parts:	Change Type;Change ID

COCTCAT1

Fields

Code new

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

Description new

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

Inactive new

Name:	Inactive
Type:	Boolean

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

Category new

Name:	Category
Unique:	true
Parts:	Code

ActiveCategory new

Name:	ActiveCategory
Unique:	true
Parts:	Inactive;Code

COCTCAT2

Fields

Code new

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

Description new

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

Inactive new

Name:	Inactive
Type:	Boolean

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

Category new

Name:	Category
Unique:	true
Parts:	Code

ActiveCategory new

Name:	ActiveCategory
Unique:	true
Parts:	Inactive;Code

COCTLOG

Fields

Log ID new

Name:	Log ID
Type:	AutoInc
Domain:	CO Setting Log ID
Required:	true

Change Type new

Name:	Change Type
Type:	String
Domain:	ChangeType
Size:	1
Required:	true
Upper:	true

User Code new

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

Name new

Name:	Name
Type:	String
Domain:	Control Name
Size:	60
Required:	true

Value new

Name:	Value
Type:	Variant
Size:	120

Record Revision new

Name:	Record Revision
Type:	Integer

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

Indices

Log new

Name:	Log
Unique:	true
CaseInsensitive:	true
Parts:	Log ID

User Log new

Name:	User Log
Unique:	true
Parts:	User Code;Log ID

Date Time Log new

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

CODELTA

Fields

Delta ID new

Name:	Delta ID
Type:	AutoInc
Domain:	CO Delta ID
Required:	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

Change Type new

Name:	Change Type
Type:	String
Domain:	ChangeType
Size:	1
Required:	true
Upper:	true

Change Heat new

Name:	Change Heat
Type:	Byte

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

Indices

Delta new

Name:	Delta
Unique:	true
Parts:	Delta ID

File Delta new

Name:	File Delta
Unique:	true
Parts:	Account File;Delta ID

Date Time Delta new

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

CODTFLD

Fields

Delta ID new

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

Line No new

Name:	Line No
Type:	Smallint

Name new

Name:	Name
Type:	String
Domain:	Table Field Name
Size:	40
Required:	true

Old Value new

Name:	Old Value
Type:	Variant
Size:	120

New Value new

Name:	New Value
Type:	Variant
Size:	120

Indices

Delta Line new

Name:	Delta Line
Unique:	true
Parts:	Delta ID;Line No

COTAXREG

Fields

Regime Code new

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

Regime Name new

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

Currency Code new

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

Tax Name new

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

Tax No Name new

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

Business No Name new

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

Website new

Name:	Website
Type:	String
Domain:	URL
Size:	120

Tax Basis new

Name:	Tax Basis
Type:	String
Domain:	TaxBasis
Size:	1
Upper:	true

Tax No new

Name:	Tax No
Type:	String
Domain:	Tax No
Size:	20

Tax Return Months new

Name:	Tax Return Months
Type:	Word

Allow Return Reopening new

Name:	Allow Return Reopening
Type:	Boolean

Default Gst Code new

Name:	Default Gst Code
Type:	String
Domain:	CO Gst Code
Size:	4
Required:	true
Upper:	true

Provisional Type new

Name:	Provisional Type
Type:	String
Domain:	ProvisionalType
Size:	1
Required:	true
Upper:	true

Provisional Ratio new

Name:	Provisional Ratio
Type:	Float
Domain:	Tax Rate

Provisional Return Months new

Name:	Provisional Return Months
Type:	Word

Business No new

Name:	Business No
Type:	String
Domain:	Tax No
Size:	20

GL Tax Sales Income Account new

Name:	GL Tax Sales Income Account
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Tax Sales Adjustment Account new

Name:	GL Tax Sales Adjustment Account
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Tax Purchases Expense Account new

Name:	GL Tax Purchases Expense Account
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Tax Purchases Adjustment Account new

Name:	GL Tax Purchases Adjustment Account
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Cash Basis Clearing Account new

Name:	GL Cash Basis Clearing Account
Type:	String
Domain:	GL Account Code
Size:	8
Upper:	true

GL Rounding Adjustment Account new

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

GL Tax Adjustment Branch new

Name:	GL Tax Adjustment Branch
Type:	String
Domain:	CO Branch Code
Size:	4
Upper:	true

GL Tax Adjustment Department new

Name:	GL Tax Adjustment Department
Type:	String
Domain:	CO Department Code
Size:	4
Upper:	true

AR Discounts new

Name:	AR Discounts
Type:	Boolean

AP Discounts new

Name:	AP Discounts
Type:	Boolean

Bank Account Code new

Name:	Bank Account Code
Type:	String
Domain:	CB Bank Account Code
Size:	8
Upper:	true

Tax Analysis Code new

Name:	Tax Analysis Code
Type:	String
Domain:	CB Analysis Code
Size:	8
Upper:	true

Provisional Analysis Code new

Name:	Provisional Analysis Code
Type:	String
Domain:	CB Analysis Code
Size:	8
Upper:	true

Last Tax Date new

Name:	Last Tax Date
Type:	Date

Next Tax Date new

Name:	Next Tax Date
Type:	Date

Last Provisional Date new

Name:	Last Provisional Date
Type:	Date

Next Provisional Date new

Name:	Next Provisional Date
Type:	Date

Last Filed Date new

Name:	Last Filed Date
Type:	Date

Inactive new

Name:	Inactive
Type:	Boolean

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

Regime new

Name:	Regime
Unique:	true
Parts:	Regime Code

Active Regime new

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

COTRACK

Fields

Table Name new

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

Heat Limit new

Name:	Heat Limit
Type:	Smallint

Indices

Table new

Name:	Table
Unique:	true
Parts:	Table Name

COTRKFLD

Fields

Table Name new

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

Field Name new

Name:	Field Name
Type:	String
Domain:	Table Field Name
Size:	40
Required:	true

Indices

Table new

Name:	Table
Unique:	true
Parts:	Table Name;Field Name

Modified

COADDR

Fields

New

Latitude

Name:	Latitude
Type:	Float
Domain:	GeoCoordinate

Longitude

Name:	Longitude
Type:	Float
Domain:	GeoCoordinate

Modified

Delivery Address 1

Domain:

changed from

Address

Delivery Address 1

Delivery Address 2

Domain:

changed from

Address

Delivery Address 2

Delivery Address 3

Domain:

changed from

Address

Delivery Address 3

Delivery Address 4

Domain:

changed from

Address

Delivery Address 4

Delivery Address 5

Domain:

changed from

Address

Delivery Address 5

COBRWORD

Fields

Count new

Name:	Count
Type:	Word

Indices

Word modified

New

Unique:

true

Modified

Parts:

changed from

Word

Word;Branch Code

COCTRL

Fields

New

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

Type

Type:

changed from

Integer

Word

CODPWORD

Fields

Count new

Name:	Count
Type:	Word

Indices

Word modified

New

Unique:

true

Modified

Parts:

changed from

Word

Word;Department Code

COGST

Fields

New

Regime Code

Name:	Regime Code
Type:	String
Domain:	CO Tax Regime Code
Size:	2
Upper:	true

Base Gst Code

Name:	Base Gst Code
Type:	String
Domain:	CO Gst Code
Size:	4
Upper:	true

Map From Gst Code

Name:	Map From Gst Code
Type:	String
Domain:	CO Gst Code
Size:	4
Upper:	true

Modified

Gst Code

Size:

changed from

Indices

Regime Gst new

Name:	Regime Gst
Unique:	true
Parts:	Regime Code;Gst Code

Regime Map new

Name:	Regime Map
ExcludeNull:	true
Parts:	Regime Code;Map From Gst Code

COGSTRT

Fields

New

Rate ID

Name:	Rate ID
Type:	AutoInc
Domain:	CO Gst Rate ID
Required:	true

Modified

Gst Code

Size:

changed from

Indices

Rate new

Name:	Rate
Unique:	true
Parts:	Rate ID

COLAYLN

Fields

Table Name modified

Domain:	changed from	Table Name	to	Domain Name
Size:	changed from	16	to	40

COLAYOUT

Fields

Label Visible new

Name:	Label Visible
Type:	Boolean

COMEMOLN

Fields

Line Space new

Name:	Line Space
Type:	Boolean

COMODULE

Indices

Module new

Name:	Module
Unique:	true
Parts:	Module Code

COPERIOD

Fields

Start Of Gst Period

deleted

Gst Basis

deleted

Gst Rate

deleted

COPHONE
- Indices
  - Transformed modified
    
    CaseInsensitive: true
  - Active Phone modified
    
    CaseInsensitive: true
  - Active Transformed modified
    
    CaseInsensitive: true

COREPORT

Fields

New

Tab Name

Name:	Tab Name
Type:	String
Domain:	Custom
Size:	20

Tab Order

Name:	Tab Order
Type:	Integer

Short Name

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

Modified

Layout Name

Deleted
- Required

Modified

Size:

changed from

255

COTDFLD

Fields

New

Control Name

Name:	Control Name
Type:	String
Domain:	Table Field Name
Size:	40

Control Type

Name:	Control Type
Type:	String
Domain:	TDControlType
Size:	1
Upper:	true

Parent Name

Name:	Parent Name
Type:	String
Domain:	Table Field Name
Size:	40

Deleted
- Field Name

Indices

New

ControlType

Name:	ControlType
Parts:	User Code;Control Type

Modified

TabField

Parts:

changed from

User Code;Tab Name;Field Name

User Code;Tab Name;Control Type;Control Name

COTDTAB

Fields

DesignedDPI new

Name:	DesignedDPI
Type:	Integer

COTEXTLN

Fields

Line Space new

Name:	Line Space
Type:	Boolean

COUSER

Fields

New

SMTP Password

Name:	SMTP Password
Type:	String
Domain:	Encrypted Password
Size:	70
Unviewable:	true

Modified

Password

Domain:	changed from	Password	to	Encrypted Password
Size:	changed from	32	to	70

COUSROLE

Fields

Role Name new

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

COUSWORD

Fields

Count new

Name:	Count
Type:	Word

Indices

Word modified

New

Unique:

true

Modified

Parts:

changed from

Word

Word;User Code