business logic query BaseCreditorAccounts

Parameters

iiCompanyId	integer	Company id
icCandoCreditorCode	character
icCandoBRCode	character
icFromBRCode	character
icFromCreditorCode	character
iiToAccYearPeriod	integer
icToBRCode	character
icToCreditorCode	character
iiFromAccYearPeriod	integer

query condition

each Creditor where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.CreditorCode >= icFromCreditorCode AND
Creditor.CreditorCode <= icToCreditorCode AND
Creditor.CreditorCode can-do icCandoCreditorCode

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Creditor.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode >= icFromBRCode AND
BusinessRelation.BusinessRelationCode <= icToBRCode AND
BusinessRelation.BusinessRelationCode can-do icCandoBRCode

each CHist (conditional-join) where

CHist.Company_Id = iiCompanyId AND
CHist.Creditor_ID = Creditor.Creditor_ID AND
CHist.CHistYearPeriodFrom >= iiFromAccYearPeriod AND
CHist.CHistYearPeriodFrom <= iiToAccYearPeriod

first CostCentre (conditional-join) where

CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = CHist.CostCentre_ID AND

first Currency (conditional-join) where

Currency.Currency_ID = CHist.Currency_ID AND

first Division (conditional-join) where

Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = CHist.Division_ID AND

first GL (conditional-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = CHist.GL_ID AND

first Journal (conditional-join) where

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

first Project (conditional-join) where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = CHist.Project_ID AND

query resultset tqBaseCreditorAccounts

field name	data type	db field	description
tiBusinessRelation_ID	integer	Creditor.BusinessRelation_ID	Name
tiBusinessRelation_ID2	integer	BusinessRelation.BusinessRelation_ID	Record ID
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcBusinessRelationName1	character	BusinessRelation.BusinessRelationName1	Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers.
	api annotation:		PartialUpdate = yes - defaults to the BusinessRelationCode.
tcBusinessRelationName2	character	BusinessRelation.BusinessRelationName2	Second Name. An extended name when the Name field is not large enough to contain all information. This fielsd can be blank.
tcBusinessRelationSearchName	character	BusinessRelation.BusinessRelationSearchName	Search Name: An alternate name for finding the business relation. This field can be useful for sorting and filtering.
	api annotation:		PartialUpdate = yes - defaults to the BusinessRelationCode.
tdCHistGrossCredNoteCC	decimal	CHist.CHistGrossCredNoteCC	SC Gross Credit Note
tdCHistGrossCredNoteLC	decimal	CHist.CHistGrossCredNoteLC	BC Gross Credit Note
tdCHistGrossCredNoteTC	decimal	CHist.CHistGrossCredNoteTC	TC Gross Credit Note
tdCHistGrossInvoiceCC	decimal	CHist.CHistGrossInvoiceCC	SC Gross Invoice
tdCHistGrossInvoiceLC	decimal	CHist.CHistGrossInvoiceLC	BC Gross Invoice
tdCHistGrossInvoiceTC	decimal	CHist.CHistGrossInvoiceTC	TC Gross Invoice
tdCHistMovementCreditCC	decimal	CHist.CHistMovementCreditCC	SC Activity Credit
tdCHistMovementCreditLC	decimal	CHist.CHistMovementCreditLC	BC Activity Credit
tdCHistMovementCreditTC	decimal	CHist.CHistMovementCreditTC	TC Activity Credit
tdCHistMovementDebitCC	decimal	CHist.CHistMovementDebitCC	SC Activity Debit
tdCHistMovementDebitLC	decimal	CHist.CHistMovementDebitLC	BC Activity Debit
tdCHistMovementDebitTC	decimal	CHist.CHistMovementDebitTC	TC Activity Debit
tdCHistNettoCredNoteCC	decimal	CHist.CHistNettoCredNoteCC	SC Net Credit Note
tdCHistNettoCredNoteLC	decimal	CHist.CHistNettoCredNoteLC	BC Net to Credit Note
tdCHistNettoCredNoteTC	decimal	CHist.CHistNettoCredNoteTC	TC Net Credit Note
tdCHistNettoInvoiceCC	decimal	CHist.CHistNettoInvoiceCC	SC Net Invoice
tdCHistNettoInvoiceLC	decimal	CHist.CHistNettoInvoiceLC	BC Net to Invoice
tdCHistNettoInvoiceTC	decimal	CHist.CHistNettoInvoiceTC	TC Net Invoice
tiCHistYearPeriodFrom	integer	CHist.CHistYearPeriodFrom	From Year GL Period
tiCHistYearPeriodTill	integer	CHist.CHistYearPeriodTill	To Year GL Period
tiCostCentre_ID	integer	CostCentre.CostCentre_ID	Record ID
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tcCostCentreDescription	character	CostCentre.CostCentreDescription	Description: a brief description of the cost center.
tiCreditor_ID	integer	Creditor.Creditor_ID	Record ID
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
tiCurrency_ID	integer	Currency.Currency_ID	Record ID
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcCurrencyDescription	character	Currency.CurrencyDescription	Currency Description
tiCurrencyNumberOfDecimals	integer	Currency.CurrencyNumberOfDecimals	Number of Decimals
tiDivision_ID	integer	Division.Division_ID	Record ID
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tcDivisionDescription	character	Division.DivisionDescription	Description
tiGL_ID	integer	GL.GL_ID	Record ID
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcGLDescription	character	GL.GLDescription	A description of the GL account.
tiJournal_ID	integer	Journal.Journal_ID	Record ID
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcJournalDescription	character	Journal.JournalDescription	A brief description of the daybook.
	api annotation:		Value for this field defaults to null.
tiProject_ID	integer	Project.Project_ID	Record ID
tcProjectCode	character	Project.ProjectCode	Project
tcProjectDescription	character	Project.ProjectDescription	Description

Internal usage

QadFinancials

method BCreditorReport.CreditorAccountsHistory