/
20.09 DB Schema Changes
20.09 DB Schema Changes
Added Table(s)
[tbl_Document_Providers]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Document_Provider_Id] | INT | NO |
[str_Document_Provider_Code] | VARCHAR (2) | NO |
[str_Document_Provider_Name] | VARCHAR (20) | 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_ETicket_Free_Baggage_Allowance]
Field | Data Type | NULLABLE |
---|---|---|
[lng_ETicket_Free_Baggage_Allowance_Id_Nmbr] | INT | NO |
[str_ETicketAndCoupon_Nmbr] | VARCHAR (20) | YES |
[lng_ETCoupon_FreeBaggage_TotalWeight] | INT | NO |
[str_ETCoupon_FreeBaggage_MeasureUnitQualifier] | VARCHAR (3) | NO |
[lng_ETCoupon_FreeBaggage_TotalNumberOfPieces] | 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 |
Modified Table(s)
[tbl_Carriers]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Response_Wait_Minutes] | INT | NO |
[tbl_EMDs]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Document_Provider_Id] | INT | NO |
[tbl_Res_Header]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Document_Provider_Id] | INT | NO |
[tbl_Tickets]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Document_Provider_Id] | INT | NO |
[tbl_Accountable_Document_Form_Codes]
Field | Data Type | NULLABLE |
---|---|---|
[lng_Document_Provider_Id] | INT | NO |
[tbl_Datamart_Users]
Field | Data Type | NULLABLE |
---|---|---|
[str_User_Logon_Name] | VARCHAR (50) | NO |
Related content
20.06 DB Schema Changes
20.06 DB Schema Changes
More like this
20.08 DB Schema Changes
20.08 DB Schema Changes
More like this
19.10 DB Schema Changes
19.10 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