22.09 DB Schema Changes
- Kalyn Galloway
- 1 Added table(s)
- 1.1 [tbl_Res_Charge]
- 1.2 [tbl_Res_Pax_Fare_Component]
- 1.3 [tbl_Res_Pax_Fare_Component_Charge_Xref]
- 1.4 [tbl_Res_Pax_Fare_Component_Passive_Leg_Xref]
- 1.5 [tbl_Res_Pax_Infant_Fare_Component]
- 1.6 [tbl_Res_Pax_Infant_Fare_Component_Charge_Xref]
- 1.7 [tbl_Res_Pax_Infant_Fare_Component_Passive_Leg_Xref]
- 1.8 [tbl_Res_Pax_Infant_Passive_Leg_Charge_Xref]
- 1.9 [tbl_Res_Pax_Passive_Leg_Charge_Xref]
- 2 Added Column(s)
- 2.1 [tbl_CRS]
Added table(s)
[tbl_Res_Charge]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Charge_Id_Nmbr] | BIGINT | NO |
[lng_Reservation_Nmbr] | INT | NO |
[lng_GL_Charge_Type_Id_Nmbr] | INT | NO |
[lng_GL_SurCharge_Id_Nmbr] | INT | NO |
[lng_Tax_Configuration_Id_Nmbr] | INT | NO |
[str_Visible_Flag] | CHAR (1) | NO |
[str_Refundable_Charge] | CHAR (1) | NO |
[str_Private_Flag] | CHAR (1) | NO |
[lng_Currency_Id_Nmbr] | INT | NO |
[mny_Exchange_Rate] | FLOAT (53) | NO |
[dtm_Charge_Date] | SMALLDATETIME | NO |
[str_Charge_Desc] | VARCHAR (60) | NO |
[mny_Amount] | MONEY | NO |
[mny_Discount] | MONEY | NO |
[mny_Taxes] | MONEY | NO |
[mny_Total] | MONEY | NO |
[mny_Currency_Amount] | MONEY | NO |
[mny_Currency_Discount] | MONEY | NO |
[mny_Currency_Taxes] | MONEY | NO |
[mny_Currency_Total] | MONEY | NO |
[str_Charge_Notes] | VARCHAR (50) | NO |
[str_Doc_Type_Flag] | CHAR (1) | YES |
[str_Code] | CHAR (1) | YES |
[str_Sub_Code] | VARCHAR (3) | YES |
[bit_Fully_Paid] | BIT | NO |
[dtm_Creation_Date] | DATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
|
| NO |
[tbl_Res_Pax_Fare_Component]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Fare_Component_Id_Nmbr] | INT | NO |
[lng_Reservation_Nmbr] | INT | NO |
[lng_Res_Pax_Group_Id_Nmbr] | INT | NO |
[lng_Fare_Class_Id_Nmbr] | INT | NO |
[str_Fare_Basis_Code] | VARCHAR (20) | 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_Fare_Component_Charge_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Fare_Component_Charge_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Fare_Component_Id_Nmbr] | INT | NO |
[lng_Res_Charge_Id_Nmbr] | BIGINT | 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_Fare_Component_Passive_Leg_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Fare_Component_Passive_Leg_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Fare_Component_Id_Nmbr] | INT | NO |
[lng_Res_Passive_Legs_Id_Nmbr] | INT | NO |
[tsp_Timestamp] | ROWVERSION | 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_Component]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Infant_Fare_Component_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 |
[lng_Fare_Class_Id_Nmbr] | INT | NO |
[str_Fare_Basis_Code] | VARCHAR (20) | 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_Component_Charge_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Infant_Fare_Component_Charge_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Infant_Fare_Component_Id_Nmbr] | INT | NO |
[lng_Res_Charge_Id_Nmbr] | BIGINT | 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_Component_Passive_Leg_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Infant_Fare_Component_Passive_Leg_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Infant_Fare_Component_Id_Nmbr] | INT | NO |
[lng_Res_Passive_Legs_Id_Nmbr] | INT | 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_Passive_Leg_Charge_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Infant_Passive_Leg_Charge_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Group_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Infant_Id_Nmbr] | INT | NO |
[lng_Res_Passive_Legs_Id_Nmbr] | INT | NO |
[lng_Res_Charge_Id_Nmbr] | BIGINT | 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_Passive_Leg_Charge_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Passive_Leg_Charge_Id_Nmbr] | INT | NO |
[lng_Res_Pax_Group_Id_Nmbr] | INT | NO |
[lng_Res_Passive_Legs_Id_Nmbr] | INT | NO |
[lng_Res_Charge_Id_Nmbr] | BIGINT | 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 |
Added Column(s)
[tbl_CRS]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Res_Pax_Passive_Leg_Charge_Id_Nmbr] | SMALLDATETIME | NO |
[lng_Res_Pax_Group_Id_Nmbr] | INT | YES |