Ratakan

Informations :

Smartlist Purchase Request Resolution


Window yang akan dijadikan smartlist adalah window Purchase Request Resolution



Gunakan sintax berikut dan execute di database company

create view ABC_Purchase_Request_Resolution
as
select 
a.ITEMNMBR as 'Item Number',
a.ITEMDESC as 'Item Description',
a.LOCNCODE as 'Site ID',
a.MRPISSUEDATE_I  as 'Required Date',
a.RELEASEDATE_I as 'Release Date',
a.Buy_Total as 'QTY Req(Firm)',
a.UOFM,
a.VENDORID as 'Vendor ID',
a.STR30 as 'MRP Number'
from 
MRP1010 a
go
grant select on ABC_Purchase_Request_Resolution to DYNGRP



Hasilnya akan tampak sebagai berikut :


No comments