Added Table(s)

[tbl_GDS_AVS_Sked_Segment]

Field1	Data Type	NULLABLE
[lng_GDS_AVS_Sked_Segment_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[str_Flight_Nmbr]	VARCHAR (10)	NO
[dtm_Flight_Date]	SMALLDATETIME	NO
[str_Airline_Code]	VARCHAR (5)	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[str_Dep_Ident]	CHAR (3)	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[str_Arr_Ident]	CHAR (3)	NO
[lng_Fare_Category_Id_Nmbr]	INT	NO
[str_Fare_Category_Ident]	CHAR (3)	NO
[str_Existing_Status_Code]	VARCHAR (2)	NO
[str_Status_Code]	CHAR (2)	NO
[lng_Availability]	INT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	INT	NO
[str_Message]	VARCHAR (40)	NO
[lng_Times_Processed]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_GDS_AVS_Sked_Segment_History_Id_Nmbr]	INT	NO
[lng_GDS_AVS_Sked_Segment_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[str_Flight_Nmbr]	VARCHAR (10)	NO
[dtm_Flight_Date]	SMALLDATETIME	NO
[str_Airline_Code]	VARCHAR (5)	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[str_Dep_Ident]	CHAR (3)	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[str_Arr_Ident]	CHAR (3)	NO
[lng_Fare_Category_Id_Nmbr]	INT	NO
[str_Fare_Category_Ident]	CHAR (3)	NO
[str_Existing_Status_Code]	VARCHAR (2)	NO
[str_Status_Code]	CHAR (2)	NO
[lng_Availability]	INT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	INT	NO
[str_Message]	VARCHAR (40)	NO
[lng_Times_Processed]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[str_Indicator_Flag]	CHAR (1)	YES

Field1	Data Type	NULLABLE
[lng_Leg_Route_Allocation_Id_Nmbr]	INT	NO
[lng_Leg_Route_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Leg_Route_Allocation_Hold_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	INT	NO
[str_MSG_Guid]	VARCHAR (50)	NO
[lng_Allocation_Adjustment]	INT	NO
[dtm_Allocation_Hold_Expires]	SMALLDATETIME	NO
[lng_Allocation_Hold_Status]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Leg_Route_Allocation_Hold_History_Id_Nmbr]	INT	NO
[lng_Leg_Route_Allocation_Hold_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	INT	NO
[str_MSG_Guid]	VARCHAR (50)	NO
[lng_Allocation_Adjustment]	INT	NO
[dtm_Allocation_Hold_Expires]	SMALLDATETIME	NO
[lng_Allocation_Hold_Status]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	INT	NO
[lng_Fare_Category_Id_Nmbr]	INT	NO
[lng_Allocated_Seats]	INT	NO
[lng_Available_Amount]	INT	NO
[lng_Sold_Amount]	INT	NO
[lng_Max_Availability_Display]	INT	NO
[str_Closed_Flag]	CHAR (1)	NO
[str_GDS_Flag]	CHAR (1)	NO
[str_AVS_Status_Code]	VARCHAR (2)	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Sked_Segment_Fare_Allocation_Audit_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	INT	NO
[lng_Fare_Category_Id_Nmbr]	INT	NO
[lng_Allocated_Seats]	INT	NO
[lng_Available_Amount]	INT	NO
[lng_Sold_Amount]	INT	NO
[lng_Max_Availability_Display]	INT	NO
[str_Closed_Flag]	CHAR (1)	NO
[str_GDS_Flag]	CHAR (1)	NO
[str_AVS_Status_Code]	VARCHAR (2)	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Level_of_Service_Id_Nmbr]	INT	NO
[lng_Seats]	INT	NO
[lng_Curtail]	INT	NO
[lng_Oversell]	INT	NO
[lng_Sold_Amount]	INT	NO
[lng_Infant_Sold_Amount]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Sked_Segment_Option_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[bit_Valid]	BIT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Sked_Segment_Option_Detail_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Option_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[bit_Valid]	BIT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	INT	NO
[lng_Agency_Id_Nmbr]	INT	NO
[lng_Allocated_Seats]	INT	NO
[lng_Start_Allocated_Seats]	INT	NO
[lng_Override_Seats]	INT	NO
[lng_Seats_From_Public]	INT	NO
[lng_Sold_Amount]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field1	Data Type	NULLABLE
[lng_Sked_Segment_Seat_Allocation_Audit_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	INT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	INT	NO
[lng_Agency_Id_Nmbr]	INT	NO
[lng_Allocated_Seats]	INT	NO
[lng_Start_Allocated_Seats]	INT	NO
[lng_Override_Seats]	INT	NO
[lng_Seats_From_Public]	INT	NO
[lng_Sold_Amount]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[str_Percentage_Rate]	CHAR(1)	NO

Field	Data Type	NULLABLE
[dtm_Old_Flight_Date]	DATETIME	NOT NULL
[dtm_New_Flight_Date]	DATETIME	NOT NULL