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
Key Field
RowIndex
Payment Method
Values List:
0 = Cash
1 = Credit Card
2 = Bank Transfer
3 = Cheque
4 = Security Bill
5 = Assignment of Rights
6 = Deduction at Source
7 = Bill of Exchange
8 = Traveller Check
9 = E.Wallet
Status 0 Select PaymentMethod
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 Amount LC Money 0 Edit Read Only TotalAmountLc
LC to PC Rate Real 0 Edit Read Only LcToPcRate
Total Amount in PC Money 0 Edit Read Only TotalAmountInPc
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. 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 105 PopupEdit RegAccountOwnerAsContactPerson
Into Internal Account Integer 0 Edit Read Only IntoInternalAccount
Into Internal Account Name String 50 PopupList IntoInternalAccountName
Handling Status
Values List:
0 = Not Relevant
1 = In Cashbox / Safe
2 = Sent for Deposit
3 = Returned to the Client
4 = Deposit Postponed
5 = Bounced
Status 0 Select Read Only HandlingStatus
Postponed Deposit Date Date 0 SelectEdit Read Only PostponedDepositDate
Sent for Deposit On FixDT 0 SelectEdit Read Only SentForDepositOn
Deposit / Refund Doc No. Integer 0 Edit Read Only DepositRefundDocNo
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