Purchase Order Confirmations

CREATE VIEW [dbo].[vw_purchPurchConfirm] 
AS 
  SELECT 'VENDPURCHORDERJOUR_AMOUNT' = vpoj.amount, 
         'VENDPURCHORDERJOUR_AMOUNTPREPAY' = 
            vpoj.amountprepay, 
  'VENDPURCHORDERJOUR_AMOUNTPURCHASEORDER' = 
  vpoj.amountpurchaseorder, 
  'VENDPURCHORDERJOUR_CONFIRMINGPO' = vpoj.confirmingpo, 
  'VENDPURCHORDERJOUR_COUNTRYREGIONID' = 
         vpoj.countryregionid, 
  'VENDPURCHORDERJOUR_DATAAREAID' = vpoj.dataareaid, 
  'VENDPURCHORDERJOUR_DELIVERYNAME' = vpoj.deliveryname, 
  'VENDPURCHORDERJOUR_DELIVERYPOSTALADDRESS' = 
  vpoj.deliverypostaladdress, 
  'VENDPURCHORDERJOUR_ENDDISC' = vpoj.enddisc, 
  'VENDPURCHORDERJOUR_EXCHRATE' = vpoj.exchrate, 
  'VENDPURCHORDERJOUR_EXCHRATESECONDARY' = 
  vpoj.exchratesecondary, 
  'VENDPURCHORDERJOUR_INTERCOMPANYPOSTED' = 
  vpoj.intercompanyposted, 
  'VENDPURCHORDERJOUR_ISPREPAY' = vpoj.isprepay, 
  'VENDPURCHORDERJOUR_ORDERACCOUNT' = vpoj.orderaccount, 
  'VENDPURCHORDERJOUR_PARMID' = vpoj.parmid, 
  'VENDPURCHORDERJOUR_PARTITION' = vpoj.partition, 
  'VENDPURCHORDERJOUR_PURCHASEORDERID' = 
         vpoj.purchaseorderid, 
  'VENDPURCHORDERJOUR_PURCHASEORDERVOUCHER' = 
  vpoj.purchaseordervoucher, 
  'VENDPURCHORDERJOUR_PURCHID' = vpoj.purchid, 
  'VENDPURCHORDERJOUR_PURCHORDERDATE' = vpoj.purchorderdate, 
  'VENDPURCHORDERJOUR_PURCHORDERDOCNUM' = 
  vpoj.purchorderdocnum, 
  'VENDPURCHORDERJOUR_PURCHTABLEHISTORY' = 
  vpoj.purchtablehistory, 
  'VENDPURCHORDERJOUR_PURCHTABLEVERSION' = 
  vpoj.purchtableversion, 
  'VENDPURCHORDERJOUR_QTY' = vpoj.qty, 
  'VENDPURCHORDERJOUR_RECID' = vpoj.recid, 
  'VENDPURCHORDERJOUR_RECVERSION' = vpoj.recversion, 
  'VENDPURCHORDERJOUR_ROUNDOFF' = vpoj.roundoff, 
  'VENDPURCHORDERJOUR_SALESORDERBALANCE' = 
  vpoj.salesorderbalance, 
  'VENDPURCHORDERJOUR_SUMLINEDISC' = vpoj.sumlinedisc, 
  'VENDPURCHORDERJOUR_SUMMARKUP' = vpoj.summarkup, 
  'VENDPURCHORDERJOUR_SUMTAX' = vpoj.sumtax, 
  'VENDPURCHORDERJOUR_TRIANGULATION' = vpoj.triangulation, 
  'VENDPURCHORDERJOUR_VOLUME' = vpoj.volume, 
  'VENDPURCHORDERJOUR_WEIGHT' = vpoj.weight, 
  'PURCHTABLEALLVERSIONS_ACCOUNTINGDATE' = 
            ptav.accountingdate, 
  'PURCHTABLEALLVERSIONS_ACCOUNTINGDISTRIBUTIONTEMPLATE' = 
  ptav.accountingdistributiontemplate, 
  'PURCHTABLEALLVERSIONS_ADDRESSREFRECID' = 
  ptav.addressrefrecid, 
  'PURCHTABLEALLVERSIONS_ADDRESSREFTABLEID' = 
  ptav.addressreftableid, 
  'PURCHTABLEALLVERSIONS_AGREEMENTHEADEREXT_RU' = 
  ptav.agreementheaderext_ru, 
  'PURCHTABLEALLVERSIONS_AUTOSUMMARYMODULETYPE' = 
  ptav.autosummarymoduletype, 
  'PURCHTABLEALLVERSIONS_BANKCENTRALBANKPURPOSECODE' = 
  ptav.bankcentralbankpurposecode, 
  'PURCHTABLEALLVERSIONS_BANKCENTRALBANKPURPOSETEXT' = 
  ptav.bankcentralbankpurposetext, 
  'PURCHTABLEALLVERSIONS_BANKDOCUMENTTYPE' = 
  ptav.bankdocumenttype, 
  'PURCHTABLEALLVERSIONS_CASHDISC' = ptav.cashdisc, 
  'PURCHTABLEALLVERSIONS_CASHDISCPERCENT' = 
  ptav.cashdiscpercent, 
  'PURCHTABLEALLVERSIONS_CONFIRMEDDLVEARLIEST' = 
  ptav.confirmeddlvearliest, 
  'PURCHTABLEALLVERSIONS_CONSIGNEEACCOUNT_RU' = 
  ptav.consigneeaccount_ru, 
  'PURCHTABLEALLVERSIONS_CONSIGNORACCOUNT_RU' = 
  ptav.consignoraccount_ru, 
  'PURCHTABLEALLVERSIONS_CONTACTPERSONID' = 
  ptav.contactpersonid, 
  'PURCHTABLEALLVERSIONS_COUNTYORIGDEST' = 
            ptav.countyorigdest, 
  'PURCHTABLEALLVERSIONS_COVSTATUS' = 
            ptav.covstatus, 
  'PURCHTABLEALLVERSIONS_CURRENCYCODE' = ptav.currencycode, 
  'PURCHTABLEALLVERSIONS_DATAAREAID' = ptav.dataareaid, 
  'PURCHTABLEALLVERSIONS_DEFAULTDIMENSION' = 
  ptav.defaultdimension, 
  'PURCHTABLEALLVERSIONS_DELIVERYDATE' = ptav.deliverydate, 
  'PURCHTABLEALLVERSIONS_DELIVERYNAME' = ptav.deliveryname, 
  'PURCHTABLEALLVERSIONS_DELIVERYPOSTALADDRESS' = 
  ptav.deliverypostaladdress, 
  'PURCHTABLEALLVERSIONS_DELIVERYTYPE' = ptav.deliverytype, 
  'PURCHTABLEALLVERSIONS_DISCPERCENT' = ptav.discpercent, 
  'PURCHTABLEALLVERSIONS_DLVMODE' = ptav.dlvmode, 
  'PURCHTABLEALLVERSIONS_DLVTERM' = ptav.dlvterm, 
  'PURCHTABLEALLVERSIONS_DOCUMENTSTATE' = 
         ptav.documentstate, 
  'PURCHTABLEALLVERSIONS_DOCUMENTSTATUS' = 
            ptav.documentstatus, 
  'PURCHTABLEALLVERSIONS_EMAIL' = ptav.email, 
  'PURCHTABLEALLVERSIONS_EMPLACCOUNT_RU' = 
            ptav.emplaccount_ru, 
  'PURCHTABLEALLVERSIONS_ENDDISC' = 
            ptav.enddisc, 
  'PURCHTABLEALLVERSIONS_ENTERPRISENUMBER' = 
  ptav.enterprisenumber, 
  'PURCHTABLEALLVERSIONS_FIXEDDUEDATE' = ptav.fixedduedate, 
  'PURCHTABLEALLVERSIONS_FREIGHTSLIPTYPE' = 
  ptav.freightsliptype, 
  'PURCHTABLEALLVERSIONS_FREIGHTZONE' = ptav.freightzone, 
  'PURCHTABLEALLVERSIONS_INCLTAX' = ptav.incltax, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYALLOWINDIRECTCREATION' 
         = 
  ptav.intercompanyallowindirectcreation, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYCOMPANYID' = 
  ptav.intercompanycompanyid, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYCUSTPURCHORDERFORMNUM' 
         = 
  ptav.intercompanycustpurchorderformnum, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYDIRECTDELIVERY' = 
  ptav.intercompanydirectdelivery, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYORDER' = 
  ptav.intercompanyorder, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYORIGIN' = 
  ptav.intercompanyorigin, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYORIGINALCUSTACCOUNT' = 
  ptav.intercompanyoriginalcustaccount, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYORIGINALSALESID' = 
  ptav.intercompanyoriginalsalesid, 
  'PURCHTABLEALLVERSIONS_INTERCOMPANYSALESID' = 
  ptav.intercompanysalesid, 
  'PURCHTABLEALLVERSIONS_INVENTLOCATIONID' = 
  ptav.inventlocationid, 
  'PURCHTABLEALLVERSIONS_INVENTPROFILEID_RU' = 
  ptav.inventprofileid_ru, 
  'PURCHTABLEALLVERSIONS_INVENTPROFILETYPE_RU' = 
  ptav.inventprofiletype_ru, 
  'PURCHTABLEALLVERSIONS_INVENTSITEID' = ptav.inventsiteid, 
  'PURCHTABLEALLVERSIONS_INVOICEACCOUNT' = 
            ptav.invoiceaccount, 
  'PURCHTABLEALLVERSIONS_ISARCHIVED' = 
            ptav.isarchived, 
  'PURCHTABLEALLVERSIONS_ISENCUMBRANCEREQUIRED' = 
  ptav.isencumbrancerequired, 
  'PURCHTABLEALLVERSIONS_ITEMBUYERGROUPID' = 
  ptav.itembuyergroupid, 
  'PURCHTABLEALLVERSIONS_LANGUAGEID' = ptav.languageid, 
  'PURCHTABLEALLVERSIONS_LINEDISC' = ptav.linedisc, 
  'PURCHTABLEALLVERSIONS_LISTCODE' = ptav.listcode, 
  'PURCHTABLEALLVERSIONS_MARKUPGROUP' = ptav.markupgroup, 
  'PURCHTABLEALLVERSIONS_MATCHINGAGREEMENT' = 
  ptav.matchingagreement, 
  'PURCHTABLEALLVERSIONS_MULTILINEDISC' = 
         ptav.multilinedisc, 
  'PURCHTABLEALLVERSIONS_NUMBERSEQUENCEGROUP' = 
  ptav.numbersequencegroup, 
  'PURCHTABLEALLVERSIONS_ONETIMEVENDOR' = 
         ptav.onetimevendor, 
  'PURCHTABLEALLVERSIONS_ORDERACCOUNT' = 
         ptav.orderaccount, 
  'PURCHTABLEALLVERSIONS_PARTITION' = ptav.partition, 
  'PURCHTABLEALLVERSIONS_PAYMENT' = ptav.payment, 
  'PURCHTABLEALLVERSIONS_PAYMENTSCHED' = ptav.paymentsched, 
  'PURCHTABLEALLVERSIONS_PAYMMODE' = ptav.paymmode, 
  'PURCHTABLEALLVERSIONS_PAYMSPEC' = ptav.paymspec, 
  'PURCHTABLEALLVERSIONS_PORT' = ptav.port, 
  'PURCHTABLEALLVERSIONS_POSTINGPROFILE' = 
            ptav.postingprofile, 
  'PURCHTABLEALLVERSIONS_PRICEAGREEMENTDATE_RU' 
            = 
  ptav.priceagreementdate_ru, 
  'PURCHTABLEALLVERSIONS_PRICEGROUPID' = ptav.pricegroupid, 
  'PURCHTABLEALLVERSIONS_PROFORMA' = ptav.proforma, 
  'PURCHTABLEALLVERSIONS_PROJID' = ptav.projid, 
  'PURCHTABLEALLVERSIONS_PURCHASETYPE' = ptav.purchasetype, 
  'PURCHTABLEALLVERSIONS_PURCHID' = ptav.purchid, 
  'PURCHTABLEALLVERSIONS_PURCHNAME' = ptav.purchname, 
  'PURCHTABLEALLVERSIONS_PURCHPOOLID' = ptav.purchpoolid, 
  'PURCHTABLEALLVERSIONS_PURCHSTATUS' = ptav.purchstatus, 
  'PURCHTABLEALLVERSIONS_PURCHTABLEVERSIONRECID' = 
  ptav.purchtableversionrecid, 
  'PURCHTABLEALLVERSIONS_REASONTABLEREF' = 
            ptav.reasontableref, 
  'PURCHTABLEALLVERSIONS_RECID' = ptav.recid, 
  'PURCHTABLEALLVERSIONS_REQATTENTION' = ptav.reqattention, 
  'PURCHTABLEALLVERSIONS_REQUESTER' = ptav.requester, 
  'PURCHTABLEALLVERSIONS_RETURNITEMNUM' = 
         ptav.returnitemnum, 
  'PURCHTABLEALLVERSIONS_RETURNREASONCODEID' = 
  ptav.returnreasoncodeid, 
  'PURCHTABLEALLVERSIONS_RETURNREPLACEMENTCREATED' = 
  ptav.returnreplacementcreated, 
  'PURCHTABLEALLVERSIONS_SETTLEVOUCHER' = 
         ptav.settlevoucher, 
  'PURCHTABLEALLVERSIONS_SOURCEDOCUMENTHEADER' 
         = 
  ptav.sourcedocumentheader, 
  'PURCHTABLEALLVERSIONS_SOURCEDOCUMENTLINE' = 
  ptav.sourcedocumentline, 
  'PURCHTABLEALLVERSIONS_STATPROCID' = ptav.statprocid, 
  'PURCHTABLEALLVERSIONS_TAXGROUP' = ptav.taxgroup, 
  'PURCHTABLEALLVERSIONS_TRANSACTIONCODE' = 
  ptav.transactioncode, 
  'PURCHTABLEALLVERSIONS_TRANSPORT' = ptav.transport, 
  'PURCHTABLEALLVERSIONS_TRANSPORTATIONDOCUMENT' = 
  ptav.transportationdocument, 
  'PURCHTABLEALLVERSIONS_UnionAllBranchId' = 
  ptav.unionallbranchid, 
  'PURCHTABLEALLVERSIONS_URL' = ptav.url, 
  'PURCHTABLEALLVERSIONS_VATCHARGESOURCE_RU' = 
  ptav.vatchargesource_ru, 
  'PURCHTABLEALLVERSIONS_VATNUM' = ptav.vatnum, 
  'PURCHTABLEALLVERSIONS_VATOPERATIONCODE_RU' = 
  ptav.vatoperationcode_ru, 
  'PURCHTABLEALLVERSIONS_VENDGROUP' = ptav.vendgroup, 
  'PURCHTABLEALLVERSIONS_VENDINVOICEDECLARATION_IS' = 
  ptav.vendinvoicedeclaration_is, 
  'PURCHTABLEALLVERSIONS_VENDORREF' = ptav.vendorref, 
  'PURCHTABLEALLVERSIONS_VERSIONDATETIME' = 
  ptav.versiondatetime, 
  'PURCHTABLEALLVERSIONS_WORKERPURCHPLACER' = 
  ptav.workerpurchplacer, 
  'PURCHLINEALLVERSIONS_ACCOUNTINGDISTRIBUTIONTEMPLATE' = 
  plav.accountingdistributiontemplate, 
  'PURCHLINEALLVERSIONS_ACTIVITYNUMBER' = 
         plav.activitynumber, 
  'PURCHLINEALLVERSIONS_ADDRESSREFRECID' = 
  plav.addressrefrecid, 
  'PURCHLINEALLVERSIONS_ADDRESSREFTABLEID' = 
  plav.addressreftableid, 
  'PURCHLINEALLVERSIONS_ASSETBOOKID' = plav.assetbookid, 
  'PURCHLINEALLVERSIONS_ASSETGROUP' = plav.assetgroup, 
  'PURCHLINEALLVERSIONS_ASSETID' = plav.assetid, 
  'PURCHLINEALLVERSIONS_ASSETTRANSTYPEPURCH' = 
  plav.assettranstypepurch, 
  'PURCHLINEALLVERSIONS_BARCODE' = plav.barcode, 
  'PURCHLINEALLVERSIONS_BARCODETYPE' = plav.barcodetype, 
  'PURCHLINEALLVERSIONS_BLOCKED' = plav.blocked, 
  'PURCHLINEALLVERSIONS_CASETAGGING' = plav.casetagging, 
  'PURCHLINEALLVERSIONS_COMPLETE' = plav.complete, 
  'PURCHLINEALLVERSIONS_CONFIRMEDDLV' = plav.confirmeddlv, 
  'PURCHLINEALLVERSIONS_CONFIRMEDTAXAMOUNT' = 
  plav.confirmedtaxamount, 
  'PURCHLINEALLVERSIONS_CONFIRMEDTAXWRITECODE' = 
  plav.confirmedtaxwritecode, 
  'PURCHLINEALLVERSIONS_COUNTRYREGIONNAME_RU' = 
  plav.countryregionname_ru, 
  'PURCHLINEALLVERSIONS_COUNTYORIGDEST' = 
         plav.countyorigdest, 
  'PURCHLINEALLVERSIONS_COVREF' = plav.covref, 
  'PURCHLINEALLVERSIONS_CREATEFIXEDASSET' = 
  plav.createfixedasset, 
  'PURCHLINEALLVERSIONS_CURRENCYCODE' = plav.currencycode, 
  'PURCHLINEALLVERSIONS_CUSTOMERREF' = plav.customerref, 
  'PURCHLINEALLVERSIONS_CUSTPURCHASEORDERFORMNUM' = 
  plav.custpurchaseorderformnum, 
  'PURCHLINEALLVERSIONS_DATAAREAID' = plav.dataareaid, 
  'PURCHLINEALLVERSIONS_DEFAULTDIMENSION' = 
  plav.defaultdimension, 
  'PURCHLINEALLVERSIONS_DELIVERYDATE' = plav.deliverydate, 
  'PURCHLINEALLVERSIONS_DELIVERYNAME' = plav.deliveryname, 
  'PURCHLINEALLVERSIONS_DELIVERYPOSTALADDRESS' = 
  plav.deliverypostaladdress, 
  'PURCHLINEALLVERSIONS_DELIVERYTYPE' = plav.deliverytype, 
  'PURCHLINEALLVERSIONS_DEPRECIATIONSTARTDATE' = 
  plav.depreciationstartdate, 
  'PURCHLINEALLVERSIONS_DEVIATIONQTY_RU' = 
  plav.deviationqty_ru, 
  'PURCHLINEALLVERSIONS_DISCAMOUNT' = plav.discamount, 
  'PURCHLINEALLVERSIONS_DISCPERCENT' = plav.discpercent, 
  'PURCHLINEALLVERSIONS_EXTERNALITEMID' = 
         plav.externalitemid, 
  'PURCHLINEALLVERSIONS_GSTHSTTAXTYPE_CA' = 
  plav.gsthsttaxtype_ca, 
  'PURCHLINEALLVERSIONS_INTERCOMPANYINVENTTRANSID' = 
  plav.intercompanyinventtransid, 
  'PURCHLINEALLVERSIONS_INTERCOMPANYORIGIN' = 
  plav.intercompanyorigin, 
  'PURCHLINEALLVERSIONS_INVENTDIMID' = plav.inventdimid, 
  'PURCHLINEALLVERSIONS_INVENTRECEIVEDNOW' = 
  plav.inventreceivednow, 
  'PURCHLINEALLVERSIONS_INVENTREFID' = plav.inventrefid, 
  'PURCHLINEALLVERSIONS_INVENTREFTRANSID' = 
  plav.inventreftransid, 
  'PURCHLINEALLVERSIONS_INVENTTRANSID' = plav.inventtransid, 
  'PURCHLINEALLVERSIONS_INVOICEGTDID_RU' = 
  plav.invoicegtdid_ru, 
  'PURCHLINEALLVERSIONS_ISARCHIVED' = plav.isarchived, 
  'PURCHLINEALLVERSIONS_ISFINALIZED' = plav.isfinalized, 
  'PURCHLINEALLVERSIONS_ITEMBOMID' = plav.itembomid, 
  'PURCHLINEALLVERSIONS_ITEMID' = plav.itemid, 
  'PURCHLINEALLVERSIONS_ITEMPBAID' = plav.itempbaid, 
  'PURCHLINEALLVERSIONS_ITEMREFTYPE' = plav.itemreftype, 
  'PURCHLINEALLVERSIONS_ITEMROUTEID' = plav.itemrouteid, 
  'PURCHLINEALLVERSIONS_ITEMTAGGING' = plav.itemtagging, 
  'PURCHLINEALLVERSIONS_LEDGERDIMENSION' = 
  plav.ledgerdimension, 
  'PURCHLINEALLVERSIONS_LINEAMOUNT' = plav.lineamount, 
  'PURCHLINEALLVERSIONS_LINEDELIVERYTYPE' = 
  plav.linedeliverytype, 
  'PURCHLINEALLVERSIONS_LINEDISC' = plav.linedisc, 
  'PURCHLINEALLVERSIONS_LINEHEADER' = plav.lineheader, 
  'PURCHLINEALLVERSIONS_LINENUMBER' = plav.linenumber, 
  'PURCHLINEALLVERSIONS_LINEPERCENT' = plav.linepercent, 
  'PURCHLINEALLVERSIONS_MARKUPCODE_RU' = plav.markupcode_ru, 
  'PURCHLINEALLVERSIONS_MATCHINGAGREEMENTLINE' = 
  plav.matchingagreementline, 
  'PURCHLINEALLVERSIONS_MATCHINGPOLICY' = 
         plav.matchingpolicy, 
  'PURCHLINEALLVERSIONS_MULTILNDISC' = plav.multilndisc, 
  'PURCHLINEALLVERSIONS_MULTILNPERCENT' = 
         plav.multilnpercent, 
  'PURCHLINEALLVERSIONS_NAME' = plav.NAME, 
  'PURCHLINEALLVERSIONS_OVERDELIVERYPCT' = 
  plav.overdeliverypct, 
  'PURCHLINEALLVERSIONS_PALLETTAGGING' = plav.pallettagging, 
  'PURCHLINEALLVERSIONS_PARTITION' = plav.partition, 
  'PURCHLINEALLVERSIONS_PDSCWINVENTRECEIVEDNOW' = 
  plav.pdscwinventreceivednow, 
  'PURCHLINEALLVERSIONS_PDSCWQTY' = plav.pdscwqty, 
  'PURCHLINEALLVERSIONS_PDSCWREMAININVENTFINANCIAL' = 
  plav.pdscwremaininventfinancial, 
  'PURCHLINEALLVERSIONS_PDSCWREMAININVENTPHYSICAL' = 
  plav.pdscwremaininventphysical, 
  'PURCHLINEALLVERSIONS_PORT' = plav.port, 
  'PURCHLINEALLVERSIONS_POSTINGPROFILE_RU' = 
  plav.postingprofile_ru, 
  'PURCHLINEALLVERSIONS_PRICEAGREEMENTDATE_RU' = 
  plav.priceagreementdate_ru, 
  'PURCHLINEALLVERSIONS_PRICEUNIT' = plav.priceunit, 
  'PURCHLINEALLVERSIONS_PROCUREMENTCATEGORY' = 
  plav.procurementcategory, 
  'PURCHLINEALLVERSIONS_PROJCATEGORYID' = 
         plav.projcategoryid, 
  'PURCHLINEALLVERSIONS_PROJID' = plav.projid, 
  'PURCHLINEALLVERSIONS_PROJLINEPROPERTYID' = 
  plav.projlinepropertyid, 
  'PURCHLINEALLVERSIONS_PROJSALESCURRENCYID' = 
  plav.projsalescurrencyid, 
  'PURCHLINEALLVERSIONS_PROJSALESPRICE' = 
         plav.projsalesprice, 
  'PURCHLINEALLVERSIONS_PROJSALESUNITID' = 
  plav.projsalesunitid, 
  'PURCHLINEALLVERSIONS_PROJTAXGROUPID' = 
         plav.projtaxgroupid, 
  'PURCHLINEALLVERSIONS_PROJTAXITEMGROUPID' = 
  plav.projtaxitemgroupid, 
  'PURCHLINEALLVERSIONS_PROJTRANSID' = plav.projtransid, 
  'PURCHLINEALLVERSIONS_PURCHASETYPE' = plav.purchasetype, 
  'PURCHLINEALLVERSIONS_PURCHID' = plav.purchid, 
  'PURCHLINEALLVERSIONS_PURCHMARKUP' = plav.purchmarkup, 
  'PURCHLINEALLVERSIONS_PURCHPRICE' = plav.purchprice, 
  'PURCHLINEALLVERSIONS_PURCHQTY' = plav.purchqty, 
  'PURCHLINEALLVERSIONS_PURCHRECEIVEDNOW' = 
  plav.purchreceivednow, 
  'PURCHLINEALLVERSIONS_PURCHREQID' = plav.purchreqid, 
  'PURCHLINEALLVERSIONS_PURCHREQLINEREFID' = 
  plav.purchreqlinerefid, 
  'PURCHLINEALLVERSIONS_PURCHSTATUS' = plav.purchstatus, 
  'PURCHLINEALLVERSIONS_PURCHTABLEVERSIONRECID' = 
  plav.purchtableversionrecid, 
  'PURCHLINEALLVERSIONS_PURCHUNIT' = plav.purchunit, 
  'PURCHLINEALLVERSIONS_QTYORDERED' = plav.qtyordered, 
  'PURCHLINEALLVERSIONS_RECID' = plav.recid, 
  'PURCHLINEALLVERSIONS_RECID1' = plav.recid1, 
  'PURCHLINEALLVERSIONS_REFRETURNINVOICETRANS_W' = 
  plav.refreturninvoicetrans_w, 
  'PURCHLINEALLVERSIONS_REMAININVENTFINANCIAL' = 
  plav.remaininventfinancial, 
  'PURCHLINEALLVERSIONS_REMAININVENTPHYSICAL' = 
  plav.remaininventphysical, 
  'PURCHLINEALLVERSIONS_REMAINPURCHFINANCIAL' = 
  plav.remainpurchfinancial, 
  'PURCHLINEALLVERSIONS_REMAINPURCHPHYSICAL' = 
  plav.remainpurchphysical, 
  'PURCHLINEALLVERSIONS_REQATTENTION' = plav.reqattention, 
  'PURCHLINEALLVERSIONS_REQPLANIDSCHED' = 
         plav.reqplanidsched, 
  'PURCHLINEALLVERSIONS_REQPOID' = plav.reqpoid, 
  'PURCHLINEALLVERSIONS_REQUESTER' = plav.requester, 
  'PURCHLINEALLVERSIONS_RETURNACTIONID' = 
         plav.returnactionid, 
  'PURCHLINEALLVERSIONS_RETURNDISPOSITIONCODEID' = 
  plav.returndispositioncodeid, 
  'PURCHLINEALLVERSIONS_RETURNSTATUS' = plav.returnstatus, 
  'PURCHLINEALLVERSIONS_SCRAP' = plav.scrap, 
  'PURCHLINEALLVERSIONS_SHIPPINGDATECONFIRMED' = 
  plav.shippingdateconfirmed, 
  'PURCHLINEALLVERSIONS_SHIPPINGDATEREQUESTED' = 
  plav.shippingdaterequested, 
  'PURCHLINEALLVERSIONS_SOURCEDOCUMENTLINE' = 
  plav.sourcedocumentline, 
  'PURCHLINEALLVERSIONS_STATPROCID' = plav.statprocid, 
  'PURCHLINEALLVERSIONS_STATTRIANGULARDEAL' = 
  plav.stattriangulardeal, 
  'PURCHLINEALLVERSIONS_STOCKEDPRODUCT' = 
         plav.stockedproduct, 
  'PURCHLINEALLVERSIONS_TAX1099AMOUNT' = plav.tax1099amount, 
  'PURCHLINEALLVERSIONS_TAX1099FIELDS' = plav.tax1099fields, 
  'PURCHLINEALLVERSIONS_TAX1099STATE' = plav.tax1099state, 
  'PURCHLINEALLVERSIONS_TAX1099STATEAMOUNT' = 
  plav.tax1099stateamount, 
  'PURCHLINEALLVERSIONS_TAXAUTOGENERATED' = 
  plav.taxautogenerated, 
  'PURCHLINEALLVERSIONS_TAXGROUP' = plav.taxgroup, 
  'PURCHLINEALLVERSIONS_TAXITEMGROUP' = plav.taxitemgroup, 
  'PURCHLINEALLVERSIONS_TAXWITHHOLDBASECUR_TH' = 
  plav.taxwithholdbasecur_th, 
  'PURCHLINEALLVERSIONS_TAXWITHHOLDGROUP_TH' = 
  plav.taxwithholdgroup_th, 
  'PURCHLINEALLVERSIONS_TAXWITHHOLDITEMGROUPHEADING_TH' = 
  plav.taxwithholditemgroupheading_th, 
  'PURCHLINEALLVERSIONS_TRANSACTIONCODE' = 
  plav.transactioncode, 
  'PURCHLINEALLVERSIONS_TRANSPORT' = plav.transport, 
  'PURCHLINEALLVERSIONS_UNDERDELIVERYPCT' = 
  plav.underdeliverypct, 
  'PURCHLINEALLVERSIONS_UnionAllBranchId' = 
  plav.unionallbranchid, 
  'PURCHLINEALLVERSIONS_VENDACCOUNT' = plav.vendaccount, 
  'PURCHLINEALLVERSIONS_VENDGROUP' = plav.vendgroup, 
  'PURCHLINEALLVERSIONS_VERSIONDATETIME' = 
  plav.versiondatetime, 
  '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   vendpurchorderjour vpoj 
         INNER JOIN purchtableallversions ptav 
                 ON ptav.purchtableversionrecid = 
                    vpoj.purchtableversion 
                    AND ptav.dataareaid = vpoj.dataareaid 
                    AND ptav.partition = vpoj.partition 
         INNER JOIN purchlineallversions plav 
                 ON plav.purchtableversionrecid = 
                    ptav.purchtableversionrecid 
                    AND plav.dataareaid = vpoj.dataareaid 
                    AND plav.partition = vpoj.partition 
         INNER JOIN inventdim id 
                 ON id.inventdimid = plav.inventdimid 
                    AND id.dataareaid = vpoj.dataareaid 
                    AND id.partition = vpoj.partition 
         LEFT JOIN ecorescategory erc 
                ON erc.recid = plav.procurementcategory 
                   AND erc.partition = vpoj.partition 

go