Database Table "hyp_Entity_Banking_and_Credit_Cards"
Table Description
Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| File Number | Integer | 0 | Edit | Hidden Read Only Key Field |
FileNumber | |
| Created On | FixDT | 0 | SelectEdit | Read Only Key Field |
CreatedOn | |
| Payment Method | Type Values List: 0 = null, Empty1 = Credit Card 2 = Bank Account 3 = Legal Usage Confirmation 4 = 3rd Party Payments |
Status | 0 | Select | Read Only | PaymentMethod |
| Default for Automatic Monetary Transactions | Values List: 0 = NO1 = YES, Automatic Transactions 2 = YES, with Additional Confirmation before use |
Status | 0 | Select | DefaultForAutomaticMonetaryTransactions | |
| Allow to be used by Website & API | Bool | 0 | Select | AllowToBeUsedByWebsiteApi | ||
| Bank Code | Serial | 12 | PopupEdit | BankCode | ||
| Branch / Swift | Serial | 15 | PopupEdit | BranchSwift | ||
| Account | Serial | 34 | Edit | Account | ||
| Bank Transfer Payment Format | Status | 0 | Select | BankTransferPaymentFormat | ||
| Reg. Bank Country | String | 40 | Select | RegBankCountry | ||
| Reg. Bank Name | String | 40 | Edit | RegBankName | ||
| Reg. Bank Address | String | 100 | Edit | RegBankAddress | ||
| Reg. Account Owner as Contact Person | String | 105 | PopupEdit | RegAccountOwnerAsContactPerson | ||
| CC Last 4 Digits | String | 4 | Edit | Read Only | CcLast4Digits | |
| Encrypted Data | String | 110 | Edit | Hidden Read Only |
EncryptedData | |
| Short Description | String | 40 | SelectEdit | ShortDescription | ||
| Requested Payment Day (Monthly) | Integer | 0 | Edit | RequestedPaymentDayMonthly | ||
| Last Usage | FixDT | 0 | SelectEdit | Read Only | LastUsage | |
| Last Update | FixDT | 0 | SelectEdit | Read Only | LastUpdate | |
| Entity Full Name | String | 105 | Edit | Read Only | EntityFullName |
Database Table "hyp_Clearing Credit Cards"
Table Description
Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Req ID | Integer | 0 | Edit | Read Only Key Field |
ReqId | |
| Data Type | Values List: 0 = Empty1 = Magnetic Data 2 = Card Numbers 3 = PCI DSS Token 4 = E-Wallet / Payment Service |
Status | 0 | Select | Hidden Read Only |
DataType |
| Encrypted Data | String | 110 | Edit | Hidden Read Only |
EncryptedData | |
| Command | Values List: 0 = Debit1 = Credit |
Status | 0 | Select | Read Only | Command |
| Total Amount | Money | 0 | Edit | Read Only | TotalAmount | |
| Currency | String | 5 | Select | Read Only | Currency | |
| Monthly Payments | Integer | 0 | Edit | Read Only | MonthlyPayments | |
| First Payment Amount | Money | 0 | Edit | Read Only | FirstPaymentAmount | |
| Next Payments Amount | Money | 0 | Edit | Read Only | NextPaymentsAmount | |
| Advanced Payment Sys | Values List: 0 = No1 = External Credit 2 = +30 Days |
Status | 0 | Select | Read Only | AdvancedPaymentSys |
| Manual Confirmation Code | String | 25 | Edit | Read Only | ManualConfirmationCode | |
| Created On UTC | FixDT | 0 | Edit | Read Only | CreatedOnUtc | |
| Created By | String | 40 | Edit | Read Only | CreatedBy | |
| Client Number | Integer | 0 | Edit | Read Only | ClientNumber | |
| Client Full Name | String | 105 | SelectEdit | Read Only | ClientFullName | |
| Reference | String | 20 | Edit | Read Only | Reference | |
| Agency | Status | 0 | Select | Read Only | Agency | |
| Drawer / Station ID | Integer | 0 | Edit | Read Only | DrawerStationId | |
| UI Language | Status | 0 | Select | Read Only | UiLanguage | |
| Waiting for Clearance | Bool | 0 | Select | Read Only | WaitingForClearance | |
| Result Code | Integer | 0 | Edit | Read Only | ResultCode | |
| Result Text | String | 70 | Edit | Read Only | ResultText | |
| Result Clearing Company | String | 40 | Edit | Read Only | ResultClearingCompany | |
| Result Card Brand | String | 25 | Edit | Read Only | ResultCardBrand | |
| Result Last 4 Digits | String | 4 | Edit | Read Only | ResultLast4Digits | |
| Result Bank Reference | String | 25 | Edit | Read Only | ResultBankReference | |
| Result Cash Flow Date | Date | 0 | Edit | Read Only | ResultCashFlowDate | |
| Result UID | Integer | 0 | Edit | Read Only | ResultUid | |
| Result Service Provider ID | Integer | 0 | Edit | Read Only | ResultServiceProviderId | |
| Result Service Fee | Money | 0 | Edit | Read Only | ResultServiceFee |