Database Table "hyp_Receipts"

Table Description

The receipts table of Hyper.

Normal Storage

Archive Storage

Deleted Storage(Recycle)

Field Name English Title Data Type Text Length Editor Attributes json
Receipt Number Integer 0 Edit Read Only
Key Field
ReceiptNumber
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 135 SelectEdit Mandatory ClientFullName
Contact Person String 135 SelectEdit ContactPerson
Address String 300 Memo Address
Phone Phone 20 Edit Phone
Fax Phone 20 Edit Fax
Email String 80 Edit Email
ID Number Serial 20 Edit IDNumber
Language Status 0 Select Language
International Document Bool 0 Select InternationalDocument
Purchaser Currency String 4 Select Mandatory PurchaserCurrency
Total Amount LC Money 0 Edit Read Only TotalAmountLC
Receipt Collection Target LC Money 0 Edit ReceiptCollectionTargetLC
Return Change to the Client LC Money 0 Edit Hidden
Read Only
ReturnChangeToTheClientLC
Total Amount on P.C. Total Amount in Purchaser currency Money 0 Edit Read Only TotalAmountOnPC
Origin Production Time FixDT 0 SelectEdit OriginProductionTime
Produced By String 40 Edit Read Only ProducedBy
Electronic Signed PDF
Values List:
No
Produced & Sent
Waiting in queue
Internal Production
Status 0 Select Read Only ElectronicSignedPDF
Assign Journal Entries to Parent Integer 0 Edit Hidden
Read Only
AssignJournalEntriesToParent
Receipt Form Purpose Status 0 Select ReceiptFormPurpose
Money Laundering
Values List:
Normal
Report Anyway
DO NOT Report
Status 0 Select MoneyLaundering
Money Laundering Bundle Real 0 Edit MoneyLaunderingBundle
Personal ID Verification Made by String 40 PopupList PersonalIDVerificationMadeBy
Reg. Contact Person is Entity Integer 0 PopupList RegContactPersonIsEntity
Notes String 800 Memo Notes
Internal Notes String 100 Edit InternalNotes
Responsible Manager String 40 PopupList Read Only ResponsibleManager
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
Jump to tables index

Database Table "hyp_Receipt Items"

Table Description

The recipt 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
Receipt Number Integer 0 Edit Hidden
Read Only
Key Field
ReceiptNumber
Row Index Integer 0 Edit Hidden
Read Only
RowIndex
Payment Method
Values List:
Cash
Credit Card
Bank Transfer
Cheque
Security Bill (or Cheque)
Assignment of Rights
Deduction at Source
Bill of Exchange
Traveller Check
Status 0 Select PaymentMethod
Payment Date Date 0 SelectEdit PaymentDate
Total Amount Money 0 Edit Mandatory TotalAmount
Currency String 4 Select Mandatory Currency
Monthly Payments Integer 0 Edit MonthlyPayments
First Payment Amount Money 0 Edit FirstPaymentAmount
Next Payments Amount Money 0 Edit Read Only NextPaymentsAmount
Payments Funding by 3rd Party
Values List:
No
External Credit
+30 Days
Status 0 Select PaymentsFundingBy3rdParty
Total Amount LC Money 0 Edit Read Only TotalAmountLC
Cheque/CC Number Serial 15 Edit ChequeCCNumber
Bank Serial 10 PopupEdit Bank
Branch Serial 15 PopupEdit Branch
Account Serial 30 Edit Account
CC Brand Name Clearing Company String 40 Select CCBrandName
Voucher Number Integer 0 Edit VoucherNumber
Exchange Rate Real 0 Edit ExchangeRate
Cash Bills Description String 40 Edit Read Only CashBillsDescription
Reg. Received from Country String 40 Select RegReceivedFromCountry
Reg. Bank Name String 40 Edit RegBankName
Reg. Bank Address String 100 Edit RegBankAddress
Reg. No. of Endorsements Integer 0 Edit RegNoOfEndorsements
Reg. Account Owner as Contact Person String 135 PopupEdit RegAccountOwnerAsContactPerson
Into Internal Account Integer 0 Edit Read Only IntoInternalAccount
Into Internal Account Name String 50 PopupList IntoInternalAccountName
Origin Production Time FixDT 0 SelectEdit Read Only OriginProductionTime
Handling Status
Values List:
Not Relevant
In Cashbox / Safe
Sent for Deposit
Returned to the Client
Deposit Postponed
Status 0 Select Read Only HandlingStatus
Postponed Deposit Date Date 0 SelectEdit Read Only PostponedDepositDate
Sent to Deposit On FixDT 0 SelectEdit Read Only SentToDepositOn
Deposit / Refund Doc No. Integer 0 Edit Read Only DepositRefundDocNo
Jump to tables index

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 CreatedOn
Payment Method
Values List:
--Select--
Credit Card
Bank Account
Legal Usage Confirmation
3rd Party Payments
Status 0 Select Read Only PaymentMethod
Default for Automatic Monetary Transactions
Values List:
NO
YES, Automatic Transactions
YES, with Additional Confirmation before use
Status 0 Select DefaultForAutomaticMonetaryTransactions
Allow to be used by Website & API Bool 0 Select AllowToBeUsedByWebsiteAPI
Bank ID Serial 10 PopupEdit BankID
Branch / Routing / Swift Serial 15 PopupEdit BranchRoutingSwift
Account (Local or IBAN) Serial 30 Edit AccountLocalOrIBAN
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 135 PopupList RegAccountOwnerAsContactPerson
CC Last 4 Digits String 4 Edit Read Only CCLast4Digits
Renew CC on Month 0 SelectEdit Read Only RenewCCOn
Encrypted Data String 110 Edit Hidden
Read Only
EncryptedData
Short Description String 40 SelectEdit ShortDescription
Last Usage FixDT 0 SelectEdit Read Only LastUsage
Last Update FixDT 0 SelectEdit Read Only LastUpdate
Entity Full Name String 135 Edit Read Only EntityFullName
Requested Payment Day (Monthly) Integer 0 Edit RequestedPaymentDayMonthly
Jump to tables index