| iiCompanyId | integer | Company id |
| iiInvoiceID | integer |
each DInvoice where
first Company (inner-join) where
each DInvoiceDeduction (inner-join) where
first DeductionCatLine (inner-join) where
first DeductionCat (inner-join) where
first Journal (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiApprovePosting_ID | integer | DInvoiceDeduction.ApprovePosting_ID | Link to ApprovePosting |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcDeductionCatCode | character | DeductionCat.DeductionCatCode | Deduction Category Code |
| tcDeductionCatDescription | character | DeductionCat.DeductionCatDescription | Description |
| tiDeductionCatLine_ID | integer | DInvoiceDeduction.DeductionCatLine_ID | Link to DeductionCatLine |
| tcDeductionCatType | character | DeductionCat.DeductionCatType | Type |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tiDInvoiceDeduction_ID | integer | DInvoiceDeduction.DInvoiceDeduction_ID | Record ID |
| ttDInvoiceDeductionAprRejectDate | date | DInvoiceDeduction.DInvoiceDeductionApRejDate | Approve/Reject Date |
| tdDInvoiceDeductionCC | decimal | DInvoiceDeduction.DInvoiceDeductionCC | Deduction SC |
| tcDInvoiceDeductionComment | character | DInvoiceDeduction.DInvoiceDeductionComment | Comment |
| ttDInvoiceDeductionCreateDate | date | DInvoiceDeduction.DInvoiceDeductionCreateDate | Create Date |
| tcDInvoiceDeductionCustRef | character | DInvoiceDeduction.DInvoiceDeductionCustRef | Customer Reference |
| tdDInvoiceDeductionLC | decimal | DInvoiceDeduction.DInvoiceDeductionLC | Deduction BC |
| tcDInvoiceDeductionPromotionCode | character | DInvoiceDeduction.DInvoiceDeductionPromotionCode | Promotion Code |
| tcDInvoiceDeductionReason | character | DInvoiceDeduction.DInvoiceDeductionApRejCom | Approve/Reject Comment |
| tiDInvoiceDeductionSequence | integer | DInvoiceDeduction.DInvoiceDeductionSequence | Sequence |
| tcDInvoiceDeductionStatus | character | DInvoiceDeduction.DInvoiceDeductionStatus | Deduction Status |
| tdDInvoiceDeductionTC | decimal | DInvoiceDeduction.DInvoiceDeductionTC | Deduction TC |
| tcDInvoiceDescription | character | DInvoice.DInvoiceDescription | Description. A brief description of the invoice. This field is mandatory. |
| tcDInvoiceDIText | character | DInvoice.DInvoiceDIText | CIDescription. A brief description for the SI posting. |
| api annotation: | This field defaults from the DInvoiceDescription. | ||
| tdDInvoiceOriginalDebitCC | decimal | DInvoice.DInvoiceOriginalDebitCC | SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate. |
| tdDInvoiceOriginalDebitLC | decimal | DInvoice.DInvoiceOriginalDebitLC | BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate. |
| tdDInvoiceOriginalDebitTC | decimal | DInvoice.DInvoiceOriginalDebitTC | TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same. |
| tiDInvoiceVoucher | integer | DInvoice.DInvoiceVoucher | Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field. |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiPaidDInvoice_ID | integer | DInvoiceDeduction.PaidDInvoice_ID | Link to PaidDInvoice |
| tiRejectPosting_ID | integer | DInvoiceDeduction.RejectPosting_ID | Link to RejectPosting |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DInvoice),rowid(Company),rowid(DInvoiceDeduction),rowid(DeductionCatLine),rowid(DeductionCat),rowid(Journal) |
QadFinancials