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, Empty1 = 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, Empty1 = 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 |
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, Empty1 = 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 |