22.12 DB Schema Changes



Added table(s)

[tbl_Ticket_Res_Charge_Xref]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_Ticket_Res_Charge_XRef_Id_Nmbr]

INT

NO

[lng_Ticket_Id]

INT

NO

[lng_Res_Charge_Id_Nmbr]

BIGINT

NO

[str_Active_Xref]

CHAR (1)

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

Added column(s)

[tbl_GL_Payments_Refund]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_User_Airport_Id_Nmbr]

INT

NO

[tbl_Ticket_Sales_Record]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_IATA_Nmbr]

VARCHAR (12)

NO

[tbl_Ticket_Sales_Record_FOP]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_IATA_Nmbr]

VARCHAR (12)

NO