Sales Order Invoice

CREATE VIEW [dbo].[vw_salesSalesInvoice] 
AS 
  SELECT 'CUSTINVOICEJOUR_BACKORDER' = cij.backorder, 
         'CUSTINVOICEJOUR_BANKLCEXPORTLINE' = 
            cij.banklcexportline, 
         'CUSTINVOICEJOUR_BILLOFLADINGID' = 
            cij.billofladingid, 
         'CUSTINVOICEJOUR_CASHDISC' = 
            cij.cashdisc, 
         'CUSTINVOICEJOUR_CASHDISCBASEDATE' = 
            cij.cashdiscbasedate, 
         'CUSTINVOICEJOUR_CASHDISCCODE' = cij.cashdisccode, 
         'CUSTINVOICEJOUR_CASHDISCDATE' = cij.cashdiscdate, 
         'CUSTINVOICEJOUR_CASHDISCPERCENT' = 
            cij.cashdiscpercent, 
         'CUSTINVOICEJOUR_CONTACTPERSONID' = 
            cij.contactpersonid, 
         'CUSTINVOICEJOUR_COVSTATUS' = cij.covstatus, 
         'CUSTINVOICEJOUR_CREATEDBY' = cij.createdby, 
         'CUSTINVOICEJOUR_CREATEDDATETIME' = 
            cij.createddatetime, 
         'CUSTINVOICEJOUR_CURRENCYCODE' = cij.currencycode, 
         'CUSTINVOICEJOUR_CUSTGROUP' = cij.custgroup, 
         'CUSTINVOICEJOUR_CUSTOMERREF' = cij.customerref, 
         'CUSTINVOICEJOUR_DATAAREAID' = cij.dataareaid, 
         'CUSTINVOICEJOUR_DEFAULTDIMENSION' = 
            cij.defaultdimension, 
         'CUSTINVOICEJOUR_DEL_CREATEDTIME' = 
            cij.del_createdtime, 
         'CUSTINVOICEJOUR_DELIVERYNAME' = cij.deliveryname, 
         'CUSTINVOICEJOUR_DELIVERYPOSTALADDRESS' = 
         cij.deliverypostaladdress, 
         'CUSTINVOICEJOUR_DIRECTDEBITMANDATE' = 
         cij.directdebitmandate, 
         'CUSTINVOICEJOUR_DLVMODE' = cij.dlvmode, 
         'CUSTINVOICEJOUR_DLVTERM' = cij.dlvterm, 
         'CUSTINVOICEJOUR_DOCUMENTDATE' = cij.documentdate, 
         'CUSTINVOICEJOUR_DOCUMENTNUM' = cij.documentnum, 
         'CUSTINVOICEJOUR_DUEDATE' = cij.duedate, 
         'CUSTINVOICEJOUR_EINVOICEACCOUNTCODE' = 
         cij.einvoiceaccountcode, 
         'CUSTINVOICEJOUR_EINVOICELINESPECIFIC' = 
         cij.einvoicelinespecific, 
         'CUSTINVOICEJOUR_ENDDISC' = cij.enddisc, 
         'CUSTINVOICEJOUR_ENDDISCMST' = cij.enddiscmst, 
         'CUSTINVOICEJOUR_ENTERPRISENUMBER' = 
            cij.enterprisenumber, 
         'CUSTINVOICEJOUR_EUSALESLIST' = cij.eusaleslist, 
         'CUSTINVOICEJOUR_EXCHRATE' = cij.exchrate, 
         'CUSTINVOICEJOUR_EXCHRATESECONDARY' = 
            cij.exchratesecondary, 
         'CUSTINVOICEJOUR_FIXEDDUEDATE' = cij.fixedduedate, 
         'CUSTINVOICEJOUR_GIROTYPE' = cij.girotype, 
         'CUSTINVOICEJOUR_INCLTAX' = cij.incltax, 
         'CUSTINVOICEJOUR_INTERCOMPANYCOMPANYID' = 
         cij.intercompanycompanyid, 
         'CUSTINVOICEJOUR_INTERCOMPANYPOSTED' = 
         cij.intercompanyposted, 
         'CUSTINVOICEJOUR_INTERCOMPANYPURCHID' = 
         cij.intercompanypurchid, 
         'CUSTINVOICEJOUR_INTRASTATDISPATCH' = 
            cij.intrastatdispatch, 
         'CUSTINVOICEJOUR_INTRASTATFULFILLMENTDATE_HU' = 
         cij.intrastatfulfillmentdate_hu, 
         'CUSTINVOICEJOUR_INVENTLOCATIONID' = 
            cij.inventlocationid, 
         'CUSTINVOICEJOUR_INVOICEACCOUNT' = 
            cij.invoiceaccount, 
         'CUSTINVOICEJOUR_INVOICEAMOUNT' = 
            cij.invoiceamount, 
         'CUSTINVOICEJOUR_INVOICEAMOUNTMST' = 
            cij.invoiceamountmst, 
         'CUSTINVOICEJOUR_INVOICEDATE' = cij.invoicedate, 
         'CUSTINVOICEJOUR_INVOICEID' = cij.invoiceid, 
         'CUSTINVOICEJOUR_INVOICEPOSTALADDRESS' = 
         cij.invoicepostaladdress, 
         'CUSTINVOICEJOUR_INVOICEROUNDOFF' = 
            cij.invoiceroundoff, 
         'CUSTINVOICEJOUR_INVOICEROUNDOFFMST' = 
         cij.invoiceroundoffmst, 
         'CUSTINVOICEJOUR_INVOICINGNAME' = 
         cij.invoicingname, 
         'CUSTINVOICEJOUR_ISCORRECTION' = 
         cij.iscorrection, 
         'CUSTINVOICEJOUR_LANGUAGEID' = cij.languageid, 
         'CUSTINVOICEJOUR_LEDGERVOUCHER' = 
         cij.ledgervoucher, 
         'CUSTINVOICEJOUR_LISTCODE' = 
         cij.listcode, 
         'CUSTINVOICEJOUR_LOG' = cij.log, 
         'CUSTINVOICEJOUR_MCRDUEAMOUNT' = cij.mcrdueamount, 
         'CUSTINVOICEJOUR_MCREMAIL' = cij.mcremail, 
         'CUSTINVOICEJOUR_MCRPAYMAMOUNT' = 
         cij.mcrpaymamount, 
         'CUSTINVOICEJOUR_MODIFIEDDATETIME' = 
            cij.modifieddatetime, 
         'CUSTINVOICEJOUR_NUMBERSEQUENCEGROUP' = 
         cij.numbersequencegroup, 
         'CUSTINVOICEJOUR_ONACCOUNTAMOUNT' = 
            cij.onaccountamount, 
         'CUSTINVOICEJOUR_ONETIMECUSTOMER' = 
            cij.onetimecustomer, 
         'CUSTINVOICEJOUR_ORDERACCOUNT' = cij.orderaccount, 
         'CUSTINVOICEJOUR_PARMID' = cij.parmid, 
         'CUSTINVOICEJOUR_PARTITION' = cij.partition, 
         'CUSTINVOICEJOUR_PAYMDAYID' = cij.paymdayid, 
         'CUSTINVOICEJOUR_PAYMENT' = cij.payment, 
         'CUSTINVOICEJOUR_PAYMENTSCHED' = cij.paymentsched, 
         'CUSTINVOICEJOUR_PAYMID' = cij.paymid, 
         'CUSTINVOICEJOUR_POSTINGPROFILE' = 
            cij.postingprofile, 
         'CUSTINVOICEJOUR_PREPAYMENT' = 
            cij.prepayment, 
         'CUSTINVOICEJOUR_PRINTEDORIGINALS' = 
            cij.printedoriginals, 
         'CUSTINVOICEJOUR_PRINTMGMTSITEID' = 
            cij.printmgmtsiteid, 
         'CUSTINVOICEJOUR_PROFORMA' = cij.proforma, 
         'CUSTINVOICEJOUR_PURCHASEORDER' = 
         cij.purchaseorder, 
         'CUSTINVOICEJOUR_QTY' = cij.qty, 
         'CUSTINVOICEJOUR_RCSALESLIST_UK' = 
            cij.rcsaleslist_uk, 
         'CUSTINVOICEJOUR_REASONTABLEREF' = 
            cij.reasontableref, 
         'CUSTINVOICEJOUR_RECEIPTDATECONFIRMED_ES' = 
         cij.receiptdateconfirmed_es, 
         'CUSTINVOICEJOUR_RECID' = cij.recid, 
         'CUSTINVOICEJOUR_RECVERSION' = cij.recversion, 
         'CUSTINVOICEJOUR_REFNUM' = cij.refnum, 
         'CUSTINVOICEJOUR_RETURNITEMNUM' = 
         cij.returnitemnum, 
         'CUSTINVOICEJOUR_RETURNREASONCODEID' = 
         cij.returnreasoncodeid, 
         'CUSTINVOICEJOUR_RETURNSTATUS' = cij.returnstatus, 
         'CUSTINVOICEJOUR_REVERSECHARGE_UK' = 
            cij.reversecharge_uk, 
         'CUSTINVOICEJOUR_REVERSEDRECID' = 
         cij.reversedrecid, 
         'CUSTINVOICEJOUR_SALESBALANCE' = 
         cij.salesbalance, 
         'CUSTINVOICEJOUR_SALESBALANCEMST' = 
            cij.salesbalancemst, 
         'CUSTINVOICEJOUR_SALESID' = cij.salesid, 
         'CUSTINVOICEJOUR_SALESORIGINID' = 
         cij.salesoriginid, 
         'CUSTINVOICEJOUR_SALESTYPE' = 
         cij.salestype, 
         'CUSTINVOICEJOUR_SOURCEDOCUMENTHEADER' = 
         cij.sourcedocumentheader, 
         'CUSTINVOICEJOUR_SOURCEDOCUMENTLINE' = 
         cij.sourcedocumentline, 
         'CUSTINVOICEJOUR_SUMLINEDISC' = cij.sumlinedisc, 
         'CUSTINVOICEJOUR_SUMLINEDISCMST' = 
            cij.sumlinediscmst, 
         'CUSTINVOICEJOUR_SUMMARKUP' = 
            cij.summarkup, 
         'CUSTINVOICEJOUR_SUMMARKUPMST' = cij.summarkupmst, 
         'CUSTINVOICEJOUR_SUMTAX' = cij.sumtax, 
         'CUSTINVOICEJOUR_SUMTAXMST' = cij.sumtaxmst, 
         'CUSTINVOICEJOUR_TAXGROUP' = cij.taxgroup, 
         'CUSTINVOICEJOUR_TAXINVOICESALESID' = 
            cij.taxinvoicesalesid, 
         'CUSTINVOICEJOUR_TAXITEMGROUP' = cij.taxitemgroup, 
         'CUSTINVOICEJOUR_TAXPRINTONINVOICE' = 
            cij.taxprintoninvoice, 
         'CUSTINVOICEJOUR_TAXSPECIFYBYLINE' = 
            cij.taxspecifybyline, 
         'CUSTINVOICEJOUR_TRANSPORTATIONDOCUMENT' = 
         cij.transportationdocument, 
         'CUSTINVOICEJOUR_TRIANGULATION' = 
         cij.triangulation, 
         'CUSTINVOICEJOUR_UPDATED' = 
         cij.updated, 
         'CUSTINVOICEJOUR_VATNUM' = cij.vatnum, 
         'CUSTINVOICEJOUR_VOLUME' = cij.volume, 
         'CUSTINVOICEJOUR_WEIGHT' = cij.weight, 
         'CUSTINVOICEJOUR_WORKERSALESTAKER' = 
            cij.workersalestaker, 
         'CUSTINVOICETRANS_ASSETBOOKID' = cit.assetbookid, 
         'CUSTINVOICETRANS_ASSETID' = cit.assetid, 
         'CUSTINVOICETRANS_BILLINGCODE' = cit.billingcode, 
         'CUSTINVOICETRANS_COMMISSAMOUNTCUR' = 
            cit.commissamountcur, 
         'CUSTINVOICETRANS_COMMISSAMOUNTMST' = 
            cit.commissamountmst, 
         'CUSTINVOICETRANS_COMMISSCALC' = cit.commisscalc, 
         'CUSTINVOICETRANS_COUNTRYREGIONOFSHIPMENT' = 
         cit.countryregionofshipment, 
         'CUSTINVOICETRANS_CREATEDBY' = cit.createdby, 
         'CUSTINVOICETRANS_CREATEDDATETIME' = 
            cit.createddatetime, 
         'CUSTINVOICETRANS_CURRENCYCODE' = cit.currencycode, 
         'CUSTINVOICETRANS_CUSTINVOICELINEIDREF' = 
         cit.custinvoicelineidref, 
         'CUSTINVOICETRANS_CUSTOMERLINENUM' = 
            cit.customerlinenum, 
         'CUSTINVOICETRANS_DATAAREAID' = cit.dataareaid, 
         'CUSTINVOICETRANS_DEFAULTDIMENSION' = 
            cit.defaultdimension, 
         'CUSTINVOICETRANS_DEL_CREATEDTIME' = 
            cit.del_createdtime, 
         'CUSTINVOICETRANS_DELIVERYPOSTALADDRESS' = 
         cit.deliverypostaladdress, 
         'CUSTINVOICETRANS_DELIVERYTYPE' = cit.deliverytype, 
         'CUSTINVOICETRANS_DISCAMOUNT' = cit.discamount, 
         'CUSTINVOICETRANS_DISCPERCENT' = cit.discpercent, 
         'CUSTINVOICETRANS_DLVDATE' = cit.dlvdate, 
         'CUSTINVOICETRANS_EINVOICEACCOUNTCODE' = 
         cit.einvoiceaccountcode, 
         'CUSTINVOICETRANS_EXTERNALITEMID' = 
            cit.externalitemid, 
         'CUSTINVOICETRANS_INTERCOMPANYINVENTTRANSID' = 
         cit.intercompanyinventtransid, 
         'CUSTINVOICETRANS_INTRASTATDISPATCHID' = 
         cit.intrastatdispatchid, 
         'CUSTINVOICETRANS_INTRASTATFULFILLMENTDATE_HU' = 
         cit.intrastatfulfillmentdate_hu, 
         'CUSTINVOICETRANS_INVENTDIMID' = cit.inventdimid, 
         'CUSTINVOICETRANS_INVENTQTY' = cit.inventqty, 
         'CUSTINVOICETRANS_INVENTREFID' = cit.inventrefid, 
         'CUSTINVOICETRANS_INVENTREFTRANSID' = 
            cit.inventreftransid, 
         'CUSTINVOICETRANS_INVENTREFTYPE' = 
         cit.inventreftype, 
         'CUSTINVOICETRANS_INVENTTRANSID' = 
         cit.inventtransid, 
         'CUSTINVOICETRANS_INVOICEDATE' = cit.invoicedate, 
         'CUSTINVOICETRANS_INVOICEID' = cit.invoiceid, 
         'CUSTINVOICETRANS_ITEMCODEID' = cit.itemcodeid, 
         'CUSTINVOICETRANS_ITEMID' = cit.itemid, 
         'CUSTINVOICETRANS_LEDGERDIMENSION' = 
            cit.ledgerdimension, 
         'CUSTINVOICETRANS_LINEAMOUNT' = cit.lineamount, 
         'CUSTINVOICETRANS_LINEAMOUNTMST' = 
         cit.lineamountmst, 
         'CUSTINVOICETRANS_LINEAMOUNTTAX' = 
         cit.lineamounttax, 
         'CUSTINVOICETRANS_LINEAMOUNTTAXMST' = 
            cit.lineamounttaxmst, 
         'CUSTINVOICETRANS_LINEDISC' = cit.linedisc, 
         'CUSTINVOICETRANS_LINEHEADER' = cit.lineheader, 
         'CUSTINVOICETRANS_LINENUM' = cit.linenum, 
         'CUSTINVOICETRANS_LINEPERCENT' = cit.linepercent, 
         'CUSTINVOICETRANS_MCRDELIVERYNAME' = 
            cit.mcrdeliveryname, 
         'CUSTINVOICETRANS_MCRDLVMODE' = cit.mcrdlvmode, 
         'CUSTINVOICETRANS_MODIFIEDDATETIME' = 
            cit.modifieddatetime, 
         'CUSTINVOICETRANS_MULTILNDISC' = cit.multilndisc, 
         'CUSTINVOICETRANS_MULTILNPERCENT' = 
            cit.multilnpercent, 
         'CUSTINVOICETRANS_NAME' = cit.NAME, 
         'CUSTINVOICETRANS_NGPCODESTABLE_FR' = 
            cit.ngpcodestable_fr, 
         'CUSTINVOICETRANS_NUMBERSEQUENCEGROUP' = 
         cit.numbersequencegroup, 
         'CUSTINVOICETRANS_OLAPCOSTVALUE' = 
         cit.olapcostvalue, 
         'CUSTINVOICETRANS_ORIGCOUNTRYREGIONID' = 
         cit.origcountryregionid, 
         'CUSTINVOICETRANS_ORIGSALESID' = cit.origsalesid, 
         'CUSTINVOICETRANS_ORIGSTATE' = cit.origstate, 
         'CUSTINVOICETRANS_PARENTRECID' = cit.parentrecid, 
         'CUSTINVOICETRANS_PARTDELIVERY' = cit.partdelivery, 
         'CUSTINVOICETRANS_PARTITION' = cit.partition, 
         'CUSTINVOICETRANS_PDSCWQTY' = cit.pdscwqty, 
         'CUSTINVOICETRANS_PDSCWQTYPHYSICAL' = 
            cit.pdscwqtyphysical, 
         'CUSTINVOICETRANS_PDSCWREMAIN' = cit.pdscwremain, 
         'CUSTINVOICETRANS_PORT' = cit.port, 
         'CUSTINVOICETRANS_PRICEUNIT' = cit.priceunit, 
         'CUSTINVOICETRANS_QTY' = cit.qty, 
         'CUSTINVOICETRANS_QTYPHYSICAL' = cit.qtyphysical, 
         'CUSTINVOICETRANS_REASONREFRECID' = 
            cit.reasonrefrecid, 
         'CUSTINVOICETRANS_RECID' = cit.recid, 
         'CUSTINVOICETRANS_RECVERSION' = cit.recversion, 
         'CUSTINVOICETRANS_REMAIN' = cit.remain, 
         'CUSTINVOICETRANS_REMAINBEFORE' = cit.remainbefore, 
         'CUSTINVOICETRANS_RETAILCATEGORY' = 
            cit.retailcategory, 
         'CUSTINVOICETRANS_RETURNARRIVALDATE' = 
            cit.returnarrivaldate, 
         'CUSTINVOICETRANS_RETURNCLOSEDDATE' = 
            cit.returncloseddate, 
         'CUSTINVOICETRANS_RETURNDISPOSITIONCODEID' = 
         cit.returndispositioncodeid, 
         'CUSTINVOICETRANS_REVERSECHARGEAPPLIES_UK' = 
         cit.reversechargeapplies_uk, 
         'CUSTINVOICETRANS_REVERSEDRECID' = 
         cit.reversedrecid, 
         'CUSTINVOICETRANS_SALESCATEGORY' = 
         cit.salescategory, 
         'CUSTINVOICETRANS_SALESGROUP' = cit.salesgroup, 
         'CUSTINVOICETRANS_SALESID' = cit.salesid, 
         'CUSTINVOICETRANS_SALESMARKUP' = cit.salesmarkup, 
         'CUSTINVOICETRANS_SALESPRICE' = cit.salesprice, 
         'CUSTINVOICETRANS_SALESUNIT' = cit.salesunit, 
         'CUSTINVOICETRANS_SOURCEDOCUMENTLINE' = 
         cit.sourcedocumentline, 
         'CUSTINVOICETRANS_STATLINEAMOUNTMST' = 
            cit.statlineamountmst, 
         'CUSTINVOICETRANS_STATPROCID' = cit.statprocid, 
         'CUSTINVOICETRANS_STOCKEDPRODUCT' = 
            cit.stockedproduct, 
         'CUSTINVOICETRANS_SUMLINEDISC' = cit.sumlinedisc, 
         'CUSTINVOICETRANS_SUMLINEDISCMST' = 
            cit.sumlinediscmst, 
         'CUSTINVOICETRANS_TAXAMOUNT' = cit.taxamount, 
         'CUSTINVOICETRANS_TAXAMOUNTMST' = cit.taxamountmst, 
         'CUSTINVOICETRANS_TAXAUTOGENERATED' = 
            cit.taxautogenerated, 
         'CUSTINVOICETRANS_TAXGROUP' = cit.taxgroup, 
         'CUSTINVOICETRANS_TAXITEMGROUP' = cit.taxitemgroup, 
         'CUSTINVOICETRANS_TAXWITHHOLDGROUP_TH' = 
         cit.taxwithholdgroup_th, 
         'CUSTINVOICETRANS_TAXWITHHOLDITEMGROUPHEADING_TH' = 
         cit.taxwithholditemgroupheading_th, 
         'CUSTINVOICETRANS_TAXWRITECODE' = cit.taxwritecode, 
         'CUSTINVOICETRANS_TRANSACTIONCODE' = 
            cit.transactioncode, 
         'CUSTINVOICETRANS_TRANSPORT' = cit.transport, 
         'CUSTINVOICETRANS_WEIGHT' = cit.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   custinvoicejour cij 
         INNER JOIN custinvoicetrans cit 
                 ON cit.salesid = cij.salesid 
                    AND cit.invoiceid = cij.invoiceid 
                    AND cit.invoicedate = cij.invoicedate 
                    AND cit.numbersequencegroup = 
                        cij.numbersequencegroup 
                    AND cit.dataareaid = cij.dataareaid 
                    AND cit.partition = cij.partition 
         INNER JOIN inventdim id 
                 ON id.inventdimid = cit.inventdimid 
                    AND id.dataareaid = cit.dataareaid 
                    AND id.partition = cit.partition 
         LEFT JOIN ecorescategory erc 
                ON erc.recid = cit.salescategory 
                   AND erc.partition = cit.partition 

go