| field name | data type | description |
|---|---|---|
| DInvoiceBank_ID | integer | |
| DInvoice_ID | integer | |
| BankNumber_ID | integer | |
| DInvoiceBankToPayTC | 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 customer 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 customer. The value of the field can only be the formats initially defined for the account. This field is calculated by the system. |
| tlDInvoiceIsReferenced | logical | Referenced. This field indicates if other invoices have linked to this invoice. This field is calculated by the system. |
| tcPayFormatTypePayInstrument | character | Payment Instrument. The payment instrument defined for payments to this customer from your bank account. This field is calculated by the system. |
| tlValidatePayment | logical | Validate the payment when the dinvoicebank amount is changed : when you come from payment selection it is false, otherwise true. |
| tcBankNumber | character | Bank Number. The customer bank account number. This field is mandatory when the payment instrument for the customer 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 customer 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 customer 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. |
| tiBankPayFormat_ID | integer | |
| tcBusinessRelationCode | character | Business Relation Code. This field displays the business relation for the customer's bank, and contains bank addressing information. This field is calculated by the system. |
| tiParentObject_ID | integer | |
| tcCompanyCode | character | Entity Code. This field identifies the entity in which you are working in. |
| tcOwnGLCode | character | Own Gl Account.The default customer bank account configured for the customer. If you have configured multiple accounts for this customer, 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