| iiCompanyId | integer | Company id |
| iiCInvoiceID | integer | CInvoiceID |
| idBalanceTC | decimal | BalanceTC |
| ilCInvoiceIsSelected | logical | Cinvoice Selected |
| itCInvoiceDueDate | date | CInvoiceDueDate |
| itCInvoiceDiscountDueDate | date | CInvoiceDiscountDueDate |
each CInvoice where
| field name | data type | db field | description |
|---|---|---|---|
| tlCInvoiceIsSelected | logical | CInvoice.CInvoiceIsSelected | Selected. This field indicates whether the invoice is included in a payment selection. This field is read-only. |
| tiCInvoice_ID | integer | CInvoice.CInvoice_ID | Record ID |
| tiCompany_ID | integer | CInvoice.Company_ID | Link to Company |
| tdCInvoiceBalanceCreditTC | decimal | CInvoice.CInvoiceBalanceCreditTC | TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. |
| tdCInvoiceBalanceDebitTC | decimal | CInvoice.CInvoiceBalanceDebitTC | TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. |
| ttCInvoiceDiscountDueDate | date | CInvoice.CInvoiceDiscountDueDate | Discount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date. User can modify this field without affecting the credit terms. |
| ttCInvoiceDueDate | date | CInvoice.CInvoiceDueDate | Due Date.This field indicates the date when payment become due. This field can be modified without affecting the credit terms. This field is calculated by the system based on the credit terms and the invoice date. |
QadFinancials