project QadFinancials > class BDInvoice > business logic query DInvoiceByDITextCompanyID
Description
Get DInvoice record by DInvoiceDIText and CompanyId
Parameters
| icInvoiceNumber | character | |
| iiCompanyId | integer | |
query condition
each DInvoice where
DInvoice.Company_ID = iiCompanyId AND
DInvoice.DInvoiceDIText = icInvoiceNumber
query resultset tqDInvoiceByDITextCompanyID
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | DInvoice.Company_ID | Link to Company |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tcDInvoiceDIText | character | DInvoice.DInvoiceDIText | CIDescription. A brief description for the SI posting. |
| api annotation: | | This field defaults from the DInvoiceDescription. |
Internal usage
QadFinancials