Cash Book

Comparison between versions 3.6 and 4.0

New

CBANWORD

Fields

Word new

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

Analysis Code new

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

Indices

Word new

Name:	Word
Parts:	Word

Analysis new

Name:	Analysis
Parts:	Analysis Code

CBRULE

Fields

RuleID new

Name:	RuleID
Type:	AutoInc
Domain:	CB Rule ID
Required:	true

Bank Account Code new

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

Currency Code new

Name:	Currency Code
Type:	String
Domain:	CO Currency Code
Size:	3
Upper:	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

Match 1 new

Name:	Match 1
Type:	String
Domain:	Name
Size:	40

Match 2 new

Name:	Match 2
Type:	String
Domain:	Name
Size:	40

Match 3 new

Name:	Match 3
Type:	String
Domain:	Name
Size:	40

Match 4 new

Name:	Match 4
Type:	String
Domain:	Name
Size:	40

Rule Type new

Name:	Rule Type
Type:	String
Domain:	CBRuleType
Size:	1
Upper:	true

Branch Code new

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

Department Code new

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

Customer Code new

Name:	Customer Code
Type:	String
Domain:	AR Customer Code
Size:	16
Upper:	true

Creditor Code new

Name:	Creditor Code
Type:	String
Domain:	AP Creditor Code
Size:	16
Upper:	true

Transfer Code new

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

Analysis Code new

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

GST Code new

Name:	GST Code
Type:	String
Domain:	CO Gst Code
Size:	1
Upper:	true

Narration new

Name:	Narration
Type:	String
Domain:	Narration
Size:	30

GL Account Code new

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

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

Last Used new

Name:	Last Used
Type:	Date

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

Rule new

Name:	Rule
Unique:	true
Parts:	RuleID

Bank new

Name:	Bank
Parts:	Bank Account Code

Customer new

Name:	Customer
Parts:	Customer Code

Creditor new

Name:	Creditor
Parts:	Creditor Code

Transfer new

Name:	Transfer
Parts:	Transfer Code

Analysis new

Name:	Analysis
Parts:	Analysis Code

CBWORD

Fields

Word new

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

Bank Account Code new

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

Indices

Word new

Name:	Word
Parts:	Word

Bank new

Name:	Bank
Parts:	Bank Account Code

Modified

CBANL

Fields

New

JC Disbursement

Name:	JC Disbursement
Type:	Boolean

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

Analysis Name

Domain:

changed from

Description

Analysis Name

Indices

GLAccount new

Name:	GLAccount
Parts:	GL Account Code;Analysis Code

CBANLBAL

Fields

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

CBAUTO

Fields

Inactive new

Name:	Inactive
Type:	Boolean

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

Active Automatic Payment new

Name:	Active Automatic Payment
Unique:	true
Parts:	Inactive;Automatic Payment Code

CBBAL

Fields

New

Withdrawal Activity

Name:	Withdrawal Activity
Type:	Float
Domain:	FX Amount

Withdrawal Activity Bs

Name:	Withdrawal Activity Bs
Type:	Float
Domain:	Amount

Variation Realised Bs

Name:	Variation Realised Bs
Type:	Float
Domain:	Amount

Variation Unrealised Bs

Name:	Variation Unrealised Bs
Type:	Float
Domain:	Amount

Period Opening Unrealised Bs

Name:	Period Opening Unrealised Bs
Type:	Float
Domain:	Amount

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Deleted
- Cheque Activity
- Cheque Activity Bs
- Variation Activity Bs

CBBANK

Fields

New

Match After Import

Name:	Match After Import
Type:	Boolean

Direct Debit Consolidate

Name:	Direct Debit Consolidate
Type:	Boolean

Direct Debit Definition File

Name:	Direct Debit Definition File
Type:	String
Domain:	Short File Path
Size:	60

Direct Debit Export File

Name:	Direct Debit Export File
Type:	String
Domain:	File Path
Size:	255

Variation Unrealised Bs

Name:	Variation Unrealised Bs
Type:	Float
Domain:	Amount

Withdrawal Activity

Name:	Withdrawal Activity
Type:	Float
Domain:	FX Amount

Unreconciled Withdrawals

Name:	Unreconciled Withdrawals
Type:	Float
Domain:	FX Amount

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Deleted
- Unreconciled Cheques
- Cheque Activity

CBCAT1

Fields

Inactive new

Name:	Inactive
Type:	Boolean

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

ActiveCategory new

Name:	ActiveCategory
Unique:	true
Parts:	Inactive;Code

CBCAT2

Fields

Inactive new

Name:	Inactive
Type:	Boolean

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Indices

ActiveCategory new

Name:	ActiveCategory
Unique:	true
Parts:	Inactive;Code

CBCTRL
- Indices
  - User Name modified
    
    CaseInsensitive: true

CBDISS

Fields

New

GL Account Overridden

Name:	GL Account Overridden
Type:	Boolean

Modified

Transaction ID

Domain:

CB Transaction ID

CBFXVAR

Fields

New

Transferred To GL

Name:	Transferred To GL
Type:	Boolean

Modified

Variation ID

Domain:

CB FX Variation ID

Indices

New

Transferred Period Variation

Name:	Transferred Period Variation
Unique:	true
Parts:	Transferred To GL;Period ID;Variation ID

Modified

Bank Period Variation

Unique:

true

CBLINK

Fields

New

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

LinkID

Domain:

CB Link ID

CBMEMO

Fields

New

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

Memo ID

Domain:

CB Memo ID

Custom 1

Domain:

changed from

Short Custom Text

CO Memo Custom 1 Text

Custom 2

Domain:

changed from

Short Custom Text

CO Memo Custom 2 Text

CBMEMOLN
- Fields
  - Memo ID modified
    
    Domain: CB Memo ID

CBREVAL

Fields

Record Revision new

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

CBSMDISS
- Fields
  - Item ID modified
    
    Domain: CB Summary Item ID

CBSMITEM

Fields

New

Other Party

Name:	Other Party
Type:	String
Domain:	Bank Payee
Size:	40

Reference

Name:	Reference
Type:	String
Domain:	Reference
Size:	20

Particulars

Name:	Particulars
Type:	String
Domain:	Comment
Size:	30

Comment

Name:	Comment
Type:	String
Domain:	Comment
Size:	30

Transaction ID

Name:	Transaction ID
Type:	RowID
Domain:	CB Transaction ID
Required:	true

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Deleted
- Bank Drawer
- Bank Name
- Bank Branch

Modified

Item ID

Domain:

CB Summary Item ID

Source ID

Domain:

Source ID

Summary ID

Domain:

CB Summary ID

CBSTMT

Fields

New

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

Statement ID

Domain:

CB Statement ID

Closed Transaction ID

Domain:

CB Transaction ID

CBSTMTLN

Fields

New

Other Party

Name:	Other Party
Type:	String
Domain:	Bank Payee
Size:	40

Rule ID

Name:	Rule ID
Type:	RowID
Domain:	CB Rule ID

Modified

Statement ID

Domain:

CB Statement ID

Transaction ID

Domain:

CB Transaction ID

CBSUM

Fields

New

Summary Type

Name:	Summary Type
Type:	String
Domain:	CBSummaryType
Size:	1
Upper:	true

Other Party

Name:	Other Party
Type:	String
Domain:	Bank Payee
Size:	40

Consolidate

Name:	Consolidate
Type:	Boolean

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

Summary ID

Domain:

CB Summary ID

Source ID

Domain:

Source ID

Transaction ID

Domain:

CB Transaction ID

CBTRAN

Fields

New

Other Party

Name:	Other Party
Type:	String
Domain:	Bank Payee
Size:	40

Transferred To GL

Name:	Transferred To GL
Type:	Boolean

Record Revision

Name:	Record Revision
Type:	Integer
Domain:	Record Revision

Modified

Transaction ID

Domain:

CB Transaction ID

Source ID

Domain:

Source ID

Summary ID

Domain:

CB Summary ID

Statement ID

Domain:

CB Statement ID

Indices

Transferred Period Transaction new

Name:	Transferred Period Transaction
Unique:	true
Parts:	Transferred To GL;Period ID;Transaction ID