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 = Cash1 = 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 = 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. 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 Relevant1 = 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 |