business logic query PostingTemplatePrim

Description

PostingTemplatePrim

Parameters

iiCompanyId	integer	Company id
iiTemplateID	integer	id
icTemplateCode	character	Code
iiPostingID	integer	id

query condition

each PostingTemplate where

PostingTemplate.Company_Id = iiCompanyId AND
PostingTemplate.Posting_ID = iiPostingID AND
PostingTemplate.PostingTemplate_ID = iiTemplateID AND
PostingTemplate.PostingTemplateCode = icTemplateCode

first Posting (inner-join) where

Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingTemplate.Posting_ID AND

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

query resultset tqPostingTemplatePrim

field name	data type	db field	description
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiPosting_ID	integer	PostingTemplate.Posting_ID	Link to Posting
tiPostingTemplate_ID	integer	PostingTemplate.PostingTemplate_ID	Record ID
tcPostingTemplateCode	character	PostingTemplate.PostingTemplateCode	Template Code
tcPostingTemplateCostCtrCode	character	PostingTemplate.PostingTemplateCostCtrCode	Cost Center
tcPostingTemplateDivCode	character	PostingTemplate.PostingTemplateDivCode	Sub-Account
tcPostingTemplateProjectCode	character	PostingTemplate.PostingTemplateProjectCode	Project

Internal usage

QadFinancials

method BPosting.ValidateComponentPostPosting2
method BJournalEntry.CreateRecEntryPosting
method BJournalEntry.CreateRecEntryPostingTemplate
method BJournalEntry.LoadTemplate
method BRecurringEntry.ApiPostRecEntryApplyFilter
read related business field(s) on tAllocation.PostingTemplate_ID
read related business field(s) on tRecEntry.PostingTemplate_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAllocation.PostingTemplate_ID
validate related business field(s) on tRecEntry.PostingTemplate_ID