21.12 DB Schema Changes
- Kalyn Galloway
Owned by Kalyn Galloway
Nov 23, 2021
1 min read
Loading data...
Added column(s)
[tbl_Accountable_Document_Form_Codes]
Field | Data Type | NULLABLE |
|---|---|---|
| [str_Accounting_Code] | CHAR (3) | NO |
| [str_Form_Code] | VARCHAR (3) | NO |
| [lng_Next_Serial] | INT | NO |
| [str_InUse] | CHAR (1) | NO |
Added tables(s)
[tbl_Ticket_Sales_Coupon_Record]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Ticket_Sales_Coupon_Record_Id_Nmbr] | CHAR (3) | NO |
| [lng_Ticket_Sales_Record_Id_Nmbr] | VARCHAR (3) | NO |
| [lng_Segment_Identifier] | INT | NO |
| [str_Coupon_Tax_Code] | CHAR (1) | NO |
| [mny_Coupon_Tax_Reported_Amount] | MONEY | NO |
| [str_Origin_Airport_Code] | VARCHAR (5) | NO |
| [str_Destination_Airport_Code] | VARCHAR (5) | NO |
| [str_Carrier] | VARCHAR (3) | NO |
| [str_Sold_Passenger_Cabin] | VARCHAR (1) | NO |
| [str_Flight_Nmbr] | VARCHAR (5) | NO |
| [str_Reservation_Booking_Designator] | VARCHAR (2) | NO |
| [dtm_Flight_Date_Time] | DATETIME | YES |
| [str_Frequent_Flyer_Reference] | VARCHAR (20) | NO |
| [str_Fare_Basis] | VARCHAR (15) | 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_Ticket_Sales_Record]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Ticket_Sales_Record_Id_Nmbr] | BIGINT | NO |
| [str_Agent_Numeric_Code] | VARCHAR (7) | NO |
| [str_Currency_Type] | VARCHAR (3) | NO |
| [str_Ticket_Number] | VARCHAR (14) | NO |
| [str_Conjunction_Ticket_Indicator] | VARCHAR (3) | NO |
| [str_Reason_For_Issuance] | VARCHAR (1) | NO |
| [str_Tour_Code] | VARCHAR (15 | NO |
| [str_Transaction_Code] | VARCHAR (4) | NO |
| [str_PNR_Reference] | VARCHAR (13) | NO |
| [mny_Commissionable_Amount] | MONEY | NO |
| [mny_Net_Fare_Amount] | MONEY | NO |
| [mny_Ticket_Document_Amount] | MONEY | NO |
| [mny_Commission_Rate] | MONEY | NO |
| [mny_Commission_Amount] | MONEY | NO |
| [mny_Supplementary_Commission_Rate] | MONEY | NO |
| [mny_Supplementary_Commission_Amount] | MONEY | NO |
| [str_Waiver_Code] | VARCHAR (14) | NO |
| [str_Reason_For_Memo_Issuance_Code] | VARCHAR (5) | NO |
| [str_Related_Ticket_Document_Coupon_Nmbr] | VARCHAR (4 | NO |
| [dtm_Related_Document_Issue_Date] | SMALLDATETIME | NO |
| [str_Original_Issue_Ticket_Document_Nmbr] | VARCHAR (14) | NO |
| [str_Original_Issue_Location] | VARCHAR (3) | NO |
| [dtm_Original_Issue_Date] | SMALLDATETIME | NO |
| [str_Original_Issue_Agent_Numeric_Code] | VARCHAR (7) | NO |
| [str_Endorsements] | VARCHAR (49) | NO |
| [mny_Fare_Amount] | MONEY | NO |
| [str_Fare_Currency_Code] | VARCHAR (3) | NO |
| [str_Fare_Tour_Indicator] | VARCHAR (2) | NO |
| [mny_Equivalent_Fare_Paid_Amount] | MONEY | NO |
| [str_Equivalent_Fare_Paid_Currency_Code] | VARCHAR (3) | NO |
| [str_Equivalent_Fare_Paid_Tour_Indicator] | VARCHAR (2) | NO |
| [mny_Total_Amount] | MONEY | NO |
| [str_Total_Currency_Code] | VARCHAR (3) | NO |
| [str_Total_Tour_Indicator] | VARCHAR (2) | NO |
| [str_Passenger_Name] | VARCHAR (49) | NO |
| [str_Passenger_Type_Code] | VARCHAR (3) | NO |
| [str_Fare_Calculation_Area] | VARCHAR (261) | 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_Ticket_Sales_Record_FOP]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Ticket_Sales_Record_FOP_Id_Nmbr] | BIGINT | NO |
| [lng_Ticket_Sales_Record_Id_Nmbr] | BIGINT | NO |
| [str_FOP_Information] | VARCHAR (50) | NO |
| [str_FOP_Type] | VARCHAR (10) | NO |
| [str_FOP_Transaction_Identifier] | VARCHAR (25) | NO |
| [mny_Amount] | DECIMAL (18) | NO |
| [mny_Account_Nmbr] | DECIMAL (18) | NO |
| [mny_Remittance_Amount] | DECIMAL (18) | 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_Ticket_Sales_Record_Tax]
Field | Data Type | NULLABLE |
|---|---|---|
| [lng_Ticket_Sales_Record_Tax_Id_Nmbr] | BIGINT | NO |
| [lng_Ticket_Sales_Record_Id_Nmbr] | BIGINT | NO |
| [str_Tax_Record_Level] | VARCHAR (1) | NO |
| [str_Tax_Type] | VARCHAR (8) | NO |
| [mny_Tax_Amount] | MONEY | 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 |