| iiCompanyId | integer | Company id |
| iiDInvoiceID | integer | DInvoiceID |
| idBalanceTC | decimal | BalanceTC |
| ilDInvoiceIsSelected | logical | CInvoice is Selected |
| itDInvoiceDueDate | date | DInvoiceDueDate |
| itDInvoiceDiscountDueDate | date | DInvoiceDiscountDueDate |
each DInvoice where
| field name | data type | db field | description |
|---|---|---|---|
| ttDInvoiceDiscountDueDate | date | DInvoice.DInvoiceDiscountDueDate | Discount Due Date. This field displays the last date a discount applies, calculated by the system based on the credit terms and the invoice date. You can modify the due date without affecting the credit terms. If the credit terms have a base date specified, this is used in the due date calculations rather than the invoice creation date. |
| ttDInvoiceDueDate | date | DInvoice.DInvoiceDueDate | Due Date. This field displays the date when payment is due, calculated by the system based on the credit terms and the invoice date. User can modify the due date without affecting the credit terms. If the credit terms have a base date specified, this is used in the due date calculations rather than the invoice creation date. |
| tlDInvoiceIsSelected | logical | DInvoice.DInvoiceIsSelected | Selected. This field indicates whether the invoice is included in a payment selection. This field is read-only. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tdDInvoiceBalanceCreditTC | decimal | DInvoice.DInvoiceBalanceCreditTC | TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. |
| tdDInvoiceBalanceDebitTC | decimal | DInvoice.DInvoiceBalanceDebitTC | TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. |
QadFinancials