21.06 DB Schema Changes

Owned by Kalyn Galloway

May 25, 2021

1 min read

Added Table(s)

[dbo].[tbl_Price]

Field	Data Type	NULLABLE
[lng_Price_Id_Nmbr]	BIGINT	NO
[lng_Currency_Id_Nmbr]	INT	NO
[mny_Amount]	MONEY	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

[dbo].[tbl_Price_Currency]

Field	Data Type	NULLABLE
[lng_Price_Currency_Id_Nmbr]	BIGINT	NO
[lng_Price_Id_Nmbr]	BIGINT	NO
[lng_Currency_Id_Nmbr]	INT	NO
[mny_Amount]	MONEY	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

[dbo].[tbl_Pricing_Channel]

Field	Data Type	NULLABLE
[lng_Pricing_Channel_Id_Nmbr]	INT	NO
[str_Pricing_Channel_Code]	VARCHAR (10)	NO
[str_Pricing_Channel_Name]	VARCHAR (30)	NO
[bln_System_Channel]	BIT	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

[dbo].[tbl_SSR_Definition_Price_Override]

Field	Data Type	NULLABLE
[lng_SSR_Definition_Price_Override_Id_Nmbr]	BIGINT	NO
[lng_SSR_Definition_Id_Nmbr]	INT	NO
[lng_Fare_Header_Id_Nmbr]	INT	NO
[lng_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Detail_Id_Nmbr]	INT	NO
[lng_Distribution_Channel_Id_Nmbr]	INT	NO
[lng_Fare_Class_Id_Nmbr]	INT	NO
[lng_Pricing_Channel_Id_Nmbr]	INT	NO
[lng_Price_Id_Nmbr]	INT	NO
[dtm_Applicable_From]	DATETIME2	NO
[dtm_Applicable_To]	DATETIME2	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

Modified Column(s)

[dbo].[tbl_Tax_Configuration]

Field	Data Type	NULLABLE
[mny_Tax_1_Percentage]	DECIMAL (9, 7)	NO
[mny_Tax_2_Percentage]	DECIMAL (9, 7)	NO
[mny_Tax_3_Percentage]	DECIMAL (9, 7)	NO

Deleted Column(s)

[dbo].[tbl_GL_Charges_Taxes]

Field	Data Type	NULLABLE
[mny_Tax_Percentage]	MONEY	NO