18.10 DB Schema Changes
- Nicolas Maillet (Unlicensed)
- Kenny Duffy
Owned by Nicolas Maillet (Unlicensed)
[tbl_Tax_Configuration]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [str_Tax_1_IATA_Code] | VARCHAR (2) | YES |
| [str_Tax_2_IATA_Code] | VARCHAR (2) | YES |
| [str_Tax_3_IATA_Code] | VARCHAR (2) | YES |
[tbl_Boarding_Security_Result_Types]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [str_Selectee_Indicator] | VCHAR (1) | NO |
[tbl_Charges_FareClass_XRef]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Res_Pax_Infant_Id_Nmbr] | INT | NO |
[tbl_EMDs]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Res_Pax_Group_Id_Nmbr] | INT | NO |
| [lng_Res_Pax_Infant_Id_Nmbr] | INT | NO |
| [lng_Conjunctive_Set_Id] | INT | NO |
[tbl_GL_Charge_Type_Definition]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [str_Doc_Type_Flag] | CHAR(1) | YES |
| [lng_RFIC_Id] | INT | YES |
[tbl_GL_Charges]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [str_Doc_Type_Flag] | CHAR(1) | YES |
| [str_Code] | CHAR(1) | YES |
| [str_Sub_Code] | VARCHAR (3) | YES |
[tbl_GL_SurCharge]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_RFISC_Id] | INT | YES |
[tbl_Tickets]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
[lng_Res_Pax_Group_Id_Nmbr] | INT | NO |
| [lng_Res_Pax_Infant_Id_Nmbr] | INT | NO |
| [lng_Conjunctive_Set_Id] | INT | NO |
[tbl_EMD_GL_Charges_XRef]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_EMD_GL_Charges_XRef_Id_Nmbr] | INT | NO |
| [lng_EMD_Id] | INT | NO |
| [lng_GL_Charges_Id_Nmbr] | INT | NO |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | YES |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | YES |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Fare_Class_Non_Combinability_Xref]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Fare_Class_Non_Combinability_Id_Nmbr] | INT | NO |
| [lng_Fare_Class_Id_Nmbr] | INT | NO |
| [lng_Non_Combinable_Fare_Class_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_Fare_Class_Pax_Type_Discount_XRef]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Fare_Class_Pax_Type_Discount_Id_Nmbr] | INT | NO |
| [lng_Fare_Class_Id_Nmbr] | INT | NO |
| [lng_Pax_Type_Codes_Id_Nmbr] | INT | NO |
| [lng_GL_Discounts_Id_Nmbr] | INT | NO |
| [tsp_Timestamp] | ROWVERSION | 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 |
[tbl_PAL]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_PAL_Id_Nmbr] | INT | NO |
| [str_Airline_Code_ID] | NVARCHAR (2) | NO |
| [str_Flight_Nmbr] | NVARCHAR (10) | NO |
| [dtm_Dep_Date_Local] | SMALLDATETIME | NO |
| [str_PAL_Record] | NVARCHAR (MAX) | NO |
| [str_Trigger_Reason] | NVARCHAR (10) | NO |
| [str_Dep_Airport_Ident] | NVARCHAR (5) | 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_PAL_Address]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_PAL_Address_Id_Nmbr] | INT | NO |
| [lng_Airport_Id_Nmbr] | INT | NO |
| [str_Station_Address] | VARCHAR (225) | NO |
| [str_InteliSys_Approved] | CHAR (1) | NO |
| [str_Description] | VARCHAR (200) | NO |
| [str_Active] | CHAR (1) | NO |
| [dtm_Creation_Date] | SMALLDATETIME | YES |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | YES |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_SSM_Sequence_Nmbr]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_SSM_Sequence_Nmbr_Id] | INT | NO |
| [dtm_Sequence_Date] | DATETIME | NO |
| [str_Sequence_Address] | VARCHAR (8) | YES |
| [lng_Sequence_Value] | INT | YES |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | DATETIME | NO |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | DATETIME | NO |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Ticket_GL_Charges_XRef]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Ticket_GL_Charges_XRef_Id_Nmbr] | INT | NO |
| [lng_Ticket_Id] | INT | NO |
| [lng_GL_Charges_Id_Nmbr] | INT | NO |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | YES |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | YES |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |