project QadFinancials > class BDDocument > business logic query DDocumentByTypeStatus


Parameters


iiCompanyIdintegerCompany id
icDDocumentStatuscharacter
icDDocumentTypecharacter
iiGLIDinteger


query condition


  each DDocument where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocumentType = icDDocumentType AND
DDocument.DDocumentStatus = icDDocumentStatus AND
DDocument.GL_ID = iiGLID


query resultset tqDDocumentByTypeStatus


field namedata typedb fielddescription
tcDDocumentStatuscharacterDDocument.DDocumentStatusStatus. The payment status. The default value for a new record is Initial.
tcDDocumentTypecharacterDDocument.DDocumentTypePayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
tiGL_IDintegerDDocument.GL_IDBank Account
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DDocument)


Internal usage


QadFinancials
method BDDocumentStatus.Calculate
method BDDocumentStatus.ValidateComponent