API query SelectDebtor (optimised)

Description

SelectDebtor;
Update the performance on select-query on the main-table.
The silly condition on the main-table of the select query is there for performance-reasons; please do not remove it.

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
iiCompanyId	i
tAddress.AddressCity	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressCounty	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressIsTaxable	l	=,<>
tAddress.AddressIsTaxIncluded	l	=,<>
tAddress.AddressName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressStreet1	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressStreet2	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressStreet3	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressTaxDeclaration	i	=,>=,>,<>,<=,<
tAddress.AddressTaxIDFederal	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressTaxIDMisc1	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressTaxIDMisc2	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressTaxIDMisc3	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddressType.AddressTypeCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressZip	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBillSchedule.BillScheduleCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBusinessRelation.BusinessRelationCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBusinessRelation.BusinessRelationIsInterco	l	=,<>
tBusinessRelation.BusinessRelationName1	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBusinessRelation.BusinessRelationName2	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBusinessRelation.BusinessRelationSearchName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCorporateGroup.CorporateGroupCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCountry.CountryCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCountry.CountryDescription	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCounty.CountyCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCurrency.CurrencyCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor2.DebtorCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorCommentNote	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtorCreditRating.DebtorCreditRatingCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorDBNumber	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorFixedCredLimTC	d	=,>=,>,<>,<=,<
tDebtor.DebtorHighCredit	d	=,>=,>,<>,<=,<
tDebtor.DebtorHighCreditDate	t	=,>=,>,<>,<=,<
tDebtor.DebtorIsActive	l	=,<>
tDebtor.DebtorIsCheckAftDICredLim	l	=,<>
tDebtor.DebtorIsCheckAftSOCredLim	l	=,<>
tDebtor.DebtorIsCheckBefDICredLim	l	=,<>
tDebtor.DebtorIsCheckBefSOCredLim	l	=,<>
tDebtor.DebtorIsFinanceCharge	l	=,<>
tDebtor.DebtorIsFixedCredLim	l	=,<>
tDebtor.DebtorIsInvoiceByAuth	l	=,<>
tDebtor.DebtorIsLockedCredLim	l	=,<>
tDebtor.DebtorIsMaxDaysDueCredLim	l	=,<>
tDebtor.DebtorIsOverruleDICredLim	l	=,<>
tDebtor.DebtorIsOverruleSOCredLim	l	=,<>
tDebtor.DebtorIsPrintReminder	l	=,<>
tDebtor.DebtorIsPrintStatement	l	=,<>
tDebtor.DebtorIsTaxable	l	=,<>
tDebtor.DebtorIsTaxInCity	l	=,<>
tDebtor.DebtorIsTaxIncluded	l	=,<>
tDebtor.DebtorIsToBeLockedCredLim	l	=,<>
tDebtor.DebtorIsTurnOverCredLim	l	=,<>
tDebtor.DebtorLastCreditReview	t	=,>=,>,<>,<=,<
tDebtor.DebtorLastCreditUpdate	t	=,>=,>,<>,<=,<
tDebtor.DebtorLastFinChargeDate	t	=,>=,>,<>,<=,<
tDebtor.DebtorLastPayment	t	=,>=,>,<>,<=,<
tDebtor.DebtorLastSale	t	=,>=,>,<>,<=,<
tDebtor.DebtorMaxNumDaysCredLim	i	=,>=,>,<>,<=,<
tDebtor.DebtorPercTurnOverCredLim	d	=,>=,>,<>,<=,<
tDebtor.DebtorPercWarningCredLim	d	=,>=,>,<>,<=,<
tDebtor.DebtorSalesOrderBalance	d	=,>=,>,<>,<=,<
tDebtor.DebtorStatementCycle	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorTaxDeclaration	i	=,>=,>,<>,<=,<
tDebtor.DebtorTaxIDFederal	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorTaxIDMisc1	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorTaxIDMisc2	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorTaxIDMisc3	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorTaxIDState	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DebtorTotalDaysLate	i	=,>=,>,<>,<=,<
tDebtor.DebtorTotalNbrOfInvoices	i	=,>=,>,<>,<=,<
tDebtorType.DebtorTypeCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.DomiciliationNumber	i	=,>=,>,<>,<=,<
tPaymentCondition.PaymentConditionCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tPaymentGroup.PaymentGroupCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tProfile5.ProfileCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tProfile3.ProfileCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tProfile1.ProfileCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tProfile2.ProfileCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tProfile4.ProfileCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tReason.ReasonCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tState.StateCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.TxclTaxCls	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.TxuTaxUsage	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDebtor.TxzTaxZone	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

iiCompanyId

integer

Company id

query condition

each Debtor where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND

first BillSchedule (conditional-join) where

BillSchedule.BillSchedule_ID = Debtor.BillSchedule_ID AND

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND

each Address (inner-join) where

Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

first AddressType (inner-join) where

AddressType.AddressType_ID = Address.AddressType_ID AND
AddressType.AddressTypeCode = 'HEADOFFICE'

first Country (inner-join) where

Country.Country_ID = Address.Country_ID AND

first County (conditional-join) where

County.County_ID = Address.County_ID AND

first State (outer-join) where

State.State_ID = Address.State_ID AND

first CorporateGroup (conditional-join) where

CorporateGroup.CorporateGroup_ID = BusinessRelation.CorporateGroup_ID AND

first Currency (inner-join) where

Currency.Currency_ID = Debtor.Currency_ID AND

first Debtor2 (conditional-join) where

Debtor2.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor2.Debtor_ID = Debtor.BillToDebtor_ID AND

first DebtorCreditRating (conditional-join) where

DebtorCreditRating.DebtorCreditRating_ID = Debtor.DebtorCreditRating_ID AND

first DebtorType (conditional-join) where

DebtorType.DebtorType_ID = Debtor.DebtorType_ID AND

first PaymentCondition (inner-join) where

PaymentCondition.PaymentCondition_ID = Debtor.NormalPaymentCondition_ID AND

first PaymentGroup (conditional-join) where

PaymentGroup.PaymentGroup_ID = Debtor.PaymentGroup_ID AND

first Profile2 (inner-join) where

Profile2.Profile_ID = Debtor.CnControlGLProfile_ID AND

first Profile3 (inner-join) where

Profile3.Profile_ID = Debtor.InvControlGLProfile_ID AND

first Profile4 (inner-join) where

Profile4.Profile_ID = Debtor.SalesAccountGLProfile_ID AND

first Profile5 (conditional-join) where

Profile5.Profile_ID = Debtor.DivisionProfile_ID AND

first Profile1 (conditional-join) where

Profile1.Profile_ID = Debtor.DeductionCtrlGLProfile_ID AND

first Reason (inner-join) where

Reason.Reason_ID = Debtor.Reason_ID AND

query sort order

Debtor.SharedSet_ID (ascending)
Debtor.DebtorIsActive (ascending)
Debtor.DebtorCode (ascending)

query resultset tqSelectDebtor

field name	data type	db field	description
tcAddressCounty	character	Address.AddressCounty	Obsolete field
tlAddressIsTaxable	logical	Address.AddressIsTaxable	Taxable Address. This field indicates if business activities for this address are normally subject to tax. The taxable status of the address defaults to transactions where the address is used.
	api annotation:		PartialUpdate = yes - defaults to false.
tlAddressIsTaxIncluded	logical	Address.AddressIsTaxIncluded	Tax Is Included. This field indicates if line item prices for this address normally include tax. The value of Tax Is Included defaults to the header of transactions created for this address.
	api annotation:		PartialUpdate = yes - defaults to false.
tcAddressName	character	Address.AddressName	Name. The full name of this particular address. The name of a headoffice address is the same as the name of the business relationship and can not be modified.
	api annotation:		PartialUpdate = yes - defaults to the name of the businessRelation.
tcAddressStreet3	character	Address.AddressStreet3	Address.Line three of address details. This field can be blank.
tiAddressTaxDeclaration	integer	Address.AddressTaxDeclaration	This field is mandatory.
tcAddressTaxIDFederal	character	Address.AddressTaxIDFederal	Federal Tax. The value of this filed is the tax ID assigned to this address by the federal or national government. If Tax Report is true, the Federal tax ID must be unique; otherwise, related business relations can share an ID.
tcAddressTaxIDMisc1	character	Address.AddressTaxIDMisc1	Miscellaneous Tax 1.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank.
tcAddressTaxIDMisc2	character	Address.AddressTaxIDMisc2	Miscellaneous Tax 2.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank.
tcAddressTaxIDMisc3	character	Address.AddressTaxIDMisc3	Miscellaneous Tax 3.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank.
tcAddressTypeCode	character	AddressType.AddressTypeCode	Address Type
tiBillSchedule_ID1	integer	BillSchedule.BillSchedule_ID	Record ID
tcBillScheduleCode	character	BillSchedule.BillScheduleCode	Billing Schedule Code
tcBillToDebtorCode	character	Debtor2.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.
tcCnControlGLProfileCode	character	Profile2.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcCorporateGroupCode	character	CorporateGroup.CorporateGroupCode	Group Name
tiCountry_ID	integer	Country.Country_ID	Record ID
tcCountryCode	character	Country.CountryCode	Country Code
tcCountryDescription	character	Country.CountryDescription	Description
tcCountyCode	character	County.CountyCode	County Code
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcDebtorCommentNote	character	Debtor.DebtorCommentNote	Free-form text related to this customer that is saved with the customer record.
	api annotation:		Value for this field defaults to null.
tcDebtorCreditRatingCode	character	DebtorCreditRating.DebtorCreditRatingCode	A code (maximum eight characters) that identifies a customer credit rating.
tcDebtorDBNumber	character	Debtor.DebtorDBNumber	The credit agency reference number assigned to this customer.
	api annotation:		Value for this field defaults to null.
tdDebtorFixedCredLimTC	decimal	Debtor.DebtorFixedCredLimTC	When Apply Fixed Ceiling is selected, specify the currency amount that determines the maximum credit extended to this customer.
	api annotation:		Value for this field defaults to 0.0000 .
tdDebtorHighCredit	decimal	Debtor.DebtorHighCredit	The highest amount of credit you have ever extended to this customer. This is the largest AR balance they have had open at one time.
ttDebtorHighCreditDate	date	Debtor.DebtorHighCreditDate	The date the highest credit amount was extended to this customer.
tlDebtorIsCheckAftDICredLim	logical	Debtor.DebtorIsCheckAftDICredLim	Indicate whether to perform the credit check when saving a new or modified invoice and include the new invoice amount in the total.
	api annotation:		Value for this field defaults to false.
tlDebtorIsCheckAftSOCredLim	logical	Debtor.DebtorIsCheckAftSOCredLim	Indicate whether to perform the credit check when saving a new or modified order and include the new order amount in the total.
	api annotation:		Value for this field defaults to false.
tlDebtorIsCheckBefDICredLim	logical	Debtor.DebtorIsCheckBefDICredLim	Indicate whether to perform the credit check before a new customer invoice is entered.
	api annotation:		Value for this field defaults to false.
tlDebtorIsCheckBefSOCredLim	logical	Debtor.DebtorIsCheckBefSOCredLim	Indicate whether to perform the credit check before a new order is entered or not.
	api annotation:		Value for this field defaults to false.
tlDebtorIsFinanceCharge	logical	Debtor.DebtorIsFinanceCharge	Indicate whether to make this customer’s accounts liable for finance charges or not.
	api annotation:		Value for this field defaults to false.
tlDebtorIsFixedCredLim	logical	Debtor.DebtorIsFixedCredLim	Indicate if the credit limit of the customer is fixed.
	api annotation:		Value for this field defaults to false.
tlDebtorIsInvoiceByAuth	logical	Debtor.DebtorIsInvoiceByAuth	Indicate how invoice totals should be calculated and displayed for this customer.
	api annotation:		Value for this field defaults to false.
tlDebtorIsLockedCredLim	logical	Debtor.DebtorIsLockedCredLim	Indicate whether to put this customer on hold.
	api annotation:		Value for this field defaults to false.
tlDebtorIsMaxDaysDueCredLim	logical	Debtor.DebtorIsMaxDaysDueCredLim	Indicate whether you can enter a value in the Maximum Number of Days field or not.
	api annotation:		Value for this field defaults to false.
tlDebtorIsOverruleDICredLim	logical	Debtor.DebtorIsOverruleDICredLim	Indicate whether to allow users to enter invoice transactions for a customer when the customer’s credit limit is exceeded.
	api annotation:		Value for this field defaults to false.
tlDebtorIsOverruleSOCredLim	logical	Debtor.DebtorIsOverruleSOCredLim	Indicate whether to allow users to enter order transactions for a customer when the customer’s credit limit is exceeded.
	api annotation:		Value for this field defaults to false.
tlDebtorIsTaxable	logical	Debtor.DebtorIsTaxable	Indicate if business activities for this address are normally subject to tax.
	api annotation:		Value for the field defaults from the Taxable field in Global Tax Management Control.
tlDebtorIsTaxInCity	logical	Debtor.DebtorIsTaxInCity	This setting determines whether the address is in the city limits for taxation purposes. It is used only with the Sales and Use Tax Interface for US and Canadian tax processing.
	api annotation:		Value for the field defaults from the business relation.
tlDebtorIsTaxIncluded	logical	Debtor.DebtorIsTaxIncluded	Tax Is Included
tlDebtorIsToBeLockedCredLim	logical	Debtor.DebtorIsToBeLockedCredLim	Indicate if the system puts the customer on credit hold if any of the credit limits are violated when new orders for this customer are created or not.
	api annotation:		Value for this field defaults to false.
tlDebtorIsTurnOverCredLim	logical	Debtor.DebtorIsTurnOverCredLim	Indicate whether you can enter a percentage in the Percentage of Turnover field.
	api annotation:		Value for this field defaults to false.
ttDebtorLastCreditReview	date	Debtor.DebtorLastCreditReview	The date when the customer’s credit status was last reviewed.
ttDebtorLastCreditUpdate	date	Debtor.DebtorLastCreditUpdate	The date when the customer’s credit status was last updated.
ttDebtorLastFinChargeDate	date	Debtor.DebtorLastFinChargeDate	The date when finance charge is last calculated for this customer.
	api annotation:		Value for this field defaults to null.
ttDebtorLastPayment	date	Debtor.DebtorLastPayment	Last payment date.
	api annotation:		The system automatically updates this date when transactions are posted in Banking Entry, Petty Cash, and Customer Payments.
ttDebtorLastSale	date	Debtor.DebtorLastSale	The date an invoice was last posted for this customer.
	api annotation:		This date is updated by Invoice Post and Print.
tiDebtorMaxNumDaysCredLim	integer	Debtor.DebtorMaxNumDaysCredLim	Specify the number of days that any invoice for this customer can be overdue before the system disallows any further credit.
	api annotation:		Value for this field defaults to 0.
tdDebtorPercTurnOverCredLim	decimal	Debtor.DebtorPercTurnOverCredLim	When Apply % of Turnover is selected,specify a percentage value. The system applies this percentage to the last year turnover and displays the result in the Credit on Turnover field. The amount is recalculated when you change the percentage.
	api annotation:		Value for this field defaults to 0.00 .
tdDebtorPercWarningCredLim	decimal	Debtor.DebtorPercWarningCredLim	Select to generate a warning message when the specified percentage of the credit limit has been reached.
	api annotation:		Value for this field defaults to 0.00 .
tdDebtorSalesOrderBalance	decimal	Debtor.DebtorSalesOrderBalance	Current balance of all sales order related to this customer.
	api annotation:		Value for this field defaults to 0.0000 .
tcDebtorStatementCycle	character	Debtor.DebtorStatementCycle	A value to indicate how often you normally print AR statements for this customer.
	api annotation:		Value for this field defaults to null.
tiDebtorTaxDeclaration	integer	Debtor.DebtorTaxDeclaration	Tax Declaration
tcDebtorTaxIDFederal	character	Debtor.DebtorTaxIDFederal	Federal Tax- the tax ID assigned to this address by the federal or national government.
	api annotation:		Value for the field defaults to null.
tcDebtorTaxIDMisc1	character	Debtor.DebtorTaxIDMisc1	Miscellaneous tax 1, 2, 3. For reference and documentation purposes, enter any other tax identification numbers that are useful.
	api annotation:		Values for these fields default to null.
tcDebtorTaxIDMisc2	character	Debtor.DebtorTaxIDMisc2	Miscellaneous Tax 2
tcDebtorTaxIDMisc3	character	Debtor.DebtorTaxIDMisc3	Miscellaneous Tax 3
tcDebtorTaxIDState	character	Debtor.DebtorTaxIDState	State Tax- For reference and documentation purposes, enter either a state or provincial tax identification number or a VAT registration number.
	api annotation:		Value for the field defaults to null.
tiDebtorTotalDaysLate	integer	Debtor.DebtorTotalDaysLate	Total Days Late
tiDebtorTotalNbrOfInvoices	integer	Debtor.DebtorTotalNbrOfInvoices	Number of paid invoices related to this customer.
tcDebtorTypeCode	character	DebtorType.DebtorTypeCode	A code (maximum four characters) that identifies a customer type.
tiDeductionCtrlGLProfile_ID	integer	Debtor.DeductionCtrlGLProfile_ID	Link to Deduction Profile
tcDeductionCtrlProfileCode	character	Profile1.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcDivisionProfileCode	character	Profile5.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tiDomiciliationNumber	integer	Debtor.DomiciliationNumber	Domiciliation Number
tcInvControlGLProfileCode	character	Profile3.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcNormalPaymentConditionCode	character	PaymentCondition.PaymentConditionCode	Credit Terms Code
tcPaymentGroupCode	character	PaymentGroup.PaymentGroupCode	Payment Group
tcReasonCode	character	Reason.ReasonCode	Invoice Status Code
tcSalesAccountGLProfileCode	character	Profile4.ProfileCode	A code (maximum 20 characters) that identifies a profile.
tcStateCode	character	State.StateCode	State
tcTxclTaxCls	character	Debtor.TxclTaxCls	A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions.
	api annotation:		The value of tax class defaults from the header of transactions created for this address.
tcTxuTaxUsage	character	Debtor.TxuTaxUsage	A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address.Common tax usages are retail, manufacturing, and industrialization.
	api annotation:		The value of tax usage defaults from the header of transactions created for this address.
tcTxzTaxZone	character	Debtor.TxzTaxZone	The tax zone for this address, defined in Tax Zone Maintenance. A value is required.
	api annotation:		The system searches for a default based on the country, state or province, county, city, and postal code of the current address.
tlBusinessRelationIsInterco	logical	BusinessRelation.BusinessRelationIsInterco	Intercompany. This field Indicates if the business relation identifies an entity that is a member of a group of entities that trade with each other. If the business relation is identified as an internal entity,this field is true and cannot be changed.
	api annotation:		PartialUpdate = yes - defaults to false.
tiBLWIGroup_ID	integer	Debtor.BLWIGroup_ID	BLWI Group Code
tiCnControlGLProfile_ID	integer	Debtor.CnControlGLProfile_ID	Control GL Profile (Credit Note)
tiCurrency_ID	integer	Debtor.Currency_ID	Currency Code
tlDebtorIsPrintReminder	logical	Debtor.DebtorIsPrintReminder	Indicate if reminders are typically printed for this customer to report past due balances.
	api annotation:		Value for this field defaults to false.
tlDebtorIsPrintStatement	logical	Debtor.DebtorIsPrintStatement	Indicate if statements should be printed for this customer. When this field is selected, a statement is printed for this customer using the frequency specified in Statement Cycle.
	api annotation:		Value for this field defaults to false.
tiDivisionProfile_ID	integer	Debtor.DivisionProfile_ID	Sub-Account Profile
tiInvControlGLProfile_ID	integer	Debtor.InvControlGLProfile_ID	Control GL Profile (Invoice)
tiNormalPaymentCondition_ID	integer	Debtor.NormalPaymentCondition_ID	Credit Terms Code
tiReason_ID	integer	Debtor.Reason_ID	Invoice Status Code
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.
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.
tlDebtorIsActive	logical	Debtor.DebtorIsActive	Indicate if this is an active record.
	api annotation:		Value for this field defaults to false.
tcAddressStreet2	character	Address.AddressStreet2	Address.Line two of address details. This field can be blank.
tcAddressStreet1	character	Address.AddressStreet1	Address: Line one of address details. 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.
tcAddressCity	character	Address.AddressCity	City. The city for this address. This field can be used to decide the tax zone of the address.
tiDebtor_ID	integer	Debtor.Debtor_ID	Record ID
tiSharedSet_ID	integer	Debtor.SharedSet_ID	Link to SharedSet
tiBusinessRelation_ID	integer	Debtor.BusinessRelation_ID	Business Relation
DebtorCustom	character	calculated	custom fields
BillScheduleCustom	character	calculated	custom fields
Profile1Custom	character	calculated	custom fields
BusinessRelationCustom	character	calculated	custom fields
AddressCustom	character	calculated	custom fields
AddressTypeCustom	character	calculated	custom fields
CountryCustom	character	calculated	custom fields
CountyCustom	character	calculated	custom fields
StateCustom	character	calculated	custom fields
CorporateGroupCustom	character	calculated	custom fields
CurrencyCustom	character	calculated	custom fields
Debtor2Custom	character	calculated	custom fields
DebtorCreditRatingCustom	character	calculated	custom fields
DebtorTypeCustom	character	calculated	custom fields
PaymentConditionCustom	character	calculated	custom fields
PaymentGroupCustom	character	calculated	custom fields
Profile2Custom	character	calculated	custom fields
Profile3Custom	character	calculated	custom fields
Profile4Custom	character	calculated	custom fields
Profile5Custom	character	calculated	custom fields
ReasonCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Debtor),rowid(BillSchedule),rowid(BusinessRelation),rowid(Address),rowid(AddressType),rowid(Country),rowid(County),rowid(State),rowid(CorporateGroup),rowid(Currency),rowid(Debtor2),rowid(DebtorCreditRating),rowid(DebtorType),rowid(PaymentCondition),rowid(PaymentGroup),rowid(Profile2),rowid(Profile3),rowid(Profile4),rowid(Profile5),rowid(Profile1),rowid(Reason)

Internal usage

QadFinancials

lookup query on tDebtor.DebtorCode
lookup query on tBill.tcDebtorCode
lookup query on tDDocument.tcDebtorCode
lookup query on tDebtor.tcBillToDebtorCode
lookup query on tDebtorEndUser.tcDebtorCode
lookup query on tDebtorShipTo.tcDebtorCode
lookup query on tDInvoice.tcDebtorCode
lookup query on tDInvoice.tcSoldToDebtorCode
lookup query on tProject.tcDebtorCode

Sample code: how to call this query through RPCRequestService (QXtend Inbound)

define temp-table ttContext no-undo
    field propertyQualifier as character
    field propertyName as character
    field propertyValue as character
    index entityContext is primary unique
        propertyQualifier
        propertyName
    index propertyQualifier
        propertyQualifier.

define dataset dsContext for ttContext.

define variable vhContextDS as handle no-undo.
define variable vhExceptionDS as handle no-undo.
define variable vhServer as handle no-undo.
define variable vhInputDS as handle no-undo.
define variable vhInputOutputDS as handle no-undo.
define variable vhOutputDS as handle no-undo.
define variable vhParameter as handle no-undo.

/* Create context */
create ttContext.
assign ttContext.propertyName = "programName"
       ttContext.propertyValue = "BDebtor".
create ttContext.
assign ttContext.propertyName = "methodName"
       ttContext.propertyValue = "SelectDebtor".
create ttContext.
assign ttContext.propertyName = "applicationId"
       ttContext.propertyValue = "fin".
create ttContext.
assign ttContext.propertyName = "entity"
       ttContext.propertyValue = "1000".
create ttContext.
assign ttContext.propertyName = "userName"
       ttContext.propertyValue = "mfg".
create ttContext.
assign ttContext.propertyName = "password"
       ttContext.propertyValue = "".

/* Create input dataset */
create dataset vhInputDS.
vhInputDS:read-xmlschema("file", "xml/bdebtor.selectdebtor.i.xsd", ?).
vhParameter = vhInputDS:get-buffer-handle("tParameterI").
vhParameter:buffer-create().

assign vhParameter::icRange = "A"
       vhParameter::icRowid = ""
       vhParameter::iiRownum = 0
       vhParameter::iiNumber = 5 /* Number of records to read */
       vhParameter::icSortColumns = ""
       vhParameter::ilCountOnly = false
       vhParameter::ilForwardRead = true
       vhParameter::iiMaximumBrowseRecordsToCount = 0.

vhParameter = vhInputDS:get-buffer-handle("tFilter").
vhParameter:buffer-create().

assign vhParameter::<field-name-1> = <field-value-1>
       vhParameter::<field-name-2> = <field-value-2>
       ...

/* Connect the AppServer */
create server vhServer.
vhServer:connect("-URL <appserver-url>").

if not vhServer:connected()
then do:
    message "Could not connect AppServer" view-as alert-box error title "Error".
    return.
end.

/* Run */
assign vhContextDS = dataset dsContext:handle.

run program/rpcrequestservice.p on vhServer
    (input-output dataset-handle vhContextDS by-reference,
           output dataset-handle vhExceptionDS,
     input        dataset-handle vhInputDS by-reference,
     input-output dataset-handle vhInputOutputDS by-reference,
           output dataset-handle vhOutputDS).

/* Handle output however you want, in this example, we dump it to xml */
if valid-handle(vhExceptionDS)
then vhExceptionDS:write-xml("file", "Exceptions.xml", true).

if valid-handle(vhOutputDS)
then vhOutputDS:write-xml("file", "Output.xml", true).

/* Cleanup */
vhServer:disconnect().
assign vhServer = ?.

if valid-handle(vhInputDS)
then delete object vhInputDS.

if valid-handle(vhOutputDS)
then delete object vhOutputDS.

if valid-handle(vhExceptionDS)
then delete object vhExceptionDS.