| iiCompanyId | integer | Company id |
| icDeductionDetailStatus | character | |
| iiDInvoice_ID | integer |
each DInvoice where
each DInvoiceDeduction (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tiDInvoiceCurrency_ID | integer | DInvoice.DInvoiceCurrency_ID | Currency Code |
| ttDInvoiceDate | date | DInvoice.DInvoiceDate | Invoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period. The system uses the invoice date with the credit terms to calculate due date and discount date. |
| api annotation: | This field defaults to the DInvoicePostingDate. | ||
| tcDInvoiceDeductionApRejCom | character | DInvoiceDeduction.DInvoiceDeductionApRejCom | Approve/Reject Comment |
| tcDInvoiceDeductionStatus | character | DInvoiceDeduction.DInvoiceDeductionStatus | Deduction Status |
| tdDInvoiceDeductionTC | decimal | DInvoiceDeduction.DInvoiceDeductionTC | Deduction TC |
| ttDInvoicePostingDate | date | DInvoice.DInvoicePostingDate | Posting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print. This field is updated when the invoice is validated and saved. |
| api annotation: | This field defaults from the invoice creation date. |
QadFinancials