dbo.vw_ms_molts_grn

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
@start_date	date	3
@end_date	date	3

SQL Script

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE FUNCTION dbo.vw_ms_molts_grn_lookup(
@start_date date,
@end_date date
)
RETURNS TABLE
---XencX---with encryption
AS
RETURN (
SELECT id
      ,used
      ,GRNUMBER
      ,GRDATE
      ,PARTNUMBER
      ,PARTCODE
      ,PARTUNIT
      ,PARTETA
      ,GRQTY
      ,PARTPRICE
      ,PONUMBER
      ,PODATE
      ,KODE_DOKUMEN_PABEAN
      ,BC_TYPE
      ,CAR
      ,BC_DATE
      ,BC_NO
      ,STATUS_MODULE
      ,SHIPPING
      ,SHIPPER
      ,create_date
      ,create_by
      ,mapping_supplier_customer_id
      ,mapping_date
      ,mapping_by
      ,r_s
   ,mapped
   ,cleansing
  FROM vw_ms_molts_grn
  WHERE GRDATE BETWEEN @start_date and @end_date


)

--GO

-- select * from gab_rpt_incoming ('12/12/2015', '12/12/2016','BC27')
GO

Depends On

dbo.vw_ms_molts_grn

Used By

No items found