Views [dbo].[EDIItem]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnNo
Created11:16:06 AM Wednesday, January 9, 2013
Last Modified7:37:02 PM Thursday, August 29, 2024
Columns
Name
itemid
itemdesc
upc
defpackqty
itemwt
itemwtuom
itemuom
ediuom
retailprice
sellingprice
sacflag
sacqual
cubelength
cubewidth
cubeheight
cubeqty
cubeuom
user1
user2
user3
user4
user5
itemrfid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
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
Uses