USP_RESERVATIONSTATUSHISTORY_STATUSCODE_GETLIST
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/27/2010 6:48:26 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.5.465.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_RESERVATIONSTATUSHISTORY_STATUSCODE_GETLIST
AS
select 0 'ID', 'Pending' 'DESCRIPTION'
union
select 1 'ID', 'Complete' 'DESCRIPTION'
union
select 2 'ID', 'Tentative' 'DESCRIPTION'
union
select 3 'ID', 'Confirmed' 'DESCRIPTION'
union
select 4 'ID', 'Finalized' 'DESCRIPTION'
union
select 5 'ID', 'Cancelled' 'DESCRIPTION'
union
select 6 'ID', 'Contract Sent' 'DESCRIPTION'
union
select 7 'ID', 'Contract Received' 'DESCRIPTION'
union
select 8 'ID', 'Contract Marked Not Sent' 'DESCRIPTION'
union
select 9 'ID', 'Contract Marked Not Received' 'DESCRIPTION'
union
select 10 'ID', 'Final Count Marked Not Received' 'DESCRIPTION'
union
select 11 'ID', 'Final Count Received' 'DESCRIPTION'
union
select 12 'ID', 'Order balance sent' 'DESCRIPTION'
union
select 13 'ID', 'Order balance marked not sent' 'DESCRIPTION'