dbo.v_master_bp_ak

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE VIEW dbo.v_master_bp_ak
AS
/** Script for SelectTopNRows command from SSMS **/
SELECT TOP 1000 [id_bahan_penolong]
      ,[part_no]
      ,[part_name]
      ,[part_name_customs]
      ,[hs_code]
      ,[bm]
      ,[cek_price]
      ,[currency]
      ,[part_no2]
      ,[kode_barang]
      ,[item_code]
      ,[uom]
      ,[seri_mesin]
      ,[item_type1]
      ,[item_type2]
      ,[net_weight_unit]
      ,[dangerous_good]
      ,[saldo_awal]
      ,[consumable]
      ,[kode_supplier]
      ,[create_date]
      ,[create_by]
      ,[update_date]
      ,[update_by]
      ,[aktif]
  FROM [dbo].[tbl_data_bahan_penolong]
  union all
  select
  [id_alat_kantor] * 1000000
      ,[part_no]
      ,[part_name]
      ,[part_name_customs]
      ,[hs_code]
      ,[bm]
      ,[cek_price]
      ,[currency]
      ,[part_no2]
      ,[kode_barang]
      ,[item_code]
      ,[uom]
      ,[seri_mesin]
      ,[item_type1]
      ,[item_type2]
      ,[net_weight_unit]
      ,[dangerous_good]
      ,[saldo_awal]
      ,[consumable]
      ,[kode_supplier]
      ,[create_date]
      ,[create_by]
      ,[update_date]
      ,[update_by]
      ,[aktif]
  FROM [dbo].[tbl_data_alat_kantor]   

GO