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