ProTech's home page

ProTech-Online.com

Microsoft SQL code example to pull Syteline item information.

USE [testsite_live_App]
GO
/****** Object:  StoredProcedure [MYSCHEMA].[_chad_Excel_Addin_BOM_Items]    Script Date: 06/24/2013 23:35:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [MYSCHEMA].[_chad_Excel_Addin_BOM_Items]
      --@ORDER_NUM nvarchar(12)
AS
BEGIN
      SET NOCOUNT ON;
      SELECT itm.item AS Item
            ,itm.description AS Description
            ,itm.alt_item AS 'Alternate Item'
            ,itm.stocked AS Stocked
            ,itm.u_m AS 'U/M'
            ,itm.phantom_flag AS 'Phantom Flag'
            ,itm.stat AS 'Material Status'
            ,itm.reason_code AS Reason
            ,itm.backflush AS Backflush
            ,itm.bflush_loc AS 'Backflush Location'
            ,itm.p_m_t_code AS 'Source'
            ,itm.product_code as 'Product Code'
            ,itm.revision
            ,itm.unit_cost
            ,itm.cur_u_cost
      FROM item AS itm

END



Copyright © 2013 ProTechs-Online.com; All rights reserved.