Contents

New Tables

[tbl_Agency_Free_Penalty_Limits]

Field1	Data Type	NULLABLE
[lng_Agency_Free_Penalty_Limits_Id_Nmbr]	INT	NO
[lng_Agency_Id_Nmbr]	INT	NO
[str_Penalty_Fee_Type]	char(1)	NO
[str_Reset_Apply_Flag]	char(1)	NO
[dtm_Reset_Date]	SMALLDATETIME	NO
[lng_Free_Limit]	INT	NO
[lng_Free_Used]	INT
[tsp_Timestamp]	ROWVERSION
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

Field1	Data Type	NULLABLE
[lng_Agency_Free_Penalty_Tracking_Id_Nmbr]	INT	NO
[lng_Agency_Id_Nmbr]	INT	NO
[str_Penalty_Fee_Type]	CHAR(1)	NO
[lng_Res_Legs_Id_Nmbr]	INT	NO
tsp_Timestamp	ROWVERSION	NO
dtm_Creation_Date	SMALLDATETIME	NO
lng_Creation_User_Id_Nmbr	INT	NO

Field1	Data Type	NULLABLE
[lng_Fare_Class_Penalty_Applicability_Id_Nmbr]	INT	NO
[lng_Fare_Class_Id_Nmbr]	INT	NO
[str_Penalty_Fee_Type]	CHAR(1)	NO
[str_Book_After_Apply_Flag]	CHAR(1)	NO
[lng_Book_After]	INT
[str_Travel_Prior_Apply_Flag]	CHAR(1)
[lng_Travel_Prior]	INT
tsp_Timestamp	ROWVERSION	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