Database Table "hyp_Import Bank Statement Main"

Table Description

The fields definitions for the import of bank statements. These fields are defined from the "Toolbox" tab of the Bookkeeping Module of Hyper.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name English Title Data Type Text Length Editor Attributes json
Profile Number Integer 0 Edit Hidden
Key Field
ProfileNumber
Nickname String 50 Edit Mandatory Nickname
Statement Type
Values List:
0 = null, Empty
1 = Bank Account Transactions
2 = Credit Card Transactions
3 = Credit Card Multi Currency
Status 0 Select Mandatory StatementType
Account ID Integer 0 Edit Read Only AccountId
Account Name String 50 PopupList Mandatory AccountName
BK Entry Date Column Integer 0 Select Mandatory BkEntryDateColumn
Cash Flow Date Column Integer 0 Select CashFlowDateColumn
Description Column Integer 0 Select Mandatory DescriptionColumn
Reference Document Column Integer 0 Select ReferenceDocumentColumn
Debit Transferred Amount Column Integer 0 Select Mandatory DebitTransferredAmountColumn
Credit Transferred Amount Column Integer 0 Select Mandatory CreditTransferredAmountColumn
Currency Column Integer 0 Select CurrencyColumn
Default Currency String 5 Select Mandatory DefaultCurrency
Date Mask
Values List:
0 = null, Empty
1 = MM/DD/YYYY
2 = DD/MM/YYYY
3 = YYYY-MM-DD
Status 0 Select Mandatory DateMask
Ext Description might be on a 2nd row Bool 0 Select ExtDescriptionMightBeOnA2ndRow
Ext Description 2 Column Integer 0 Select ExtDescription2Column
Ext Description 3 Column Integer 0 Select ExtDescription3Column
Client Name Column Integer 0 Select ClientNameColumn
Client ID Column Integer 0 Select ClientIdColumn
Client ID Refer to field name String 50 Select ClientIdReferToFieldName
Jump to tables index

Database Table "hyp_Import Bank Statement Rules"

Table Description

The logical rules for auto identifying target accounts. The fields of this table are defined during the import of bank statements as entries, after defining the imported columns.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name English Title Data Type Text Length Editor Attributes json
Profile Number Integer 0 Edit Hidden
Key Field
ProfileNumber
Created On FixDT 0 SelectEdit Read Only
Key Field
CreatedOn
Rule Function
Values List:
0 = null, Empty
1 = Description Contain Text
2 = Description Starting with
3 = Description is Equal to
4 = Description Contain the Word
5 = Description Sound Search
6 = Both Desc and Ref included
Status 0 Select Mandatory RuleFunction
Rule String String 50 Edit Mandatory RuleString
Target Account ID Integer 0 Edit Read Only TargetAccountId
Target Account Name String 50 PopupList Mandatory TargetAccountName
Last Use Date 0 SelectEdit Read Only LastUse
Jump to tables index