SET QUOTED_IDENTIFIER OFF
GO
CREATE view [dbo].[EDIItem]
(
    itemid,
    itemdesc,
    upc,
    defpackqty,
    itemwt,
    itemwtuom,
    itemuom,
    ediuom,
    retailprice,
    sellingprice,
    sacflag,
    sacqual,
    cubelength,
    cubewidth,
    cubeheight,
    cubeqty,
    cubeuom,
    user1,
    user2,
    user3,
    user4,
    user5,
    itemrfid
)
as

select
    itemid = dbo.EdiTextCleaner( CustomerInvoiceReportEDIItem.EDIItemCode ),
    itemdesc = dbo.EdiTextCleaner( CustomerInvoiceReportEDIItem.[Description] ),
    upc = '',
    defpackqty = null,
    itemwt = 0,
    itemwtuom = '',
    itemuom = dbo.EdiTextCleaner( CustomerInvoiceReportEDIItem.UnitOfMeasure1 ),
    ediuom = dbo.EdiTextCleaner( CustomerInvoiceReportEDIItem.UnitOfMeasure2 ),
    retailprice = null,
    sellingprice = null,
    sacflag = 0,
    sacqual = '',
    cubelength = null,
    cubewidth = null,
    cubeheight = null,
    cubeqty = 0.00,
    cubeuom = '',
    user1 = null,
    user2 = null,
    user3 = null,
    user4 = null,
    user5 = null,
    itemrfid = null
from CustomerInvoiceReportEDIItem
GO
GRANT SELECT ON  [dbo].[EDIItem] TO [MssExec]
GRANT INSERT ON  [dbo].[EDIItem] TO [MssExec]
GRANT DELETE ON  [dbo].[EDIItem] TO [MssExec]
GRANT UPDATE ON  [dbo].[EDIItem] TO [MssExec]
GO