business logic query DinvoiceByIDForBusinessRel

Parameters

iiCompanyId	integer	Company id
iiDinvoiceID	integer

query condition

each DInvoice where

DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDinvoiceID

first CostCentre (outer-join) where

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

first Currency (inner-join) where

Currency.Currency_ID = DInvoice.DInvoiceCurrency_ID AND

first Debtor (inner-join) where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DInvoice.Debtor_ID AND

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND

first Division (outer-join) where

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

first Project (outer-join) where

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

query resultset tqDinvoiceByIDForBusinessRel

field name	data type	db field	description
tiBusinessRelation_ID	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.
tcBusinessRelationICCode	character	BusinessRelation.BusinessRelationICCode	Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation.
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiDebtor_ID	integer	Debtor.Debtor_ID	Record ID
tcDebtorCode	character	Debtor.DebtorCode	A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
	api annotation:		If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
tiDInvoice_ID	integer	DInvoice.DInvoice_ID	Record ID
tdDInvoiceCCRate	decimal	DInvoice.DInvoiceCCRate	SC Rate. The statutory exchange rate used by the invoice. The SC Invoice Amount is calculated based on the SC rate.
tdDInvoiceCCScale	decimal	DInvoice.DInvoiceCCScale	Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments.
tiDInvoiceCurrency_ID	integer	DInvoice.DInvoiceCurrency_ID	Currency Code
tcDInvoiceDIText	character	DInvoice.DInvoiceDIText	CIDescription. A brief description for the SI posting.
	api annotation:		This field defaults from the DInvoiceDescription.
tdDInvoiceExchangeRate	decimal	DInvoice.DInvoiceExchangeRate	Exchange Rate. The accounting exchange rate used by the invoice. The BC Invoice Amount is calculated based on the exchange rate. If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted.
tdDInvoiceRateScale	decimal	DInvoice.DInvoiceRateScale	Scale Factor.This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. The exchange rate is multiplied by the scale factor to determine the actual exchange rate.
	api annotation:		The value for the scale factor defaults from the exchange rate definition, but it can be modified.
tiDivision_ID	integer	DInvoice.Division_ID	Sub-Account
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tcProjectCode	character	Project.ProjectCode	Project

Internal usage

QadFinancials

method BDInvoice.AdditionalUpdatesAllCreateDA
method BDInvoice.AdditionalUpdatesAllCreateDALinkedDI