| field name | data type | description |
|---|---|---|
| CInvoiceBank_ID | integer | |
| CInvoice_ID | integer | |
| BankNumber_ID | integer | |
| CInvoiceBankToPayTC | decimal(4) | TC Payment Amount. This field displays the payment amount in the transaction currency. |
| tcOwnBankNumber | character | Own Bank Number. This field displays the account number that receives payments from this customer. This number is defined on the supplier record, and is normally the default bank account number for the entity you are currently working in. |
| tcPayFormatTypeCode | character | Payment Format. The payment format you have defined for payments from your bank to this supplier. The value of the field can only be the formats initially defined for the account. This field is calculated by the system. |
| tcPayFormatTypePayInstrument | character | Payment Instrument. The payment instrument defined for payments to this supplier from your bank account. This field is calculated by the system. |
| tiBankPayFormat_ID | integer | |
| tlValidatePayment | logical | Validate Payment: This field validate the payment when the cinvoicebank amount is changed : when you come from payment selection it is false, otherwise true. |
| tcBankNumber | character | Bank Number. The supplier bank account number. This field is mandatory when the payment instrument for the supplier is electronic. This field is calculated by the system. |
| tcBankNumberExtension | character | Extension. This field indicates the bank number extension. The extension defines the currency when an account has amounts in multiple currencies. This field is calculated by the system. |
| tcBankNumberFormatted | character | Formatted Number. This field displays the supplier bank account number, formatted according to the validation you applied. This field is calculated by the system. |
| tcBankNumberSwiftCode | character | SWIFT Code. This field displays the SWIFT code of the bank. SWIFT (the Society for Worldwide Interbank Financial Telecommunication) is a banking network for world-wide payments between banks. Also known as the BIC or Bank Identifier Code. This field is calculated by the system and can be blank. |
| tcBankNumberValidation | character | Validation. This field identifies the bank format validation for the supplier bank account. Account number validation ensures that the account number is formatted according to the regulations of the national banking system. This field is calculated by the system. |
| tcBusinessRelationCode | character | Business Relation Code. This field displays the business relation for the supplier's bank, and contains bank addressing information. This field is calculated by the system. |
| tiParentObject_ID | integer | |
| tcOwnGLCode | character | Own Gl Account.The default supplier bank account configured for the supplier. If you have configured multiple accounts for this supplier, you can add these account details by inserting a new row for each account. You can use a maximum of three bank accounts to make the invoice payment,specifying the bank reference and amounts to be paid per account in each case. The total of the separate amounts must equal the total invoice amount. This field is calculated by the system. |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials