Description
Query that returns some WHT-fields for a certain invoice.
Do not add joins onto this query.
Try to keep this result-set as small as possible to avoid performance-overhead
Parameters
| iiCompanyId | integer | Company id |
| iiCInvoiceId | integer | CInvoice ID |
| icWHTStatusDiffersFrom | character | Status that it can't be |
| icWHTStatus | character | WHTStatus you want to filter on |
query condition
each WHT where
WHT.Company_Id = iiCompanyId AND
WHT.CInvoice_ID = iiCInvoiceId AND
WHT.WHTStatus <> icWHTStatusDiffersFrom AND
WHT.WHTStatus = icWHTStatus
query resultset tqWHTByCInvoice
| field name | data type | db field | description |
|---|
| tiWHT_ID | integer | WHT.WHT_ID | Record ID |
| tiCInvoice_ID | integer | WHT.CInvoice_ID | Link to CInvoice |
| tiCInvoiceWHT_ID | integer | WHT.CInvoiceWHT_ID | Link to CInvoiceWHT |
| tiCompany_ID | integer | WHT.Company_ID | Link to Company |
| tcWHTStatus | character | WHT.WHTStatus | WHT Status |
| tdWHTAmtCreditCC | decimal | WHT.WHTAmtCreditCC | WHT Amount Cr SC |
| tdWHTAmtCreditLC | decimal | WHT.WHTAmtCreditLC | WHT Amount Cr BC |
| tdWHTAmtCreditTC | decimal | WHT.WHTAmtCreditTC | WHT Amount Cr TC |
| tdWHTAmtDebitCC | decimal | WHT.WHTAmtDebitCC | WHT Amount Dr SC |
| tdWHTAmtDebitLC | decimal | WHT.WHTAmtDebitLC | WHT Amount Dr LC |
| tdWHTAmtDebitTC | decimal | WHT.WHTAmtDebitTC | WHT Amount Dr TC |
Internal usage
QadFinancials