business logic query AllItemsForEmployee

Parameters

iiCompanyId	integer	Company id
icAddressCity	character
icAddressStreet	character
icBRCode	character
icBRName	character
icCreditorCode	character
icEmployeeCodeCando	character
icEmployeeCodeFrom	character
icEmployeeCodeTo	character
icUserName	character
itEndDateFrom	date
itEndDateTo	date
itStartDateFrom	date
itStartDateTo	date
ilEmployeeIsActive	logical
ilEmployeeIsUser	logical
ilEmloyeeIsExternal	logical
icEmployeeDepartmentCode	character
icEmployeeJobTitle	character

query condition

each Employee where

Employee.Company_Id = iiCompanyId AND
Employee.EmployeeCode can-do icEmployeeCodeCando AND
Employee.EmployeeCode >= icEmployeeCodeFrom AND
Employee.EmployeeCode <= icEmployeeCodeTo AND
Employee.EmployeeIsActive = ilEmployeeIsActive AND
Employee.EmployeeIsExternal = ilEmloyeeIsExternal AND
Employee.EmployeeIsUser = ilEmployeeIsUser AND
Employee.EmployeeStartDate >= itStartDateFrom AND
Employee.EmployeeStartDate <= itStartDateTo AND
Employee.EmployeeEndDate >= itEndDateFrom AND
Employee.EmployeeEndDate <= itEndDateTo AND
Employee.EmployeeDepartmentCode matches icEmployeeDepartmentCode AND
Employee.EmployeeJobTitle matches icEmployeeJobTitle

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Employee.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode can-do icBRCode AND
BusinessRelation.BusinessRelationName1 can-do icBRName

each Address (conditional-join) where

Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND
Address.AddressCity can-do icAddressCity AND
Address.AddressStreet1 can-do icAddressStreet

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 Creditor (conditional-join) where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = Employee.Creditor_ID AND
Creditor.CreditorCode can-do icCreditorCode

first Currency (conditional-join) where

Currency.Currency_ID = Employee.Currency_ID AND

first Project (conditional-join) where

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

first Usr (conditional-join) where

Usr.Usr_ID = Employee.Usr_ID AND
Usr.UsrName can-do icUserName

query resultset tqAllItemsForEmployee

field name	data type	db field	description
tcAddressCity	character	Address.AddressCity	City. The city for this address. This field can be used to decide the tax zone of the address.
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.
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.
tiCountry_ID	integer	Country.Country_ID	Record ID
tcCountryCode	character	Country.CountryCode	Country Code
tcCountryDescription	character	Country.CountryDescription	Description
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
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
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiEmployee_ID	integer	Employee.Employee_ID	Record ID
tcEmployeeCode	character	Employee.EmployeeCode	Employee Code. A code that identifies an employee. The code cannot match any other employee in the current entity or any other entities in the current domain. If you leave the Employee Code field blank, the system automatically generates a number for the record based on the sequence defined in Employee Autonumber Create.
tcEmployeeDepartmentCode	character	Employee.EmployeeDepartmentCode	Department Code: The department in which this employee normally works.
ttEmployeeEndDate	date	Employee.EmployeeEndDate	End Date: The date when this employee terminated employment at your company. This field is for reference and filtering report data.
tlEmployeeIsActive	logical	Employee.EmployeeIsActive	Active: This field indicates if this is an active record.
	api annotation:		PartialUpdate = yes - defaults to true
tlEmployeeIsActiveExpNotes	logical	Employee.EmployeeIsActiveExpNotes	Obsolete field
tlEmployeeIsActiveTimeReg	logical	Employee.EmployeeIsActiveTimeReg	Obsolete field
tlEmployeeIsExternal	logical	Employee.EmployeeIsExternal	External Employee: Indicate if the employee is a contractor or not employed directly by your organization.
	api annotation:		PartialUpdate = yes - defaults to false
tlEmployeeIsUser	logical	Employee.EmployeeIsUser	User: Indicate if this employee is also defined as a valid user in User Maintenance.
	api annotation:		PartialUpdate = yes - defaults to false
tcEmployeeJobTitle	character	Employee.EmployeeJobTitle	Job Title: An optional job title for this employee. This field is for reference only and useful in sorting browses.
ttEmployeeStartDate	date	Employee.EmployeeStartDate	Start Date: The date this employee was hired. This field is for reference and filtering report data.
	api annotation:		PartialUpdate = yes - defaults to the date the record was created
tcProjectCode	character	Project.ProjectCode	Project
tcTxclTaxCls	character	Creditor.TxclTaxCls	Tax Class
tcTxuTaxUsage	character	Creditor.TxuTaxUsage	Tax Usage
tcTxzTaxZone	character	Creditor.TxzTaxZone	Tax Zone
tcUsrName	character	Usr.UsrName	User Name

Internal usage

QadFinancials

method BEmployeeReport.EmployeeMasterCard