24.08 DB Schema Changes


Added column(s)

tbl_Ticket_Sales_Record

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Company_Identification_Number]

VARCHAR (3)

NO

[str_InHouse_Identification]

VARCHAR (50)

NO

[str_Provider_Type]

VARCHAR (3)

NO

[str_Delivering_System_Identification]

VARCHAR (2)

NO

[str_Delivering_System_Location]

VARCHAR (3)

NO

[str_Originator_Location]

VARCHAR (3)

NO

[str_Originator_Type_Code]

VARCHAR (1)

NO

[str_Originator_Country_Code]

VARCHAR (3)

NO

[str_Originator_Authority_Request_Code]

VARCHAR (6)

NO

Added table(s)

tbl_Crew_APIS_Result

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_Crew_APIS_Result_Id_Nmbr]

INT

NO

[lng_Crew_Members_Sked_Detail_XRef_Id]

INT

YES

[str_Country_Code]

VARCHAR (5)

YES

[lng_Boarding_Security_Result_Types_Id_Nmbr]

INT

YES

[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

tbl_PAXLST_City_Pair

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_PAXLST_City_Pair_Id_Nmbr]

INT

NO

[str_Departure_Airport]

VARCHAR (5)

NO

[str_Arrival_Airport]

VARCHAR (5)

NO

[str_Countries]

VARCHAR (500)

NO

[str_Minutes_Before_Flight]

VARCHAR (500)

NO

[str_Flight_Nmbrs]

VARCHAR (500)

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

tbl_Res_Header_Multi_City

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_Res_Header_Multicity_Id_Nmbr]

INT

NO

[lng_Reservation_Nmbr]

INT

YES

[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