Database Table "hyp_Refunds"
Table Description
The Refunds table in Hyper.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
---|---|---|---|---|---|---|
Refund Number | Withdrawal Form Number | Integer | 0 | Edit | Read Only Key Field |
RefundNumber |
Agency | Status | 0 | Select | Agency | ||
Drawer / Station ID | Integer | 0 | Edit | Read Only | DrawerStationId | |
Sales Agent | String | 40 | PopupList | SalesAgent | ||
Client Number | Integer | 0 | Edit | Hidden Read Only Mandatory |
ClientNumber | |
Client Full Name | String | 105 | SelectEdit | Mandatory | ClientFullName | |
Contact Person | String | 105 | PopupList | ContactPerson | ||
Address | String | 300 | Memo | Address | ||
Phone | Phone | 20 | Edit | Phone | ||
String | 80 | Edit | ||||
ID Number | Serial | 20 | Edit | IdNumber | ||
Language | Status | 0 | Select | Language | ||
International Document | Bool | 0 | Select | InternationalDocument | ||
Total Refund LC | Total Withdrawal | Money | 0 | Edit | Read Only | TotalRefundLc |
Purchaser Currency | String | 5 | Select | Mandatory | PurchaserCurrency | |
Total Refund in PC | Total Withdrawal in PC | Money | 0 | Edit | Read Only | TotalRefundInPc |
Origin Production Time | FixDT | 0 | SelectEdit | OriginProductionTime | ||
Produced By | String | 40 | Edit | Read Only | ProducedBy | |
Electronic Signed PDF | Values List: 0 = No1 = Produced & Sent 2 = Waiting in queue 3 = Internal Production |
Status | 0 | Select | Read Only | ElectronicSignedPdf |
Assign Journal Entries to Parent | Integer | 0 | Edit | Hidden Read Only |
AssignJournalEntriesToParent | |
Refund Form Purpose | Values List: 0 = Retail Refund1 = Withdrawal from Account 2 = Withdrawal from Loan Account 3 = Property Exchange Service |
Status | 0 | Select | Read Only | RefundFormPurpose |
Money Laundering | Values List: 0 = Normal1 = Report Anyway 2 = DO NOT Report |
Status | 0 | Select | MoneyLaundering | |
Money Laundering Bundle | Integer | 0 | Edit | Read Only | MoneyLaunderingBundle | |
Personal ID Verification Made by | String | 40 | PopupList | PersonalIdVerificationMadeBy | ||
Notes | String | 800 | Memo | Notes | ||
Internal Notes | String | 100 | Edit | InternalNotes | ||
Responsible Manager | String | 40 | PopupList | Read Only | ResponsibleManager | |
Account Balance at Production Time | Money | 0 | Edit | Read Only | AccountBalanceAtProductionTime | |
Credit Line Usage (Risk) LC | Integer | 0 | Edit | Read Only | CreditLineUsageRiskLc | |
Old Doc Reference | String | 20 | Edit | Read Only | OldDocReference | |
Old Software Name | String | 10 | Edit | Read Only | OldSoftwareName | |
Cancellation Time | FixDT | 0 | SelectEdit | Read Only | CancellationTime | |
Cancelled By | String | 40 | Edit | Read Only | CancelledBy | |
Cancellation Reason | String | 50 | Edit | Read Only | CancellationReason | |
Loan Property Details | String | 100 | Edit | LoanPropertyDetails | ||
Loan Serial Number | String | 20 | Edit | LoanSerialNumber | ||
Amount of Payments for Loan Repayment | Integer | 0 | Edit | AmountOfPaymentsForLoanRepayment | ||
Loan Termination Date | Date | 0 | SelectEdit | LoanTerminationDate |
Database Table "hyp_Refund Items"
Table Description
The refund items table, which includes the payment method and its details.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
---|---|---|---|---|---|---|
Refund Number | Integer | 0 | Edit | Hidden Read Only Key Field |
RefundNumber | |
Row Index | Integer | 0 | Edit | Hidden Read Only Key Field |
RowIndex | |
Refund Method | Withdrawal Form Method Values List: 0 = Cash1 = Credit Card 2 = Bank Transfer 3 = Return Client Cheque 4 = Cheque 5 = Return Assignment of Rights 6 = Return Security Bill 7 = Bill of Exchange 8 = Traveller Check 9 = E. Wallet |
Status | 0 | Select | RefundMethod | |
Payment Date | Date | 0 | SelectEdit | PaymentDate | ||
Total Amount | Money | 0 | Edit | Mandatory | TotalAmount | |
Currency | String | 5 | Select | Mandatory | Currency | |
Exchange Rate | Real | 0 | Edit | ExchangeRate | ||
Total Refund LC | Total Withdrawal | Money | 0 | Edit | Read Only | TotalRefundLc |
LC to PC Rate | Real | 0 | Edit | Read Only | LcToPcRate | |
Total Refund in PC | Money | 0 | Edit | Read Only | TotalRefundInPc | |
Exchange Rate Source | String | 1 | Edit | Hidden Read Only |
ExchangeRateSource | |
Monthly Payments | Integer | 0 | Edit | MonthlyPayments | ||
First Payment Amount | Money | 0 | Edit | 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 | AdvancedPaymentSys | |
Bills Description | Cash / Bills Description | String | 40 | Edit | Read Only | BillsDescription |
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 | ||
Cheque/CC Number | Serial | 15 | Edit | ChequeCcNumber | ||
Clearing Company | Clearing Company | String | 40 | Select | Read Only | ClearingCompany |
CC / EW Brand | String | 25 | Select | Read Only | CcEwBrand | |
Clearing Voucher | String | 25 | Edit | Read Only | ClearingVoucher | |
Reg. Refund to Country | String | 40 | Select | RegRefundToCountry | ||
Reg. Bank Name | String | 40 | Edit | RegBankName | ||
Reg. Bank Address | String | 100 | Edit | RegBankAddress | ||
Reg. Account Owner as Contact Person | String | 105 | PopupEdit | RegAccountOwnerAsContactPerson | ||
From Internal Account | Integer | 0 | Edit | Read Only | FromInternalAccount | |
From Internal Account Name | String | 50 | PopupList | FromInternalAccountName | ||
Scan File A Ext | String | 5 | Edit | Hidden Read Only |
ScanFileAExt | |
Scan File B Ext | String | 5 | Edit | Hidden Read Only |
ScanFileBExt |