Purchase Order Invoice

CREATE VIEW [dbo].[vw_purchPurchInvoice] 
AS 
  SELECT 'VENDINVOICEJOUR_ATTORNEYDATE_RU' = 
         vij.attorneydate_ru, 
         'VENDINVOICEJOUR_ATTORNEYID_RU' = 
         vij.attorneyid_ru, 
         'VENDINVOICEJOUR_ATTORNEYISSUEDNAME_RU' 
         = 
         vij.attorneyissuedname_ru, 
         'VENDINVOICEJOUR_BANKLCIMPORTLINE' = 
            vij.banklcimportline, 
         'VENDINVOICEJOUR_CASHDISC' = vij.cashdisc, 
         'VENDINVOICEJOUR_CASHDISCCODE' = vij.cashdisccode, 
         'VENDINVOICEJOUR_CASHDISCDATE' = vij.cashdiscdate, 
         'VENDINVOICEJOUR_CASHDISCPERCENT' = 
            vij.cashdiscpercent, 
         'VENDINVOICEJOUR_CONSIGNEEACCOUNT_RU' = 
         vij.consigneeaccount_ru, 
         'VENDINVOICEJOUR_CONSIGNORACCOUNT_RU' = 
         vij.consignoraccount_ru, 
         'VENDINVOICEJOUR_CONSTARGET_JP' = 
         vij.constarget_jp, 
         'VENDINVOICEJOUR_CONTRACTNUM_SA' = 
            vij.contractnum_sa, 
         'VENDINVOICEJOUR_CORRECT_RU' = 
            vij.correct_ru, 
         'VENDINVOICEJOUR_CORRECTEDINVOICEDATE_RU' = 
         vij.correctedinvoicedate_ru, 
         'VENDINVOICEJOUR_CORRECTEDINVOICEID_RU' = 
         vij.correctedinvoiceid_ru, 
         'VENDINVOICEJOUR_CORRECTIONTYPE_RU' = 
            vij.correctiontype_ru, 
         'VENDINVOICEJOUR_COSTLEDGERVOUCHER' = 
            vij.costledgervoucher, 
         'VENDINVOICEJOUR_COUNTRYREGIONID' = 
            vij.countryregionid, 
         'VENDINVOICEJOUR_CREATEDBY' = vij.createdby, 
         'VENDINVOICEJOUR_CREATEDDATETIME' = 
            vij.createddatetime, 
         'VENDINVOICEJOUR_CURRENCYCODE' = vij.currencycode, 
         'VENDINVOICEJOUR_DATAAREAID' = vij.dataareaid, 
         'VENDINVOICEJOUR_DEFAULTDIMENSION' = 
            vij.defaultdimension, 
         'VENDINVOICEJOUR_DELIVERYADDRESS_LT' = 
         vij.deliveryaddress_lt, 
         'VENDINVOICEJOUR_DELIVERYDATE_ES' = 
            vij.deliverydate_es, 
         'VENDINVOICEJOUR_DELIVERYNAME' = vij.deliveryname, 
         'VENDINVOICEJOUR_DELIVERYNAME_LT' = 
            vij.deliveryname_lt, 
         'VENDINVOICEJOUR_DELIVERYPOSTALADDRESS' = 
         vij.deliverypostaladdress, 
         'VENDINVOICEJOUR_DESCRIPTION' = vij.description, 
         'VENDINVOICEJOUR_DLVADDRESS_LV' = 
         vij.dlvaddress_lv, 
         'VENDINVOICEJOUR_DLVMODE' = 
         vij.dlvmode, 
         'VENDINVOICEJOUR_DLVTERM' = 
         vij.dlvterm, 
         'VENDINVOICEJOUR_DOCUMENTDATE' = 
         vij.documentdate, 
         'VENDINVOICEJOUR_DOCUMENTNUM' = vij.documentnum, 
         'VENDINVOICEJOUR_DOCUMENTORIGIN' = 
            vij.documentorigin, 
         'VENDINVOICEJOUR_DUEDATE' = vij.duedate, 
         'VENDINVOICEJOUR_ENDDISC' = vij.enddisc, 
         'VENDINVOICEJOUR_ENDDISCMST' = vij.enddiscmst, 
         'VENDINVOICEJOUR_ENTERPRISENUMBER' = 
            vij.enterprisenumber, 
         'VENDINVOICEJOUR_EUSALESLIST' = vij.eusaleslist, 
         'VENDINVOICEJOUR_EXCHRATE' = vij.exchrate, 
         'VENDINVOICEJOUR_EXCHRATESECONDARY' = 
            vij.exchratesecondary, 
         'VENDINVOICEJOUR_FACTUREDFULLY_RU' = 
            vij.facturedfully_ru, 
         'VENDINVOICEJOUR_FISCALDOCUMENTTYPE_BR' = 
         vij.fiscaldocumenttype_br, 
         'VENDINVOICEJOUR_FIXEDDUEDATE' = vij.fixedduedate, 
         'VENDINVOICEJOUR_INCLTAX' = vij.incltax, 
         'VENDINVOICEJOUR_INTERCOMPANYCOMPANYID' = 
         vij.intercompanycompanyid, 
         'VENDINVOICEJOUR_INTERCOMPANYLEDGERVOUCHER' = 
         vij.intercompanyledgervoucher, 
         'VENDINVOICEJOUR_INTERCOMPANYPOSTED' = 
         vij.intercompanyposted, 
         'VENDINVOICEJOUR_INTERCOMPANYSALESID' = 
         vij.intercompanysalesid, 
         'VENDINVOICEJOUR_INTERNALINVOICEID' = 
            vij.internalinvoiceid, 
         'VENDINVOICEJOUR_INTRASTATADDVALUE_LV' = 
         vij.intrastataddvalue_lv, 
         'VENDINVOICEJOUR_INTRASTATDISPATCH' = 
            vij.intrastatdispatch, 
         'VENDINVOICEJOUR_INTRASTATFULFILLMENTDATE_HU' = 
         vij.intrastatfulfillmentdate_hu, 
         'VENDINVOICEJOUR_INVENTBAILEERECEIPTREPORTID_RU' = 
         vij.inventbaileereceiptreportid_ru, 
         'VENDINVOICEJOUR_INVENTPROFILETYPE_RU' = 
         vij.inventprofiletype_ru, 
         'VENDINVOICEJOUR_INVOICEACCOUNT' = 
            vij.invoiceaccount, 
         'VENDINVOICEJOUR_INVOICEAMOUNT' = 
            vij.invoiceamount, 
         'VENDINVOICEJOUR_INVOICEAMOUNTMST' = 
            vij.invoiceamountmst, 
         'VENDINVOICEJOUR_INVOICEDATE' = vij.invoicedate, 
         'VENDINVOICEJOUR_INVOICEID' = vij.invoiceid, 
         'VENDINVOICEJOUR_INVOICEREGISTER_LT' = 
         vij.invoiceregister_lt, 
         'VENDINVOICEJOUR_INVOICEROUNDOFF' = 
            vij.invoiceroundoff, 
         'VENDINVOICEJOUR_INVOICESTATUS_LT' = 
            vij.invoicestatus_lt, 
         'VENDINVOICEJOUR_INVOICETYPE' = vij.invoicetype, 
         'VENDINVOICEJOUR_ITEMBUYERGROUPID' = 
            vij.itembuyergroupid, 
         'VENDINVOICEJOUR_LANGUAGEID' = vij.languageid, 
         'VENDINVOICEJOUR_LEDGERVOUCHER' = 
         vij.ledgervoucher, 
         'VENDINVOICEJOUR_LISTCODE' = 
         vij.listcode, 
         'VENDINVOICEJOUR_LOGISTICSELECTRONICADDRESS' = 
         vij.logisticselectronicaddress, 
         'VENDINVOICEJOUR_MODIFIEDDATETIME' = 
            vij.modifieddatetime, 
         'VENDINVOICEJOUR_NONREALREVENUE_RU' = 
            vij.nonrealrevenue_ru, 
         'VENDINVOICEJOUR_NUMBERSEQUENCECODE_LT' = 
         vij.numbersequencecode_lt, 
         'VENDINVOICEJOUR_NUMBERSEQUENCEGROUP' = 
         vij.numbersequencegroup, 
         'VENDINVOICEJOUR_OFFSESSIONID_RU' = 
            vij.offsessionid_ru, 
         'VENDINVOICEJOUR_OPERATIONTYPE_MX' = 
            vij.operationtype_mx, 
         'VENDINVOICEJOUR_ORDERACCOUNT' = vij.orderaccount, 
         'VENDINVOICEJOUR_PARMID' = vij.parmid, 
         'VENDINVOICEJOUR_PARTITION' = vij.partition, 
         'VENDINVOICEJOUR_PAYMDAYID' = vij.paymdayid, 
         'VENDINVOICEJOUR_PAYMENT' = vij.payment, 
         'VENDINVOICEJOUR_PAYMENTSCHED' = vij.paymentsched, 
         'VENDINVOICEJOUR_PAYMID' = vij.paymid, 
         'VENDINVOICEJOUR_POSTINGPROFILE' = 
            vij.postingprofile, 
         'VENDINVOICEJOUR_PREPAYMENT' = 
            vij.prepayment, 
         'VENDINVOICEJOUR_PROFORMA' = vij.proforma, 
         'VENDINVOICEJOUR_PURCHAGREEMENTHEADER_PSN' = 
         vij.purchagreementheader_psn, 
         'VENDINVOICEJOUR_PURCHASETYPE' = vij.purchasetype, 
         'VENDINVOICEJOUR_PURCHID' = vij.purchid, 
         'VENDINVOICEJOUR_PURCHRECEIPTDATE_W' = 
         vij.purchreceiptdate_w, 
         'VENDINVOICEJOUR_QTY' = vij.qty, 
         'VENDINVOICEJOUR_REASONTABLEREF_BR' = 
            vij.reasontableref_br, 
         'VENDINVOICEJOUR_RECID' = vij.recid, 
         'VENDINVOICEJOUR_RECVERSION' = vij.recversion, 
         'VENDINVOICEJOUR_REMITTANCEADDRESS' = 
            vij.remittanceaddress, 
         'VENDINVOICEJOUR_RETURNITEMNUM' = 
         vij.returnitemnum, 
         'VENDINVOICEJOUR_REVERSECHARGE_UK' = 
            vij.reversecharge_uk, 
         'VENDINVOICEJOUR_SALESBALANCE' = vij.salesbalance, 
         'VENDINVOICEJOUR_SALESPURCHOPERATIONTYPE_BR' = 
         vij.salespurchoperationtype_br, 
         'VENDINVOICEJOUR_SERVICECODEONDLVADDRESS_BR' = 
         vij.servicecodeondlvaddress_br, 
         'VENDINVOICEJOUR_SOURCEDOCUMENTHEADER' = 
         vij.sourcedocumentheader, 
         'VENDINVOICEJOUR_SOURCEDOCUMENTLINE' = 
         vij.sourcedocumentline, 
         'VENDINVOICEJOUR_STATEINVOICEPRINTED_LV' = 
         vij.stateinvoiceprinted_lv, 
         'VENDINVOICEJOUR_SUMLINEDISC' = vij.sumlinedisc, 
         'VENDINVOICEJOUR_SUMMARKUP' = vij.summarkup, 
         'VENDINVOICEJOUR_SUMMARKUPMST' = vij.summarkupmst, 
         'VENDINVOICEJOUR_SUMTAX' = vij.sumtax, 
         'VENDINVOICEJOUR_TAXGROUP' = vij.taxgroup, 
         'VENDINVOICEJOUR_TAXINVOICEPURCHID' = 
            vij.taxinvoicepurchid, 
         'VENDINVOICEJOUR_TAXPRINTONINVOICE' = 
            vij.taxprintoninvoice, 
         'VENDINVOICEJOUR_TAXROUNDOFF' = vij.taxroundoff, 
         'VENDINVOICEJOUR_TAXSETOFFVOUCHER_IN' = 
         vij.taxsetoffvoucher_in, 
         'VENDINVOICEJOUR_TAXSPECIFYBYLINE' = 
            vij.taxspecifybyline, 
         'VENDINVOICEJOUR_TAXWITHHOLDAMOUNT_IN' = 
         vij.taxwithholdamount_in, 
         'VENDINVOICEJOUR_TRANSITCONTROLVOUCHER_BR' = 
         vij.transitcontrolvoucher_br, 
         'VENDINVOICEJOUR_TRANSPORTATIONDOCUMENT' = 
         vij.transportationdocument, 
         'VENDINVOICEJOUR_TRIANGULATION' = 
         vij.triangulation, 
         'VENDINVOICEJOUR_UNITEDVATINVOICE_LT' = 
         vij.unitedvatinvoice_lt, 
         'VENDINVOICEJOUR_VATAMOUNT_IN' = vij.vatamount_in, 
         'VENDINVOICEJOUR_VATNUM' = vij.vatnum, 
         'VENDINVOICEJOUR_VATONPAYMENT_RU' = 
            vij.vatonpayment_ru, 
         'VENDINVOICEJOUR_VENDCONSINVOICE_JP' = 
         vij.vendconsinvoice_jp, 
         'VENDINVOICEJOUR_VENDFINALUSER_BR' = 
            vij.vendfinaluser_br, 
         'VENDINVOICEJOUR_VENDGROUP' = vij.vendgroup, 
         'VENDINVOICEJOUR_VENDINVOICEDECLARATION_IS' = 
         vij.vendinvoicedeclaration_is, 
         'VENDINVOICEJOUR_VENDINVOICEGROUP' = 
            vij.vendinvoicegroup, 
         'VENDINVOICEJOUR_VENDORREQUESTEDWORKEREMAIL' = 
         vij.vendorrequestedworkeremail, 
         'VENDINVOICEJOUR_VENDPAYMENTGROUP' = 
            vij.vendpaymentgroup, 
         'VENDINVOICEJOUR_VOLUME' = vij.volume, 
         'VENDINVOICEJOUR_WEIGHT' = vij.weight, 
         'VENDINVOICEJOUR_WHOISAUTHOR_LT' = 
            vij.whoisauthor_lt, 
         'VENDINVOICETRANS_ADVANCEAPPLICATIONID' 
            = 
         vit.advanceapplicationid, 
         'VENDINVOICETRANS_AGREEMENTLINE_PSN' = 
            vit.agreementline_psn, 
         'VENDINVOICETRANS_ALCOHOLLICENSESERIESNUM_RU' = 
         vit.alcohollicenseseriesnum_ru, 
         'VENDINVOICETRANS_ASSESSABLEVALUE_IN' = 
         vit.assessablevalue_in, 
         'VENDINVOICETRANS_COMPANYLOCATION_IN' = 
         vit.companylocation_in, 
         'VENDINVOICETRANS_COUNTRYREGIONNAME_RU' = 
         vit.countryregionname_ru, 
         'VENDINVOICETRANS_CREATEDDATETIME' = 
            vit.createddatetime, 
         'VENDINVOICETRANS_CREDITNOTEDATE_IN' = 
            vit.creditnotedate_in, 
         'VENDINVOICETRANS_CURRENCYCODE' = vit.currencycode, 
         'VENDINVOICETRANS_CUSTOMSTARIFFCODETABLE_IN' = 
         vit.customstariffcodetable_in, 
         'VENDINVOICETRANS_DATAAREAID' = vit.dataareaid, 
         'VENDINVOICETRANS_DEFAULTDIMENSION' = 
            vit.defaultdimension, 
         'VENDINVOICETRANS_DELIVERYNAME' = vit.deliveryname, 
         'VENDINVOICETRANS_DELIVERYPOSTALADDRESS' = 
         vit.deliverypostaladdress, 
         'VENDINVOICETRANS_DESCRIPTION' = vit.description, 
         'VENDINVOICETRANS_DESTCOUNTRYREGIONID' = 
         vit.destcountryregionid, 
         'VENDINVOICETRANS_DESTCOUNTY' = vit.destcounty, 
         'VENDINVOICETRANS_DESTSTATE' = vit.deststate, 
         'VENDINVOICETRANS_DISCAMOUNT' = vit.discamount, 
         'VENDINVOICETRANS_DISCPERCENT' = vit.discpercent, 
         'VENDINVOICETRANS_DSA_IN' = vit.dsa_in, 
         'VENDINVOICETRANS_EXCISEAMOUNT_RU' = 
            vit.exciseamount_ru, 
         'VENDINVOICETRANS_EXCISEAMOUNTMST_RU' = 
         vit.exciseamountmst_ru, 
         'VENDINVOICETRANS_EXCISERECORDTYPE_IN' = 
         vit.exciserecordtype_in, 
         'VENDINVOICETRANS_EXCISETARIFFCODES_IN' = 
         vit.excisetariffcodes_in, 
         'VENDINVOICETRANS_EXCISETYPE_IN' = 
         vit.excisetype_in, 
         'VENDINVOICETRANS_EXCISEVALUE_RU' = 
            vit.excisevalue_ru, 
         'VENDINVOICETRANS_EXTERNALITEMID' = 
            vit.externalitemid, 
         'VENDINVOICETRANS_FACTUREDFULLY_RU' = 
            vit.facturedfully_ru, 
         'VENDINVOICETRANS_FACTUREDQTY_RU' = 
            vit.facturedqty_ru, 
         'VENDINVOICETRANS_GTASERVICECATEGORY_IN' = 
         vit.gtaservicecategory_in, 
         'VENDINVOICETRANS_INTERCOMPANYINVENTTRANSID' = 
         vit.intercompanyinventtransid, 
         'VENDINVOICETRANS_INTERNALINVOICEID' = 
            vit.internalinvoiceid, 
         'VENDINVOICETRANS_INTRASTATDISPATCHID' = 
         vit.intrastatdispatchid, 
         'VENDINVOICETRANS_INTRASTATFULFILLMENTDATE_HU' = 
         vit.intrastatfulfillmentdate_hu, 
         'VENDINVOICETRANS_INVENTDATE' = vit.inventdate, 
         'VENDINVOICETRANS_INVENTDIMID' = vit.inventdimid, 
         'VENDINVOICETRANS_INVENTQTY' = vit.inventqty, 
         'VENDINVOICETRANS_INVENTREFID' = vit.inventrefid, 
         'VENDINVOICETRANS_INVENTREFTRANSID' = 
            vit.inventreftransid, 
         'VENDINVOICETRANS_INVENTREFTYPE' = 
         vit.inventreftype, 
         'VENDINVOICETRANS_INVENTTRANSID' = 
         vit.inventtransid, 
         'VENDINVOICETRANS_INVOICEDATE' = vit.invoicedate, 
         'VENDINVOICETRANS_INVOICEGTDID_RU' = 
            vit.invoicegtdid_ru, 
         'VENDINVOICETRANS_INVOICEID' = vit.invoiceid, 
         'VENDINVOICETRANS_ISPWP' = vit.ispwp, 
         'VENDINVOICETRANS_ITEMCODEID' = vit.itemcodeid, 
         'VENDINVOICETRANS_ITEMID' = vit.itemid, 
         'VENDINVOICETRANS_LEDGERDIMENSION' = 
            vit.ledgerdimension, 
         'VENDINVOICETRANS_LINEAMOUNT' = vit.lineamount, 
         'VENDINVOICETRANS_LINEAMOUNTMST' = 
         vit.lineamountmst, 
         'VENDINVOICETRANS_LINEAMOUNTMST_W' = 
            vit.lineamountmst_w, 
         'VENDINVOICETRANS_LINEAMOUNTTAX' = 
         vit.lineamounttax, 
         'VENDINVOICETRANS_LINEDISC' = vit.linedisc, 
         'VENDINVOICETRANS_LINENUM' = vit.linenum, 
         'VENDINVOICETRANS_LINEPERCENT' = vit.linepercent, 
         'VENDINVOICETRANS_LINETYPE' = vit.linetype, 
         'VENDINVOICETRANS_MARKUPCODE_RU' = 
         vit.markupcode_ru, 
         'VENDINVOICETRANS_MAXIMUMRETAILPRICE_IN' = 
         vit.maximumretailprice_in, 
         'VENDINVOICETRANS_MODIFIEDDATETIME' = 
            vit.modifieddatetime, 
         'VENDINVOICETRANS_MULTILNDISC' = vit.multilndisc, 
         'VENDINVOICETRANS_MULTILNPERCENT' = 
            vit.multilnpercent, 
         'VENDINVOICETRANS_NAME' = vit.NAME, 
         'VENDINVOICETRANS_NGPCODESTABLE_FR' = 
            vit.ngpcodestable_fr, 
         'VENDINVOICETRANS_NONRECOVERABLEPERCENT_IN' = 
         vit.nonrecoverablepercent_in, 
         'VENDINVOICETRANS_NUMBERSEQUENCEGROUP' = 
         vit.numbersequencegroup, 
         'VENDINVOICETRANS_OPERATIONTYPE_MX' = 
            vit.operationtype_mx, 
         'VENDINVOICETRANS_ORIGCOUNTRYREGIONID' = 
         vit.origcountryregionid, 
         'VENDINVOICETRANS_ORIGPURCHID' = vit.origpurchid, 
         'VENDINVOICETRANS_ORIGSTATEID' = vit.origstateid, 
         'VENDINVOICETRANS_PARTDELIVERY' = vit.partdelivery, 
         'VENDINVOICETRANS_PARTITION' = vit.partition, 
         'VENDINVOICETRANS_PDSCWQTY' = vit.pdscwqty, 
         'VENDINVOICETRANS_PDSCWQTYPHYSICAL' = 
            vit.pdscwqtyphysical, 
         'VENDINVOICETRANS_PORT' = vit.port, 
         'VENDINVOICETRANS_PRICEUNIT' = vit.priceunit, 
         'VENDINVOICETRANS_PROCUREMENTCATEGORY' = 
         vit.procurementcategory, 
         'VENDINVOICETRANS_PSARELEASEAMOUNT' = 
            vit.psareleaseamount, 
         'VENDINVOICETRANS_PSARETAINAGEAMOUNT' = 
         vit.psaretainageamount, 
         'VENDINVOICETRANS_PURCHASELINELINENUMBER' = 
         vit.purchaselinelinenumber, 
         'VENDINVOICETRANS_PURCHCOMMITMENTLINE_PSN' = 
         vit.purchcommitmentline_psn, 
         'VENDINVOICETRANS_PURCHID' = vit.purchid, 
         'VENDINVOICETRANS_PURCHMARKUP' = vit.purchmarkup, 
         'VENDINVOICETRANS_PURCHPRICE' = vit.purchprice, 
         'VENDINVOICETRANS_PURCHUNIT' = vit.purchunit, 
         'VENDINVOICETRANS_QTY' = vit.qty, 
         'VENDINVOICETRANS_QTYPHYSICAL' = vit.qtyphysical, 
         'VENDINVOICETRANS_RBOPACKAGELINENUM' = 
            vit.rbopackagelinenum, 
         'VENDINVOICETRANS_READYFORPAYMENT' = 
            vit.readyforpayment, 
         'VENDINVOICETRANS_REASONTABLEREF' = 
            vit.reasontableref, 
         'VENDINVOICETRANS_RECID' = vit.recid, 
         'VENDINVOICETRANS_RECVERSION' = vit.recversion, 
         'VENDINVOICETRANS_REFRETURNINVOICETRANS_W' = 
         vit.refreturninvoicetrans_w, 
         'VENDINVOICETRANS_REGISTRATIONPOSTALADDRESS_IN' = 
         vit.registrationpostaladdress_in, 
         'VENDINVOICETRANS_RETAILPACKAGEID' = 
            vit.retailpackageid, 
         'VENDINVOICETRANS_REVERSECHARGEAPPLIES_UK' = 
         vit.reversechargeapplies_uk, 
         'VENDINVOICETRANS_SALESTAXFORMTYPES_IN' = 
         vit.salestaxformtypes_in, 
         'VENDINVOICETRANS_SERVICECODETABLE_IN' = 
         vit.servicecodetable_in, 
         'VENDINVOICETRANS_SETTLETAX1099AMOUNT' = 
         vit.settletax1099amount, 
         'VENDINVOICETRANS_SETTLETAX1099STATEAMOUNT' = 
         vit.settletax1099stateamount, 
         'VENDINVOICETRANS_SOURCEDOCUMENTLINE' = 
         vit.sourcedocumentline, 
         'VENDINVOICETRANS_STATISTICVALUE_LT' = 
            vit.statisticvalue_lt, 
         'VENDINVOICETRANS_STATPROCID' = vit.statprocid, 
         'VENDINVOICETRANS_STOCKEDPRODUCT' = 
            vit.stockedproduct, 
         'VENDINVOICETRANS_TAX1099AMOUNT' = 
         vit.tax1099amount, 
         'VENDINVOICETRANS_TAX1099DATE' = vit.tax1099date, 
         'VENDINVOICETRANS_TAX1099FIELDS' = 
         vit.tax1099fields, 
         'VENDINVOICETRANS_TAX1099NUM' = vit.tax1099num, 
         'VENDINVOICETRANS_TAX1099RECID' = vit.tax1099recid, 
         'VENDINVOICETRANS_TAX1099STATE' = vit.tax1099state, 
         'VENDINVOICETRANS_TAX1099STATEAMOUNT' = 
         vit.tax1099stateamount, 
         'VENDINVOICETRANS_TAXAMOUNT' = vit.taxamount, 
         'VENDINVOICETRANS_TAXAMOUNTMST_W' = 
            vit.taxamountmst_w, 
         'VENDINVOICETRANS_TAXAUTOGENERATED' = 
            vit.taxautogenerated, 
         'VENDINVOICETRANS_TAXGROUP' = vit.taxgroup, 
         'VENDINVOICETRANS_TAXITEMGROUP' = vit.taxitemgroup, 
         'VENDINVOICETRANS_TAXWITHHOLDBASECUR_TH' = 
         vit.taxwithholdbasecur_th, 
         'VENDINVOICETRANS_TAXWITHHOLDGROUP_TH' = 
         vit.taxwithholdgroup_th, 
         'VENDINVOICETRANS_TAXWITHHOLDITEMGROUPHEADING_TH' = 
         vit.taxwithholditemgroupheading_th, 
         'VENDINVOICETRANS_TAXWITHHOLDLINENUM_IN' = 
         vit.taxwithholdlinenum_in, 
         'VENDINVOICETRANS_TAXWITHHOLDVOUCHER_IN' = 
         vit.taxwithholdvoucher_in, 
         'VENDINVOICETRANS_TAXWRITECODE' = vit.taxwritecode, 
         'VENDINVOICETRANS_TCSGROUP_IN' = vit.tcsgroup_in, 
         'VENDINVOICETRANS_TDSGROUP_IN' = vit.tdsgroup_in, 
         'VENDINVOICETRANS_TRANSACTIONCODE' = 
            vit.transactioncode, 
         'VENDINVOICETRANS_TRANSPORT' = vit.transport, 
         'VENDINVOICETRANS_VATAMOUNT_IN' = vit.vatamount_in, 
         'VENDINVOICETRANS_VATAMOUNT_RU' = vit.vatamount_ru, 
         'VENDINVOICETRANS_VATAMOUNTMST_RU' = 
            vit.vatamountmst_ru, 
         'VENDINVOICETRANS_VATDEFERRED_IN' = 
            vit.vatdeferred_in, 
         'VENDINVOICETRANS_VATDOCUMENTTYPE_RU' = 
         vit.vatdocumenttype_ru, 
         'VENDINVOICETRANS_VATEXPENSE_IN' = 
         vit.vatexpense_in, 
         'VENDINVOICETRANS_VATGOODSTYPE_IN' = 
            vit.vatgoodstype_in, 
         'VENDINVOICETRANS_VATVALUE_RU' = vit.vatvalue_ru, 
         'VENDINVOICETRANS_VENDDIRECTIVE_PSN' = 
            vit.venddirective_psn, 
         'VENDINVOICETRANS_VENDORLOCATION_IN' = 
            vit.vendorlocation_in, 
         'VENDINVOICETRANS_WEIGHT' = vit.weight, 
         'INVENTDIM_CONFIGID' = id.configid, 
         'INVENTDIM_CREATEDDATETIME' = id.createddatetime, 
         'INVENTDIM_DATAAREAID' = id.dataareaid, 
         'INVENTDIM_INVENTBATCHID' = id.inventbatchid, 
         'INVENTDIM_INVENTCOLORID' = id.inventcolorid, 
         'INVENTDIM_INVENTDIMID' = id.inventdimid, 
         'INVENTDIM_INVENTGTDID_RU' = id.inventgtdid_ru, 
         'INVENTDIM_INVENTLOCATIONID' = id.inventlocationid, 
         'INVENTDIM_INVENTOWNERID_RU' = id.inventownerid_ru, 
         'INVENTDIM_INVENTPROFILEID_RU' = 
            id.inventprofileid_ru, 
         'INVENTDIM_INVENTSERIALID' = id.inventserialid, 
         'INVENTDIM_INVENTSITEID' = id.inventsiteid, 
         'INVENTDIM_INVENTSIZEID' = id.inventsizeid, 
         'INVENTDIM_INVENTSTATUSID' = id.inventstatusid, 
         'INVENTDIM_INVENTSTYLEID' = id.inventstyleid, 
         'INVENTDIM_LICENSEPLATEID' = id.licenseplateid, 
         'INVENTDIM_MODIFIEDBY' = id.modifiedby, 
         'INVENTDIM_MODIFIEDDATETIME' = id.modifieddatetime, 
         'INVENTDIM_PARTITION' = id.partition, 
         'INVENTDIM_RECID' = id.recid, 
         'INVENTDIM_RECVERSION' = id.recversion, 
         'INVENTDIM_SHA1HASH' = id.sha1hash, 
         'INVENTDIM_WMSLOCATIONID' = id.wmslocationid, 
         'INVENTDIM_WMSPALLETID' = id.wmspalletid, 
         'ECORESCATEGORY_CATEGORYHIERARCHY' = 
            erc.categoryhierarchy, 
         'ECORESCATEGORY_CHANGESTATUS' = erc.changestatus, 
         'ECORESCATEGORY_CODE' = erc.code, 
         'ECORESCATEGORY_CREATEDBY' = erc.createdby, 
         'ECORESCATEGORY_CREATEDDATETIME' = 
            erc.createddatetime, 
         'ECORESCATEGORY_DEFAULTPROJECTGLOBALCATEGORY' = 
         erc.defaultprojectglobalcategory, 
         'ECORESCATEGORY_DEFAULTTHRESHOLD_PSN' = 
         erc.defaultthreshold_psn, 
         'ECORESCATEGORY_INSTANCERELATIONTYPE' = 
         erc.instancerelationtype, 
         'ECORESCATEGORY_ISACTIVE' = erc.isactive, 
         'ECORESCATEGORY_ISCATEGORYATTRIBUTESINHERITED' = 
         erc.iscategoryattributesinherited, 
         'ECORESCATEGORY_ISTANGIBLE' = erc.istangible, 
         'ECORESCATEGORY_LEVEL_' = erc.level_, 
         'ECORESCATEGORY_MODIFIEDBY' = erc.modifiedby, 
         'ECORESCATEGORY_MODIFIEDDATETIME' = 
            erc.modifieddatetime, 
         'ECORESCATEGORY_NAME' = erc.NAME, 
         'ECORESCATEGORY_NESTEDSETLEFT' = erc.nestedsetleft, 
         'ECORESCATEGORY_NESTEDSETRIGHT' = 
         erc.nestedsetright, 
         'ECORESCATEGORY_PARENTCATEGORY' = 
         erc.parentcategory, 
         'ECORESCATEGORY_PARTITION' = erc.partition, 
         'ECORESCATEGORY_PKWIUCODE' = erc.pkwiucode, 
         'ECORESCATEGORY_RECID' = erc.recid, 
         'ECORESCATEGORY_RECVERSION' = erc.recversion, 
         'ECORESCATEGORY_RELATIONTYPE' = erc.relationtype, 
         'ECORESCATEGORY_REUSEENABLED' = erc.reuseenabled 
  FROM   vendinvoicejour vij 
         INNER JOIN vendinvoicetrans vit 
                 ON vit.purchid = vij.purchid 
                    AND vit.invoiceid = vij.invoiceid 
                    AND vit.invoicedate = vij.invoicedate 
                    AND vit.numbersequencegroup = 
                        vij.numbersequencegroup 
                    AND vit.internalinvoiceid = 
                        vij.internalinvoiceid 
         INNER JOIN inventdim id 
                 ON id.inventdimid = vit.inventdimid 
                    AND id.dataareaid = vij.dataareaid 
                    AND id.partition = vij.partition 
         LEFT JOIN ecorescategory erc 
                ON erc.recid = vit.procurementcategory 
                   AND erc.partition = vij.partition 

go