Microsoft SQL code example to pull Syteline customer order information for edi communication.

USE [testsite_live_App]
GO
/****** Object: StoredProcedure [MYSCHEMA].[_chad_EDI_pull_CO]    Script Date: 06/24/2013 23:31:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [MYSCHEMA].[_chad_EDI_pull_CO]
      @ORDER_NUM nvarchar(12)
AS
BEGIN
      SET NOCOUNT ON;
      SELECT T1.cust_po AS PONUM
            ,T3.name AS NAME
            ,T1.co_num AS ORDERNUM
            ,T4.UDFDT1 AS DTREQUESTED
            ,T4.UDFDT2 AS DTPROMISED
            ,T3.addr##1 AS ADDRESS1
            ,T3.addr##2 AS ADDRESS2
            ,T3.city AS CITY
            ,T3.state AS STATE
            ,T6.iso_country_code AS COUNTRY
            ,T3.zip AS ZIP
            ,T1.ship_code AS CARRIER
            ,T2.cust_item AS ALTITEMNUM
            ,T2.item AS ITEMNUM
            ,T5.description AS ALTITEMDESC
            ,CAST(T2.qty_ordered AS INT) AS QTY
            ,CAST(T2.qty_shipped AS INT) AS SHIPQTY
            ,T2.co_line AS LINE_NUM
            ,T1.charfld1 AS PO_TYPE
      FROM co AS T1
            INNER JOIN coitem AS T2 ON
                  T1.co_num = T2.co_num
                  AND T1.co_num = @ORDER_NUM
            INNER JOIN custaddr AS T3 ON
                  T1.cust_num = T3.cust_num
                  AND T1.cust_seq = T3.cust_seq
            LEFT OUTER JOIN UserDefinedFields AS T4 ON
                  T1.RowPointer = T4.RowId
                  AND T4.TableName = 'co'
            LEFT OUTER JOIN item AS T5 ON
                  T2.item = T5.item
            LEFT OUTER JOIN country AS T6 ON
                  T3.country = T6.country

END