FastReport 9Mj3z01rewlpCCXM/hhpY9F4yy5IWXqBy3jtjfCY4WPjPMsLaVaxjGpETb1jSaRj1XCtjE1f0vXAE7nw4dC159Fa9cNLQZMdanftBHNU7HvEeNWMSwNzTXIYLeT5cKpe FastReport CustomReport 9Mj3z01rewlpCCXM/hhpY9F4yy5IWXqBy3jtjfCY4WPjPMsLaVaxjGpETb1jSaRj1XCtjE1f0vXAE7nw4dC159Fa9cNLQZMdanftBHNU7HvEeNWMSwNzTXIYLeT5cKpe CustomReport AuditHistory EntityType,System.String UserName,System.String UpdateDateTime,System.DateTime EventType,System.String ReferenceId,System.String ColumnName,System.String OldValue,System.String NewValue,System.String 900 AuditHistory FastReport Select * from rpt.AuditHistory where 1=2 AvailableTimesheets JobOrder_id,System.Int32 Candidate_id,System.Int32 Office_id,System.Int16 Start_date,System.DateTime End_date,System.DateTime Keyed_id,System.Int32 Deleted_flag,System.String ScheduledHours,System.Decimal 900 AvailableTimesheets FastReport Select * from rpt.AvailableTimesheets where 1=2 BillCodes BillCode_id,System.Int32 Name,System.String Disabled_flag,System.Boolean UnitType,System.String BillCodeType,System.String ExportCode,System.String ImportCode,System.String Country_id,System.Int32 Description,System.String Rate,System.Decimal Type,System.String PLExportAccount,System.String SortOrder,System.Int32 900 BillCodes FastReport Select * from rpt.BillCodes where 1=2 Brand BrandId,System.Int32 Name,System.String Description,System.String AccountSegment,System.String ExportCode,System.String ImportCode,System.String Status,System.String 900 Brand FastReport Select * from rpt.Brand where 1=2 Candidate CandidateId,System.Int32 OfficeId,System.Int32 Name,System.String Surname,System.String Salutation,System.String PreferredOrPreviousName,System.String SkillGroup,System.String PrimaryPosition,System.String Grade,System.Decimal Type,System.String CandidateAvail1,System.String CandidateAvail2,System.String CandidateOwner,System.String OfficeCode,System.String Status,System.String InActiveReason,System.String Industry,System.String BHPhone,System.String MobilePhone,System.String AHPhone,System.String Fax,System.String Email1,System.String Email2,System.String PreferredContactMethod,System.String WebSite,System.String Source,System.String DateOfBirth,System.DateTime Gender,System.String MaritalStatus,System.String SocialSecNo,System.String ClientContactName,System.String ReceivingCommunication,System.String Email,System.String SMS,System.String Mail,System.String MailCodes,System.String PrivacyStatement,System.String PrivacyStatementDate,System.DateTime PrivacyStatementTime,System.String InterviewDate,System.DateTime InterviewNotes,System.String Verified,System.String VerifiedBy,System.String VerifiedDate,System.DateTime VerifiedTime,System.String Rate,System.Decimal Salary,System.Decimal SalaryPackage,System.String IncomeComments,System.String Profile,System.String Height,System.Int16 Weight,System.Int16 SpecialNotes,System.String Speech,System.Int16 Understanding,System.Int16 Writing,System.Int16 Attitude,System.Int16 Appearance,System.Int16 EmergencyName,System.String EmergencyPhone,System.String RelationshipToCandidate,System.String ActualAddress1,System.String ActualAddress2,System.String ActualAddressCity,System.String ActualAddressSuburb,System.String ActualAddressState,System.String ActualAddressPostcode,System.String ActualAddressCountry,System.String MailingAddress1,System.String MailingAddress2,System.String MailingCity,System.String MailingSuburb,System.String MailingState,System.String MailingPostcode,System.String MailingCountry,System.String DiaryType,System.String AvailableDate,System.DateTime NoticePeriod,System.String PreferredWorkHrs,System.String NoticeWeeks,System.Int16 WillingToTravel,System.String WillingToTravelNotes,System.String CarAvailable,System.String DriversLicense,System.String ResidencyStatus,System.String ContractVisaDetails,System.String VisaNo,System.String VisaType,System.String ExpireDate,System.DateTime Nationality,System.String ImmigrationDate,System.DateTime PlaceOfBirth,System.String PortalUserName,System.String PortalLoginBlocked,System.String PortalSecurityQuestion,System.String PortalLastLoginDate,System.DateTime CreationDate,System.DateTime LastUpdateDate,System.DateTime CreatedBy,System.String CreatedById,System.Int32 LastUpdateBy,System.String LastUpdateById,System.Int32 AlternateNo,System.String MigrationID,System.String 900 Candidate FastReport Select * from rpt.Candidate where 1=2 CandidateActivities ActivityId,System.Int32 CandidateId,System.Int32 CreatedBy,System.String CreatedById,System.Int32 CreatedDate,System.DateTime CreatedTime,System.String ActivityOwner,System.String ActivityOwnerId,System.Int32 TaskDate,System.DateTime TaskTime,System.String Priority,System.Int32 TaskCode,System.String Description,System.String Details,System.String Status,System.String CompletionComments,System.String TaskDurationTime,System.String CreateInOutlook,System.String 900 CandidateActivities FastReport Select * from rpt.CandidateActivities where 1=2 CandidateComment CommentId,System.Int32 CandidateId,System.Int32 CommentDate,System.DateTime CreateDate,System.DateTime CreatedTime,System.String CreatedBy,System.String CreatedById,System.Int32 StandardDescription,System.String Comment,System.String 900 CandidateComment FastReport Select * from rpt.CandidateComment where 1=2 CandidateCustomFields CustomFieldId,System.Int32 CandidateId,System.Int32 CustomField,System.String CustomFieldValue,System.String 900 CandidateCustomFields FastReport Select * from rpt.CandidateCustomFields where 1=2 CandidateDiary CandidateId,System.Int32 CandidateName,System.String JobOrderId,System.Int32 JobOrderType,System.String StartDate,System.DateTime EndDate,System.DateTime AvailabilityType,System.String ReasonCode,System.String TypeOfLeave,System.String ApprovedBy,System.String ApprovedById,System.Int32 900 CandidateDiary FastReport Select * from rpt.CandidateDiary where 1=2 CandidateDocuments AttachFileId,System.Int32 CandidateId,System.Int32 FileName,System.String FolderName,System.String AttachedDate,System.DateTime AttachedTime,System.TimeSpan AttachedBy,System.String AttachedById,System.Int32 UserType,System.String Comment,System.String DisplayInPortal,System.String 900 CandidateDocuments FastReport Select * from rpt.CandidateDocuments where 1=2 CandidateResume AttachFileId,System.Int32 CandidateId,System.Int32 ClientId,System.Int32 FileName,System.String FolderName,System.String AttachedDate,System.DateTime AttachedTime,System.String Comment,System.String PrimaryResume,System.String DisplayInPortal,System.String LockAttachment,System.Boolean AttachedBy,System.String UserType,System.String 900 CandidateResume FastReport Select * from rpt.CandidateResume where 1=2 CandidateSkill CandidateId,System.Int32 Skill,System.String SkillGroup,System.String SkillType,System.String Grade,System.Int16 ReferenceNo,System.String YearsUsed,System.Int16 LastUsed,System.DateTime ExpiryDate,System.DateTime Level,System.Int16 Verified,System.String Preference,System.String Comments,System.String 900 CandidateSkill FastReport Select * from rpt.CandidateSkill where 1=2 CandidateUnavailability CandidateId,System.Int32 CandidateName,System.String StartDate,System.DateTime EndDate,System.DateTime AvailabilityType,System.String 900 CandidateUnavailability FastReport Select * from rpt.CandidateUnavailability where 1=2 CandidateWorkReference CandidateWorkReferenceId,System.Int32 CandidateId,System.Int32 Company,System.String Industry,System.String Location,System.String Contact,System.String BHPhone,System.String ReferenceType,System.String DutiesandResponsibilities,System.String Skills,System.String EmployeeType,System.String Position,System.String SalRate,System.Decimal StartDate,System.String EndDate,System.String Current,System.String Verified,System.String ReferenceCheckDetails,System.String ReasonForLeaving,System.String ReferenceChecked,System.String OutCome,System.String ReferenceDate,System.DateTime 900 CandidateWorkReference FastReport Select * from rpt.CandidateWorkReference where 1=2 Client ClientId,System.Int32 ParentCompanyId,System.Int32 ParentCompanyName,System.String ClientName,System.String ClientType,System.String DepartmentName,System.String ABN,System.String Industry,System.String MainPhone,System.String Fax,System.String WebSite,System.String ClientOwnerId,System.Int32 ClientOwner,System.String OfficeId,System.Int32 OfficeCode,System.String Status,System.String Source,System.String Grade,System.Decimal TotalEmployees,System.Int32 WhiteCollarEmployees,System.Int32 BlueCollarEmployees,System.Int32 AnnualSales,System.Decimal Capitalization,System.Decimal ParentCompanyNotes,System.String ClientProfile,System.String SpecialNotes,System.String MainAddress1,System.String MainCity,System.String MainSuburb,System.String MainState,System.String MainPostCode,System.String MainCountry,System.String MailingAddress1,System.String MailingCity,System.String MailingSuburb,System.String MailingState,System.String MailingPostCode,System.String MailingCountry,System.String TimeSheetFrequency,System.String Period1StartDay,System.Int32 Period2StartDay,System.Int32 WeekEndDay,System.String CycleStartDate,System.DateTime SplitTimeSheetatEndofCalendarMonth,System.String TimeSheetCodeRequired,System.String TimesheetCodeDuplicateCheck,System.String TradeRefChecked,System.String CreditCheck,System.String TermsandConditions,System.String WorkPlaceDescription,System.String ClothingandDressRequirement,System.String TravelInstructions,System.String MealandAmenities,System.String InspectionDate,System.DateTime OccupationalHealthandSafetyDetails,System.String CreationDate,System.DateTime CreatedById,System.Int32 CreatedBy,System.String RegistrationDate,System.DateTime DeRegistrationDate,System.DateTime LastUpdateDate,System.DateTime LastUpdateById,System.Int32 LastUpdateBy,System.String AlternateNo,System.String MigrationId,System.String PayRollTaxExempt,System.Boolean 900 Client FastReport Select * from rpt.Client where 1=2 ClientActivities ActivityId,System.Int32 ClientId,System.Int32 CreatedById,System.Int32 CreatedBy,System.String CreatedDate,System.DateTime CreatedTime,System.String ClientName,System.String Contact,System.String ActivityOwner,System.String ActivityOwnerId,System.Int32 TaskDate,System.DateTime TaskTime,System.String Priority,System.Int32 TaskCode,System.String Description,System.String Details,System.String Status,System.String CompletionComments,System.String TaskDurationTime,System.String Synctooutlook,System.String 900 ClientActivities FastReport Select * from rpt.ClientActivities where 1=2 ClientComment CommentId,System.Int32 ClientId,System.Int32 CommentDate,System.DateTime CreateDate,System.DateTime CreatedTime,System.String CreatedBy,System.String CreatedById,System.Int32 StandardDescriptionId,System.Int32 StandardDescription,System.String Comment,System.String 900 ClientComment FastReport Select * from rpt.ClientComment where 1=2 ClientContact ClientContactId,System.Int32 ClientId,System.Int32 ClientName,System.String CandidateId,System.Int32 CandidateName,System.String ContactOwner,System.String ContactOwnerId,System.Int32 FirstName,System.String Surname,System.String ContactTitle,System.String PreferredFirstName,System.String ContactType,System.String Status,System.String InActiveReason,System.String BHPhone,System.String Mobile,System.String AHPhone,System.String Fax,System.String CoEmail1,System.String CoEmail2,System.String PreferredContactMethod,System.String AuthorisedSkillGroup,System.String AuthorisedPositionType,System.String DateOfBirth,System.DateTime UserName,System.String Email,System.String SMS,System.String Mail,System.String AcceptReferrals,System.String OptIn,System.String MainAddress1,System.String MainCity,System.String MainSuburb,System.String MainState,System.String MainPostcode,System.String MainCountry,System.String CreationDate,System.DateTime CreatedBy,System.String CreatedById,System.Int32 LastUpdateDate,System.DateTime LastUpdateById,System.Int32 LastUpdateBy,System.String AlternateNo,System.String MigrationID,System.String 900 ClientContact FastReport Select * from rpt.ClientContact where 1=2 ClientContactCustomFields CustomFieldId,System.Int32 ClientContactId,System.Int32 CustomField,System.String CustomFieldValue,System.String 900 ClientContactCustomFields FastReport Select * from rpt.ClientContactCustomFields where 1=2 ClientContactLinkedClients ClientContactId,System.Int32 ClientId,System.Int32 ClientName,System.String ContactName,System.String 900 ClientContactLinkedClients FastReport Select * from rpt.ClientContactLinkedClients where 1=2 ClientContactLinkedCostCentres ClientContactId,System.Int32 ClientId,System.Int32 ClientName,System.String ContactName,System.String CostCentreId,System.Int32 CostCentreName,System.String 900 ClientContactLinkedCostCentres FastReport Select * from rpt.ClientContactLinkedCostCentres where 1=2 ClientCustomFields CustomFieldId,System.Int32 ClientId,System.Int32 CustomField,System.String CustomFieldValue,System.String 900 ClientCustomFields FastReport Select * from rpt.ClientCustomFields where 1=2 ClientDocuments AttachFileId,System.Int32 ClientId,System.Int32 FileName,System.String TemplateFolderId,System.Int32 FolderName,System.String AttachedDate,System.DateTime AttachedTime,System.TimeSpan AttachedBy,System.String UserType,System.String Comment,System.String DisplayInPortal,System.String 900 ClientDocuments FastReport Select * from rpt.ClientDocuments where 1=2 ClientProjectCodes ClientProjectCodeId,System.Int32 ClientId,System.Int32 Name,System.String Description,System.String Default,System.String Active,System.String 900 ClientProjectCodes FastReport Select * from rpt.ClientProjectCodes where 1=2 CostCentre CostCentreId,System.Int32 ClientId,System.Int32 ClientName,System.String CostCentreName,System.String CostCentreCode,System.String CostCentreType,System.String ABN,System.String CostCentreOwner,System.String OfficeCode,System.String OfficeCodeId,System.Int32 Status,System.String Profile,System.String MainAddress1,System.String MainAddress2,System.String MainAddressCity,System.String MainAddressSuburb,System.String MainAddressState,System.String MainAddressPostcode,System.String MainAddressCountry,System.String MailingAddress1,System.String MailingAddress2,System.String MailingCity,System.String MailingSuburb,System.String MailingAddressState,System.String MailingAddressCountry,System.String MailingPostcode,System.String TradeRefChecked,System.String CreditCheck,System.String TermsandConditions,System.String CreationDate,System.DateTime CreatedBy,System.String CreatedById,System.Int32 RegistrationDate,System.DateTime DeRegistrationDate,System.DateTime LastUpdateDate,System.DateTime LastUpdateById,System.Int32 LastUpdateBy,System.String AlternateNo,System.String MigrationId,System.String 900 CostCentre FastReport Select * from rpt.CostCentre where 1=2 CostCentreActivities ActivityId,System.Int32 CostCentreId,System.Int32 CreatedBy,System.String CreatedById,System.Int32 CreatedDate,System.DateTime CreatedTime,System.String ActivityOwner,System.String ActivityOwnerId,System.Int32 TaskDate,System.DateTime TaskTime,System.String Priority,System.Int32 TaskCode,System.String Description,System.String Details,System.String Status,System.String CompletionComments,System.String TaskDurationTime,System.String CreateInOutlook,System.String 900 CostCentreActivities FastReport Select * from rpt.CostCentreActivities where 1=2 CostCentreComment CommentId,System.Int32 CommentDate,System.DateTime CreateDate,System.DateTime CreatedTime,System.String CreatedBy,System.String StandardDescriptionId,System.Int32 StandardDescription,System.String Comment,System.String CostCentreId,System.Int32 900 CostCentreComment FastReport Select * from rpt.CostCentreComment where 1=2 CostCentreCustomFields CustomFieldId,System.Int32 CostCentreId,System.Int32 CustomField,System.String CustomFieldValue,System.String 900 CostCentreCustomFields FastReport Select * from rpt.CostCentreCustomFields where 1=2 CostCentreDocuments AttachFileId,System.Int32 CostCentreId,System.Int32 FileName,System.String TemplateFolderId,System.Int32 FolderName,System.String AttachedDate,System.DateTime AttachedTime,System.TimeSpan AttachedBy,System.String AttachedById,System.Int32 UserType,System.String Comment,System.String DisplayInPortal,System.String 900 CostCentreDocuments FastReport Select * from rpt.CostCentreDocuments where 1=2 Country CountryId,System.Int32 CountryName,System.String Language,System.String CurrencySymbol,System.String Status,System.String Currency,System.String Sample,System.String ExportCode,System.String AccountSegment,System.String ImportCode,System.String Address1Label,System.String DisplayAddress1,System.String Address2Label,System.String DisplayAddress2,System.String CityLabel,System.String DisplayCity,System.String SuburbLabel,System.String DisplaySuburb,System.String StateLabel,System.String DisplayState,System.String PostCodeLabel,System.String DisplayPostCode,System.String CorporateIdentityNumberLabel,System.String CorporateIdentityNumberFormat,System.String 900 Country FastReport Select * from rpt.Country where 1=2 DataGroup DataGroupId,System.Int32 DataGroupName,System.String Status,System.String 900 DataGroup FastReport Select * from rpt.DataGroup where 1=2 DataGroupEntity DataGroupId,System.Int32 OfficeId,System.Int32 BrandId,System.Int32 CountryId,System.Int32 DataGroupName,System.String Status,System.String OfficeName,System.String Brand,System.String Country,System.String 900 DataGroupEntity FastReport Select * from rpt.DataGroupEntity where 1=2 DebtorBillingRules DebtorInvoiceLink_id,System.Int32 Debtor_id,System.Int32 BillingCompany_id,System.Int32 InvoiceFormatGroup_id,System.Int32 TimeGroup_id,System.Int32 DataGroupType_no,System.String DeliveryMethodType_no,System.String BillToContact_id,System.Int32 EmailDeliveryType_no,System.String DeliveryOrderByContact_flag,System.Boolean DeliverInvoicedTimesheets,System.Boolean BillToAddressType,System.String UseClientPositionForTimesheetInvoicing,System.Boolean DeliverInvoicedTimesheetAttachments,System.Boolean InvoiceTerms_id,System.Int32 InvoiceMessage_id,System.Int32 900 DebtorBillingRules FastReport Select * from rpt.DebtorBillingRules where 1=2 DebtorBillingTaxRules Debtor_id,System.Int32 Taxation_id,System.Int32 TaxationNumber,System.String 900 DebtorBillingTaxRules FastReport Select * from rpt.DebtorBillingTaxRules where 1=2 DebtorCustomFields Debtor_Id,System.Int32 DebtorName,System.String CustomFieldName,System.String CustomFieldValue,System.String 900 DebtorCustomFields FastReport Select * from rpt.DebtorCustomFields where 1=2 DebtorDeliveryContacts Contact_id,System.Int32 DebtorInvoiceLinkID,System.Int32 900 DebtorDeliveryContacts FastReport Select * from rpt.DebtorDeliveryContacts where 1=2 DebtorInvoiceFees DebtorInvoiceLink_id,System.Int32 Start_date,System.DateTime End_date,System.DateTime Amount,System.Decimal ExportCode,System.String ImportCode,System.String 900 DebtorInvoiceFees FastReport Select * from rpt.DebtorInvoiceFees where 1=2 Debtors DebtorId,System.Int32 Name,System.String CorporateIdentityNumber,System.String Disabled_flag,System.String CustomerType,System.String CustomerId,System.Int32 ImportCode,System.String ExportCode,System.String CreditLimit,System.Decimal CreditWarningType_no,System.String BillingDepartment,System.String MigrationId,System.String RemittanceOfficeCode,System.Int16 AddressLine1,System.String AddressLine2,System.String Suburb,System.String State,System.String PostCode,System.String Country,System.String City,System.String CostCentreName,System.String ClientName,System.String ParentCompanyName,System.String CountryName,System.String 900 Debtors FastReport Select * from rpt.Debtors where 1=2 DebtorTaxation Debtor_id,System.Int32 TaxationName,System.String TaxationNumber,System.String IsExempted,System.Boolean 900 DebtorTaxation FastReport Select * from rpt.DebtorTaxation where 1=2 GrossWageBatchPayslipDeduction GrossWageBatchPayeeDeduction_History_id,System.Int32 DeductionName,System.String ApplyTo_no,System.String AccountName,System.String AccountNumber,System.String 900 GrossWageBatchPayslipDeduction FastReport Select * from rpt.GrossWageBatchPayslipDeduction where 1=2 GrossWageBatchPayslipDeductionAustralia GrossWageBatchPayeeDeduction_History_id,System.Int32 ShowOnPayslip_flag,System.Boolean 900 GrossWageBatchPayslipDeductionAustralia FastReport Select * from rpt.GrossWageBatchPayslipDeductionAustralia where 1=2 GrossWageBatchPayslipItem GrossWageBatchItem_History_id,System.Int32 PayCodeName,System.String ClientName,System.String JobPosition,System.String EarliestTimesheetItemDate,System.DateTime LatestTimesheetItemDate,System.DateTime JobClientPosition,System.String 900 GrossWageBatchPayslipItem FastReport Select * from rpt.GrossWageBatchPayslipItem where 1=2 GrossWageBatchPayslipPayCompany GrossWageBatchPayslipPayCompany_id,System.Int32 GrossWageBatch_id,System.Int32 PayCompany_id,System.Int32 Name,System.String TradeName,System.String MailAddressLine1,System.String MailAddressLine2,System.String MailAddressSuburb,System.String MailAddressState,System.String MailAddressPostCode,System.String MailAddressCountry,System.String ContactPhone,System.String ContactEmail,System.String PayslipMessage,System.String ContactMobile,System.String 900 GrossWageBatchPayslipPayCompany FastReport Select * from rpt.GrossWageBatchPayslipPayCompany where 1=2 GrossWageBatchPayslipPayCompanyAustralia GrossWageBatchPayslipPayCompany_id,System.Int32 ABN,System.String 900 GrossWageBatchPayslipPayCompanyAustralia FastReport Select * from rpt.GrossWageBatchPayslipPayCompanyAustralia where 1=2 GrossWageBatchPayslipPayCompanyNewZealand GrossWageBatchPayslipPayCompany_id,System.Int32 IRDNumber,System.String GSTNumber,System.String 900 GrossWageBatchPayslipPayCompanyNewZealand FastReport Select * from rpt.GrossWageBatchPayslipPayCompanyNewZealand where 1=2 GrossWageBatchPayslipPayee GrossWageBatchPayee_History_id,System.Int32 GrossWageBatchPayslipPayCompany_id,System.Int32 Candidate_id,System.Int32 PayeeIdentifier,System.Int32 Office_id,System.Int32 OfficeName,System.String FirstName,System.String Surname,System.String MailAddressLine1,System.String MailAddressLine2,System.String MailAddressSuburb,System.String MailAddressState,System.String MailAddressPostCode,System.String MailAddressCountry,System.String PayslipMessage,System.String TaxableAllowancesTotal,System.Decimal TaxableAllowancesTotalYTD,System.Decimal NonTaxableAllowancesTotal,System.Decimal NonTaxableAllowancesTotalYTD,System.Decimal AllowancesTotal,System.Decimal AllowancesTotalYTD,System.Decimal GrossPay,System.Decimal GrossPayYTD,System.Decimal WithholdingTaxTotal,System.Decimal WithholdingTaxTotalYTD,System.Decimal TaxTotal,System.Decimal TaxTotalYTD,System.Decimal GrossDeductionsTotal,System.Decimal GrossDeductionsTotalYTD,System.Decimal NetDeductionsTotal,System.Decimal NetDeductionsTotalYTD,System.Decimal GST,System.Decimal GSTYTD,System.Decimal ReimbursementTotal,System.Decimal ReimbursementTotalYTD,System.Decimal NETPay,System.Decimal NETPayYTD,System.Decimal GrossWageBatch_id,System.Int32 Delivered,System.Boolean ActualDeliveryMethod,System.String DeliveredBy,System.String DeliveredDatetime,System.DateTime PreferredDeliveryMethod,System.String TaxPeriodEndDate,System.DateTime EnquiryOfficeCode,System.Int16 EnquiryOfficeName,System.String EnquiryOfficeAddressLine1,System.String EnquiryOfficeAddressLine2,System.String EnquiryOfficeSuburb,System.String EnquiryOfficeState,System.String EnquiryOfficePostCode,System.String EnquiryOfficePhone,System.String EnquiryOfficeEmail,System.String 900 GrossWageBatchPayslipPayee FastReport Select * from rpt.GrossWageBatchPayslipPayee where 1=2 GrossWageBatchPayslipPayeeAustralia GrossWageBatchPayee_History_id,System.Int32 GrossWageBatch_id,System.Int32 SFSSTotal,System.Decimal SFSSTotalYTD,System.Decimal SFSS_flag,System.Boolean HELPTotal,System.Decimal HELPTotalYTD,System.Decimal HELP_flag,System.Boolean TaxLevyTotal,System.Decimal TaxLevyTotalYTD,System.Decimal Levy_flag,System.Boolean Super,System.Decimal SuperYTD,System.Decimal CompanyName,System.String TradingName,System.String CompanyABN,System.String CompanyAddressLine1,System.String CompanyAddressLine2,System.String CompanyAddressSuburb,System.String CompanyAddressState,System.String CompanyAddressPostCode,System.String CompanyAddressCountry,System.String ShowNoTFNProvidedMessage,System.Boolean 900 GrossWageBatchPayslipPayeeAustralia FastReport Select * from rpt.GrossWageBatchPayslipPayeeAustralia where 1=2 GrossWageBatchPayslipPayeeEmployeeBenefit GrossWageBatchPayslipPayeeEmployeeBenefitId,System.Int32 GrossWageBatchPayee_History_id,System.Int32 EmployeeBenefitTypeId,System.Int32 EmployeeBenefitTypeName,System.String EmployeeBenefitSchemeAdministratorId,System.Int32 EmployeeBenefitSchemeAdministratorName,System.String PayeeMemberNumber,System.String Amount,System.Decimal 900 GrossWageBatchPayslipPayeeEmployeeBenefit FastReport Select * from rpt.GrossWageBatchPayslipPayeeEmployeeBenefit where 1=2 GrossWageBatchPayslipPayeeKiwiSaver GrossWageBatchPayslipPayeeKiwiSaverId,System.Int32 GrossWageBatchPayee_History_id,System.Int32 Amount,System.Decimal AmountPeriodTD,System.Decimal AmountYTD,System.Decimal Esct,System.Decimal EsctPeriodTD,System.Decimal EsctYTD,System.Decimal 900 GrossWageBatchPayslipPayeeKiwiSaver FastReport Select * from rpt.GrossWageBatchPayslipPayeeKiwiSaver where 1=2 GrossWageBatchPayslipPayeeLeaveBalance GrossWageBatchPayslipPayeeLeaveBalanceId,System.Int32 GrossWageBatchPayee_History_id,System.Int32 LeaveTypeName,System.String Balance,System.Decimal BalanceCost,System.Decimal 900 GrossWageBatchPayslipPayeeLeaveBalance FastReport Select * from rpt.GrossWageBatchPayslipPayeeLeaveBalance where 1=2 GrossWageBatchPayslipPayeeNewZealand GrossWageBatchPayee_History_id,System.Int32 GrossWageBatch_id,System.Int32 SLTotal,System.Decimal SLTotalYTD,System.Decimal CompanyAddressSuburb,System.String TradingName,System.String CompanyName,System.String CompanyAddressCountry,System.String CompanyAddressLine1,System.String CompanyAddressState,System.String CompanyAddressPostCodeArea,System.String CompanyAddressLine2,System.String CompanyABN,System.String 900 GrossWageBatchPayslipPayeeNewZealand FastReport Select * from rpt.GrossWageBatchPayslipPayeeNewZealand where 1=2 GrossWageBatchPayslipPayeeSuper GrossWageBatchPayslipPayeeSuperId,System.Int32 GrossWageBatchPayee_History_id,System.Int32 PayeeIdentifier,System.Int32 SuperFundId,System.Int32 Name,System.String PaymentDate,System.DateTime PolicyNumber,System.String SPIN,System.String Amount,System.Decimal AmountPeriodTD,System.Decimal AmountYTD,System.Decimal TaxPeriodEndDate,System.DateTime 900 GrossWageBatchPayslipPayeeSuper FastReport Select * from rpt.GrossWageBatchPayslipPayeeSuper where 1=2 InterpretedBatch InterpretedBatch_id,System.Int32 Start_datetime,System.DateTime End_datetime,System.DateTime 900 InterpretedBatch FastReport Select * from rpt.InterpretedBatch where 1=2 InterpretedTimesheet TimesheetHeader_id,System.Int32 InterpretedBatch_id,System.Int32 Status,System.String Start_date,System.DateTime End_date,System.DateTime Countryid,System.Int32 CountryName,System.String OfficeCode,System.Int16 ClientNo,System.Int32 ClientName,System.String JobOrderNo,System.Int32 CandidateName,System.String CandidateNo,System.Int32 OfficeName,System.String PayeeNo,System.Int32 900 InterpretedTimesheet FastReport Select * from rpt.InterpretedTimesheet where 1=2 InterpretedTimesheetOncostResult PayBillResult_id,System.Int32 OncostType,System.String OncostValue,System.Decimal Name,System.String StartDate_date,System.DateTime EndDate_date,System.DateTime RateValue,System.Decimal HierarchyType,System.String HierarchyValue,System.Int32 Exempt_flag,System.Boolean ExportCode,System.String PLExportAccount,System.String BSExportAccount,System.String 900 InterpretedTimesheetOncostResult FastReport Select * from rpt.InterpretedTimesheetOncostResult where 1=2 InterpretedTimesheetResult InterpretedBatch_id,System.Int32 ResultType,System.String PayResult_id,System.Int32 BillResult_id,System.Int32 TimesheetHeader_id,System.Int32 PayCode_id,System.Int32 PayCodeName,System.String BillCode_id,System.Int32 BillCodeName,System.String Quantity,System.Decimal Rate,System.Decimal Total,System.Decimal RateHierarchyType,System.String RateHierarchyValue,System.Int32 ProjectCode,System.String PrimedShiftStart_date,System.DateTime PrimedShiftStart_time,System.TimeSpan PrimedShiftEnd_time,System.TimeSpan ScheduledStatus_flag,System.Boolean Source,System.String Net,System.Decimal Tax,System.Decimal AttendanceItem_id,System.Int32 ManualItem_id,System.Int32 LinkedBillResultId,System.Int32 900 InterpretedTimesheetResult FastReport Select * from rpt.InterpretedTimesheetResult where 1=2 InvoiceAudit InvoiceAudit_id,System.Int32 Invoice_id,System.Int32 Action,System.String ActionDate_datetime,System.DateTime UserType,System.String Delivered_flag,System.Boolean DeliveryMethod,System.String Username,System.String UserFirstName,System.String UserSurname,System.String 900 InvoiceAudit FastReport Select * from rpt.InvoiceAudit where 1=2 InvoiceBatch InvoiceBatch_id,System.Int32 RunStartDatetime,System.DateTime RunEndDatetime,System.DateTime RunStatusCode,System.String TimeGroup_date,System.DateTime Country_id,System.Int32 BillingCompany_id,System.Int32 900 InvoiceBatch FastReport Select * from rpt.InvoiceBatch where 1=2 InvoiceHeader Invoice_id,System.Int32 InvoiceBatch_id,System.Int32 InvoiceTerms,System.String DueDate,System.DateTime Invoice_date,System.DateTime CreateDate,System.DateTimeOffset CreatedByUser,System.String OriginalInvoice_id,System.Int32 InvoiceType,System.String Status,System.String InvoiceMessage,System.String BillingCompanyName,System.String BillingCompanyAddressLine1,System.String BillingCompanyAddressLine2,System.String BillingCompanySuburb,System.String BillingCompanyState,System.String BillingCompanyPostCode,System.String BillingCompanyCountry,System.String BillingCompanyPhone,System.String BillingCompanyEmail,System.String BillingCompanyNumber,System.String BillingCompanyContact,System.String DebtorId,System.Int32 DebtorName,System.String DebtorContact,System.String DebtorBillingDepartment,System.String DebtorAddressLine1,System.String DebtorAddressLine2,System.String DebtorSuburb,System.String DebtorState,System.String DebtorPostCode,System.String DebtorCountry,System.String InvoiceSubTotal,System.Decimal TaxTotal,System.Decimal InvoiceTotal,System.Decimal BalanceDue,System.Decimal Delivered_flag,System.String TaxMessage,System.String InvoiceFormatType_no,System.String CustomerType,System.String CustomerId,System.Int32 CustomerName,System.String CustomerAddress1,System.String CustomerAddress2,System.String CustomerSuburb,System.String CustomerState,System.String CustomerPostCode,System.String CustomerCountry,System.String CustomerMailingAddress1,System.String CustomerMailingAddress2,System.String CustomerMailingSuburb,System.String CustomerMailingState,System.String CustomerMailingPostCode,System.String CustomerMailingCountry,System.String CostCentreName,System.String OwnerStaffName,System.String OwnerStaffBHPhone,System.String OwnerStaffMobilePhone,System.String OwnerStaffEmail,System.String InvoiceFee,System.Decimal ExcludeInvoiceFee_flag,System.Boolean ReferenceNo,System.String BillToAddressType,System.String RemittanceOfficeCode,System.Int16 RemittanceOfficeName,System.String RemittanceOfficeAddressLine1,System.String RemittanceOfficeAddressLine2,System.String RemittanceOfficeSuburb,System.String RemittanceOfficeState,System.String RemittanceOfficePostCode,System.String RemittanceOfficePhone,System.String RemittanceOfficeEmail,System.String ActualBillToAddressType,System.String CreditNoteReason,System.String 900 InvoiceHeader FastReport Select * from rpt.InvoiceHeader where 1=2 InvoiceHeaderTaxation Invoice_id,System.Int32 TaxationName,System.String InvoiceTaxationTotal,System.Decimal InvoiceHeaderTaxation_id,System.Int32 900 InvoiceHeaderTaxation FastReport Select * from rpt.InvoiceHeaderTaxation where 1=2 InvoiceItem InvoiceItem_id,System.Int32 Invoice_id,System.Int32 Item,System.String ItemDate,System.DateTime Description,System.String Quantity,System.Decimal Rate,System.Decimal ItemSubTotal,System.Decimal ItemTaxTotal,System.Decimal BillingFeeTotal,System.Decimal ItemTotal,System.Decimal Cost,System.Decimal TimesheetStart_date,System.DateTime TimesheetEnd_date,System.DateTime JobOrder_id,System.Int32 OfficeCode,System.Int16 PurchaseOrderNumber,System.String ProjectCode,System.String TimesheetCode,System.String PayeeNo,System.Int32 PayeeFirstName,System.String PayeeMiddleName,System.String PayeeSurname,System.String IsAdjustmentFlag,System.String JobOrderByContactFirstName,System.String JobOrderByContactSurname,System.String JobOrderByContactTitle,System.String JobOrderSiteContactFirstName,System.String JobOrderSiteContactSurname,System.String JobOrderSiteContactTitle,System.String JobOrderReportToContactFirstName,System.String JobOrderReportToContactSurname,System.String JobOrderReportToContactTitle,System.String ClientDepartmentName,System.String CostCentreName,System.String JobOrderPositionType,System.Byte JobOrderClientPosition,System.String JobOrderPosition,System.String Job_x0020_Order_x0020_Base_x0020_Salary,System.String Candidate_id,System.Int32 BillResult_id,System.Int32 900 InvoiceItem FastReport Select * from rpt.InvoiceItem where 1=2 InvoiceItemBillingFee InvoiceItemId,System.Int32 BillingFeeName,System.String Total,System.Decimal 900 InvoiceItemBillingFee FastReport Select * from rpt.InvoiceItemBillingFee where 1=2 InvoiceItemOncostGroup InvoiceItemId,System.Int32 OncostName,System.String Total,System.Decimal 900 InvoiceItemOncostGroup FastReport Select * from rpt.InvoiceItemOncostGroup where 1=2 InvoiceItemTaxation InvoiceItem_id,System.Int32 TaxationName,System.String Total,System.Decimal 900 InvoiceItemTaxation FastReport Select * from rpt.InvoiceItemTaxation where 1=2 JobOrder JobOrderId,System.Int32 ClientNo,System.Int32 ClientName,System.String CandidateId,System.Int32 CandidateName,System.String PositionType,System.String DeptartmentSection,System.String CostCenter,System.String Type,System.String TypeOfService,System.String ExtPossibility,System.Boolean OfficeId,System.Int32 OfficeCode,System.String Status,System.String StatusReason,System.String SkillGroup,System.String Position,System.String StartDate,System.DateTime EndDate,System.DateTime OrderById,System.Int32 OrderBy,System.String SiteContactId,System.Int32 SiteContact,System.String ReportToId,System.Int32 ReportTo,System.String WorkType,System.String Location,System.String ClientPostition,System.String JobDescription,System.String JobOwnerId,System.Int32 JobOwner,System.String JobCreatorId,System.Int32 JobCreator,System.String OrderDate,System.DateTime OrderTime,System.TimeSpan Source,System.String ReasonForNeed,System.String ProbabilityFill,System.Decimal Exclusive,System.Boolean ExclusiveDate,System.DateTime FilledById,System.Int32 FilledBy,System.String FilledDate,System.DateTime FilledTime,System.TimeSpan AdvertisingDescription,System.String Frequency,System.String WeekEndDay,System.String CycleStartDate,System.DateTime JobRateFrequency,System.String PayRate,System.Decimal PurchaseOrderGroup,System.String PurchaseOrderNo,System.String WorkPlaceDescription,System.String ClothingandDressRequirement,System.String TravelInstructions,System.String MealandAmenities,System.String InspectionDate,System.DateTime OccupationalHealthandSafetyDetails,System.String Agency,System.String AgencyCandidate,System.String AgencyJobNo,System.String AgencyClientNo,System.String AgencyPositionTitle,System.String AgencyCandidateNo,System.String CreationDate,System.DateTime CreatedById,System.Int32 CreatedBy,System.String LastUpdatedDateTime,System.DateTime LastUpdateById,System.Int32 LastUpdateBy,System.String FamilyNo,System.Int32 AlternateNo,System.String MigrationId,System.String PostedToJobPost,System.String EstimatedJobBillRate,System.Decimal EstimatedOnCosts,System.Decimal 900 JobOrder FastReport Select * from rpt.JobOrder where 1=2 JobOrderActivities ActivityId,System.Int32 JobOrderId,System.Int32 CreatedBy,System.String CreatedById,System.Int32 CreatedDate,System.DateTime CreatedTime,System.String ActivityOwnerId,System.Int32 ActivityOwner,System.String TaskDate,System.DateTime TaskTime,System.String Priority,System.Int32 TaskCode,System.String Description,System.String Details,System.String Status,System.String CompletionComments,System.String TaskDurationTime,System.String CreateInOutlook,System.String CandidateId,System.Int32 ClientContactId,System.Int32 900 JobOrderActivities FastReport Select * from rpt.JobOrderActivities where 1=2 JobOrderComment CommentId,System.Int32 JobOrderId,System.Int32 CommentDate,System.DateTime CreatedDate,System.DateTime CreatedTime,System.String CreatedById,System.Int32 CreatedBy,System.String StandardDescription,System.String Comment,System.String 900 JobOrderComment FastReport Select * from rpt.JobOrderComment where 1=2 JobOrderCustomFields CustomFieldId,System.Int32 JobOrderId,System.Int32 CustomField,System.String CustomFieldValue,System.String 900 JobOrderCustomFields FastReport Select * from rpt.JobOrderCustomFields where 1=2 JobOrderDocuments AttachFileId,System.Int32 JobOrderId,System.Int32 FileName,System.String FolderName,System.String AttachedDate,System.DateTime AttachedTime,System.TimeSpan AttachedById,System.Int32 AttachedBy,System.String UserType,System.String Comment,System.String DisplayInPortal,System.String 900 JobOrderDocuments FastReport Select * from rpt.JobOrderDocuments where 1=2 JobOrderReferral JobOrderReferralId,System.Int32 JobOrderId,System.Int32 ClientId,System.Int32 CandidateId,System.Int32 Candidate,System.String ClientName,System.String Contact,System.String Position,System.String Source,System.String CandidateNo,System.Int32 CandidateName,System.String MobilePhone,System.String Stage,System.String Comment,System.String CandidateOwnerId,System.Int32 CandidateOwner,System.String Date,System.DateTime Time,System.TimeSpan ReferralNo,System.Int32 CreationDate,System.DateTime CreatedBy,System.String CreatedById,System.Int32 LastUpdatedBy,System.String LastUpdatedById,System.Int32 LastUpdateDate,System.DateTime MigrationId,System.String 900 JobOrderReferral FastReport Select * from rpt.JobOrderReferral where 1=2 JobOrderReferralHistory JobOrderReferralStageHistoryId,System.Int32 JobOrderId,System.Int32 JobOrderReferralId,System.Int32 HistoryDate,System.DateTime HistoryTime,System.String StageName,System.String ActionById,System.Int32 ActionBy,System.String Comment,System.String 900 JobOrderReferralHistory FastReport Select * from rpt.JobOrderReferralHistory where 1=2 JobOrderServiceFees JobOrderPermServiceId,System.Int32 JobOrderId,System.Int32 ServiceCode,System.String ServiceName,System.String Service,System.String InvoiceDescription,System.String Unit,System.Int32 ItemCost,System.Decimal TotalCost,System.Decimal TotalSales,System.Decimal Margin,System.Decimal EstimatedBillDate,System.DateTime ReadyforInvoice,System.Boolean ActualBillDate,System.DateTime UnitPriceName,System.String UnitPrice,System.Decimal ItemPrice,System.Decimal BillValue,System.Decimal 900 JobOrderServiceFees FastReport Select * from rpt.JobOrderServiceFees where 1=2 JobProjectCodes JobOrderId,System.Int32 JobOrderProjectCodeId,System.Int32 Name,System.String Description,System.String Default,System.String 900 JobProjectCodes FastReport Select * from rpt.JobProjectCodes where 1=2 JobSchedule JobOrderId,System.Int32 StartDate,System.DateTime EndDate,System.DateTime StartTime,System.TimeSpan EndTime,System.TimeSpan BreakStartTime,System.TimeSpan BreakEndTime,System.TimeSpan PatternName,System.String Code,System.String 900 JobSchedule FastReport Select * from rpt.JobSchedule where 1=2 KeywordLibrary SkillKeywordId,System.Int32 Keyword,System.String SkillGroup,System.String SkillType,System.String Description,System.String Precode,System.String Synonyms,System.String AccountSegment,System.String ExportCode,System.String ImportCode,System.String CandidateProfile,System.String Status,System.String 900 KeywordLibrary FastReport Select * from rpt.KeywordLibrary where 1=2 LeaveRequest LeaveRequest_id,System.Int32 PayeeNo,System.Int32 CandidateNo,System.Int32 FirstName,System.String MiddleName,System.String SurName,System.String StartDate_date,System.DateTime EndDate_date,System.DateTime AbsenceTypeName,System.String Status,System.String UserCreated,System.String YearEntitled,System.Int32 AutoApproved_flag,System.Boolean 900 LeaveRequest FastReport Select * from rpt.LeaveRequest where 1=2 LeaveRequestCommentHistory LeaveRequestComment_id,System.Int32 LeaveRequest_id,System.Int32 Comment,System.String DateCreated_datetime,System.DateTime UserCreated,System.String 900 LeaveRequestCommentHistory FastReport Select * from rpt.LeaveRequestCommentHistory where 1=2 LeaveRequestStatusHistory LeaveRequestStatus_id,System.Int32 LeaveRequest_id,System.Int32 Status_no,System.String DateCreated_datetime,System.DateTime 900 LeaveRequestStatusHistory FastReport Select * from rpt.LeaveRequestStatusHistory where 1=2 LeaveRequestTimes LeaveRequestTime_id,System.Int32 LeaveRequest_id,System.Int32 LeaveRequestDate_date,System.DateTime StartTime_time,System.TimeSpan EndTime_time,System.TimeSpan Status_no,System.String 900 LeaveRequestTimes FastReport Select * from rpt.LeaveRequestTimes where 1=2 MarginAnalysis PayResult_id,System.Int32 BillResult_id,System.Int32 PayBatchID,System.Int32 InvoiceId,System.Int32 OfficeCode,System.Int32 OfficeName,System.String JobOrderNo,System.Int32 PONumber,System.String OwnedByStaff,System.String FilledByStaff,System.String CreatedByStaff,System.String ClientNo,System.Int32 ClientName,System.String CandidateId,System.Int32 CandidateName,System.String PeriodEndDate,System.DateTime AdjustmentPeriodEndDate,System.DateTime PaymentDate,System.DateTime InvoiceDate,System.DateTime ProjectCode,System.String ItemDate,System.DateTime PayItemName,System.String PayQuantity,System.Decimal PayRate,System.Decimal PayTotal,System.Decimal BillItemName,System.String BillQuantity,System.Decimal BillRate,System.Decimal BillTotal,System.Decimal PayOncostTotal,System.Decimal BillOncostTotal,System.Decimal Margin_x0024_,System.Decimal MarginPcnt,System.Decimal 900 MarginAnalysis FastReport Select * from rpt.MarginAnalysis where 1=2 Office OfficeId,System.Int32 CountryId,System.Int32 RegionId,System.Int32 BrandId,System.Int32 StateId,System.Int32 OfficeName,System.String OfficeCode,System.Int16 Description,System.String Status,System.String ExportCode,System.String AccountSegment,System.String ImportCode,System.String AddressLineOne,System.String AddressLineTwo,System.String City,System.String Suburb,System.String State,System.String Postcode,System.String Phone,System.String Email,System.String Fax,System.String 900 Office FastReport Select * from rpt.Office where 1=2 OnCostResult PayBillResult_id,System.Int32 OncostRate_id,System.Int32 OncostType,System.String OncostName,System.String OncostValue,System.Decimal 900 OnCostResult FastReport Select * from rpt.OnCostResult where 1=2 Parent ParentCompanyId,System.Int32 ParentName,System.String ParentType,System.String ABN,System.String Industry,System.String BHPhoneNo,System.String Fax,System.String ParentOwnerId,System.Int32 ParentOwner,System.String OfficeCode,System.String Status,System.String InActiveReason,System.String ParentCompanyProfile,System.String ParentCompanyNotes,System.String MainAddress1,System.String MainAddress2,System.String MainAddressCity,System.String MainAddressSuburb,System.String MainAddressState,System.String MainAddressPostcode,System.String MainAddressCountry,System.String MailingAddress1,System.String MailingAddress2,System.String MailingCity,System.String MailingSuburb,System.String MailingAddressState,System.String MailingAddressCountry,System.String MailingPostcode,System.String CreationDate,System.DateTime LastUpdateDate,System.DateTime CreatedBy,System.String LastUpdateBy,System.String AlternateNumber,System.String MigrationId,System.String 900 Parent FastReport Select * from rpt.Parent where 1=2 ParentCustomFields CustomFieldId,System.Int32 ParentId,System.Int32 CustomField,System.String CustomFieldValue,System.String 900 ParentCustomFields FastReport Select * from rpt.ParentCustomFields where 1=2 ParentDocuments AttachFileId,System.Int32 ParentCompanyId,System.Int32 FileName,System.String FolderName,System.String AttachedDate,System.DateTime AttachedTime,System.String AttachedBy,System.String AttachedByUserType,System.String Comment,System.String DisplayInPortal,System.String 900 ParentDocuments FastReport Select * from rpt.ParentDocuments where 1=2 PayBatch GrossWageBatch_id,System.Int32 StartDate_datetime,System.DateTime FinishDate_datetime,System.DateTime Status_no,System.String Stage_no,System.String UserStarted,System.String UserFinished,System.String OnlyIncludePayeesWithTimesheets_flag,System.Boolean PayPeriod_id,System.Int32 OnlyIncludeTimesheetsWithWeekendingDateLessThanPayPeriod_flag,System.Boolean AdjustmentPayPeriod_id,System.Int32 PaymentDate_date,System.DateTime IsBalancingPayment,System.Boolean UserModified,System.String PayPeriodStartDate,System.DateTime PayPeriodEndDate,System.DateTime PayGroupName,System.String IsAdjustmentBatch,System.Boolean 900 PayBatch FastReport Select * from rpt.PayBatch where 1=2 PayBatchHistoryEmployeeBenefits EmployeeBenefitTransactionId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeHistoryId,System.Int32 PayeeIdentifier,System.Int32 OfficeCode,System.Int16 JobOrderId,System.Int32 EmployeeBenefitSchemeAdministrator,System.String EmployeeBenefitSchemeAdministratorId,System.Int32 EmployeeBenefitTypeId,System.Int32 EmployeeBenefitTypeName,System.String AgreementId,System.Int32 TransactionType,System.String ContributionDate,System.DateTime EmployeeBenefitPeriodId,System.Int32 Amount,System.Decimal 900 PayBatchHistoryEmployeeBenefits FastReport Select * from rpt.PayBatchHistoryEmployeeBenefits where 1=2 PayBatchHistoryEmployerACCLevy EmployerAccLevyTransactionId,System.Int32 GrossWageBatchId,System.Int32 PayeeIdentifier,System.Int32 GrossWageBatchPayeeHistoryId,System.Int32 JobOrderId,System.Int32 OfficeCode,System.Int32 LiableEarnings,System.Decimal Amount,System.Decimal 900 PayBatchHistoryEmployerACCLevy FastReport Select * from rpt.PayBatchHistoryEmployerACCLevy where 1=2 PayBatchHistoryItemOnCosts GrossWageBatchItem_History_id,System.Int32 OnCostHeaderName,System.String OnCostRateName,System.String OncostValue,System.Decimal Type,System.String 900 PayBatchHistoryItemOnCosts FastReport Select * from rpt.PayBatchHistoryItemOnCosts where 1=2 PayBatchHistoryItems GrossWageBatchItem_History_id,System.Int32 GrossWageBatchPayee_History_id,System.Int32 JobOrder_id,System.Int32 OfficeCode,System.Int32 Client_id,System.Int32 ClientName,System.String ItemType,System.String PayCodeName,System.String ItemDate_date,System.DateTime Quantity,System.Decimal Rate,System.Decimal Total,System.Decimal ProjectCode,System.String PayoutType,System.String YearEntitled,System.Int32 LeaveDeductionRule_id,System.Int32 Taxable_flag,System.Boolean GST,System.Decimal LumpSumType,System.String ReimbursementNet,System.Decimal EtpType,System.String IsReimbursement,System.Boolean PayResult_id,System.Int32 900 PayBatchHistoryItems FastReport Select * from rpt.PayBatchHistoryItems where 1=2 PayBatchHistoryKiwiSaver KiwiSaverTransactionId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeHistoryId,System.Int32 PayeeIdentifier,System.Int32 OfficeCode,System.Int16 JobOrderId,System.Int32 TransactionType,System.String Username,System.String Amount,System.Decimal ESCT,System.Decimal 900 PayBatchHistoryKiwiSaver FastReport Select * from rpt.PayBatchHistoryKiwiSaver where 1=2 PayBatchHistoryPayeeDeductions GrossWageBatchPayeeDeduction_History_id,System.Int32 GrossWageBatchPayee_History_id,System.Int32 DeductionRule_id,System.Int32 Amount,System.Decimal AppliedInFull_flag,System.Boolean GST,System.Decimal TransactionType,System.String SuperFundId,System.Int32 SuperFundName,System.String RESC,System.Boolean PayeeAccountReference,System.String DeductionHeader_id,System.Int32 DeductionName,System.String ApplyTo,System.String 900 PayBatchHistoryPayeeDeductions FastReport Select * from rpt.PayBatchHistoryPayeeDeductions where 1=2 PayBatchHistoryPayees GrossWageBatch_id,System.Int32 PayeeNo,System.Int32 GrossWageBatchPayee_History_id,System.Int32 PaymentMethod_no,System.String 900 PayBatchHistoryPayees FastReport Select * from rpt.PayBatchHistoryPayees where 1=2 PayBatchHistoryPayeeTax GrossWageBatchPayeeTax_History_id,System.Int32 GrossWageBatchPayee_History_id,System.Int32 TaxType,System.String TaxTotal,System.Decimal TaxableTotal,System.Decimal EtpType,System.String TaxCalculationMethod,System.String 900 PayBatchHistoryPayeeTax FastReport Select * from rpt.PayBatchHistoryPayeeTax where 1=2 PayBatchHistoryPayeeTerminatinEtp GrossWageBatchPayeeTerminationEtpId,System.Int32 GrossWageBatchPayeeHistory_id,System.Int32 EtpType,System.String LumpSumDNonTaxableAmount,System.Decimal LumpSumDNonTaxablePayCodeId,System.Int32 LumpSumDTaxableAmount,System.Decimal LumpSumDTaxableTaxType,System.String LumpSumDTaxableTax,System.Decimal LumpSumDTaxablePayCodeId,System.Int32 PaymentSummaryEtpId,System.Int32 ETPNonTaxableAmount,System.Decimal ETPNonTaxablePayCodeId,System.Int32 900 PayBatchHistoryPayeeTerminatinEtp FastReport Select * from rpt.PayBatchHistoryPayeeTerminatinEtp where 1=2 PayBatchHistoryPayeeTerminationAU GrossWageBatchPayeeHistory_id,System.Int32 TerminationDate,System.DateTime TerminationReason,System.String LumpSumATerminationType,System.String LumpSumBTax,System.Decimal 900 PayBatchHistoryPayeeTerminationAU FastReport Select * from rpt.PayBatchHistoryPayeeTerminationAU where 1=2 PayBatchHistoryPayeeTerminationNZ GrossWageBatchPayeeHistory_id,System.Int32 TaxableRetirementRedundancyLumpSum,System.Decimal TaxableRetirementRedundancyLumpSumPayCodeName,System.String OtherTaxableLumpSum,System.Decimal OtherTaxableLumpSumPayCodeName,System.String IsTaxAtLowestRate,System.Boolean TerminationReason,System.String TerminationDate,System.DateTime 900 PayBatchHistoryPayeeTerminationNZ FastReport Select * from rpt.PayBatchHistoryPayeeTerminationNZ where 1=2 PayBatchHistoryPayrollTax PayrollTaxTransactionId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeHistoryId,System.Int32 PayeeIdentifier,System.Int32 State,System.String OfficeCode,System.Int16 JobOrderId,System.Int32 TransactionType,System.String Amount,System.Decimal 900 PayBatchHistoryPayrollTax FastReport Select * from rpt.PayBatchHistoryPayrollTax where 1=2 PayBatchHistorySummary GrossWageBatchId,System.Int32 PayGroupName,System.String PayFrequency,System.String CountryName,System.String PayeeNo,System.Int32 CandidateId,System.Int32 FirstName,System.String Surname,System.String DateOfBirth,System.DateTime EmailOne,System.String EmailTwo,System.String MobilePhone,System.String BHPhone,System.String AHPhone,System.String AddressLineOne,System.String AddressLineTwo,System.String City,System.String Suburb,System.String PostCode,System.String StateName,System.String Expr1,System.String PayCompanyId,System.Int32 PayCompanyName,System.String EmployementType,System.String EmploymentStartDate,System.DateTime EmploymentEndDate,System.DateTime TaxType,System.String TaxFileNo,System.String ItemType,System.String OfficeCode,System.Int32 OfficeName,System.String JobOrderId,System.Int32 ClientId,System.Int32 ClientName,System.String DateType,System.String ItemDate,System.DateTime ItemName,System.String Quantity,System.Decimal Rate,System.Decimal Amount,System.Decimal ContributionStartDate,System.DateTime ContributionEndDate,System.DateTime ContributionName,System.String TimesheetId,System.Int32 ProjectCode,System.String IsTaxable,System.Boolean Expr2,System.String TaxAmount,System.Decimal 900 PayBatchHistorySummary FastReport Select * from rpt.PayBatchHistorySummary where 1=2 PayBatchHistorySuper SuperTransactionId,System.Int32 PayBatchId,System.Int32 GrossWageBatchPayeeHistoryId,System.Int32 OfficeCode,System.Int16 JobOrderId,System.Int32 SuperFundName,System.String TransactionType,System.String ContributionDate,System.DateTime ContributionPeriodStartDate,System.DateTime ContributionPeriodEndDate,System.DateTime ContributionPeriodName,System.String ContributionAmount,System.Decimal ContributionBasis,System.String 900 PayBatchHistorySuper FastReport Select * from rpt.PayBatchHistorySuper where 1=2 PayBatchHistorySuperContributions GrossWageBatchPayee_History_id,System.Int32 GrossWageBatch_id,System.Int32 PayCompanyName,System.String Surname,System.String FirstName,System.String PayeeNo,System.Int32 Salutation,System.String Address1,System.String Address2,System.String Suburb,System.String State,System.String PostCode,System.String Email,System.String DateOfBirth,System.DateTime HomePhone,System.String WorkPhone,System.String MobilePhone,System.String Fax,System.String EmploymentStartDate,System.DateTime EmploymentEndDate,System.DateTime TFNNumber,System.String Remuneration,System.Decimal TaxTypeNo,System.String PayPeriodEndDate,System.DateTime FundName,System.String SPIN,System.String SuperGuarnteeAmount,System.Decimal EmployerAdditionalSuper,System.Decimal SalarySacrificeSuper,System.Decimal PayeeSuper,System.Decimal 900 PayBatchHistorySuperContributions FastReport Select * from rpt.PayBatchHistorySuperContributions where 1=2 PayBatchHistoryWorkCover WorkCoverTransactionId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeHistoryId,System.Int32 PayeeIdentifier,System.Int32 State,System.String OfficeCode,System.Int16 JobOrderId,System.Int32 TransactionType,System.String Amount,System.Decimal 900 PayBatchHistoryWorkCover FastReport Select * from rpt.PayBatchHistoryWorkCover where 1=2 PayBatchInProgressEmployeeBenefits EmployeeBenefitTransactionGrossWageBatchId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeId,System.Int32 PayeeIdentifier,System.Int32 OfficeCode,System.Int16 JobOrderId,System.Int32 EmployeeBenefitSchemeAdministrator,System.String EmployeeBenefitTypeName,System.String TransactionType,System.String ContributionDate,System.DateTime Amount,System.Decimal 900 PayBatchInProgressEmployeeBenefits FastReport Select * from rpt.PayBatchInProgressEmployeeBenefits where 1=2 PayBatchInProgressEmployerACCLevy EmployerAccLevyTransactionGrossWageBatchId,System.Int32 GrossWageBatchId,System.Int32 PayeeIdentifier,System.Int32 GrossWageBatchPayeeId,System.Int32 JobOrderId,System.Int32 OfficeCode,System.Int32 LiableEarnings,System.Decimal Amount,System.Decimal 900 PayBatchInProgressEmployerACCLevy FastReport Select * from rpt.PayBatchInProgressEmployerACCLevy where 1=2 PayBatchInProgressItemOnCosts GrossWageBatchItem_id,System.Int32 OnCostHeaderName,System.String OnCostRateName,System.String OncostValue,System.Decimal Type,System.String 900 PayBatchInProgressItemOnCosts FastReport Select * from rpt.PayBatchInProgressItemOnCosts where 1=2 PayBatchInProgressItems GrossWageBatchItem_id,System.Int32 GrossWageBatchPayee_id,System.Int32 Timesheet_id,System.Int32 JobOrder_id,System.Int32 OfficeCode,System.Int32 Client_id,System.Int32 ClientName,System.String ItemType,System.String PayCode_id,System.Int32 PayCodeName,System.String ItemDate_date,System.DateTime Quantity,System.Decimal Rate,System.Decimal Total,System.Decimal ProjectCode,System.String PayoutType,System.String YearEntitled,System.Int32 Taxable_flag,System.Boolean GST,System.Decimal LumpSumType,System.String ReimbursementNet,System.Decimal EtpType,System.String IsReimbursement,System.Boolean PayResult_id,System.Int32 900 PayBatchInProgressItems FastReport Select * from rpt.PayBatchInProgressItems where 1=2 PayBatchInProgressKiwiSaver KiwiSaverTransactionGrossWageBatchId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeId,System.Int32 OfficeCode,System.Int16 JobOrderId,System.Int32 TransactionType,System.String Amount,System.Decimal ESCT,System.Decimal Username,System.String 900 PayBatchInProgressKiwiSaver FastReport Select * from rpt.PayBatchInProgressKiwiSaver where 1=2 PayBatchInProgressPayeeDeductions GrossWageBatchPayeeDeduction_id,System.Int32 GrossWageBatchPayee_id,System.Int32 DeductionRule_id,System.Int32 Amount,System.Decimal AppliedInFull_flag,System.Boolean GST,System.Decimal TransactionType,System.String SuperFundId,System.Int32 SuperFundName,System.String RESC,System.Boolean PayeeAccountReference,System.String DeductionHeader_id,System.Int32 DeductionName,System.String ApplyTo,System.String 900 PayBatchInProgressPayeeDeductions FastReport Select * from rpt.PayBatchInProgressPayeeDeductions where 1=2 PayBatchInProgressPayees GrossWageBatch_id,System.Int32 GrossWageBatchPayee_id,System.Int32 PaymentMethod,System.String 900 PayBatchInProgressPayees FastReport Select * from rpt.PayBatchInProgressPayees where 1=2 PayBatchInProgressPayeeTax GrossWageBatchPayeeTax_id,System.Int32 GrossWageBatchPayee_id,System.Int32 TaxType,System.String TaxTotal,System.Decimal EtpType,System.String TaxCalculationMethod,System.String 900 PayBatchInProgressPayeeTax FastReport Select * from rpt.PayBatchInProgressPayeeTax where 1=2 PayBatchInProgressPayeeTerminatinEtp GrossWageBatchPayeeTerminationEtpId,System.Int32 GrossWageBatchPayeeId,System.Int32 EtpType,System.String LumpSumDNonTaxableAmount,System.Decimal LumpSumDNonTaxablePayCodeId,System.Int32 LumpSumDTaxableAmount,System.Decimal LumpSumDTaxableTaxType,System.String LumpSumDTaxableTax,System.Decimal LumpSumDTaxablePayCodeId,System.Int32 PaymentSummaryEtpId,System.Int32 ETPNonTaxableAmount,System.Decimal ETPNonTaxablePayCodeId,System.Int32 900 PayBatchInProgressPayeeTerminatinEtp FastReport Select * from rpt.PayBatchInProgressPayeeTerminatinEtp where 1=2 PayBatchInProgressPayeeTerminationAU GrossWageBatchPayeeId,System.Int32 TerminationDate,System.DateTime TerminationReason,System.String LumpSumATerminationType,System.String LumpSumBTax,System.Decimal 900 PayBatchInProgressPayeeTerminationAU FastReport Select * from rpt.PayBatchInProgressPayeeTerminationAU where 1=2 PayBatchInProgressPayeeTerminationNZ GrossWageBatchPayeeId,System.Int32 TerminationDate,System.DateTime TerminationReasonId,System.Int32 TaxableRetirementRedundancyLumpSum,System.Decimal TaxableRetirementRedundancyLumpSumPayCodeId,System.Int32 TaxableRetirementRedundancyLumpSumPayCodeName,System.String OtherTaxableLumpSum,System.Decimal OtherTaxableLumpSumPayCodeId,System.Int32 OtherTaxableLumpSumPayCodeName,System.String IsTaxAtLowestRate,System.Boolean 900 PayBatchInProgressPayeeTerminationNZ FastReport Select * from rpt.PayBatchInProgressPayeeTerminationNZ where 1=2 PayBatchInProgressPayrollTax PayrollTaxTransactionGrossWageBatchId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeId,System.Int32 PayeeIdentifier,System.Int32 State,System.String OfficeCode,System.Int16 JobOrderId,System.Int32 TransactionType,System.String Amount,System.Decimal 900 PayBatchInProgressPayrollTax FastReport Select * from rpt.PayBatchInProgressPayrollTax where 1=2 PayBatchInProgressSummary GrossWageBatchId,System.Int32 PayGroupName,System.String PayFrequency,System.String CountryName,System.String PayeeNo,System.Int32 CandidateId,System.Int32 FirstName,System.String Surname,System.String DateOfBirth,System.DateTime EmailOne,System.String EmailTwo,System.String MobilePhone,System.String BHPhone,System.String AHPhone,System.String AddressLineOne,System.String AddressLineTwo,System.String City,System.String Suburb,System.String PostCode,System.String StateName,System.String Expr1,System.String PayCompanyId,System.Int32 PayCompanyName,System.String EmployementType,System.String EmploymentStartDate,System.DateTime EmploymentEndDate,System.DateTime TaxType,System.String TaxFileNo,System.String ItemType,System.String OfficeCode,System.Int32 OfficeName,System.String JobOrderId,System.Int32 ClientId,System.Int32 ClientName,System.String DateType,System.String ItemDate,System.DateTime ItemName,System.String Quantity,System.Decimal Rate,System.Decimal Amount,System.Decimal ContributionStartDate,System.DateTime ContributionEndDate,System.DateTime ContributionName,System.String TimesheetId,System.Int32 ProjectCode,System.String IsTaxable,System.Boolean Expr2,System.String TaxAmount,System.Decimal 900 PayBatchInProgressSummary FastReport Select * from rpt.PayBatchInProgressSummary where 1=2 PayBatchInProgressSuper SuperTransactionGrossWageBatchId,System.Int32 PayBatchId,System.Int32 GrossWageBatchPayeeId,System.Int32 PayeeIdentifier,System.Int32 OfficeCode,System.Int16 JobOrderId,System.Int32 SuperFundId,System.Int32 SuperFundName,System.String AgreementId,System.Int32 TransactionType,System.String ContributionDate,System.DateTime ContributionPeriodStartDate,System.DateTime ContributionPeriodEndDate,System.DateTime ContributionPeriodName,System.String ContributionAmount,System.Decimal Username,System.String ContributionBasis,System.String 900 PayBatchInProgressSuper FastReport Select * from rpt.PayBatchInProgressSuper where 1=2 PayBatchInProgressSuperContributions GrossWageBatchPayee_id,System.Int32 GrossWageBatch_id,System.Int32 PayCompanyName,System.String Surname,System.String FirstName,System.String PayeeNo,System.Int32 Salutation,System.String Address1,System.String Address2,System.String Suburb,System.String State,System.String PostCode,System.String Email,System.String DateOfBirth,System.DateTime HomePhone,System.String WorkPhone,System.String MobilePhone,System.String Fax,System.String EmploymentStartDate,System.DateTime EmploymentEndDate,System.DateTime TFNNumber,System.String Remuneration,System.Decimal TaxTypeNo,System.String PayPeriodEndDate,System.DateTime FundName,System.String SPIN,System.String SuperGuarnteeAmount,System.Decimal EmployerAdditionalSuper,System.Decimal SalarySacrificeSuper,System.Decimal PayeeSuper,System.Decimal 900 PayBatchInProgressSuperContributions FastReport Select * from rpt.PayBatchInProgressSuperContributions where 1=2 PayBatchInProgressWorkCover WorkCoverTransactionGrossWageBatchId,System.Int32 GrossWageBatchId,System.Int32 GrossWageBatchPayeeId,System.Int32 PayeeIdentifier,System.Int32 StateNo,System.String OfficeCode,System.Int16 JobOrderId,System.Int32 TransactionType,System.String Amount,System.Decimal BaseAmount,System.Decimal 900 PayBatchInProgressWorkCover FastReport Select * from rpt.PayBatchInProgressWorkCover where 1=2 PayCodes PayCode_id,System.Int32 Name,System.String UnitType,System.String PayCodeType,System.String Disabled_flag,System.Boolean ExportCode,System.String ImportCode,System.String Country_id,System.Int32 SortOrder,System.Int32 PLExportAccount,System.String 900 PayCodes FastReport Select * from rpt.PayCodes where 1=2 PayeeAssignedConditionalVariables PayeeValidityId,System.Int32 PayeeConditionalVariableType_id,System.Int32 PayeeConditionalVariableTypeName,System.String PayeeConditionalVariable_id,System.Int32 PayeeConditionalVariableValue,System.String 900 PayeeAssignedConditionalVariables FastReport Select * from rpt.PayeeAssignedConditionalVariables where 1=2 PayeeAssignedSuperanuationFunds PayeeValidityId,System.Int32 PayeePayrollSuperId,System.Int32 Type,System.String SuperFundId,System.Int32 SuperFundName,System.String PolicyNumber,System.String IsAgreementDefault,System.Boolean RegistrationDate,System.DateTime ContributionRateRuleName,System.String ContributionRateRuleStatus,System.String WeekendingDay,System.String RESC,System.Boolean IsMinimumMonthlyThresholdExempt,System.Boolean IsMaximumQuarterlyThresholdExempt,System.Boolean 900 PayeeAssignedSuperanuationFunds FastReport Select * from rpt.PayeeAssignedSuperanuationFunds where 1=2 PayeeCustomFields PayeeValidityId,System.Int32 CustomFieldName,System.String CustomFieldValue,System.String 900 PayeeCustomFields FastReport Select * from rpt.PayeeCustomFields where 1=2 PayeeEmployeeBenefits PayeeValidityId,System.Int32 PayeePayrollEmployeeBenefitId,System.Int32 PayeePayrollId,System.Int32 EmployeeBenefitSchemeAdministratorId,System.Int32 EmployeeBenefitSchemeAdministratorName,System.String EmployeeBenefitTypeId,System.Int32 EmployeeBenefitName,System.String MemberNumber,System.String 900 PayeeEmployeeBenefits FastReport Select * from rpt.PayeeEmployeeBenefits where 1=2 PayeeHeader PayeeHeader_id,System.Int32 Candidate_id,System.Int32 PayeeNo,System.Int32 EmploymentStartDate,System.DateTime EmploymentEndDate,System.DateTime IsTerminated,System.Boolean TerminationGrossWageBatchId,System.Int32 TerminatedReason,System.String UserModified,System.String PayeeTypeAus,System.String TaxTypeNZ,System.String PayCompanyName,System.String 900 PayeeHeader FastReport Select * from rpt.PayeeHeader where 1=2 PayeeHeaderAllowances PayeeAllowance_id,System.Int32 PayeeNo,System.Int32 ValidityStart_date,System.DateTime ValidityEnd_date,System.DateTime PayCode_id,System.Int32 PayCodeName,System.String AllowanceValue,System.Decimal 900 PayeeHeaderAllowances FastReport Select * from rpt.PayeeHeaderAllowances where 1=2 PayeeHeaderAttachments PayeeHeaderId,System.Int32 FileName,System.String Attachment,System.Byte[] 900 PayeeHeaderAttachments FastReport Select * from rpt.PayeeHeaderAttachments where 1=2 PayeeHeaderBankAccounts PayeeBankAccount_id,System.Int32 PayeeNo,System.Int32 AccountName,System.String Description,System.String BranchNumber,System.String AccountNumber,System.String Reference,System.String EFTIndicator_flag,System.Boolean Sequence,System.Int32 SplitType,System.String SplitValue,System.Decimal Default_flag,System.Boolean 900 PayeeHeaderBankAccounts FastReport Select * from rpt.PayeeHeaderBankAccounts where 1=2 PayeeHeaderDeductions PayeeNo,System.Int32 DeductionRule_id,System.Int32 DeductionHeader_id,System.Int32 DeductionName,System.String Start_date,System.DateTime End_date,System.DateTime Type,System.String CalculationBase,System.String ApplyTo,System.String Value,System.Decimal Rolling_flag,System.Boolean RollingTotalAmount,System.Decimal RollingOutstandingAmount,System.Decimal NetProtected_flag,System.Boolean NetProtectedType,System.String NetProtectedValue,System.Decimal RESC,System.Boolean PayeeAccountReference,System.String SuperFundName,System.String 900 PayeeHeaderDeductions FastReport Select * from rpt.PayeeHeaderDeductions where 1=2 PayeeKiwiSaverOptInDates PayeeValidityId,System.Int32 OptInDate,System.DateTime OptOutDate,System.DateTime IsOptOutSigned,System.Boolean 900 PayeeKiwiSaverOptInDates FastReport Select * from rpt.PayeeKiwiSaverOptInDates where 1=2 PayeeValidity PayeeValidityId,System.Int32 PayeeNo,System.Int32 PayeeHeader_id,System.Int32 Candidate_id,System.Int32 ValidityStartDate,System.DateTime ValidityEndDate,System.DateTime EmploymentTypeName,System.String ReviewDate_date,System.DateTime PayGroupName,System.String ExportCode,System.String MonthlyPay,System.Decimal MonthlyHours,System.Decimal FullTimeEquivalent,System.Decimal DateCreated_datetime,System.DateTime DateModified_datetime,System.DateTime UserCreated,System.String UserModified,System.String HourlyPay,System.Decimal Schedule_id,System.Int32 ExtraHourlyPay,System.Decimal FixedSalaryHours,System.Decimal MigrationId,System.String PayeeRateType,System.String PaymentMethod,System.String PaymentSummaryDeliveryMethod,System.String PayslipDeliveryMethod,System.String EnquiryOfficeCode,System.Int16 TotalRebates,System.Decimal MedicareLevyAdjustment_flag,System.Boolean Dependents,System.Int32 TFNNumber,System.String NoTFNReason,System.String BasisOfPayment,System.String AustralianResident_flag,System.Boolean SeniorAustralianTaxOffset_flag,System.Boolean ZoneDependentSpecialRebates_flag,System.Boolean TFNDeclarationDateSigned_flag,System.Boolean TFNDeclarationReceived_date,System.DateTime CompanyName,System.String TradingName,System.String Insurance_flag,System.Boolean ABN,System.String GSTRegistered_flag,System.Boolean HELP_flag,System.Boolean SFSS_flag,System.Boolean Levy_flag,System.Boolean VoluntaryAgreement_flag,System.Boolean FlatRateCIRValue,System.Decimal IsExemptFromSuper,System.Boolean TFNReported,System.Boolean WithholdingVariationPercentage,System.Decimal TFNReportedDate,System.DateTime InsurancePolicyExpiryDate,System.DateTime NoTFNProvided,System.Boolean ExemptFromNoTFN28DayRule,System.Boolean IRDNumber,System.String SDR_flag,System.Boolean FlatSL,System.Decimal FlatTaxRate,System.Decimal GSTNumber,System.String KiwiSaverEmployerRateName,System.String ContinueEmployerContribution,System.Boolean IsSchedularPayments,System.Boolean TaxScaleName,System.String ContractName,System.String CountryName,System.String 900 PayeeValidity FastReport Select * from rpt.PayeeValidity where 1=2 PayeeWorkSchedule PayeeWorkSchedule_id,System.Int32 PayeeValidityId,System.Int32 DayOfWeek,System.String Start_time,System.TimeSpan End_time,System.TimeSpan BreakStart_time,System.TimeSpan BreakEnd_time,System.TimeSpan 900 PayeeWorkSchedule FastReport Select * from rpt.PayeeWorkSchedule where 1=2 Region RegionId,System.Int32 CountryId,System.Int32 Name,System.String Description,System.String AccountSegment,System.String ExportCode,System.String ImportCode,System.String Status,System.String 900 Region FastReport Select * from rpt.Region where 1=2 Role SecurityRoleId,System.Int32 SecurityRoleName,System.String UserType,System.String Status,System.String 900 Role FastReport Select * from rpt.Role where 1=2 RolePermissions SecurityRolePermissionId,System.Int32 SecurityRoleId,System.Int32 RoleName,System.String Application,System.String Module,System.String PermissionItemName,System.String FullControl,System.String Add,System.String Edit,System.String View,System.String 900 RolePermissions FastReport Select * from rpt.RolePermissions where 1=2 TimesheetAttachments AttachmentItem_id,System.Int32 TimesheetHeader_id,System.Int32 FileName,System.String Attachment,System.Byte[] 900 TimesheetAttachments FastReport Select * from rpt.TimesheetAttachments where 1=2 TimesheetAttendanceAbsenceItems TimesheetAttendanceAbsenceItem_Id,System.Int32 ItemType,System.String TimesheetHeader_id,System.Int32 Start_date,System.DateTime Start_time,System.TimeSpan End_time,System.TimeSpan ItemName,System.String 900 TimesheetAttendanceAbsenceItems FastReport Select * from rpt.TimesheetAttendanceAbsenceItems where 1=2 TimesheetHeader TimesheetHeader_id,System.Int32 JobOrder_id,System.Int32 OfficeCode,System.Int16 Start_date,System.DateTime End_date,System.DateTime Mode,System.String LastUpdateUser,System.String LastUpdate_datetime,System.DateTime InitiatorUser,System.String Initiated_datetime,System.DateTime PayeeNo,System.Int32 TotalAttendanceHours,System.Decimal TotalAbsenceHours,System.Decimal AdditionalItemsQuantity,System.Decimal TotalReimbursements,System.Decimal HasAttachments,System.Boolean CreditNoteReason,System.String 900 TimesheetHeader FastReport Select * from rpt.TimesheetHeader where 1=2 TimesheetItemBreaks BreakItem_id,System.Int32 TimesheetAttendanceAbsenceItem_Id,System.Int32 StartDate,System.DateTime StartTime,System.TimeSpan EndTime,System.TimeSpan Type,System.String 900 TimesheetItemBreaks FastReport Select * from rpt.TimesheetItemBreaks where 1=2 TimesheetItemProjects ProjectItem_id,System.Int32 TimesheetAttendanceItem_Id,System.Int32 Start_date,System.DateTime Start_time,System.TimeSpan End_time,System.TimeSpan ProjectCodeText,System.String 900 TimesheetItemProjects FastReport Select * from rpt.TimesheetItemProjects where 1=2 TimesheetManualItems TimesheetManualItems_id,System.Int32 TimesheetHeader_id,System.Int32 Item_date,System.DateTime Quantity,System.Decimal Rate,System.Decimal ProjectCodeText,System.String ManualItemType,System.String Net,System.Decimal Tax,System.Decimal PayCodeType,System.String PayCodeName,System.String 900 TimesheetManualItems FastReport Select * from rpt.TimesheetManualItems where 1=2 UserCustomFields CustomFieldId,System.Int32 UserId,System.Int32 CustomField,System.String CustomFieldValue,System.String 900 UserCustomFields FastReport Select * from rpt.UserCustomFields where 1=2 Users UserId,System.Int32 UserType,System.String FirstName,System.String MiddleName,System.String Surname,System.String Salutation,System.String Position,System.String AgencyType,System.String DateOfBirth,System.DateTime MaritalStatus,System.String Gender,System.String Office,System.String Status,System.String UserManager,System.Int32 UserName,System.String Language,System.String LastLoginDate,System.DateTime LoginBlocked,System.String SecurityQuestion,System.String PageScrollOption,System.String PhoneBH,System.String Mobile,System.String PhoneAH,System.String Fax,System.String EmailOne,System.String EmailTwo,System.String EmergencyContactName,System.String EmergencyPhone,System.String Relationship,System.String AddressLine1,System.String AddressLine2,System.String City,System.String Suburb,System.String State,System.String Postcode,System.String JobBoardUserName,System.String EmailSignature,System.String SMSSignature,System.String DefaultSkillGroup,System.String DefaultPositionType,System.String DefaultCountry,System.String DefaultBrand,System.String DefaultRegion,System.String DefaultOffice,System.String ImportCode,System.String ExportCode,System.String AccountSegment,System.String AlternateNo,System.String CreationDate,System.DateTime CreatedBy,System.String LastUpdateDate,System.DateTime LastUpdateBy,System.String MigrationId,System.String 900 Users FastReport Select * from rpt.Users where 1=2 UserSecurity UserId,System.Int32 SecurityRoleId,System.Int32 User,System.String Role,System.String DataGroupId,System.Int32 DataGroup,System.String 900 UserSecurity FastReport Select * from rpt.UserSecurity where 1=2 DataSource1 Customer_Id,System.Int32 ClientName,System.String ClientPosition,System.String Candidate_Id,System.Int32 EmpName,System.String PayCode,System.String Units,System.Decimal Charge,System.Decimal DayFirstWorked,System.DateTime Weeks,System.Int32 30 DataSource1 CustomReport SELECT IH.Customer_Id , CL.ClientName , JO.ClientPosition , II.Candidate_Id , CA.EmpName , PAY.PayCode , sum(BR.Quantity) as Units , Sum(BR.Total) as Charge , CASE WHEN FW.FirstWorked IS NULL THEN CONVERT(DATETIME, '2000-01-01 00:00:00', 102) ELSE FW.FirstWorked END AS 'DayFirstWorked' , CASE WHEN DATEDIFF(ww,FW.FirstWorked,CONVERT(DATETIME, '2019-06-01 00:00:00', 102)) IS NULL THEN 999 ELSE DATEDIFF(ww,FW.FirstWorked,CONVERT(DATETIME, '2019-06-01 00:00:00', 102)) END AS 'Weeks' FROM rar.PayResult PR FULL JOIN rar.BillResult BR ON PR.BillResult_Id = BR.BillResult_Id LEFT JOIN (SELECT Candidate_Id, BillResult_id, Invoice_Id, ItemDate FROM DBO.InvoiceItem)II ON BR.BillResult_id = II.BillResult_id LEFT JOIN (SELECT Invoice_id, Invoice_Date, Customer_Id FROM dbo.InvoiceHeader) IH ON II.Invoice_Id = IH.Invoice_Id LEFT JOIN (SELECT ParentCompanyId, ClientId, ClientName FROM FO.Clients) CL on CL.ClientId = IH.Customer_Id LEFT JOIN (SELECT PayCode_Id, Name as PayCode, UnitType_no FROM rar.PayCode) PAY ON PR.PayCode_id = PAY.PayCode_id LEFT JOIN (SELECT BillCode_Id, UnitType_no,Name FROM rar.BillCode) Bill ON BR.BillCode_id = BILL.BillCode_id LEFT JOIN (SELECT TimesheetResult_Id, DayResults_Id FROM rar.DayResults) DR on PR.DayResults_Id=DR.DayResults_Id OR BR.DayResults_Id=DR.DayResults_Id LEFT JOIN (SELECT TimesheetResult_Id, JobOrder_Id FROM rar.TimesheetResult) TR on DR.TimesheetResult_Id=TR.TimesheetResult_Id LEFT JOIN (SELECT JobOrderId,ClientPosition FROM FO.JobOrders) JO on TR.JobOrder_Id=JO.JobOrderId LEFT JOIN (SELECT CandidateId, (SurName + ', ' + FirstName) EmpName FROM FO.Candidates) CA ON II.Candidate_Id = CA.CandidateID LEFT JOIN (SELECT CandidateId, ClientId, MIN(StartDate) FirstWorked FROM FO.JobOrders GROUP BY CandidateId ,ClientId) FW ON (II.Candidate_Id = FW.CandidateId AND IH.Customer_Id = FW.ClientId) and FW.CandidateId IS NOT NULL WHERE IH.Invoice_Date BETWEEN CONVERT(DATETIME, '2018-07-01 00:00:00', 102) AND CONVERT(DATETIME, '2019-06-01 00:00:00', 102) AND CL.ClientName LIKE 'ABC%' GROUP BY IH.Customer_Id, CL.ClientName, JO.ClientPosition, II.Candidate_Id, CA.EmpName, PAY.PayCode, FW.FirstWorked ORDER BY JO.ClientPosition, CA.EmpName, PAY.PayCode CandidateDiaryRelation CandidateId CandidateDiaryRelation CandidateDiaryRelation CandidateId CandidateResumeRelation CandidateId CandidateResumeRelation CandidateResumeRelation CandidateId CandidateSkillRelation CandidateId CandidateSkillRelation CandidateSkillRelation CandidateId CandidateUnavailabilityRelation CandidateId CandidateUnavailabilityRelation CandidateUnavailabilityRelation CandidateId CandidateWorkReferenceRelation CandidateId CandidateWorkReferenceRelation CandidateWorkReferenceRelation CandidateId CandidateClientContactRelation CandidateId CandidateClientContactRelation CandidateClientContactRelation CandidateId ClientCommentRelation ClientId ClientCommentRelation ClientCommentRelation ClientId ClientContactCustomFieldsRelation ClientContactId ClientContactCustomFieldsRelation ClientContactCustomFieldsRelation ClientContactId ClientCustomFieldsRelation ClientId ClientCustomFieldsRelation ClientCustomFieldsRelation ClientId ClientProjectCodesRelation ClientId ClientProjectCodesRelation ClientProjectCodesRelation ClientId CountryRegionRelation CountryId CountryRegionRelation CountryRegionRelation CountryId ClientActivityRelation ClientId ClientActivityRelation ClientActivityRelation ClientId ClientDocumentRelation ClientId ClientDocumentRelation ClientDocumentRelation ClientId CostCentreCustomRelation CostCentreId CostCentreCustomRelation CostCentreCustomRelation CostCentreId CostCentreCommentRelation CostCentreId CostCentreCommentRelation CostCentreCommentRelation CostCentreId CostCentreDocumentRelation CostCentreId CostCentreDocumentRelation CostCentreDocumentRelation CostCentreId CandidateCustomRelation CandidateId CandidateCustomRelation CandidateCustomRelation CandidateId CandidateCommentRelation CandidateId CandidateCommentRelation CandidateCommentRelation CandidateId CandidateActivitiesRelation CandidateId CandidateActivitiesRelation CandidateActivitiesRelation CandidateId CandidateDocumentsRelation CandidateId CandidateDocumentsRelation CandidateDocumentsRelation CandidateId CandidateOfficeRelation OfficeId CandidateOfficeRelation CandidateOfficeRelation OfficeId ClientContactLinkedClientsRelation ClientId ClientContactLinkedClientsRelation ClientContactLinkedClientsRelation ClientId ClientContactLinkedCostCentresRelation ClientId ClientContactLinkedCostCentresRelation ClientContactLinkedCostCentresRelation ClientId ClientContactCostCentresRelation CostCentreId ClientContactCostCentresRelation ClientContactCostCentresRelation CostCentreId CostCentreClientRelation ClientId CostCentreClientRelation CostCentreClientRelation ClientId CostCentreActivityRelation CostCentreId CostCentreActivityRelation CostCentreActivityRelation CostCentreId DataGroupEntityRelation DataGroupId DataGroupEntityRelation DataGroupEntityRelation DataGroupId JobOrderActivitiesRelation JobOrderId JobOrderActivitiesRelation JobOrderActivitiesRelation JobOrderId JobOrderCommentRelation JobOrderId JobOrderCommentRelation JobOrderCommentRelation JobOrderId JobOrderCustomFieldsRelation JobOrderId JobOrderCustomFieldsRelation JobOrderCustomFieldsRelation JobOrderId JobOrderDocumentsRelation JobOrderId JobOrderDocumentsRelation JobOrderDocumentsRelation JobOrderId JobOrderClientRelation ClientNo JobOrderClientRelation JobOrderClientRelation ClientId JobOrderCandidateRelation CandidateId JobOrderCandidateRelation JobOrderCandidateRelation CandidateId JobOrderServiceFeesRelation JobOrderId JobOrderServiceFeesRelation JobOrderServiceFeesRelation JobOrderId JobProjectCodesRelation JobOrderId JobProjectCodesRelation JobProjectCodesRelation JobOrderId JobSchedulRelation JobOrderId JobSchedulRelation JobSchedulRelation JobOrderId OfficeBrandRelation BrandId OfficeBrandRelation OfficeBrandRelation BrandId OfficeCountryRelation CountryId OfficeCountryRelation OfficeCountryRelation CountryId OfficeRegionRelation RegionId OfficeRegionRelation OfficeRegionRelation RegionId ParentDocumentsRelation ParentCompanyId ParentDocumentsRelation ParentDocumentsRelation ParentCompanyId RolePermissionsRelation SecurityRoleId RolePermissionsRelation RolePermissionsRelation SecurityRoleId UserCustomFieldsRelation UserId UserCustomFieldsRelation UserCustomFieldsRelation UserId UserSecurityDataGroupRelation DataGroupId UserSecurityDataGroupRelation UserSecurityDataGroupRelation DataGroupId ClientParentRelation ParentCompanyId ClientParentRelation ClientParentRelation ParentCompanyId JobOrderReferralRelation JobOrderId JobOrderReferralRelation JobOrderReferralRelation JobOrderId OfficeCandidateRelation OfficeId OfficeCandidateRelation OfficeCandidateRelation OfficeId DebtorBillingRulesDebtorRelation Debtor_id DebtorBillingRulesDebtorRelation DebtorBillingRulesDebtorRelation DebtorId DebtorBillingTaxRulesDebtorRelation Debtor_id DebtorBillingTaxRulesDebtorRelation DebtorBillingTaxRulesDebtorRelation DebtorId DebtorBillingDeliveryContactsRelation DebtorInvoiceLinkID DebtorBillingDeliveryContactsRelation DebtorBillingDeliveryContactsRelation DebtorInvoiceLink_id DebtorBillingInvoiceFeesRelation DebtorInvoiceLink_id DebtorBillingInvoiceFeesRelation DebtorBillingInvoiceFeesRelation DebtorInvoiceLink_id TimesheetAttachmentsHeaderRelation TimesheetHeader_id TimesheetAttachmentsHeaderRelation TimesheetAttachmentsHeaderRelation TimesheetHeader_id TimesheetHeaderAttendanceAbsenceRelation TimesheetHeader_id TimesheetHeaderAttendanceAbsenceRelation TimesheetHeaderAttendanceAbsenceRelation TimesheetHeader_id TimesheetAttendanceAbsenceItemBreaksRelation TimesheetAttendanceAbsenceItem_Id TimesheetAttendanceAbsenceItemBreaksRelation TimesheetAttendanceAbsenceItemBreaksRelation TimesheetAttendanceAbsenceItem_Id TimesheetAttendanceAbsenceItemProjectsRelation TimesheetAttendanceItem_Id TimesheetAttendanceAbsenceItemProjectsRelation TimesheetAttendanceAbsenceItemProjectsRelation TimesheetAttendanceAbsenceItem_Id TimesheetHeaderManualItemsRelation TimesheetHeader_id TimesheetHeaderManualItemsRelation TimesheetHeaderManualItemsRelation TimesheetHeader_id InterpretedBatchTimesheetRelation InterpretedBatch_id InterpretedBatchTimesheetRelation InterpretedBatchTimesheetRelation InterpretedBatch_id TimesheetHeaderInterpretedTimesheetRelation TimesheetHeader_id TimesheetHeaderInterpretedTimesheetRelation TimesheetHeaderInterpretedTimesheetRelation TimesheetHeader_id InterpretedTimesheetResultRelation TimesheetHeader_id InterpretedTimesheetResultRelation InterpretedTimesheetResultRelation TimesheetHeader_id PayeeHeaderAllowancesRelation PayeeNo PayeeHeaderAllowancesRelation PayeeHeaderAllowancesRelation PayeeNo PayeeHeaderAttachmentsRelation PayeeHeaderId PayeeHeaderAttachmentsRelation PayeeHeaderAttachmentsRelation PayeeHeader_id PayeeHeaderBankAccountsRelation PayeeNo PayeeHeaderBankAccountsRelation PayeeHeaderBankAccountsRelation PayeeNo PayeeHeaderDeductionsRelation PayeeNo PayeeHeaderDeductionsRelation PayeeHeaderDeductionsRelation PayeeNo PayeeHeaderValidityRelation PayeeNo PayeeHeaderValidityRelation PayeeHeaderValidityRelation PayeeNo PayeeValidityAssignedConditionalVariablesRelation PayeeValidityId PayeeValidityAssignedConditionalVariablesRelation PayeeValidityAssignedConditionalVariablesRelation PayeeValidityId PayeeValidityAssignedSuperanuationFundsRelation PayeeValidityId PayeeValidityAssignedSuperanuationFundsRelation PayeeValidityAssignedSuperanuationFundsRelation PayeeValidityId PayeeValidityCustomFieldsRelation PayeeValidityId PayeeValidityCustomFieldsRelation PayeeValidityCustomFieldsRelation PayeeValidityId PayeeValidityEmployeeBenefitsRelation PayeeValidityId PayeeValidityEmployeeBenefitsRelation PayeeValidityEmployeeBenefitsRelation PayeeValidityId PayeeValidityKiwiSaverOptInDatesRelation PayeeValidityId PayeeValidityKiwiSaverOptInDatesRelation PayeeValidityKiwiSaverOptInDatesRelation PayeeValidityId PayBatchHistoryPayeesRelation GrossWageBatch_id PayBatchHistoryPayeesRelation PayBatchHistoryPayeesRelation GrossWageBatch_id PayBatchHistoryPayeesSuperRelation GrossWageBatchPayeeHistoryId PayBatchHistoryPayeesSuperRelation PayBatchHistoryPayeesSuperRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesWorkCoverRelation GrossWageBatchPayeeHistoryId PayBatchHistoryPayeesWorkCoverRelation PayBatchHistoryPayeesWorkCoverRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesEmployeeBenefitsRelation GrossWageBatchPayeeHistoryId PayBatchHistoryPayeesEmployeeBenefitsRelation PayBatchHistoryPayeesEmployeeBenefitsRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesEmployerACCLevyRelation GrossWageBatchPayeeHistoryId PayBatchHistoryPayeesEmployerACCLevyRelation PayBatchHistoryPayeesEmployerACCLevyRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesItemsRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesItemsRelation PayBatchHistoryPayeesItemsRelation GrossWageBatchPayee_History_id PayBatchHistoryItemsOnCostsRelation GrossWageBatchItem_History_id PayBatchHistoryItemsOnCostsRelation PayBatchHistoryItemsOnCostsRelation GrossWageBatchItem_History_id PayBatchHistoryPayeesKiwiSaverRelation GrossWageBatchPayeeHistoryId PayBatchHistoryPayeesKiwiSaverRelation PayBatchHistoryPayeesKiwiSaverRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesDeductionsRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesDeductionsRelation PayBatchHistoryPayeesDeductionsRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesTaxRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesTaxRelation PayBatchHistoryPayeesTaxRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesTerminatinEtpRelation GrossWageBatchPayeeHistory_id PayBatchHistoryPayeesTerminatinEtpRelation PayBatchHistoryPayeesTerminatinEtpRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesTerminationAURelation GrossWageBatchPayeeHistory_id PayBatchHistoryPayeesTerminationAURelation PayBatchHistoryPayeesTerminationAURelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesTerminationNZRelation GrossWageBatchPayeeHistory_id PayBatchHistoryPayeesTerminationNZRelation PayBatchHistoryPayeesTerminationNZRelation GrossWageBatchPayee_History_id PayBatchHistoryPayeesPayrollTaxRelation GrossWageBatchPayeeHistoryId PayBatchHistoryPayeesPayrollTaxRelation PayBatchHistoryPayeesPayrollTaxRelation GrossWageBatchPayee_History_id InvoiceBatchHeaderRelation InvoiceBatch_id InvoiceBatchHeaderRelation InvoiceBatchHeaderRelation InvoiceBatch_id InvoiceHeaderTaxationRelation Invoice_id InvoiceHeaderTaxationRelation InvoiceHeaderTaxationRelation Invoice_id InvoiceHeaderItemRelation Invoice_id InvoiceHeaderItemRelation InvoiceHeaderItemRelation Invoice_id InvoiceItemTaxationRelation InvoiceItem_id InvoiceItemTaxationRelation InvoiceItemTaxationRelation InvoiceItem_id InvoiceHeaderAuditRelation Invoice_id InvoiceHeaderAuditRelation InvoiceHeaderAuditRelation Invoice_id CandidateResumeClientRelation ClientId CandidateResumeClientRelation CandidateResumeClientRelation ClientId JobOrderReferralCandidateRelation CandidateId JobOrderReferralCandidateRelation JobOrderReferralCandidateRelation CandidateId ClientContactLinkedClientContact ClientContactId ClientContactLinkedClientContact ClientContactLinkedClientContact ClientContactId AvailableTimesheetsJobOrderRelation JobOrder_id AvailableTimesheetsJobOrderRelation AvailableTimesheetsJobOrderRelation JobOrderId AvailableTimesheetsCandidateRelation Candidate_id AvailableTimesheetsCandidateRelation AvailableTimesheetsCandidateRelation CandidateId CandidateCreatedByUserRelation CreatedById CandidateCreatedByUserRelation CandidateCreatedByUserRelation UserId CandidateLastUpdatedByUserRelation LastUpdateById CandidateLastUpdatedByUserRelation CandidateLastUpdatedByUserRelation UserId CandidateActivitiesCreatedByUserRelation CreatedById CandidateActivitiesCreatedByUserRelation CandidateActivitiesCreatedByUserRelation UserId CandidateActivitiesActivityOwnerUserRelation ActivityOwnerId CandidateActivitiesActivityOwnerUserRelation CandidateActivitiesActivityOwnerUserRelation UserId CandidateCommentUserRelation CreatedById CandidateCommentUserRelation CandidateCommentUserRelation UserId CandidateDiaryJobORderRelation JobOrderId CandidateDiaryJobORderRelation CandidateDiaryJobORderRelation JobOrderId CandidateDiaryUserRelation ApprovedById CandidateDiaryUserRelation CandidateDiaryUserRelation UserId CandidateDocumentsUserRelation AttachedById CandidateDocumentsUserRelation CandidateDocumentsUserRelation UserId ClientUserRelation ClientOwnerId ClientUserRelation ClientUserRelation UserId ClientOfficeRelation OfficeId ClientOfficeRelation ClientOfficeRelation OfficeId ClientCreatedByUserRelation CreatedById ClientCreatedByUserRelation ClientCreatedByUserRelation UserId ClientUpdateByUserRelation LastUpdateById ClientUpdateByUserRelation ClientUpdateByUserRelation UserId ClientActivitiesCreatedByUserRelation CreatedById ClientActivitiesCreatedByUserRelation ClientActivitiesCreatedByUserRelation UserId ClientActivitiesActivityOwnerUserRelation ActivityOwnerId ClientActivitiesActivityOwnerUserRelation ClientActivitiesActivityOwnerUserRelation UserId ClientCommentUserRelation CreatedById ClientCommentUserRelation ClientCommentUserRelation UserId ClientContactClientRelation ClientId ClientContactClientRelation ClientContactClientRelation ClientId ClientContactContactOwnerUserRelation ContactOwnerId ClientContactContactOwnerUserRelation ClientContactContactOwnerUserRelation UserId ClientContactCreatedByUserRelation CreatedById ClientContactCreatedByUserRelation ClientContactCreatedByUserRelation UserId ClientContactUpdateByUserRelation LastUpdateById ClientContactUpdateByUserRelation ClientContactUpdateByUserRelation UserId ClientContactLinkedClientsClientContactRelation ClientContactId ClientContactLinkedClientsClientContactRelation ClientContactLinkedClientsClientContactRelation ClientContactId ClientContactLinkedCostCentresContactRelation ClientContactId ClientContactLinkedCostCentresContactRelation ClientContactLinkedCostCentresContactRelation ClientContactId CostCentreOfficeRelation OfficeCodeId CostCentreOfficeRelation CostCentreOfficeRelation OfficeId CostCentreCreatedByUserRelation CreatedById CostCentreCreatedByUserRelation CostCentreCreatedByUserRelation UserId CostCentreUpdateByUserRelation LastUpdateById CostCentreUpdateByUserRelation CostCentreUpdateByUserRelation UserId CostCentreActivitiesCreatedByUserRelation CreatedById CostCentreActivitiesCreatedByUserRelation CostCentreActivitiesCreatedByUserRelation UserId CostCentreActivitiesActivityOwnerUserRelation ActivityOwnerId CostCentreActivitiesActivityOwnerUserRelation CostCentreActivitiesActivityOwnerUserRelation UserId CostCentreDocumentsUserRelation AttachedById CostCentreDocumentsUserRelation CostCentreDocumentsUserRelation UserId InterpretedTimesheetCountryRelation Countryid InterpretedTimesheetCountryRelation InterpretedTimesheetCountryRelation CountryId InterpretedTimesheetOfficeRelation OfficeCode InterpretedTimesheetOfficeRelation InterpretedTimesheetOfficeRelation OfficeCode InterpretedTimesheetJobOrderRelation JobOrderNo InterpretedTimesheetJobOrderRelation InterpretedTimesheetJobOrderRelation JobOrderId InterpretedTimesheetCandidateRelation CandidateNo InterpretedTimesheetCandidateRelation InterpretedTimesheetCandidateRelation CandidateId InvoiceBatchCountryRelation Country_id InvoiceBatchCountryRelation InvoiceBatchCountryRelation CountryId InvoiceItemJobOrderRelation JobOrder_id InvoiceItemJobOrderRelation InvoiceItemJobOrderRelation JobOrderId InvoiceItemOfficeRelation OfficeCode InvoiceItemOfficeRelation InvoiceItemOfficeRelation OfficeCode JobOrderActivitiesCreatedByUserRelation CreatedById JobOrderActivitiesCreatedByUserRelation JobOrderActivitiesCreatedByUserRelation UserId JobOrderActivitiesActivityOwnerUserRelation ActivityOwnerId JobOrderActivitiesActivityOwnerUserRelation JobOrderActivitiesActivityOwnerUserRelation UserId JobOrderCommentUserRelation CreatedById JobOrderCommentUserRelation JobOrderCommentUserRelation UserId JobOrderDocumentsUserRelation AttachedById JobOrderDocumentsUserRelation JobOrderDocumentsUserRelation UserId JobOrderReferralClientRelation ClientId JobOrderReferralClientRelation JobOrderReferralClientRelation ClientId JobOrderReferralCandidateOwnerUserRelation CandidateOwnerId JobOrderReferralCandidateOwnerUserRelation JobOrderReferralCandidateOwnerUserRelation UserId JobOrderReferralCreatedByUserRelation CreatedById JobOrderReferralCreatedByUserRelation JobOrderReferralCreatedByUserRelation UserId JobOrderReferralUpdatedByUserRelation LastUpdatedById JobOrderReferralUpdatedByUserRelation JobOrderReferralUpdatedByUserRelation UserId JobOrderReferralHistoryJobOrderReferralRelation JobOrderReferralId JobOrderReferralHistoryJobOrderReferralRelation JobOrderReferralHistoryJobOrderReferralRelation JobOrderReferralId JobOrderReferralHistoryUserRelation ActionById JobOrderReferralHistoryUserRelation JobOrderReferralHistoryUserRelation UserId JobOrderOfficeRelation OfficeId JobOrderOfficeRelation JobOrderOfficeRelation OfficeId JobOrderOrderByContactRelation OrderById JobOrderOrderByContactRelation JobOrderOrderByContactRelation ClientContactId JobOrderSiteContactRelation SiteContactId JobOrderSiteContactRelation JobOrderSiteContactRelation ClientContactId JobOrderReportToContactRelation ReportToId JobOrderReportToContactRelation JobOrderReportToContactRelation ClientContactId JobOrderOwnerUserRelation JobOwnerId JobOrderOwnerUserRelation JobOrderOwnerUserRelation UserId JobOrderJobCreatorUserRelation JobCreatorId JobOrderJobCreatorUserRelation JobOrderJobCreatorUserRelation UserId JobOrderFilledByUserRelation FilledByID JobOrderFilledByUserRelation JobOrderFilledByUserRelation UserId JobOrderCreatedByUserRelation CreatedById JobOrderCreatedByUserRelation JobOrderCreatedByUserRelation UserId JobOrderUpdatedByUserRelation LastUpdateById JobOrderUpdatedByUserRelation JobOrderUpdatedByUserRelation UserId ParentUserRelation ParentOwnerId ParentUserRelation ParentUserRelation UserId ParentCustomFieldsParentRelation ParentId ParentCustomFieldsParentRelation ParentCustomFieldsParentRelation ParentCompanyId PayBatchHistoryEmployeeBenefitsOfficeRelation OfficeCode PayBatchHistoryEmployeeBenefitsOfficeRelation PayBatchHistoryEmployeeBenefitsOfficeRelation OfficeCode PayBatchHistoryEmployeeBenefitsJobOrderRelation JobOrderId PayBatchHistoryEmployeeBenefitsJobOrderRelation PayBatchHistoryEmployeeBenefitsJobOrderRelation JobOrderId PayBatchHistoryEmployerACCLevyJobOrderRelation JobOrderId PayBatchHistoryEmployerACCLevyJobOrderRelation PayBatchHistoryEmployerACCLevyJobOrderRelation JobOrderId PayBatchHistoryPayrollTaxOfficeRelation OfficeCode PayBatchHistoryPayrollTaxOfficeRelation PayBatchHistoryPayrollTaxOfficeRelation OfficeCode PayBatchHistoryPayrollTaxJobOrderRelation JobOrderId PayBatchHistoryPayrollTaxJobOrderRelation PayBatchHistoryPayrollTaxJobOrderRelation JobOrderId PayBatchHistoryItemsJobOrderRelation JobOrder_id PayBatchHistoryItemsJobOrderRelation PayBatchHistoryItemsJobOrderRelation JobOrderId PayBatchHistoryItemsClientRelation Client_id PayBatchHistoryItemsClientRelation PayBatchHistoryItemsClientRelation ClientId PayBatchHistoryKiwiSaverJobOrderRelation JobOrderId PayBatchHistoryKiwiSaverJobOrderRelation PayBatchHistoryKiwiSaverJobOrderRelation JobOrderId PayBatchHistoryKiwiSaverOfficeRelation OfficeCode PayBatchHistoryKiwiSaverOfficeRelation PayBatchHistoryKiwiSaverOfficeRelation OfficeCode PayBatchHistorySuperJobOrderRelation JobOrderId PayBatchHistorySuperJobOrderRelation PayBatchHistorySuperJobOrderRelation JobOrderId PayBatchHistorySuperOfficeRelation OfficeCode PayBatchHistorySuperOfficeRelation PayBatchHistorySuperOfficeRelation OfficeCode PayBatchHistoryWorkCoverJobOrderRelation JobOrderId PayBatchHistoryWorkCoverJobOrderRelation PayBatchHistoryWorkCoverJobOrderRelation JobOrderId PayBatchHistoryWorkCoverOfficeRelation OfficeCode PayBatchHistoryWorkCoverOfficeRelation PayBatchHistoryWorkCoverOfficeRelation OfficeCode PayeeHeaderCandidateRelation Candidate_id PayeeHeaderCandidateRelation PayeeHeaderCandidateRelation CandidateId PayeeValidityCandidateRelation Candidate_id PayeeValidityCandidateRelation PayeeValidityCandidateRelation CandidateId TimesheetHeaderJobOrderRelation JobOrder_id TimesheetHeaderJobOrderRelation TimesheetHeaderJobOrderRelation JobOrderId TimesheetHeaderOfficeRelation OfficeCode TimesheetHeaderOfficeRelation TimesheetHeaderOfficeRelation OfficeCode UserSecurityUserRelation UserId UserSecurityUserRelation UserSecurityUserRelation UserId UserSecuritySecurityRoleRelation SecurityRoleId UserSecuritySecurityRoleRelation UserSecuritySecurityRoleRelation SecurityRoleId DebtorInvoiceRelation DebtorId DebtorInvoiceRelation DebtorInvoiceRelation DebtorId JobOrderActivitiesCandidateRelation CandidateId JobOrderActivitiesCandidateRelation JobOrderActivitiesCandidateRelation CandidateId JobOrderActivitiesContactRelation ClientContactId JobOrderActivitiesContactRelation JobOrderActivitiesContactRelation ClientContactId EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,1,10.9,2.3 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 0,1.64,3.9,0.2 Arial,10 18f60eefb442b21090c22ac5f8961a2d 0,0,0,0 CrossTab1_RowTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black White 0,0.22,0.8,0.4 Arial,10 4cdf30e3f022cc0f879e2ac5f896da23 0,0,0,0 CrossTab1_Row1_Title AllowMove, AllowResize, AllowSelect, AllowChange ClientName [105:105:105] Row:CrossTab1_Row1 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 0.8,1.44,3.1,0.2 False Arial,10 76b0904e96743837b7682ac6002636b2 0,0,0,0 CrossTab1_RowTotal2 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black White 0.8,0.22,0.9,0.4 Arial,10 e50047a233fcc8a5c1942ac600267bc5 0,0,0,0 CrossTab1_Row2_Title AllowMove, AllowResize, AllowSelect, AllowChange ClientPosition [105:105:105] Row:CrossTab1_Row2 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 1.7,1.24,2.2,0.2 False Arial,10 16a57895d903cb558fb12ac609a7816e 0,0,0,0 CrossTab1_RowTotal3 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black White 1.7,0.22,0.7,0.4 Arial,10 e1f9f594f0535512e6932ac609a7bba2 0,0,0,0 CrossTab1_Row3_Title AllowMove, AllowResize, AllowSelect, AllowChange EmpName [105:105:105] Row:CrossTab1_Row3 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 4.72,0.22,0.7,0.4 Arial,10 bf45e10c1ac3ccff73a32ac611335b8d 0,0,0,0 CrossTab1_ColTotal1 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black White 0,0,3.9,0.2 Arial,10 b834fd0dd9147b2d329d2ac61133a7d3 0,0,0,0 CrossTab1_LeftTitle AllowMove, AllowResize, AllowSelect, AllowChange DataSource1 [105:105:105] LeftTitle All;[155:155:155];1;Solid;False;4;Black [255:255:255] 2.4,1.04,1.5,0.2 False Arial,10 0f60998634b8ef4fc8092ac624bf2923 0,0,0,0 CrossTab1_RowTotal4 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black White 2.4,0.22,1,0.4 Arial,10 e7651df8a6a505abd9f42ac624bf36fd 0,0,0,0 CrossTab1_Row4_Title AllowMove, AllowResize, AllowSelect, AllowChange DayFirstWorked [105:105:105] Row:CrossTab1_Row4 All;[155:155:155];1;Solid;False;4;Black [255:255:255] 3.4,0.84,0.5,0.2 False Arial,10 203e81f2b80b992fa9f52ac62d8aa419 0,0,0,0 CrossTab1_RowTotal5 AllowMove, AllowResize, AllowSelect, AllowChange Total Black All;[155:155:155];1;Solid;False;4;Black White 3.4,0.22,0.5,0.4 Arial,10 d859d329e98843ec062f2ac62d8a436b 0,0,0,0 CrossTab1_Row5_Title AllowMove, AllowResize, AllowSelect, AllowChange Weeks [105:105:105] Row:CrossTab1_Row5 All;[155:155:155];1;Solid;False;4;Black White 3.92,0.42,0.3,0.2 Arial,10 4398f1f77a6b5ea2cd702ac641a491f7 0,0,0,0 CrossTab1_SumHeader1 AllowMove, AllowResize, AllowSelect, AllowChange Qty [105:105:105] All;[155:155:155];1;Solid;False;4;Black White 4.22,0.42,0.5,0.2 Arial,10 907595e94675663d65df2ac641a4916a 0,0,0,0 CrossTab1_SumHeader2 AllowMove, AllowResize, AllowSelect, AllowChange Charge [105:105:105] ClientName All;[155:155:155];1;Solid;False;4;Black White 0,0.64,0.8,1 {DataSource1.ClientName} Arial,10 24a305342428c54ebc502ac5f8948ac4 0,0,0,0 CrossTab1_Row1 AllowMove, AllowResize, AllowSelect, AllowChange ClientName [105:105:105] 18f60eefb442b21090c22ac5f8961a2d {DataSource1.ClientName} ClientPosition All;[155:155:155];1;Solid;False;4;Black White 0.8,0.64,0.9,0.8 {DataSource1.ClientPosition} Arial,10 f86ec787dd47dfa467572ac60024fba5 0,0,0,0 CrossTab1_Row2 AllowMove, AllowResize, AllowSelect, AllowChange ClientPosition [105:105:105] 76b0904e96743837b7682ac6002636b2 {DataSource1.ClientPosition} EmpName All;[155:155:155];1;Solid;False;4;Black White 1.7,0.64,0.7,0.6 {DataSource1.EmpName} Arial,10 e1a7d94e51667f7fedbc2ac609a5298d 0,0,0,0 CrossTab1_Row3 AllowMove, AllowResize, AllowSelect, AllowChange EmpName [105:105:105] 16a57895d903cb558fb12ac609a7816e {DataSource1.EmpName} DayFirstWorked All;[155:155:155];1;Solid;False;4;Black White 2.4,0.64,1,0.4 {DataSource1.DayFirstWorked} Arial,10 53260c6f3d1b8c78ed212ac624bcdb30 0,0,0,0 CrossTab1_Row4 AllowMove, AllowResize, AllowSelect, AllowChange DayFirstWorked [105:105:105] dd/MM/yyyy 0f60998634b8ef4fc8092ac624bf2923 {DataSource1.DayFirstWorked} Weeks All;[155:155:155];1;Solid;False;4;Black White 3.4,0.64,0.5,0.2 _x007B_DataSource1.Weeks_x0020__x003C__x003D__x0020_40_x007D_,[0:0:0],Transparent,Arial_x002C_10_x002C_Bold,True,False,,,None _x007B_DataSource1.Weeks_x0020__x003E__x0020_40_x007D_,Red,[112:253:255],Arial_x002C_10_x002C_Bold,True,False,,,None {DataSource1.Weeks} Arial,10 bf3704ce5ff41f99bd2a2ac62d84d841 0,0,0,0 CrossTab1_Row5 AllowMove, AllowResize, AllowSelect, AllowChange Weeks [105:105:105] 0 , 1 False 203e81f2b80b992fa9f52ac62d8aa419 {DataSource1.Weeks} PayCode All;[155:155:155];1;Solid;False;4;Black White 3.92,0.22,0.8,0.2 {DataSource1.PayCode} Arial,10 f5adc8f5651c2da30d202ac61131ccd9 0,0,0,0 CrossTab1_Column1 AllowMove, AllowResize, AllowSelect, AllowChange PayCode [105:105:105] bf45e10c1ac3ccff73a32ac611335b8d {DataSource1.PayCode} Units All;[155:155:155];1;Solid;False;4;Black [255:255:255] 3.92,0.64,0.3,0.2 Arial,10 0ceccd365a0d8104cdcc2ac63971f28c 0,0,0,0 CrossTab1_Sum1 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black , 1 {DataSource1.Units} Charge All;[155:155:155];1;Solid;False;4;Black [255:255:255] 4.22,0.64,0.5,0.2 Arial,10 bca1add7da94c454794b2ac641a2c8c0 0,0,0,0 CrossTab1_Sum2 AllowMove, AllowResize, AllowSelect, AllowChange 0 Black , 5 1 p. {DataSource1.Charge} All;[155:155:155];1;Solid;False;4;Black White 3.92,0,1.5,0.2 Arial,10 d29e52177de009e998be2ac641a4c3f4 0,0,0,0 CrossTab1_RightTitle AllowMove, AllowResize, AllowSelect, AllowChange PayCode [105:105:105] RightTitle DataSource1 CrossTab1 LeftToRight 47c690eddea041b99dc2d9be289065ad 0.39,0.39,0.39,0.39 Page1 Landscape 16.54 23.39 A2 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 6/6/2019 1:29:40 PM 6/6/2019 11:29:54 AM 09c12c9ed169e28844db2a8922ad4b01 Report Inches 2016.3.7 CSharp