/
21.09 DB Schema Changes
21.09 DB Schema Changes
- Kalyn Galloway
Owned by Kalyn Galloway
Sept 13, 2021
Analytics
Loading data...
Deleted table(s)
[tbl_Batch_Header]
[tbl_BatchHeader_Charges_XREF]
[tbl_BatchHeader_Payments_XREF]
[tbl_Quick_Ticket_Fare_Detail]
[tbl_Quick_Ticket_Fare_Detail_Fare_Header_Xref]
[tbl_Quick_Ticket_Fare_Detail_Pax_Company_Xref]
[tbl_Quick_Tickets]
[tbl_QuickTickets_GLPayments_Xref]
Added table(s)
[tbl_Res_Pending_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Res_Pending_Xref_Id_Nmbr] | BIGINT | NO |
| [lng_Reservation_Nmbr] | INT | NO |
| [str_Guid] | VARCHAR (62) | NO |
| [lng_GL_Payment_Method_Id_Nmbr] | INT | NO |
| [mny_Payment_Amt] | MONEY | NO |
| [mny_Payment_Process_Fee_Amt] | MONEY | NO |
| [str_Pending_Status] | CHAR (1) | NO |
| [bit_Pending_Lock] | BIT | NO |
| [dtm_Pending_Lock_Expiry_Date] | SMALLDATETIME | YES |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | NO |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | YES |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
Added column(s)
[tbl_3rd_Party_Pmt_Type_Definition]
Field | Data Type | NULLABLE |
|---|---|---|
| [bit_Allow_Multiple] | BIT | NO |
| [bit_Lock_Pending] | BIT | NO |
[tbl_ECATS3_Sent_History]
Field | Data Type | NULLABLE |
|---|---|---|
| [mny_WS_Dep_Enplaned_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Dep_Transiting_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Arr_Deplaned_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Arr_Transiting_Freight_Kg_Rev] | MONEY | NO |
| [mny_WS_Dep_Enplaned_Mail] | MONEY | NO |
| [mny_WS_Dep_Transiting_Mail] | MONEY | NO |
| [mny_WS_Arr_Deplaned_Mail] | MONEY | NO |
| [mny_WS_Arr_Transiting_Mail] | MONEY | NO |
[tbl_Res_Segments_Pending]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Distribution_Channel_Ident] | VARCHAR (2) | YES |
| [bit_Involuntary_Change] | BIT | NO |
| [str_Guid] | VARCHAR (62) | YES |
[tbl_Seat_Assignment_Reservation]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid] | VARCHAR (62) | NO |
[tbl_Seat_Assignment_Reservation_Verification_Hold]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid] | VARCHAR (62) | NO |
[tbl_Sked_Detail_Weight]
Field | Data Type | NULLABLE |
|---|---|---|
| [mny_Departure_Enplaned_Freight] | MONEY | NO |
| [mny_Departure_Transiting_Freight] | MONEY | NO |
| [mny_Arrival_Deplaned_Freight] | MONEY | NO |
| [mny_Arrival_Transiting_Freight] | MONEY | NO |
| [mny_Departure_Enplaned_Mail] | MONEY | NO |
| [mny_Departure_Transiting_Mail] | MONEY | NO |
| [mny_Arrival_Deplaned_Mail] | MONEY | NO |
| [mny_Arrival_Transiting_Mail] | MONEY | NO |
Deleted column(s)
[tbl_ECATS3_Sent_History]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_WS_Dep_Enplaned_Freight_Kg_Rev] | INT | NO |
| [lng_WS_Dep_Transiting_Freight_Kg_Rev] | INT | NO |
| [lng_WS_Arr_Deplaned_Freight_Kg_Rev] | INT | NO |
| [lng_WS_Arr_Transiting_Freight_Kg_Rev] | INT | NO |
[tbl_GL_Non_Res_Payments_Refund]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_GL_Refund_Notes] | VARCHAR (50) | NO |
Modified column(s)
[tbl_GL_Non_Res_Payments]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_GL_Payments_Notes] | VARCHAR (250) | NO |
[tbl_GL_Payments]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_GL_Payments_Notes] | VARCHAR (250) | NO |
[tbl_Non_Reservation_3rd_Party_Payment_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid_Id] | NVARCHAR (62) | NO |
[tbl_Reservation_3rd_Party_Payment_Xref]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Guid_Id] | NVARCHAR (62) | NO |
, multiple selections available,
Related content
23.10 DB Schema Changes
23.10 DB Schema Changes
More like this
21.12 DB Schema Changes
21.12 DB Schema Changes
More like this
22.12 DB Schema Changes
22.12 DB Schema Changes
More like this
22.06 DB Schema Changes
22.06 DB Schema Changes
More like this
24.03 DB Schema Changes
24.03 DB Schema Changes
More like this
21.11 DB Schema Changes
21.11 DB Schema Changes
More like this