Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Null on Null Input | False |
| Schema Bound | False |
| Assembly |
Parameters
| Name | Data Type | Length | Description |
|---|---|---|---|
| @date_start | date | 3 | |
| @date_stop | date | 3 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE FUNCTION dbo.gab_rpt_mutasi_wip_wh(
@date_start date
,@date_stop date
)
RETURNS TABLE
---XencX---with encryption
AS
RETURN (
select
part_no as barang_code,
part_name as barang_name,
cast(isnull(qty_pakebom,0) as decimal(24,4)) as qty,
unit as satuan_code
from dbo.f_mutasi_wip1(@date_stop)
)
GO
GO
CREATE FUNCTION dbo.gab_rpt_mutasi_wip_wh(
@date_start date
,@date_stop date
)
RETURNS TABLE
---XencX---with encryption
AS
RETURN (
select
part_no as barang_code,
part_name as barang_name,
cast(isnull(qty_pakebom,0) as decimal(24,4)) as qty,
unit as satuan_code
from dbo.f_mutasi_wip1(@date_stop)
)
GO
Depends On
1Used By
No items found