/
18.10 DB Schema Changes
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 |
Related content
18.06 DB Schema Changes
18.06 DB Schema Changes
More like this
19.10 DB Schema Changes
19.10 DB Schema Changes
More like this
18.09 DB Schema Changes
18.09 DB Schema Changes
More like this
21.12 DB Schema Changes
21.12 DB Schema Changes
More like this
24.06 DB Schema Changes
24.06 DB Schema Changes
More like this
24.08 DB Schema Changes
24.08 DB Schema Changes
More like this