24.06 DB Schema Changes
- Kalyn Galloway
Analytics
Added column(s)
[tbl_Airline_Codes_Definition]
Field | Data Type | NULLABLE |
|---|---|---|
[str_GDS_Address] | VARCHAR (10) | YES |
[tbl_Currency]
Field | Data Type | NULLABLE |
|---|---|---|
[tsp_Timestamp] | ROWVERSION | NO |
[mny_Fare_Rounding_Unit] | MONEY | NO |
[mny_Charge_Rounding_Unit] | MONEY | NO |
[mny_Tax_Rounding_Unit] | MONEY | NO |
[lng_Decimal_Unit] | INT | NO |
[str_Rounding_Algorithm] | NVARCHAR (2000) | NO |
[tbl_EMDs]
Field | Data Type | NULLABLE |
|---|---|---|
[bit_Internal] | BIT | NO |
[tbl_Sked_Detail_Weight]
Field | Data Type | NULLABLE |
|---|---|---|
[mny_Undefined_Weight] | MONEY | YES |
[tbl_SSR_Definition]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Weight] | INT | YES |
[tbl_Ticket_Sales_Record_Tax]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Tax_Category] | VARCHAR (3) | NO |
[tbl_SSR_Definition_Price_Override_Agency_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_SSR_Definition_Price_Override_Agency_Id_Nmbr] | BIGINT | NO |
[lng_SSR_Definition_Price_Override_Id_Nmbr] | BIGINT | NO |
[lng_Agency_Id_Nmbr] | INT | NO |
[tsp_Timestamp] | ROWVERSION | NO |
[dtm_Creation_Date] | DATETIME2 | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | DATETIME2 | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |