23.06 DB Schema Changes
- Thao Nguyen
Updated column(s)
[tbl_Airport]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Name] | VARCHAR (100) | NO |
[tbl_Bases]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Name] | VARCHAR (100) | NO |
[tbl_Tax_Configuration]
Field | Data Type | NULLABLE |
|---|---|---|
[str_Tax_1_IATA_Code] | VARCHAR (3) | YES |
[str_Tax_2_IATA_Code] | VARCHAR (3) | YES |
[str_Tax_3_IATA_Code] | VARCHAR (3) | YES |
Added column(s)
[tbl_Ticket_Sales_Coupon_Record]
Field | Data Type | NULLABLE |
|---|---|---|
[dtm_Export_Utc_Date_Time] | DATETIME2 | YES |
[lng_Export_File_Sequence_Number] | INT | YES |
Added table(s)
[tbl_Auto_CheckIn_City_Pair]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Auto_CheckIn_City_Pair_Id_Nmbr] | INT | NO |
[lng_Dep_Airport_Id_Nmbr] | INT | NO |
[lng_Arr_Airport_Id_Nmbr] | INT | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[tbl_Coupon_Uplift_Export]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Coupon_Uplift_Export_ID] | INT | NO |
[lng_Export_File_Sequence_Number] | INT | NO |
[dtm_Export_Start_Date] | DATETIME2 | NO |
[dtm_Export_End_Date] | DATETIME2 | NO |
[dtm_Export_Execution_Date] | DATETIME2 | 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_Coupon_Uplift_Record]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Coupon_Uplift_Record_Id] | INT | NO |
[dtm_Exported_Utc_DateTime] | DATETIME2 | YES |
[lng_Export_File_Sequence_Number] | INT | YES |
[str_Document_Type] | VARCHAR (3) | NO |
[str_Document_Number] | VARCHAR (14) | NO |
[lng_Coupon_Number] | INT | NO |
[str_Coupon_Status] | VARCHAR (2) | NO |
[str_Settlement_Authorisation] | VARCHAR (14) | NO |
[dtm_Document_Issue_Date] | DATETIME2 | NO |
[str_Airline_Code] | VARCHAR (3) | NO |
[str_Flight_Number] | VARCHAR (5) | NO |
[dtm_Departure_Date] | DATETIME2 | NO |
[str_Departure_Airport_Code] | VARCHAR (5) | NO |
[str_Arrival_Airport_Code] | VARCHAR (5) | NO |
[str_Reservation_Booking_Designator] | VARCHAR (2) | NO |
[str_FareBasis_Code] | VARCHAR (20) | NO |
[str_Passenger_Name] | VARCHAR (60) | NO |
[str_Passenger_Type] | VARCHAR (3) | NO |
[str_Reason_For_Issuance_Code] | VARCHAR (1) | NO |
[str_Reason_For_Issuance_Subcode] | VARCHAR (3) | NO |
[str_Action_Request_Code] | VARCHAR (3) | 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_IATCI_Error_Codes]
Field | Data Type | NULLABLE |
|---|---|---|
[lng_Error_Codes_Id_Nmbr] | INT | NO |
[lng_Error_Codes] | INT | NO |
[str_Description] | VARCHAR (600) | 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 |