Microsoft SQL code example to pull Syteline aged receivables data.
USE [Testsite_live_App]GO
/****** Object: StoredProcedure [MYSCHEMA].[_chad_Excel_Addin_Executive_AR_AGED_Export] Script Date: 06/17/2013 21:39:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [MYSCHEMA].[_chad_Excel_Addin_Executive_AR_AGED_Export]
AS
BEGIN
SET NOCOUNT ON;
IF OBJECT_ID('[MYSCHEMA].chad_ar_aged_export') IS NOT NULL
BEGIN
DROP TABLE [MYSCHEMA].chad_ar_aged_export
END
DECLARE
@TcSortCurrCode CurrCodeType
, @CurrencyFormat InputMaskType
, @CurrencyPlaces DecimalPlacesType
, @TotCurrencyFormat InputMaskType
, @TotCurrencyPlaces DecimalPlacesType
, @TcSortBy NameType
, @TcCustNum CustNumType
, @TcCustName NameType
, @TcCity CityType
, @TcState StateType
, @TcSite SiteType
, @TcSiteName NameType
, @TcContact ContactType
, @TcPhone PhoneType
, @TcTempTermsCode DescriptionType
, @TcCustType CustTypeType
, @TcCreditLimit AmountType
, @TcCredhold InfoBarType
, @TcCurrCode CurrCodeType
, @TcArtranType ArtranTypeType
, @StdCh NVARCHAR(50)
, @TcArtranInvSeq INT
, @TcArtranDate CurrentDateType
, @TcArtranDueDate DateType
, @TcAmtTran AmountType
, @TcArtranExchRate ExchRateType
, @TcAmtTemp AmountType
, @PAgeDesc AgeDescType
, @PAgeDescNum GenericNoType
, @TcApprovalStatus ListPendingApprovedRejectedType
, @StdCh1 NVARCHAR(50)
, @TcCustCurrCode CurrCodeType
, @OrderByDate DateType
, @ApplyToInv InvNumType
, @TcArTranIvDate DateType
, @TcArTranChkSeq ArCheckNumType
, @InvNum InvNumType
, @TotalDays INT
, @seq INT
SELECT
@TcSortCurrCode AS TcSortCurrCode
,@CurrencyFormat AS CurrencyFormat
,@CurrencyPlaces AS CurrencyPlaces
,@TotCurrencyFormat AS TotCurrencyFormat
,@TotCurrencyPlaces AS TotCurrencyPlaces
,@TcSortBy AS TcSortBy
,@TcCustNum AS TcCustNum
,@TcCustName AS TcCustName
,@TcCity AS TcCity
,@TcState AS TcState
,@TcSite AS TcSite
,@TcSiteName AS TcSiteName
,@TcContact AS TcContact
,@TcPhone AS TcPhone
,@TcTempTermsCode AS TcTempTermsCode
,@TcCustType AS TcCustType
,@TcCreditLimit AS TcCreditLimit
,@TcCredhold AS TcCredhold
,@TcCurrCode AS TcCurrCode
,@TcArtranType AS TcArtranType
,@StdCh AS StdCh
,@TcArtranInvSeq AS TcArtranInvSeq
,@TcArtranDate AS TcArtranDate
,@TcArtranDueDate AS TcArtranDueDate
,@TcAmtTran AS TcAmtTran
,@TcArtranExchRate AS TcArtranExchRate
,@TcAmtTemp AS TcAmtTemp
,@PAgeDesc AS PAgeDesc
,@PAgeDescNum AS PAgeDescNum
,@TcApprovalStatus AS TcApprovalStatus
,@StdCh1 AS StdCh1
,@TcCustCurrCode AS TcCustCurrCode
,@OrderByDate AS OrderByDate
,@ApplyToInv AS ApplyToInv
,@TcArTranIvDate AS TcArTranIvDate
,@TcArTranChkSeq AS TcArTranChkSeq
,@InvNum AS InvNum
,@TotalDays AS TotalDays
,@seq AS seq
INTO #AR_RESULTS
WHERE 1=2
INSERT INTO #AR_RESULTS
EXEC [dbo].[Rpt_AccountsReceivableAgingSp]
@StateCycle = 'A',
@ShowActive = 1,
@PrZeroBal = 0,
@CreditHold = 'B',
@PrCreditBal = 1,
@SumToCorp = 0,
@TransDomCurr = 1,
@UseHistRate = 1,
@PrOpenItem = 'N',
@PrOpenPay = 1,
@HidePaid = 60,
@SortByCurr = 0,
@ArSortBy = 'B',
@AgeBuckets = '12345',
@InvDue = 'I',
@AgeDays1 = 30,
@AgeDesc1 = 'Current',
@AgeDays2 = 60,
@AgeDesc2 = '30 - 60',
@AgeDays3 = 90,
@AgeDesc3 = '60 - 90',
@AgeDays4 = 120,
@AgeDesc4 = '90 - 120',
@AgeDays5 = 9999,
@AgeDesc5 = '> 120',
@SiteGroup = 'Testsite',
@DisplayHeader = 0,
@ConsolidateCustomers = 0
INSERT INTO #AR_RESULTS
EXEC [dbo].[Rpt_AccountsReceivableAgingSp]
@StateCycle = 'A',
@ShowActive = 1,
@PrZeroBal = 0,
@CreditHold = 'B',
@PrCreditBal = 1,
@SumToCorp = 0,
@TransDomCurr = 1,
@UseHistRate = 1,
@PrOpenItem = 'N',
@PrOpenPay = 1,
@HidePaid = 60,
@SortByCurr = 0,
@ArSortBy = 'B',
@AgeBuckets = '12345',
@InvDue = 'I',
@AgeDays1 = 30,
@AgeDesc1 = 'Current',
@AgeDays2 = 60,
@AgeDesc2 = '30 - 60',
@AgeDays3 = 90,
@AgeDesc3 = '60 - 90',
@AgeDays4 = 120,
@AgeDesc4 = '90 - 120',
@AgeDays5 = 9999,
@AgeDesc5 = '> 120',
@SiteGroup = 'Testsite2',
@DisplayHeader = 0,
@ConsolidateCustomers = 0
INSERT INTO #AR_RESULTS
EXEC [dbo].[Rpt_AccountsReceivableAgingSp]
@StateCycle = 'A',
@ShowActive = 1,
@PrZeroBal = 0,
@CreditHold = 'B',
@PrCreditBal = 1,
@SumToCorp = 0,
@TransDomCurr = 1,
@UseHistRate = 1,
@PrOpenItem = 'N',
@PrOpenPay = 1,
@HidePaid = 60,
@SortByCurr = 0,
@ArSortBy = 'B',
@AgeBuckets = '12345',
@InvDue = 'I',
@AgeDays1 = 30,
@AgeDesc1 = 'Current',
@AgeDays2 = 60,
@AgeDesc2 = '30 - 60',
@AgeDays3 = 90,
@AgeDesc3 = '60 - 90',
@AgeDays4 = 120,
@AgeDesc4 = '90 - 120',
@AgeDays5 = 9999,
@AgeDesc5 = '> 120',
@SiteGroup = 'TESTSITE3',
@DisplayHeader = 0,
@ConsolidateCustomers = 0
SELECT
TcSite
,TcCustNum
,TcCustName
,TcTempTermsCode
,TcCustType
,TcCreditLimit
,TcCredhold
,TcArtranType
,TcArtranDueDate
,TcAmtTran
,TcArTranIvDate
,InvNum
INTO [MYSCHEMA].chad_ar_aged_export
FROM #AR_RESULTS
END