Sales Order Details with Lines and extended Line Info

CREATE VIEW [dbo].[vw_salesSalesOrderDetail] 
AS 
  SELECT 'SALESTABLE_ADDRESSREFRECID' = st.addressrefrecid, 
         'SALESTABLE_ADDRESSREFTABLEID' = 
            st.addressreftableid, 
         'SALESTABLE_AUTOSUMMARYMODULETYPE' = 
         st.autosummarymoduletype, 
         'SALESTABLE_BANKACCOUNT_LV' = st.bankaccount_lv, 
         'SALESTABLE_BANKCENTRALBANKPURPOSECODE' = 
         st.bankcentralbankpurposecode, 
         'SALESTABLE_BANKCENTRALBANKPURPOSETEXT' = 
         st.bankcentralbankpurposetext, 
         'SALESTABLE_BANKDOCUMENTTYPE' = 
         st.bankdocumenttype, 
         'SALESTABLE_CASETAGGING' = 
         st.casetagging, 
         'SALESTABLE_CASHDISC' = st.cashdisc, 
         'SALESTABLE_CASHDISCBASEDATE' = 
         st.cashdiscbasedate, 
         'SALESTABLE_CASHDISCBASEDAYS' = 
         st.cashdiscbasedays, 
         'SALESTABLE_CASHDISCPERCENT' = st.cashdiscpercent, 
         'SALESTABLE_COMMISSIONGROUP' = st.commissiongroup, 
         'SALESTABLE_CONSTARGET_JP' = st.constarget_jp, 
         'SALESTABLE_CONTACTPERSONID' = st.contactpersonid, 
         'SALESTABLE_COUNTYORIGDEST' = st.countyorigdest, 
         'SALESTABLE_COVSTATUS' = st.covstatus, 
         'SALESTABLE_CREATEDBY' = st.createdby, 
         'SALESTABLE_CREATEDDATETIME' = st.createddatetime, 
         'SALESTABLE_CREATEDTRANSACTIONID' = 
            st.createdtransactionid, 
         'SALESTABLE_CREDITCARDAPPROVALAMOUNT' = 
         st.creditcardapprovalamount, 
         'SALESTABLE_CREDITCARDAUTHORIZATION' = 
         st.creditcardauthorization, 
         'SALESTABLE_CREDITCARDAUTHORIZATIONERROR' = 
         st.creditcardauthorizationerror, 
         'SALESTABLE_CREDITCARDCUSTREFID' = 
            st.creditcardcustrefid, 
         'SALESTABLE_CREDITNOTEREASONCODE' = 
            st.creditnotereasoncode, 
         'SALESTABLE_CURBANKACCOUNT_LV' = 
            st.curbankaccount_lv, 
         'SALESTABLE_CURRENCYCODE' = 
            st.currencycode, 
         'SALESTABLE_CUSTACCOUNT' = st.custaccount, 
         'SALESTABLE_CUSTBANKACCOUNT_LV' = 
            st.custbankaccount_lv, 
         'SALESTABLE_CUSTGROUP' = st.custgroup, 
         'SALESTABLE_CUSTINVOICEID' = st.custinvoiceid, 
         'SALESTABLE_CUSTOMERREF' = st.customerref, 
         'SALESTABLE_CUSTOMSEXPORTORDER_IN' = 
         st.customsexportorder_in, 
         'SALESTABLE_CUSTOMSSHIPPINGBILL_IN' = 
         st.customsshippingbill_in, 
         'SALESTABLE_DATAAREAID' = st.dataareaid, 
         'SALESTABLE_DAXINTEGRATIONID' = 
         st.daxintegrationid, 
         'SALESTABLE_DEADLINE' = st.deadline, 
         'SALESTABLE_DEFAULTDIMENSION' = 
         st.defaultdimension, 
         'SALESTABLE_DEL_CREATEDTIME' = 
         st.del_createdtime, 
         'SALESTABLE_DEL_MODIFIEDTIME' = 
         st.del_modifiedtime, 
         'SALESTABLE_DELIVERYDATE' = 
         st.deliverydate, 
         'SALESTABLE_DELIVERYDATECONTROLTYPE' = 
         st.deliverydatecontroltype, 
         'SALESTABLE_DELIVERYNAME' = st.deliveryname, 
         'SALESTABLE_DELIVERYPOSTALADDRESS' = 
         st.deliverypostaladdress, 
         'SALESTABLE_DIRECTDEBITMANDATE' = 
            st.directdebitmandate, 
         'SALESTABLE_DISCPERCENT' = st.discpercent, 
         'SALESTABLE_DLVMODE' = st.dlvmode, 
         'SALESTABLE_DLVREASON' = st.dlvreason, 
         'SALESTABLE_DLVTERM' = st.dlvterm, 
         'SALESTABLE_DOCUMENTSTATUS' = st.documentstatus, 
         'SALESTABLE_EINVOICEACCOUNTCODE' = 
            st.einvoiceaccountcode, 
         'SALESTABLE_EINVOICELINESPEC' = 
         st.einvoicelinespec, 
         'SALESTABLE_EMAIL' = st.email, 
         'SALESTABLE_ENDDISC' = st.enddisc, 
         'SALESTABLE_ENTERPRISENUMBER' = 
         st.enterprisenumber, 
         'SALESTABLE_ESTIMATE' = st.estimate, 
         'SALESTABLE_EXPORTREASON' = st.exportreason, 
         'SALESTABLE_FISCALDOCTYPE_PL' = 
         st.fiscaldoctype_pl, 
         'SALESTABLE_FIXEDDUEDATE' = 
         st.fixedduedate, 
         'SALESTABLE_FIXEDEXCHRATE' = st.fixedexchrate, 
         'SALESTABLE_FREIGHTSLIPTYPE' = st.freightsliptype, 
         'SALESTABLE_FREIGHTZONE' = st.freightzone, 
         'SALESTABLE_GIROTYPE' = st.girotype, 
         'SALESTABLE_INCLTAX' = st.incltax, 
         'SALESTABLE_INTERCOMPANYALLOWINDIRECTCREATION' = 
         st.intercompanyallowindirectcreation, 
         'SALESTABLE_INTERCOMPANYALLOWINDIRECTCREATIONORIG' 
         = 
         st.intercompanyallowindirectcreationorig, 
         'SALESTABLE_INTERCOMPANYAUTOCREATEORDERS' = 
         st.intercompanyautocreateorders, 
         'SALESTABLE_INTERCOMPANYCOMPANYID' = 
         st.intercompanycompanyid, 
         'SALESTABLE_INTERCOMPANYDIRECTDELIVERY' = 
         st.intercompanydirectdelivery, 
         'SALESTABLE_INTERCOMPANYDIRECTDELIVERYORIG' = 
         st.intercompanydirectdeliveryorig, 
         'SALESTABLE_INTERCOMPANYORDER' = 
            st.intercompanyorder, 
         'SALESTABLE_INTERCOMPANYORIGIN' = 
            st.intercompanyorigin, 
         'SALESTABLE_INTERCOMPANYORIGINALCUSTACCOUNT' = 
         st.intercompanyoriginalcustaccount, 
         'SALESTABLE_INTERCOMPANYORIGINALSALESID' = 
         st.intercompanyoriginalsalesid, 
         'SALESTABLE_INTERCOMPANYPURCHID' = 
            st.intercompanypurchid, 
         'SALESTABLE_INTRASTATADDVALUE_LV' = 
            st.intrastataddvalue_lv, 
         'SALESTABLE_INTRASTATFULFILLMENTDATE_HU' = 
         st.intrastatfulfillmentdate_hu, 
         'SALESTABLE_INVENTLOCATIONID' = 
         st.inventlocationid, 
         'SALESTABLE_INVENTSITEID' = 
         st.inventsiteid, 
         'SALESTABLE_INVOICEACCOUNT' = st.invoiceaccount, 
         'SALESTABLE_INVOICEREGISTER_LT' = 
            st.invoiceregister_lt, 
         'SALESTABLE_ITEMTAGGING' = st.itemtagging, 
         'SALESTABLE_LANGUAGEID' = st.languageid, 
         'SALESTABLE_LINEDISC' = st.linedisc, 
         'SALESTABLE_LISTCODE' = st.listcode, 
         'SALESTABLE_MANUALENTRYCHANGEPOLICY' = 
         st.manualentrychangepolicy, 
         'SALESTABLE_MARKUPGROUP' = st.markupgroup, 
         'SALESTABLE_MATCHINGAGREEMENT' = 
            st.matchingagreement, 
         'SALESTABLE_MCRORDERSTOPPED' = 
            st.mcrorderstopped, 
         'SALESTABLE_MODIFIEDBY' = st.modifiedby, 
         'SALESTABLE_MODIFIEDDATETIME' = 
         st.modifieddatetime, 
         'SALESTABLE_MODIFIEDTRANSACTIONID' = 
         st.modifiedtransactionid, 
         'SALESTABLE_MULTILINEDISC' = st.multilinedisc, 
         'SALESTABLE_NATUREOFASSESSEE_IN' = 
            st.natureofassessee_in, 
         'SALESTABLE_NUMBERSEQUENCEGROUP' = 
            st.numbersequencegroup, 
         'SALESTABLE_ONETIMECUSTOMER' = st.onetimecustomer, 
         'SALESTABLE_PACKINGSLIPREGISTER_LT' = 
         st.packingslipregister_lt, 
         'SALESTABLE_PALLETTAGGING' = st.pallettagging, 
         'SALESTABLE_PARTITION' = st.partition, 
         'SALESTABLE_PAYMENT' = st.payment, 
         'SALESTABLE_PAYMENTSCHED' = st.paymentsched, 
         'SALESTABLE_PAYMMODE' = st.paymmode, 
         'SALESTABLE_PAYMSPEC' = st.paymspec, 
         'SALESTABLE_PDSBATCHATTRIBAUTORES' = 
         st.pdsbatchattribautores, 
         'SALESTABLE_PDSCUSTREBATEGROUPID' = 
            st.pdscustrebategroupid, 
         'SALESTABLE_PDSREBATEPROGRAMTMAGROUP' = 
         st.pdsrebateprogramtmagroup, 
         'SALESTABLE_PORT' = st.port, 
         'SALESTABLE_POSTINGPROFILE' = st.postingprofile, 
         'SALESTABLE_PRICEGROUPID' = st.pricegroupid, 
         'SALESTABLE_PROJID' = st.projid, 
         'SALESTABLE_PURCHID' = st.purchid, 
         'SALESTABLE_PURCHORDERFORMNUM' = 
            st.purchorderformnum, 
         'SALESTABLE_QUOTATIONID' = 
            st.quotationid, 
         'SALESTABLE_RECEIPTDATECONFIRMED' = 
            st.receiptdateconfirmed, 
         'SALESTABLE_RECEIPTDATEREQUESTED' = 
            st.receiptdaterequested, 
         'SALESTABLE_RECID' = st.recid, 
         'SALESTABLE_RECVERSION' = st.recversion, 
         'SALESTABLE_RELEASESTATUS' = st.releasestatus, 
         'SALESTABLE_RESERVATION' = st.reservation, 
         'SALESTABLE_RETURNDEADLINE' = st.returndeadline, 
         'SALESTABLE_RETURNITEMNUM' = st.returnitemnum, 
         'SALESTABLE_RETURNREASONCODEID' = 
            st.returnreasoncodeid, 
         'SALESTABLE_RETURNREPLACEMENTCREATED' = 
         st.returnreplacementcreated, 
         'SALESTABLE_RETURNREPLACEMENTID' = 
            st.returnreplacementid, 
         'SALESTABLE_RETURNSTATUS' = st.returnstatus, 
         'SALESTABLE_SALESGROUP' = st.salesgroup, 
         'SALESTABLE_SALESID' = st.salesid, 
         'SALESTABLE_SALESNAME' = st.salesname, 
         'SALESTABLE_SALESORIGINID' = st.salesoriginid, 
         'SALESTABLE_SALESPOOLID' = st.salespoolid, 
         'SALESTABLE_SALESSTATUS' = st.salesstatus, 
         'SALESTABLE_SALESTYPE' = st.salestype, 
         'SALESTABLE_SALESUNITID' = st.salesunitid, 
         'SALESTABLE_SETTLEVOUCHER' = st.settlevoucher, 
         'SALESTABLE_SHIPCARRIERACCOUNT' = 
            st.shipcarrieraccount, 
         'SALESTABLE_SHIPCARRIERACCOUNTCODE' = 
         st.shipcarrieraccountcode, 
         'SALESTABLE_SHIPCARRIERBLINDSHIPMENT' = 
         st.shipcarrierblindshipment, 
         'SALESTABLE_SHIPCARRIERDELIVERYCONTACT' = 
         st.shipcarrierdeliverycontact, 
         'SALESTABLE_SHIPCARRIERDLVTYPE' = 
            st.shipcarrierdlvtype, 
         'SALESTABLE_SHIPCARRIEREXPEDITEDSHIPMENT' = 
         st.shipcarrierexpeditedshipment, 
         'SALESTABLE_SHIPCARRIERFUELSURCHARGE' = 
         st.shipcarrierfuelsurcharge, 
         'SALESTABLE_SHIPCARRIERID' = st.shipcarrierid, 
         'SALESTABLE_SHIPCARRIERNAME' = st.shipcarriername, 
         'SALESTABLE_SHIPCARRIERPOSTALADDRESS' = 
         st.shipcarrierpostaladdress, 
         'SALESTABLE_SHIPCARRIERRESIDENTIAL' = 
         st.shipcarrierresidential, 
         'SALESTABLE_SHIPPINGDATECONFIRMED' = 
         st.shippingdateconfirmed, 
         'SALESTABLE_SHIPPINGDATEREQUESTED' = 
         st.shippingdaterequested, 
         'SALESTABLE_SMMCAMPAIGNID' = st.smmcampaignid, 
         'SALESTABLE_SMMSALESAMOUNTTOTAL' = 
            st.smmsalesamounttotal, 
         'SALESTABLE_SOURCEDOCUMENTHEADER' = 
            st.sourcedocumentheader, 
         'SALESTABLE_STATPROCID' = st.statprocid, 
         'SALESTABLE_SYSTEMENTRYCHANGEPOLICY' = 
         st.systementrychangepolicy, 
         'SALESTABLE_SYSTEMENTRYSOURCE' = 
            st.systementrysource, 
         'SALESTABLE_TAXGROUP' = st.taxgroup, 
         'SALESTABLE_TAXPERIODPAYMENTCODE_PL' = 
         st.taxperiodpaymentcode_pl, 
         'SALESTABLE_TCSGROUP_IN' = st.tcsgroup_in, 
         'SALESTABLE_TDSGROUP_IN' = st.tdsgroup_in, 
         'SALESTABLE_TRANSACTIONCODE' = st.transactioncode, 
         'SALESTABLE_TRANSPORT' = st.transport, 
         'SALESTABLE_TRANSPORTATIONDOCUMENT' = 
         st.transportationdocument, 
         'SALESTABLE_UNITEDVATINVOICE_LT' = 
            st.unitedvatinvoice_lt, 
         'SALESTABLE_URL' = st.url, 
         'SALESTABLE_VATNUM' = st.vatnum, 
         'SALESTABLE_WORKERSALESRESPONSIBLE' = 
         st.workersalesresponsible, 
         'SALESTABLE_WORKERSALESTAKER' = 
         st.workersalestaker, 
         'SALESLINE_ACTIVITYNUMBER' = 
         sl.activitynumber, 
         'SALESLINE_ADDRESSREFRECID' = sl.addressrefrecid, 
         'SALESLINE_ADDRESSREFTABLEID' = 
         sl.addressreftableid, 
         'SALESLINE_AGREEMENTSKIPAUTOLINK' = 
            sl.agreementskipautolink, 
         'SALESLINE_ASSETID_RU' = sl.assetid_ru, 
         'SALESLINE_BARCODE' = sl.barcode, 
         'SALESLINE_BARCODETYPE' = sl.barcodetype, 
         'SALESLINE_BLOCKED' = sl.blocked, 
         'SALESLINE_CASETAGGING' = sl.casetagging, 
         'SALESLINE_COMPLETE' = sl.complete, 
         'SALESLINE_CONFIRMEDDLV' = sl.confirmeddlv, 
         'SALESLINE_COSTPRICE' = sl.costprice, 
         'SALESLINE_COUNTRYREGIONNAME_RU' = 
            sl.countryregionname_ru, 
         'SALESLINE_COUNTYORIGDEST' = sl.countyorigdest, 
         'SALESLINE_CREATEDBY' = sl.createdby, 
         'SALESLINE_CREATEDDATETIME' = sl.createddatetime, 
         'SALESLINE_CREDITNOTEINTERNALREF_PL' = 
         sl.creditnoteinternalref_pl, 
         'SALESLINE_CREDITNOTEREASONCODE' = 
            sl.creditnotereasoncode, 
         'SALESLINE_CURRENCYCODE' = sl.currencycode, 
         'SALESLINE_CUSTACCOUNT' = sl.custaccount, 
         'SALESLINE_CUSTGROUP' = sl.custgroup, 
         'SALESLINE_CUSTOMERLINENUM' = sl.customerlinenum, 
         'SALESLINE_CUSTOMERREF' = sl.customerref, 
         'SALESLINE_CUSTOMSDOCDATE_MX' = 
         sl.customsdocdate_mx, 
         'SALESLINE_CUSTOMSDOCNUMBER_MX' = 
            sl.customsdocnumber_mx, 
         'SALESLINE_CUSTOMSNAME_MX' = sl.customsname_mx, 
         'SALESLINE_DATAAREAID' = sl.dataareaid, 
         'SALESLINE_DEFAULTDIMENSION' = sl.defaultdimension, 
         'SALESLINE_DEL_CREATEDTIME' = sl.del_createdtime, 
         'SALESLINE_DEL_MODIFIEDTIME' = sl.del_modifiedtime, 
         'SALESLINE_DELIVERYDATECONTROLTYPE' = 
         sl.deliverydatecontroltype, 
         'SALESLINE_DELIVERYNAME' = sl.deliveryname, 
         'SALESLINE_DELIVERYPOSTALADDRESS' = 
            sl.deliverypostaladdress, 
         'SALESLINE_DELIVERYTAXGROUP_BR' = 
            sl.deliverytaxgroup_br, 
         'SALESLINE_DELIVERYTAXITEMGROUP_BR' = 
         sl.deliverytaxitemgroup_br, 
         'SALESLINE_DELIVERYTYPE' = sl.deliverytype, 
         'SALESLINE_DLVMODE' = sl.dlvmode, 
         'SALESLINE_DLVTERM' = sl.dlvterm, 
         'SALESLINE_EINVOICEACCOUNTCODE' = 
            sl.einvoiceaccountcode, 
         'SALESLINE_EXPECTEDRETQTY' = sl.expectedretqty, 
         'SALESLINE_EXTERNALITEMID' = sl.externalitemid, 
         'SALESLINE_INTERCOMPANYINVENTTRANSID' = 
         sl.intercompanyinventtransid, 
         'SALESLINE_INTERCOMPANYORIGIN' = 
            sl.intercompanyorigin, 
         'SALESLINE_INTRASTATFULFILLMENTDATE_HU' = 
         sl.intrastatfulfillmentdate_hu, 
         'SALESLINE_INVENTDELIVERNOW' = sl.inventdelivernow, 
         'SALESLINE_INVENTDIMID' = sl.inventdimid, 
         'SALESLINE_INVENTREFID' = sl.inventrefid, 
         'SALESLINE_INVENTREFTRANSID' = sl.inventreftransid, 
         'SALESLINE_INVENTREFTYPE' = sl.inventreftype, 
         'SALESLINE_INVENTTRANSID' = sl.inventtransid, 
         'SALESLINE_INVENTTRANSIDRETURN' = 
            sl.inventtransidreturn, 
         'SALESLINE_INVOICEGTDID_RU' = sl.invoicegtdid_ru, 
         'SALESLINE_ITEMBOMID' = sl.itembomid, 
         'SALESLINE_ITEMID' = sl.itemid, 
         'SALESLINE_ITEMPBAID' = sl.itempbaid, 
         'SALESLINE_ITEMREPLACED' = sl.itemreplaced, 
         'SALESLINE_ITEMROUTEID' = sl.itemrouteid, 
         'SALESLINE_ITEMTAGGING' = sl.itemtagging, 
         'SALESLINE_LEDGERDIMENSION' = sl.ledgerdimension, 
         'SALESLINE_LINEAMOUNT' = sl.lineamount, 
         'SALESLINE_LINEDELIVERYTYPE' = sl.linedeliverytype, 
         'SALESLINE_LINEDISC' = sl.linedisc, 
         'SALESLINE_LINEHEADER' = sl.lineheader, 
         'SALESLINE_LINENUM' = sl.linenum, 
         'SALESLINE_LINEPERCENT' = sl.linepercent, 
         'SALESLINE_MANUALENTRYCHANGEPOLICY' = 
         sl.manualentrychangepolicy, 
         'SALESLINE_MATCHINGAGREEMENTLINE' = 
            sl.matchingagreementline, 
         'SALESLINE_MCRORDERLINE2PRICEHISTORYREF' = 
         sl.mcrorderline2pricehistoryref, 
         'SALESLINE_MODIFIEDBY' = sl.modifiedby, 
         'SALESLINE_MODIFIEDDATETIME' = sl.modifieddatetime, 
         'SALESLINE_MULTILNDISC' = sl.multilndisc, 
         'SALESLINE_MULTILNPERCENT' = sl.multilnpercent, 
         'SALESLINE_NAME' = sl.NAME, 
         'SALESLINE_OVERDELIVERYPCT' = sl.overdeliverypct, 
         'SALESLINE_PACKINGUNIT' = sl.packingunit, 
         'SALESLINE_PACKINGUNITQTY' = sl.packingunitqty, 
         'SALESLINE_PALLETTAGGING' = sl.pallettagging, 
         'SALESLINE_PARTITION' = sl.partition, 
         'SALESLINE_PDSBATCHATTRIBAUTORES' = 
            sl.pdsbatchattribautores, 
         'SALESLINE_PDSCWEXPECTEDRETQTY' = 
            sl.pdscwexpectedretqty, 
         'SALESLINE_PDSCWINVENTDELIVERNOW' = 
            sl.pdscwinventdelivernow, 
         'SALESLINE_PDSCWQTY' = sl.pdscwqty, 
         'SALESLINE_PDSCWREMAININVENTFINANCIAL' = 
         sl.pdscwremaininventfinancial, 
         'SALESLINE_PDSCWREMAININVENTPHYSICAL' = 
         sl.pdscwremaininventphysical, 
         'SALESLINE_PDSEXCLUDEFROMREBATE' = 
            sl.pdsexcludefromrebate, 
         'SALESLINE_PDSITEMREBATEGROUPID' = 
            sl.pdsitemrebategroupid, 
         'SALESLINE_PDSSAMELOT' = sl.pdssamelot, 
         'SALESLINE_PDSSAMELOTOVERRIDE' = 
            sl.pdssamelotoverride, 
         'SALESLINE_PORT' = sl.port, 
         'SALESLINE_POSTINGPROFILE_RU' = 
         sl.postingprofile_ru, 
         'SALESLINE_PRICEAGREEMENTDATE_RU' = 
            sl.priceagreementdate_ru, 
         'SALESLINE_PRICEUNIT' = sl.priceunit, 
         'SALESLINE_PROJCATEGORYID' = sl.projcategoryid, 
         'SALESLINE_PROJID' = sl.projid, 
         'SALESLINE_PROJLINEPROPERTYID' = 
            sl.projlinepropertyid, 
         'SALESLINE_PROJTRANSID' = sl.projtransid, 
         'SALESLINE_PROPERTYNUMBER_MX' = 
         sl.propertynumber_mx, 
         'SALESLINE_PSACONTRACTLINENUM' = 
            sl.psacontractlinenum, 
         'SALESLINE_PSAPROJPROPOSALINVENTQTY' = 
         sl.psaprojproposalinventqty, 
         'SALESLINE_PSAPROJPROPOSALQTY' = 
            sl.psaprojproposalqty, 
         'SALESLINE_PURCHORDERFORMNUM' = 
         sl.purchorderformnum, 
         'SALESLINE_QTYORDERED' = sl.qtyordered, 
         'SALESLINE_RECEIPTDATECONFIRMED' = 
            sl.receiptdateconfirmed, 
         'SALESLINE_RECEIPTDATEREQUESTED' = 
            sl.receiptdaterequested, 
         'SALESLINE_RECID' = sl.recid, 
         'SALESLINE_RECVERSION' = sl.recversion, 
         'SALESLINE_REFRETURNINVOICETRANS_W' = 
         sl.refreturninvoicetrans_w, 
         'SALESLINE_REMAININVENTFINANCIAL' = 
            sl.remaininventfinancial, 
         'SALESLINE_REMAININVENTPHYSICAL' = 
            sl.remaininventphysical, 
         'SALESLINE_REMAINSALESFINANCIAL' = 
            sl.remainsalesfinancial, 
         'SALESLINE_REMAINSALESPHYSICAL' = 
            sl.remainsalesphysical, 
         'SALESLINE_RESERVATION' = sl.reservation, 
         'SALESLINE_RETAILBLOCKQTY' = sl.retailblockqty, 
         'SALESLINE_RETAILVARIANTID' = sl.retailvariantid, 
         'SALESLINE_RETURNALLOWRESERVATION' = 
         sl.returnallowreservation, 
         'SALESLINE_RETURNARRIVALDATE' = 
         sl.returnarrivaldate, 
         'SALESLINE_RETURNCLOSEDDATE' = sl.returncloseddate, 
         'SALESLINE_RETURNDEADLINE' = sl.returndeadline, 
         'SALESLINE_RETURNDISPOSITIONCODEID' = 
         sl.returndispositioncodeid, 
         'SALESLINE_RETURNSTATUS' = sl.returnstatus, 
         'SALESLINE_SALESCATEGORY' = sl.salescategory, 
         'SALESLINE_SALESDELIVERNOW' = sl.salesdelivernow, 
         'SALESLINE_SALESGROUP' = sl.salesgroup, 
         'SALESLINE_SALESID' = sl.salesid, 
         'SALESLINE_SALESMARKUP' = sl.salesmarkup, 
         'SALESLINE_SALESPRICE' = sl.salesprice, 
         'SALESLINE_SALESQTY' = sl.salesqty, 
         'SALESLINE_SALESSTATUS' = sl.salesstatus, 
         'SALESLINE_SALESTYPE' = sl.salestype, 
         'SALESLINE_SALESUNIT' = sl.salesunit, 
         'SALESLINE_SCRAP' = sl.scrap, 
         'SALESLINE_SERVICEORDERID' = sl.serviceorderid, 
         'SALESLINE_SHIPCARRIERACCOUNT' = 
            sl.shipcarrieraccount, 
         'SALESLINE_SHIPCARRIERACCOUNTCODE' = 
         sl.shipcarrieraccountcode, 
         'SALESLINE_SHIPCARRIERDLVTYPE' = 
            sl.shipcarrierdlvtype, 
         'SALESLINE_SHIPCARRIERID' = sl.shipcarrierid, 
         'SALESLINE_SHIPCARRIERNAME' = sl.shipcarriername, 
         'SALESLINE_SHIPCARRIERPOSTALADDRESS' = 
         sl.shipcarrierpostaladdress, 
         'SALESLINE_SHIPPINGDATECONFIRMED' = 
            sl.shippingdateconfirmed, 
         'SALESLINE_SHIPPINGDATEREQUESTED' = 
            sl.shippingdaterequested, 
         'SALESLINE_SOURCEDOCUMENTLINE' = 
            sl.sourcedocumentline, 
         'SALESLINE_STATISTICVALUE_LT' = 
         sl.statisticvalue_lt, 
         'SALESLINE_STATPROCID' = sl.statprocid, 
         'SALESLINE_STATTRIANGULARDEAL' = 
            sl.stattriangulardeal, 
         'SALESLINE_STOCKEDPRODUCT' = sl.stockedproduct, 
         'SALESLINE_SYSTEMENTRYCHANGEPOLICY' = 
         sl.systementrychangepolicy, 
         'SALESLINE_SYSTEMENTRYSOURCE' = 
         sl.systementrysource, 
         'SALESLINE_TAXAUTOGENERATED' = sl.taxautogenerated, 
         'SALESLINE_TAXGROUP' = sl.taxgroup, 
         'SALESLINE_TAXITEMGROUP' = sl.taxitemgroup, 
         'SALESLINE_TAXWITHHOLDGROUP' = sl.taxwithholdgroup, 
         'SALESLINE_TAXWITHHOLDITEMGROUPHEADING_TH' = 
         sl.taxwithholditemgroupheading_th, 
         'SALESLINE_TRANSACTIONCODE' = sl.transactioncode, 
         'SALESLINE_TRANSPORT' = sl.transport, 
         'SALESLINE_UNDERDELIVERYPCT' = sl.underdeliverypct, 
         '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, 
         'itdw_ITEMID' = itwd.itemid, 
         'itdw_ITEMTYPE' = itwd.itemtype, 
         'itdw_PURCHMODEL' = itwd.purchmodel, 
         'itdw_HEIGHT' = itwd.height, 
         'itdw_WIDTH' = itwd.width, 
         'itdw_SALESMODEL' = itwd.salesmodel, 
         'itdw_COSTGROUPID' = itwd.costgroupid, 
         'itdw_REQGROUPID' = itwd.reqgroupid, 
         'itdw_EPCMANAGER' = itwd.epcmanager, 
         'itdw_PRIMARYVENDORID' = itwd.primaryvendorid, 
         'itdw_NETWEIGHT' = itwd.netweight, 
         'itdw_DEPTH' = itwd.depth, 
         'itdw_UNITVOLUME' = itwd.unitvolume, 
         'itdw_BOMUNITID' = itwd.bomunitid, 
         'itdw_ITEMPRICETOLERANCEGROUPID' = 
         itwd.itempricetolerancegroupid, 
         'itdw_DENSITY' = itwd.density, 
         'itdw_COSTMODEL' = itwd.costmodel, 
         'itdw_USEALTITEMID' = itwd.usealtitemid, 
         'itdw_ALTITEMID' = itwd.altitemid, 
         'itdw_MATCHINGPOLICY' = itwd.matchingpolicy, 
         'itdw_INTRACODE' = itwd.intracode, 
         'itdw_PRODFLUSHINGPRINCIP' = 
            itwd.prodflushingprincip, 
         'itdw_MINIMUMPALLETQUANTITY' = 
            itwd.minimumpalletquantity, 
         'itdw_PBAITEMAUTOGENERATED' = 
            itwd.pbaitemautogenerated, 
         'itdw_WMSARRIVALHANDLINGTIME' = 
            itwd.wmsarrivalhandlingtime, 
         'itdw_BOMMANUALRECEIPT' = itwd.bommanualreceipt, 
         'itdw_PHANTOM' = itwd.phantom, 
         'itdw_INTRAUNIT' = itwd.intraunit, 
         'itdw_BOMLEVEL' = itwd.bomlevel, 
         'itdw_BATCHNUMGROUPID' = itwd.batchnumgroupid, 
         'itdw_AUTOREPORTFINISHED' = 
         itwd.autoreportfinished, 
         'itdw_ORIGCOUNTRYREGIONID' = 
            itwd.origcountryregionid, 
         'itdw_STATISTICSFACTOR' = 
            itwd.statisticsfactor, 
         'itdw_ALTCONFIGID' = itwd.altconfigid, 
         'itdw_STANDARDCONFIGID' = itwd.standardconfigid, 
         'itdw_PRODPOOLID' = itwd.prodpoolid, 
         'itdw_PROPERTYID' = itwd.propertyid, 
         'itdw_ABCTIEUP' = itwd.abctieup, 
         'itdw_ABCREVENUE' = itwd.abcrevenue, 
         'itdw_ABCVALUE' = itwd.abcvalue, 
         'itdw_ABCCONTRIBUTIONMARGIN' = 
            itwd.abccontributionmargin, 
         'itdw_COMMISSIONGROUPID' = itwd.commissiongroupid, 
         'itdw_SALESPERCENTMARKUP' = 
         itwd.salespercentmarkup, 
         'itdw_SALESCONTRIBUTIONRATIO' = 
            itwd.salescontributionratio, 
         'itdw_SALESPRICEMODELBASIC' = 
            itwd.salespricemodelbasic, 
         'itdw_NAMEALIAS' = itwd.namealias, 
         'itdw_PRODGROUPID' = itwd.prodgroupid, 
         'itdw_PROJCATEGORYID' = itwd.projcategoryid, 
         'itdw_GROSSDEPTH' = itwd.grossdepth, 
         'itdw_GROSSWIDTH' = itwd.grosswidth, 
         'itdw_GROSSHEIGHT' = itwd.grossheight, 
         'itdw_STANDARDPALLETQUANTITY' = 
            itwd.standardpalletquantity, 
         'itdw_QTYPERLAYER' = itwd.qtyperlayer, 
         'itdw_SORTCODE' = itwd.sortcode, 
         'itdw_SERIALNUMGROUPID' = itwd.serialnumgroupid, 
         'itdw_ITEMBUYERGROUPID' = itwd.itembuyergroupid, 
         'itdw_TAXPACKAGINGQTY' = itwd.taxpackagingqty, 
         'itdw_WMSPALLETTYPEID' = itwd.wmspallettypeid, 
         'itdw_ORIGSTATEID' = itwd.origstateid, 
         'itdw_WMSPICKINGQTYTIME' = itwd.wmspickingqtytime, 
         'itdw_TARAWEIGHT' = itwd.taraweight, 
         'itdw_PACKAGINGGROUPID' = itwd.packaginggroupid, 
         'itdw_SCRAPVAR' = itwd.scrapvar, 
         'itdw_SCRAPCONST' = itwd.scrapconst, 
         'itdw_STANDARDINVENTCOLORID' = 
            itwd.standardinventcolorid, 
         'itdw_STANDARDINVENTSIZEID' = 
            itwd.standardinventsizeid, 
         'itdw_ITEMDIMCOSTPRICE' = itwd.itemdimcostprice, 
         'itdw_ALTINVENTSIZEID' = itwd.altinventsizeid, 
         'itdw_ALTINVENTCOLORID' = itwd.altinventcolorid, 
         'itdw_FORECASTDMPINCLUDE' = 
         itwd.forecastdmpinclude, 
         'itdw_PRODUCT' = itwd.product, 
         'itdw_PALLETTAGGING' = itwd.pallettagging, 
         'itdw_ITEMTAGGINGLEVEL' = itwd.itemtagginglevel, 
         'itdw_DEFAULTDIMENSION' = itwd.defaultdimension, 
         'itdw_FISCALLIFOAVOIDCALC' = 
            itwd.fiscallifoavoidcalc, 
         'itdw_FISCALLIFONORMALVALUE' = 
            itwd.fiscallifonormalvalue, 
         'itdw_FISCALLIFONORMALVALUECALC' = 
         itwd.fiscallifonormalvaluecalc, 
         'itdw_BOMCALCGROUPID' = itwd.bomcalcgroupid, 
         'itdw_INVENTFISCALLIFOGROUP' = 
            itwd.inventfiscallifogroup, 
         'itdw_NGPCODESTABLE_FR' = itwd.ngpcodestable_fr, 
         'itdw_ORIGCOUNTYID' = itwd.origcountyid, 
         'itdw_TAXFISCALCLASSIFICATION_BR' = 
         itwd.taxfiscalclassification_br, 
         'itdw_PBAITEMCONFIGURABLE' = 
            itwd.pbaitemconfigurable, 
         'itdw_PBAINVENTITEMGROUPID' = 
            itwd.pbainventitemgroupid, 
         'itdw_PBAHIDEDIALOG' = itwd.pbahidedialog, 
         'itdw_PBAHIDEAPPROVAL' = itwd.pbahideapproval, 
         'itdw_PBAAUTOSTART' = itwd.pbaautostart, 
         'itdw_PBAMANDATORYCONFIG' = 
         itwd.pbamandatoryconfig, 
         'itdw_INVENTPRODUCTTYPE_BR' = 
            itwd.inventproducttype_br, 
         'itdw_TAXATIONORIGIN_BR' = itwd.taxationorigin_br, 
         'itdw_TAXSERVICECODE_BR' = itwd.taxservicecode_br, 
         'itdw_EXCISETARIFFCODES_IN' = 
            itwd.excisetariffcodes_in, 
         'itdw_CUSTOMSEXPORTTARIFFCODETABLE_IN' = 
         itwd.customsexporttariffcodetable_in, 
         'itdw_CUSTOMSIMPORTTARIFFCODETABLE_IN' = 
         itwd.customsimporttariffcodetable_in, 
         'itdw_SERVICECODETABLE_IN' = 
            itwd.servicecodetable_in, 
         'itdw_EXIMPRODUCTGROUPTABLE_IN' = 
         itwd.eximproductgrouptable_in, 
         'itdw_PACKING_RU' = itwd.packing_ru, 
         'itdw_ASSETGROUPID_RU' = itwd.assetgroupid_ru, 
         'itdw_ASSETID_RU' = itwd.assetid_ru, 
         'itdw_INTRASTATEXCLUDE' = itwd.intrastatexclude, 
         'itdw_INTRASTATPROCID_CZ' = 
         itwd.intrastatprocid_cz, 
         'itdw_PKWIUCODE_PL' = 
         itwd.pkwiucode_pl, 
         'itdw_EXCEPTIONCODE_BR' = itwd.exceptioncode_br, 
         'itdw_ICMSONSERVICE_BR' = itwd.icmsonservice_br, 
         'itdw_PDSCWWMSSTANDARDPALLETQTY' = 
         itwd.pdscwwmsstandardpalletqty, 
         'itdw_PDSCWWMSMINIMUMPALLETQTY' = 
         itwd.pdscwwmsminimumpalletqty, 
         'itdw_PDSCWWMSQTYPERLAYER' = 
            itwd.pdscwwmsqtyperlayer, 
         'itdw_ALCOHOLMANUFACTURERID_RU' = 
         itwd.alcoholmanufacturerid_ru, 
         'itdw_ALCOHOLPRODUCTIONTYPEID_RU' = 
         itwd.alcoholproductiontypeid_ru, 
         'itdw_ALCOHOLSTRENGTH_RU' = 
         itwd.alcoholstrength_ru, 
         'itdw_ALTINVENTSTYLEID' = 
         itwd.altinventstyleid, 
         'itdw_APPROXTAXVALUE_BR' = itwd.approxtaxvalue_br, 
         'itdw_BATCHMERGEDATECALCULATIONMETHOD' = 
         itwd.batchmergedatecalculationmethod, 
         'itdw_DAXINTEGRATIONKEY' = itwd.daxintegrationkey, 
         'itdw_MARKUPCODE_RU' = itwd.markupcode_ru, 
         'itdw_NRTAXGROUP_LV' = itwd.nrtaxgroup_lv, 
         'itdw_PDSBASEATTRIBUTEID' = 
         itwd.pdsbaseattributeid, 
         'itdw_PDSBESTBEFORE' = 
         itwd.pdsbestbefore, 
         'itdw_PDSFREIGHTALLOCATIONGROUPID' = 
         itwd.pdsfreightallocationgroupid, 
         'itdw_PDSITEMREBATEGROUPID' = 
            itwd.pdsitemrebategroupid, 
         'itdw_PDSPOTENCYATTRIBRECORDING' = 
         itwd.pdspotencyattribrecording, 
         'itdw_PDSSHELFADVICE' = itwd.pdsshelfadvice, 
         'itdw_PDSSHELFLIFE' = itwd.pdsshelflife, 
         'itdw_PDSTARGETFACTOR' = itwd.pdstargetfactor, 
         'itdw_PDSVENDORCHECKITEM' = 
         itwd.pdsvendorcheckitem, 
         'itdw_PMFPLANNINGITEMID' = 
         itwd.pmfplanningitemid, 
         'itdw_PMFPRODUCTTYPE' = itwd.pmfproducttype, 
         'itdw_PMFYIELDPCT' = itwd.pmfyieldpct, 
         'itdw_SADRATECODE_PL' = itwd.sadratecode_pl, 
         'itdw_SKIPINTRACOMPANYSYNC_RU' = 
         itwd.skipintracompanysync_ru, 
         'itdw_STANDARDINVENTSTYLEID' = 
            itwd.standardinventstyleid, 
         'itdw_MODIFIEDDATETIME' = itwd.modifieddatetime, 
         'itdw_DEL_MODIFIEDTIME' = itwd.del_modifiedtime, 
         'itdw_MODIFIEDBY' = itwd.modifiedby, 
         'itdw_CREATEDDATETIME' = itwd.createddatetime, 
         'itdw_DEL_CREATEDTIME' = itwd.del_createdtime, 
         'itdw_CREATEDBY' = itwd.createdby, 
         'itdw_DATAAREAID' = itwd.dataareaid, 
         'itdw_RECVERSION' = itwd.recversion, 
         'itdw_PARTITION' = itwd.partition, 
         'itdw_RECID' = itwd.recid, 
         'itdw_productmaster' = itwd.productmaster, 
         'itdw_retaitotalweight' = itwd.retaitotalweight, 
         'itdw_variantconfigurationtechnology' = 
         itwd.variantconfigurationtechnology, 
         'itdw_retailcolorgroupid' = 
         itwd.retailcolorgroupid, 
         'itdw_retailsizegroupid' = 
         itwd.retailsizegroupid, 
         'itdw_retailstylegroupid' = 
         itwd.retailstylegroupid, 
         'itdw_instancerelationtype' = 
            itwd.instancerelationtype, 
         'itdw_displayproductnumber' = 
            itwd.displayproductnumber, 
         'itdw_searchname' = itwd.searchname, 
         'itdw_producttype' = itwd.producttype, 
         'itdw_pdscwproduct' = itwd.pdscwproduct, 
         'itdw_storageName' = itwd.storagename, 
         'itdw_storageDescription' = 
         itwd.storagedescription, 
         'itdw_iswarehousemandatoryenabled' = 
         itwd.iswarehousemandatoryenabled, 
         'itdw_iswarehouseprimarystockingenabled' = 
         itwd.iswarehouseprimarystockingenabled, 
         'itdw_iswarehousewhsenabled' = 
            itwd.iswarehousewhsenabled, 
         'itdw_wmslocationenabled' = 
         itwd.wmslocationenabled, 
         'itdw_wmspalletidenabled' = 
         itwd.wmspalletidenabled, 
         'itdw_inventwarehouseenabled' = 
            itwd.inventwarehouseenabled, 
         'itdw_inventsiteenabled' = itwd.inventsiteenabled, 
         'itdw_licenseplateenabled' = 
            itwd.licenseplateenabled, 
         'itdw_inventstatusenabled' = 
            itwd.inventstatusenabled, 
         'itdw_trackingName' = itwd.trackingname, 
         'itdw_trackingDescription' = 
            itwd.trackingdescription, 
         'itdw_isserialnumbercontrolenabled' = 
         itwd.isserialnumbercontrolenabled, 
         'itdw_captureserial' = itwd.captureserial, 
         'itdw_inventbatchenabled' = 
         itwd.inventbatchenabled, 
         'itdw_inventserialenabled' = 
            itwd.inventserialenabled, 
         'itdw_inventgtdenabled' = 
            itwd.inventgtdenabled, 
         'itdw_inventprofileenabled' = 
            itwd.inventprofileenabled, 
         'itdw_inventownerenabled' = 
         itwd.inventownerenabled, 
         'itdw_ProductName' = itwd.productname, 
         'itdw_productDescription' = 
         itwd.productdescription, 
         'itdw_configenabled' = 
         itwd.configenabled, 
         'itdw_inventsizeenabled' = itwd.inventsizeenabled, 
         'itdw_inventcolorenabled' = 
         itwd.inventcolorenabled, 
         'itdw_inventstyleenabled' = 
         itwd.inventstyleenabled 
  FROM   salestable st 
         LEFT JOIN salesline sl 
                ON sl.salesid = st.salesid 
                   AND sl.dataareaid = st.dataareaid 
                   AND sl.partition = st.partition 
         INNER JOIN inventdim id 
                 ON id.inventdimid = sl.inventdimid 
                    AND id.dataareaid = st.dataareaid 
                    AND id.partition = st.partition 
         INNER JOIN vw_inventitemswithdimensions itwd 
                 ON itwd.itemid = sl.itemid 
                    AND itwd.dataareaid = sl.dataareaid 
                    AND itwd.partition = st.partition 

go