project
QadFinancials
> class
BCreditorReport
> business logic query GetPaymentIDByInvoice
Parameters
iiInvoiceID
integer
query condition
each CDocumentInvoiceXref where
CDocumentInvoiceXref.CInvoice_ID = iiInvoiceID
query resultset tqGetPaymentIDByInvoice
field name
data type
db field
description
tiCDocument_ID
integer
CDocumentInvoiceXref.CDocument_ID
Link to CDocument
tdCDocumentInvoiceXRefWHTAmtTC
decimal
CDocumentInvoiceXref.CDocumentInvoiceXRefWHTAmtTC
TC WHT Amount
Internal usage
QadFinancials
method BCreditorReport.CreditorWithholdingTax