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
Email String 80 Edit Email
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 = No
1 = 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 Refund
1 = Withdrawal from Account
2 = Withdrawal from Loan Account
3 = Property Exchange Service
Status 0 Select Read Only RefundFormPurpose
Money Laundering
Values List:
0 = Normal
1 = 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
Jump to tables index

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 = Cash
1 = 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 = No
1 = 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
Jump to tables index