/
21.06 DB Schema Changes
21.06 DB Schema Changes
- Kalyn Galloway
Owned by Kalyn Galloway
May 25, 2021
Analytics
Loading data...
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 |
, multiple selections available,
Related content
22.09 DB Schema Changes
22.09 DB Schema Changes
More like this
22.06 DB Schema Changes
22.06 DB Schema Changes
More like this
24.06 DB Schema Changes
24.06 DB Schema Changes
More like this
20.11 DB Schema Changes
20.11 DB Schema Changes
More like this
21.11 DB Schema Changes
21.11 DB Schema Changes
More like this
21.09 DB Schema Changes
21.09 DB Schema Changes
More like this