business logic query CreditorAllItems

Parameters

iiCompanyId	integer	Company id
icCreditorCode	character
icCreditorCodeTo	character
icCreditorCodeFrom	character
icBusRelCode	character
icBusRelCodeFrom	character
icBusRelCodeTo	character
icCurrencyCode	character
ilCreditorIsActive	logical
ilCreditorIsSendRemittance	logical
ilCreditorIsIndividualPayment	logical
icVatDeliveryType	character
icVatPercentageLevel	character
icAddressCity	character
icAddressStreet1	character
icBusinessRelationName	character
icProfileCodeCnFilter	character
icProfileCodeDivFilter	character
icProfileCodeInvFilter	character
icPaymentCondCodeNmFilter	character
icDeliveryCondCodeFilter	character
icReasonCodeFilter	character
icBLWIGroupCodeFilter	character
icPaymentGroupCodeFilter	character
icFederalTaxID	character
icStateTaxID	character

query condition

each Creditor where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.CreditorCode can-do icCreditorCode AND
Creditor.CreditorCode >= icCreditorCodeFrom AND
Creditor.CreditorCode <= icCreditorCodeTo AND
Creditor.CreditorIsActive = ilCreditorIsActive AND
Creditor.CreditorIsIndividualPaymnt = ilCreditorIsIndividualPayment AND
Creditor.CreditorIsSendRemittance = ilCreditorIsSendRemittance AND
Creditor.VatDeliveryType = icVatDeliveryType AND
Creditor.CreditorTaxIDState = icVatPercentageLevel AND
Creditor.CreditorTaxIDFederal = icFederalTaxID AND
Creditor.CreditorTaxIDState = icStateTaxID

first BLWIGroup (conditional-join) where

BLWIGroup.BLWIGroup_ID = Creditor.BLWIGroup_ID AND
BLWIGroup.BLWIGroupCode can-do icBLWIGroupCodeFilter

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Creditor.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode can-do icBusRelCode AND
BusinessRelation.BusinessRelationCode >= icBusRelCodeFrom AND
BusinessRelation.BusinessRelationCode <= icBusRelCodeTo AND
BusinessRelation.BusinessRelationName1 can-do icBusinessRelationName

each Address (conditional-join) where

Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND
Address.AddressCity can-do icAddressCity AND
Address.AddressStreet1 can-do icAddressStreet1 AND
Address.AddressIsTemporary = no

first AddressType (conditional-join) where

AddressType.AddressType_ID = Address.AddressType_ID AND

first Country (conditional-join) where

Country.Country_ID = Address.Country_ID AND

first County (outer-join) where

County.County_ID = Address.County_ID AND

first State (outer-join) where

State.State_ID = Address.State_ID AND

first CreditorType (outer-join) where

CreditorType.CreditorType_ID = Creditor.CreditorType_ID AND

first Currency (inner-join) where

Currency.Currency_ID = Creditor.Currency_ID AND
Currency.CurrencyCode can-do icCurrencyCode

first DeliveryCond (conditional-join) where

DeliveryCond.DeliveryCond_ID = Creditor.DeliveryCond_ID AND
DeliveryCond.DeliveryCondCode can-do icDeliveryCondCodeFilter

first PaymentCondition (inner-join) where

PaymentCondition.PaymentCondition_ID = Creditor.NormalPaymentCondition_ID AND
PaymentCondition.PaymentConditionCode can-do icPaymentCondCodeNmFilter

first PaymentGroup (conditional-join) where

PaymentGroup.PaymentGroup_ID = Creditor.PaymentGroup_ID AND
PaymentGroup.PaymentGroupCode can-do icPaymentGroupCodeFilter

first Profile4 (inner-join) where

Profile4.Profile_ID = Creditor.PurchaseGLProfile_ID AND

first Profile5 (inner-join) where

Profile5.Profile_ID = Creditor.PrePayControlGLProfile_ID AND

first Profile1 (inner-join) where

Profile1.Profile_ID = Creditor.InvControlGLProfile_ID AND
Profile1.ProfileCode can-do icProfileCodeInvFilter

first Profile2 (conditional-join) where

Profile2.Profile_ID = Creditor.DivisionProfile_ID AND
Profile2.ProfileCode can-do icProfileCodeDivFilter

first Profile3 (inner-join) where

Profile3.Profile_ID = Creditor.CnControlGLProfile_ID AND
Profile3.ProfileCode can-do icProfileCodeCnFilter

first PurchaseType (outer-join) where

PurchaseType.PurchaseType_ID = Creditor.PurchaseType_ID AND

first Reason (inner-join) where

Reason.Reason_ID = Creditor.Reason_ID AND
Reason.ReasonCode can-do icReasonCodeFilter

query resultset tqCreditorAllItems

field name	data type	db field	description
tiAddress_ID	integer	Address.Address_ID	Record ID
tcAddressCity	character	Address.AddressCity	City. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressCounty	character	Address.AddressCounty	Obsolete field
tcAddressEMail	character	Address.AddressEMail	E-Mail. This field indicates the e-mail address associated with this business relation. This field can be blank.
tcAddressFax	character	Address.AddressFax	Fax. This field indicates the fax or telex number to use when sending documents to this address. This field can be balnk.
tcAddressStreet1	character	Address.AddressStreet1	Address: Line one of address details. This field can be blank.
tcAddressStreet2	character	Address.AddressStreet2	Address.Line two of address details. This field can be blank.
tcAddressStreet3	character	Address.AddressStreet3	Address.Line three of address details. This field can be blank.
tcAddressTelephone	character	Address.AddressTelephone	Telephone. The telephone number for calling this business relation address. This field can be blank.
tcAddressTypeCode	character	AddressType.AddressTypeCode	Address Type
tcAddressWebSite	character	Address.AddressWebSite	Internet. This field indicates the Web site of this business relation. This field can be blank.
tcAddressZip	character	Address.AddressZip	Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank.
tcBLWIGroupCode	character	BLWIGroup.BLWIGroupCode	BLWI Group Code
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.
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.
tiCounty_ID	integer	County.County_ID	Record ID
tcCountyCode	character	County.CountyCode	County Code
tcCountyDescription	character	County.CountyDescription	Description
tiCreditor_ID	integer	Creditor.Creditor_ID	Record ID
tcCreditorCocNumber	character	Creditor.CreditorCocNumber	Chamber of Commerce Number
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
tcCreditorCommentNote	character	Creditor.CreditorCommentNote	Comment Note
tcCreditorDBNumber	character	Creditor.CreditorDBNumber	Credit Agency Reference
tcCreditorDebtorNumber	character	Creditor.CreditorDebtorNumber	External Customer Number
tlCreditorIsActive	logical	Creditor.CreditorIsActive	Active
tlCreditorIsIndividualPaymnt	logical	Creditor.CreditorIsIndividualPaymnt	Individual Payments
tlCreditorIsSendRemittance	logical	Creditor.CreditorIsSendRemittance	Send Remittance
tlCreditorIsTaxable	logical	Creditor.CreditorIsTaxable	Taxable Supplier
tlCreditorIsTaxInCity	logical	Creditor.CreditorIsTaxInCity	Tax in City
tlCreditorIsTaxIncluded	logical	Creditor.CreditorIsTaxIncluded	Tax Is Included
tlCreditorIsTaxReport	logical	Creditor.CreditorIsTaxReport	Tax Report
tcCreditorTaxIDFederal	character	Creditor.CreditorTaxIDFederal	Federal Tax
tcCreditorTaxIDMisc1	character	Creditor.CreditorTaxIDMisc1	Miscellaneous Tax 1
tcCreditorTaxIDMisc2	character	Creditor.CreditorTaxIDMisc2	Miscellaneous Tax 2
tcCreditorTaxIDMisc3	character	Creditor.CreditorTaxIDMisc3	Miscellaneous Tax 3
tcCreditorTaxIDState	character	Creditor.CreditorTaxIDState	State Tax
tcCreditorTIDNotice	character	Creditor.CreditorTIDNotice	TID Notice
tiCreditorType_ID	integer	CreditorType.CreditorType_ID	Record ID
tcCreditorTypeCode	character	CreditorType.CreditorTypeCode	Code
tcCreditorTypeDescription	character	CreditorType.CreditorTypeDescription	Description
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcDeliveryCondCode	character	DeliveryCond.DeliveryCondCode	Code
tcPaymentConditionCodeNm	character	PaymentCondition.PaymentConditionCode	Credit Terms Code
tcPaymentGroupCode	character	PaymentGroup.PaymentGroupCode	Payment Group
tcProfileCodeCn	character	Profile3.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcProfileCodeDiv	character	Profile2.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcProfileCodeInv	character	Profile1.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcProfileCodePrePay	character	Profile5.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcProfileCodePur	character	Profile4.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcPurchaseTypeCode	character	PurchaseType.PurchaseTypeCode	Purchase Type
tcReasonCode	character	Reason.ReasonCode	Invoice Status Code
tiState_ID	integer	State.State_ID	Record ID
tcStateCode	character	State.StateCode	State
tcStateDescription	character	State.StateDescription	Description
tcTxclTaxCls	character	Creditor.TxclTaxCls	Tax Class
tcTxuTaxUsage	character	Creditor.TxuTaxUsage	Tax Usage
tcTxzTaxZone	character	Creditor.TxzTaxZone	Tax Zone
tcVatDeliveryType	character	Creditor.VatDeliveryType	Tax Nature
tcVatPercentageLevel	character	Creditor.VatPercentageLevel	Tax Level
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Creditor),rowid(BLWIGroup),rowid(BusinessRelation),rowid(Address),rowid(AddressType),rowid(Country),rowid(County),rowid(State),rowid(CreditorType),rowid(Currency),rowid(DeliveryCond),rowid(PaymentCondition),rowid(PaymentGroup),rowid(Profile4),rowid(Profile5),rowid(Profile1),rowid(Profile2),rowid(Profile3),rowid(PurchaseType),rowid(Reason)

Internal usage

QadFinancials

method BCreditorReport.CreditorList
method BCreditorReport.CreditorMasterCard