Inventory Transactions

CREATE VIEW [dbo].[vw_inventInventTrans] 
AS 
  SELECT 'INVENTTRANSORIGIN_DATAAREAID' = ito.dataareaid, 
         'INVENTTRANSORIGIN_INVENTTRANSID' = 
            ito.inventtransid, 
         'INVENTTRANSORIGIN_ITEMID' = ito.itemid, 
         'INVENTTRANSORIGIN_ITEMINVENTDIMID' = 
            ito.iteminventdimid, 
         'INVENTTRANSORIGIN_PARTITION' = ito.partition, 
         'INVENTTRANSORIGIN_PARTY' = ito.party, 
         'INVENTTRANSORIGIN_RECID' = ito.recid, 
         'INVENTTRANSORIGIN_RECVERSION' = ito.recversion, 
         'INVENTTRANSORIGIN_REFERENCECATEGORY' = 
         ito.referencecategory, 
         'INVENTTRANSORIGIN_REFERENCEID' = ito.referenceid, 
         'INVENTTRANS_ACTIVITYNUMBER' = 
         itrans.activitynumber, 
         'INVENTTRANS_COSTAMOUNTADJUSTMENT' = 
         itrans.costamountadjustment, 
         'INVENTTRANS_COSTAMOUNTOPERATIONS' = 
         itrans.costamountoperations, 
         'INVENTTRANS_COSTAMOUNTPHYSICAL' = 
            itrans.costamountphysical, 
         'INVENTTRANS_COSTAMOUNTPOSTED' = 
            itrans.costamountposted, 
         'INVENTTRANS_COSTAMOUNTSECCURADJUSTMENT_RU' = 
         itrans.costamountseccuradjustment_ru, 
         'INVENTTRANS_COSTAMOUNTSECCURPHYSICAL_RU' = 
         itrans.costamountseccurphysical_ru, 
         'INVENTTRANS_COSTAMOUNTSECCURPOSTED_RU' = 
         itrans.costamountseccurposted_ru, 
         'INVENTTRANS_COSTAMOUNTSETTLED' = 
            itrans.costamountsettled, 
         'INVENTTRANS_COSTAMOUNTSETTLEDSECCUR_RU' = 
         itrans.costamountsettledseccur_ru, 
         'INVENTTRANS_COSTAMOUNTSTD' = itrans.costamountstd, 
         'INVENTTRANS_COSTAMOUNTSTDSECCUR_RU' = 
         itrans.costamountstdseccur_ru, 
         'INVENTTRANS_CURRENCYCODE' = itrans.currencycode, 
         'INVENTTRANS_DATAAREAID' = itrans.dataareaid, 
         'INVENTTRANS_DATECLOSED' = itrans.dateclosed, 
         'INVENTTRANS_DATECLOSEDSECCUR_RU' = 
         itrans.dateclosedseccur_ru, 
         'INVENTTRANS_DATEEXPECTED' = itrans.dateexpected, 
         'INVENTTRANS_DATEFINANCIAL' = itrans.datefinancial, 
         'INVENTTRANS_DATEINVENT' = itrans.dateinvent, 
         'INVENTTRANS_DATEPHYSICAL' = itrans.datephysical, 
         'INVENTTRANS_DATESTATUS' = itrans.datestatus, 
         'INVENTTRANS_GROUPREFID_RU' = itrans.grouprefid_ru, 
         'INVENTTRANS_GROUPREFTYPE_RU' = 
            itrans.groupreftype_ru, 
         'INVENTTRANS_INTERCOMPANYINVENTDIMTRANSFERRED' = 
         itrans.intercompanyinventdimtransferred, 
         'INVENTTRANS_INVENTDIMFIXED' = 
         itrans.inventdimfixed, 
         'INVENTTRANS_INVENTDIMID' = itrans.inventdimid, 
         'INVENTTRANS_INVENTDIMIDSALES_RU' = 
         itrans.inventdimidsales_ru, 
         'INVENTTRANS_INVENTTRANSORIGIN' = 
            itrans.inventtransorigin, 
         'INVENTTRANS_INVENTTRANSORIGINDELIVERY_RU' = 
         itrans.inventtransorigindelivery_ru, 
         'INVENTTRANS_INVENTTRANSORIGINSALES_RU' = 
         itrans.inventtransoriginsales_ru, 
         'INVENTTRANS_INVENTTRANSORIGINTRANSIT_RU' = 
         itrans.inventtransorigintransit_ru, 
         'INVENTTRANS_INVOICEID' = itrans.invoiceid, 
         'INVENTTRANS_INVOICERETURNED' = 
            itrans.invoicereturned, 
         'INVENTTRANS_ITEMID' = itrans.itemid, 
         'INVENTTRANS_MARKINGREFINVENTTRANSORIGIN' = 
         itrans.markingrefinventtransorigin, 
         'INVENTTRANS_MODIFIEDDATETIME' = 
            itrans.modifieddatetime, 
         'INVENTTRANS_PACKINGSLIPID' = itrans.packingslipid, 
         'INVENTTRANS_PACKINGSLIPRETURNED' = 
         itrans.packingslipreturned, 
         'INVENTTRANS_PARTITION' = itrans.partition, 
         'INVENTTRANS_PDSCWQTY' = itrans.pdscwqty, 
         'INVENTTRANS_PDSCWSETTLED' = itrans.pdscwsettled, 
         'INVENTTRANS_PICKINGROUTEID' = 
         itrans.pickingrouteid, 
         'INVENTTRANS_PROJADJUSTREFID' = 
            itrans.projadjustrefid, 
         'INVENTTRANS_PROJCATEGORYID' = 
         itrans.projcategoryid, 
         'INVENTTRANS_PROJID' = itrans.projid, 
         'INVENTTRANS_QTY' = itrans.qty, 
         'INVENTTRANS_QTYSETTLED' = itrans.qtysettled, 
         'INVENTTRANS_QTYSETTLEDSECCUR_RU' = 
         itrans.qtysettledseccur_ru, 
         'INVENTTRANS_RECID' = itrans.recid, 
         'INVENTTRANS_RECVERSION' = itrans.recversion, 
         'INVENTTRANS_RETURNINVENTTRANSORIGIN' = 
         itrans.returninventtransorigin, 
         'INVENTTRANS_REVENUEAMOUNTPHYSICAL' = 
         itrans.revenueamountphysical, 
         'INVENTTRANS_SHIPPINGDATECONFIRMED' = 
         itrans.shippingdateconfirmed, 
         'INVENTTRANS_SHIPPINGDATEREQUESTED' = 
         itrans.shippingdaterequested, 
         'INVENTTRANS_STATUSISSUE' = itrans.statusissue, 
         'INVENTTRANS_STATUSRECEIPT' = itrans.statusreceipt, 
         'INVENTTRANS_STORNO_RU' = itrans.storno_ru, 
         'INVENTTRANS_STORNOPHYSICAL_RU' = 
            itrans.stornophysical_ru, 
         'INVENTTRANS_TAXAMOUNTPHYSICAL' = 
            itrans.taxamountphysical, 
         'INVENTTRANS_TIMEEXPECTED' = itrans.timeexpected, 
         'INVENTTRANS_TRANSCHILDREFID' = 
            itrans.transchildrefid, 
         'INVENTTRANS_TRANSCHILDTYPE' = 
         itrans.transchildtype, 
         'INVENTTRANS_VALUEOPEN' = itrans.valueopen, 
         'INVENTTRANS_VALUEOPENSECCUR_RU' = 
            itrans.valueopenseccur_ru, 
         'INVENTTRANS_VOUCHER' = itrans.voucher, 
         'INVENTTRANS_VOUCHERPHYSICAL' = 
            itrans.voucherphysical 
  FROM   inventtransorigin ito 
         INNER JOIN inventtrans itrans 
                 ON itrans.inventtransorigin = ito.recid 
                    AND itrans.dataareaid = ito.dataareaid 
                    AND itrans.partition = ito.partition 

go