23.12 DB Schema Changes

Added column(s)

[tbl_Baggage]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Baggage_Type]

CHAR (1)

NO

Added table(s)

[tbl_PNL_Inbound_PartyID]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_PNL_Inbound_PartyID_Id_Nmbr]

BIGINT

NO

[lng_Reservation_Nmbr]

BIGINT

NO

[str_Airline_Code]

VARCHAR (3)

NO

[str_Flight_Nmbr]

VARCHAR (10)

NO

[str_Dep_Airport_Code]

VARCHAR (5)

NO

[dtm_Flight_Date]

DATETIME2

YES

[str_Party_ID]

VARCHAR (10)

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