Interpretation MSSQL 9FTVSEhKq4Htbu3cdhjrP9Hyz81FSruFRhXoperApGOQFNHJyE2izWl8odxnhONG3xKBCcZd8oXzWrnsb5jgf8Nw2UlDXLud/FzxfGM99nfDLNsCWEx7pGpHTcljXKJ72cjPiO9r09V9Zrns MSSQL VendorInvoiceBEE VENDORID,System.String ListID,System.String EditSequence,System.String VENDORNAME,System.String ACTIVEYN,System.String ADDRESS1,System.String ADDRESS2,System.String ADDRESS3,System.String Suburb,System.String POSTCODE,System.String COUNTRY,System.String BUSINESSSIZEID,System.String BUSINESSCATEGORYID,System.String DOCCOMPLIANTYN,System.Int16 TermsID,System.String CountryID,System.String FinalizedYN,System.Int16 ACCOUNTSCONTACTNAME,System.String AccountsContactLastName,System.String PayVATYN,System.Int16 VATNo,System.String ProjectVendor,System.Int16 Default_GL_Acc_ContractorVendor,System.String Default_GL_Acc_ContractorPSP,System.String Default_GL_Acc_3rdPartyCommission,System.String Default_GL_Acc_ProjectVendor,System.String Default_GL_Acc_SOWVendor,System.String PrefillOfficeID,System.String PrefillGLAccount5,System.String PrefillGLAccount6,System.String PrefillGLAccount7,System.String PrefillGLAccount8,System.String BankerID,System.String BankAccountTypeID,System.String BankAccountCode,System.String BankAccountNumber,System.String BankAccountHolderName,System.String BankAccountOwnerType,System.String BEEExpiryDate,System.DateTime BEEOrgCategoryID,System.String BEEOrgCategoryCode,System.String BEELevelNumber,System.Int16 BEECertificateTypeID,System.String BEECertificateTypeCode,System.String BEEFinancialYearEnd,System.Int16 BEEFinancialMonthEnd,System.Int16 BEEFinalizedYN,System.Int16 BEEDesignatedGroupYN,System.Int16 BEENatureOfBusiness,System.String BEEPctBlackOwned,System.Decimal BEEPctBlackFemaleOwned,System.Decimal BEEPctBlackDesignatedGroupOwned,System.Decimal BEEPctBlackDesignatedYouthGroupOwned,System.Decimal BEEPctBlackDesignatedDisabledGroupOwned,System.Decimal BEEPctBlackDesignatedUnemployedOwned,System.Decimal BEEPctBlackDesignatedYouthRuralOwned,System.Decimal BEEPctBlackDesignatedYouthMilitaryOwned,System.Decimal BEENotes,System.String BEERequestSentByID,System.String BEERequestSentByCode,System.String BEERequestSentByName,System.String BEERequestSentDate,System.DateTime BEESignatureDate,System.DateTime PSPVendor,System.Int16 PSPSignatureDate,System.DateTime PSPExpiryDate,System.DateTime PSPFinalizedYN,System.Int16 PSPRequestSentDate,System.DateTime AddressUnitNumber,System.String AddressStreetNumber,System.String ContractCommenceDate,System.DateTime ContractTerminationDate,System.DateTime ContractSentByID,System.String ContractSentDate,System.DateTime ContractReceivedByID,System.String ContractReceivedDate,System.DateTime ContractSpecialTerms,System.String ContractRevisionNumber,System.String ThirdPartyVendor,System.Int16 AccountsContactFirstName,System.String OfficeID,System.String TERMS,System.String OFFICENAME,System.String INVOICEDATE,System.DateTime INVOICEDUEDATE,System.DateTime InvPayVATYN,System.Int16 INVOICEVAT,System.Decimal INVOICEGRANDTOTAL,System.Decimal INVOICETOTALEXVAT,System.Decimal PAIDYN,System.Int16 PAIDDATE,System.DateTime 30 0c78adf9347443ff9e1b08a951a25f61 VendorInvoiceBEE MSSQL SELECT Vendor.VENDORID, Vendor.ListID, Vendor.EditSequence, Vendor.VENDORNAME, Vendor.ACTIVEYN, Vendor.ADDRESS1, Vendor.ADDRESS2, Vendor.ADDRESS3, Vendor.Suburb, Vendor.POSTCODE, Vendor.COUNTRY, Vendor.BUSINESSSIZEID, Vendor.BUSINESSCATEGORYID, Vendor.DOCCOMPLIANTYN, Vendor.TermsID, Vendor.CountryID, Vendor.FinalizedYN, Vendor.ACCOUNTSCONTACTNAME, Vendor.AccountsContactLastName, Vendor.PayVATYN, Vendor.VATNo, Vendor.ProjectVendor, Vendor.Default_GL_Acc_ContractorVendor, Vendor.Default_GL_Acc_ContractorPSP, Vendor.Default_GL_Acc_3rdPartyCommission, Vendor.Default_GL_Acc_ProjectVendor, Vendor.Default_GL_Acc_SOWVendor, Vendor.PrefillOfficeID, Vendor.PrefillGLAccount5, Vendor.PrefillGLAccount6, Vendor.PrefillGLAccount7, Vendor.PrefillGLAccount8, Vendor.BankerID, Vendor.BankAccountTypeID, Vendor.BankAccountCode, Vendor.BankAccountNumber, Vendor.BankAccountHolderName, Vendor.BankAccountOwnerType, Vendor.BEEExpiryDate, Vendor.BEEOrgCategoryID, Vendor.BEEOrgCategoryCode, Vendor.BEELevelNumber, Vendor.BEECertificateTypeID, Vendor.BEECertificateTypeCode, Vendor.BEEFinancialYearEnd, Vendor.BEEFinancialMonthEnd, Vendor.BEEFinalizedYN, Vendor.BEEDesignatedGroupYN, Vendor.BEENatureOfBusiness, Vendor.BEEPctBlackOwned, Vendor.BEEPctBlackFemaleOwned, Vendor.BEEPctBlackDesignatedGroupOwned, Vendor.BEEPctBlackDesignatedYouthGroupOwned, Vendor.BEEPctBlackDesignatedDisabledGroupOwned, Vendor.BEEPctBlackDesignatedUnemployedOwned, Vendor.BEEPctBlackDesignatedYouthRuralOwned, Vendor.BEEPctBlackDesignatedYouthMilitaryOwned, Vendor.BEENotes, Vendor.BEERequestSentByID, Vendor.BEERequestSentByCode, Vendor.BEERequestSentByName, Vendor.BEERequestSentDate, Vendor.BEESignatureDate, Vendor.PSPVendor, Vendor.PSPSignatureDate, Vendor.PSPExpiryDate, Vendor.PSPFinalizedYN, Vendor.PSPRequestSentDate, Vendor.AddressUnitNumber, Vendor.AddressStreetNumber, Vendor.ContractCommenceDate, Vendor.ContractTerminationDate, Vendor.ContractSentByID, Vendor.ContractSentDate, Vendor.ContractReceivedByID, Vendor.ContractReceivedDate, Vendor.ContractSpecialTerms, Vendor.ContractRevisionNumber, Vendor.ThirdPartyVendor, Vendor.AccountsContactFirstName, Vendor.OfficeID, TradingTerms.TERMS, Office.OFFICENAME, VendorInvoiceHeader.INVOICEDATE, VendorInvoiceHeader.INVOICEDUEDATE, VendorInvoiceHeader.PAYVATYN AS InvPayVATYN, VendorInvoiceHeader.INVOICEVAT, VendorInvoiceHeader.INVOICEGRANDTOTAL, VendorInvoiceHeader.INVOICETOTALEXVAT, VendorInvoiceHeader.PAIDYN, VendorInvoiceHeader.PAIDDATE FROM Vendor RIGHT OUTER JOIN VendorInvoiceHeader ON Vendor.VENDORID = VendorInvoiceHeader.VENDORID LEFT OUTER JOIN Office ON Vendor.OfficeID = Office.OFFICEID LEFT OUTER JOIN TradingTerms ON Vendor.TermsID = TradingTerms.TERMSID WHERE (VendorInvoiceHeader.INVOICEDATE BETWEEN '2022/03/01' AND '2023/02/28') EngineV2 e618f3d235ae499a884c1359795354cb None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,89,0.8 Transparent 0,0,89,0.6 Calibri,12,Bold 0,0,0,0 Text1 BEE PassThrough for Vendor Payments - by Vendor From 01/03/2022 to 28/02/2023 Black Expression ReportTitleBand1 Transparent 0,2,89,0.6 Transparent 2.6,0,3.2,0.6 Calibri,9,Bold Right 0,0,0,0 Text32 Invoice Date Black Expression Center Transparent 5.8,0,3.2,0.6 Calibri,9,Bold Right 0,0,0,0 Text33 Invoice Due Date Black Expression Center Transparent 9,0,1.6,0.6 Calibri,9,Bold Center 0,0,0,0 Text34 Paid Black Expression Center Transparent 10.6,0,3.2,0.6 Calibri,9,Bold Right 0,0,0,0 Text35 Paid Date Black Expression Center Transparent 13.8,0,4,0.6 Calibri,9,Bold Right 0,0,0,0 Text36 Invoice Excl Black Expression Center Transparent 17.8,0,4,0.6 Calibri,9,Bold Right 0,0,0,0 Text37 Invoice VAT Black Expression Center Transparent 21.8,0,4,0.6 Calibri,9,Bold Right 0,0,0,0 Text38 Total Invoice Black Expression Center Transparent 25.8,0,2.4,0.6 Calibri,9,Bold Right 0,0,0,0 Text39 BEE Expiry Date Black Expression Center Transparent 28.2,0,2.6,0.6 Calibri,9,Bold Right 0,0,0,0 Text9 BEE Category Code Black Expression Center Transparent 30.8,0,1.4,0.6 Calibri,9,Bold Right 0,0,0,0 Text41 BEE Level Black Expression Center Transparent 32.2,0,3.2,0.6 Calibri,9,Bold Right 0,0,0,0 Text42 BEE Category TypeID Black Expression Center Transparent 35.4,0,3.6,0.6 Calibri,9,Bold Right 0,0,0,0 Text43 BEE Certificate Type Code Black Expression Center Transparent 39,0,3.2,0.6 Calibri,9,Bold Right 0,0,0,0 Text44 BEE Financial Year End Black Expression Center Transparent 42.2,0,3.4,0.6 Calibri,9,Bold Right 0,0,0,0 Text45 BEE Financial Month End Black Expression Center Transparent 45.6,0,2,0.6 Calibri,9,Bold Right 0,0,0,0 Text46 BEE Finalized Black Expression Center Transparent 47.6,0,3,0.6 Calibri,9,Bold Right 0,0,0,0 Text47 BEE Designated Group Black Expression Center Transparent 50.6,0,2.2,0.6 Calibri,9,Bold Right 0,0,0,0 Text49 % Black Owned Black Expression Center Transparent 52.8,0,3.2,0.6 Calibri,9,Bold Right 0,0,0,0 Text50 % Black Female Owned Black Expression Center Transparent 56,0,4.6,0.6 Calibri,9,Bold Right 0,0,0,0 Text51 % Black Designated Group Owned Black Expression Center Transparent 60.6,0,5.6,0.6 Calibri,9,Bold Right 0,0,0,0 Text52 % Black Designated Youth Group Owned Black Expression Center Transparent 66.2,0,5.6,0.6 Calibri,9,Bold Right 0,0,0,0 Text26 % Black Designated Unemployed Owned Black Expression Center Transparent 71.8,0,5.8,0.6 Calibri,9,Bold Right 0,0,0,0 Text53 % Black Designated Disabled Group Owned Black Expression Center Transparent 77.6,0,5.6,0.6 Calibri,9,Bold Right 0,0,0,0 Text54 % Black Designated Youth Rural Owned Black Expression Center Transparent 83.2,0,5.8,0.6 Calibri,9,Bold Right 0,0,0,0 Text55 % Black Designated Youth Military Owned Black Expression Center Transparent 0,0,2.6,0.6 Calibri,9,Bold 0,0,0,0 Text12 Vendor Name Black Expression Center HeaderBand1 Transparent 0,3.4,89,0 {VendorInvoiceBEE.VENDORNAME} GroupHeaderBand1 Transparent 0,4.2,89,0.4 Transparent 2.6,0,3.2,0.4 Calibri,8 Right 0,0,0,0 Text2 - {VendorInvoiceBEE.INVOICEDATE} Black DataColumn Transparent 5.8,0,3.2,0.4 Calibri,8 Right 0,0,0,0 Text3 - {VendorInvoiceBEE.INVOICEDUEDATE} Black DataColumn Transparent 9,0,1.6,0.4 Calibri,8 Center 0,0,0,0 Text4 {VendorInvoiceBEE.PAIDYN} Black No 0 Yes 1 Transparent 10.6,0,3.2,0.4 Calibri,8 Right 0,0,0,0 Text5 {VendorInvoiceBEE.PAIDDATE} Black Transparent 13.8,0,4,0.4 Calibri,8 Right 0,0,0,0 Text6 {VendorInvoiceBEE.INVOICETOTALEXVAT} Black 2   1 False Transparent 17.8,0,4,0.4 Calibri,8 Right 0,0,0,0 Text7 {VendorInvoiceBEE.INVOICEVAT} Black 2   1 False Expression Transparent 21.8,0,4,0.4 Calibri,8 Right 0,0,0,0 Text8 {VendorInvoiceBEE.INVOICEGRANDTOTAL} Black 2   1 False Transparent 25.8,0,2.4,0.4 Calibri,8 Right 0,0,0,0 Text11 - {VendorInvoiceBEE.BEEExpiryDate} Black DataColumn Transparent 28.2,0,2.6,0.4 Calibri,8 Right 0,0,0,0 Text13 {VendorInvoiceBEE.BEEOrgCategoryCode} Black Transparent 30.8,0,1.4,0.4 Calibri,8 Right 0,0,0,0 Text14 {VendorInvoiceBEE.BEELevelNumber} Black Transparent 32.2,0,3.2,0.4 Calibri,8 Right 0,0,0,0 Text15 {VendorInvoiceBEE.BEECertificateTypeID} Black Transparent 35.4,0,3.6,0.4 Calibri,8 Right 0,0,0,0 Text16 {VendorInvoiceBEE.BEECertificateTypeCode} Black Transparent 39,0,3.2,0.4 Calibri,8 Right 0,0,0,0 Text17 {VendorInvoiceBEE.BEEFinancialYearEnd} Black Transparent 42.2,0,3.4,0.4 Calibri,8 Right 0,0,0,0 Text18 {VendorInvoiceBEE.BEEFinancialMonthEnd} Black Transparent 45.6,0,2,0.4 Calibri,8 Right 0,0,0,0 Text19 {VendorInvoiceBEE.BEEFinalizedYN} Black No 0 Yes 1 Transparent 47.6,0,3,0.4 Calibri,8 Right 0,0,0,0 Text20 {VendorInvoiceBEE.BEEDesignatedGroupYN} Black No 0 Yes 1 Transparent 50.6,0,2.2,0.4 Calibri,8 Right 0,0,0,0 Text22 {VendorInvoiceBEE.BEEPctBlackOwned} Black 2   1 False Transparent 52.8,0,3.2,0.4 Calibri,8 Right 0,0,0,0 Text23 {VendorInvoiceBEE.BEEPctBlackFemaleOwned} Black 2   1 False Expression Transparent 56,0,4.6,0.4 Calibri,8 Right 0,0,0,0 Text24 {VendorInvoiceBEE.BEEPctBlackDesignatedGroupOwned} Black 2   1 False Expression Transparent 60.6,0,5.6,0.4 Calibri,8 Right 0,0,0,0 Text25 {VendorInvoiceBEE.BEEPctBlackDesignatedYouthGroupOwned} Black 2   1 False Expression Transparent 66.2,0,5.6,0.4 Calibri,8 Right 0,0,0,0 Text28 {VendorInvoiceBEE.BEEPctBlackDesignatedUnemployedOwned} Black 2   1 False Expression Transparent 71.8,0,5.8,0.4 Calibri,8 Right 0,0,0,0 Text27 {VendorInvoiceBEE.BEEPctBlackDesignatedDisabledGroupOwned} Black 2   1 False Transparent 83.2,0,5.8,0.4 Calibri,8 Right 0,0,0,0 Text30 {VendorInvoiceBEE.BEEPctBlackDesignatedYouthMilitaryOwned} Black 2   1 False Transparent 77.6,0,5.6,0.4 Calibri,8 Right 0,0,0,0 Text29 {VendorInvoiceBEE.BEEPctBlackDesignatedYouthRuralOwned} Black 2   1 False Transparent True 0,0,2.6,0.4 Calibri,8 0,0,0,0 Text10 {VendorInvoiceBEE.VENDORNAME} Black VendorInvoiceBEE DataBand1 ASC PAIDDATE Transparent 0,5.4,89,0 GroupFooterBand1 3a83b62927b949c1ad2dd27ebfedaf80 0.5,0.5,0.5,0.5 Page1 Landscape 21 90 A4 False True System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll BEE PassThrough for Vendor Payments Marius Nel 8/29/2023 9:08:18 AM 8/29/2023 6:04:12 AM C:\Resourgenix\Reports\29082023\BEEPassThruByVendor.mrt 6e9d12bfcae643008038084e82151296 BEE PassThrough for Vendor Payments Centimeters 2023.3.2.0 CSharp