23.10 DB Schema Changes
- Kalyn Galloway
Updated column(s)
[tbl_Security_Process]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Process_Description] | VARCHAR (100) | NO |
Added column(s)
[tbl_SSR_Definition]
Field | Data Type | NULLABLE |
|---|---|---|
[str_SSR_Removable_Flag] | CHAR (1) | NO |
[tbl_Tickets]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_GL_Payments_Id_Nmbr] | INT | NO |
[tbl_TourCode_Monitor]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Ticket_Coupon_Assignment_Id] | INT | NO |
Added table(s)
[tbl_Res_Pax_Fare_Calculation]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Fare_Calculation_Id_Nmbr] | INT | NO |
[lng_Reservation_Nmbr] | INT | NO |
[lng_Res_Pax_Group_Id_Nmbr] | INT | NO |
[str_Fare_Calculation_Line] | NVARCHAR (2000) | 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_Pax_Infant_Fare_Calculation]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Infant_Fare_Calculation_Id_Nmbr] | INT | NO |
[lng_Reservation_Nmbr] | INT | NO |
[lng_Res_Pax_Group_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Infant_Id_Nmbr] | INT | NO |
[str_Fare_Calculation_Line] | NVARCHAR (2000) | 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 |