19.08 DB Schema Changes

Owned by Nicolas Maillet (Unlicensed)
Last updated: Jul 23, 2019
1 min read

[tbl_PHOBOS_Comm_Rules]

Added Field(s)

FieldDatatypeNULLABLE
[str_Targeted_Carrier_Code]VARCHAR (2)YES

[tbl_Carrier_Operating_Rbd_Map]

New Table

FieldDatatypeNULLABLE
[lng_Carrier_Operating_Rbd_Map_Id_Nmbr]INTNO
[lng_Carrier_Id]INTNO
[lng_Fare_Category_Id_Nmbr]INTNO
[str_Operating_Rbd]CHAR(1)NO
[lng_Quota_Sale]INTNO
[tsp_Timestamp]ROWVERSIONNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO

[tbl_EDIFACT_Msg_Interaction]

New Table

FieldDatatypeNULLABLE
[lng_EDIFACT_Msg_Interaction_Id_Nmbr]INTNO
[str_Sending_Process]VARCHAR (20)NO
[str_Control_Reference]VARCHAR (14)NO
[dtm_Request_Sent]SMALLDATETIMENO
[dtm_Response_Received]SMALLDATETIMEYES
[bit_Request_Failed]BITYES
[tsp_Timestamp]ROWVERSIONNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO