project QadFinancials > class BPostingTemplate > business logic query PostingTemplateByCyPostingID

Description

Retrieve PostingTemplateCode By Company/PostingID (No joins to keep it performant)


Parameters


iiCompanyIdintegerCompany id
iiPostingIdinteger


query condition


  each PostingTemplate where
PostingTemplate.Company_Id = iiCompanyId AND
PostingTemplate.Posting_ID = iiPostingId


query resultset tqPostingTemplateByCyPostingID


field namedata typedb fielddescription
tiCompany_IDintegerPostingTemplate.Company_IDLink to Company
tiPosting_IDintegerPostingTemplate.Posting_IDLink to Posting
tiPostingTemplate_IDintegerPostingTemplate.PostingTemplate_IDRecord ID
tcPostingTemplateCodecharacterPostingTemplate.PostingTemplateCodeTemplate Code


Internal usage


QadFinancials
method BPosting.Calculate