CustomDeclarationPrinting Help
Allows the user to login
into the application and, based on the user type, access its
functionality
By
clicking on the Login menu, a form will pop up for the user to introduce user
name and the password
The user name and the password entered using the
Login form will be verified and in case of a positive verification, meaning, the
combination user name and password match a defined user, the user will be
authenticated and will have access to the application. If, when the user was defined the “Password change at login” was
checked, a new defined user will be requested to change the password at the
first login. For the “Password change at login” more details on Tools menu help
documentation. The action of changing the password at login is enabled through
“Passord change” form which will appear after the user logins into the
application and has the credentials (user name and password) verified
succesfully.1. Custom Declaration Printing - Menu Options
1.1 Login Menu
User
Administration – provides the following
functionalities, depending on the type of the user logged in into the
application
ü Regular User – for a regular user it allows to view the
various properties or characteristics for the user currently logged in and
using the application;
The User Admin form for a Regular User
The
only property available to be changed is the password of the user.This
operation can be performed using the “Password change” form.
§
Application Administration User – Add user
When a new user is added there are certain attributes
need to be defined or selected before the user will be saved and become a valid
user for the application:
o User Name – the name of the new user
o User Is Application Admin – the option will be checked if the
user to be created will be Application Adminstartion user type, having all the
privileges for this type of user
o Password – allows establishing the password for the new user
o Password Expiry Date – a date on which the user password will
expire and the user will not be allowed to log in into the application using
this password
o Pasword never expires – eliminates the need for the user to
change is password after it expired based on the value of Password Expiry Date
field
The Password expiry date will be automatically set to
o Passwor change at login – having this option checked the new
user will have to enter a new password after a succcesful login using the
password defined here.
o User Begin Date and User End Date – allow to define a period
of time for which the user is a valid user for the application and can log in
into the application using the combination user name and password defined for
the user
o User never expires – will make the user permanently available
for the application
User end
date will be automatically set to 31-12-9998 and will not allow to be edited
Allows to be edit any of the attributes of an already
defined application user
Database – provides the application administration user with the options
for application database administration, as it follows:
ü
Backup – allows the backup of the database that
supports the application
– the
application administration user will be prompted with a screen in which he is
notified that connections to the database will be closed and that he must save
any current work before proceeding. He can choose to cancel the backup
operation or continue.
- database backupps are placed
in a specific application folder defined in application configuration file
ü
Restore – allows the
restore of a previous backuped database
– the
application administration user will be prompted with a screen wich provides
the date and time when the database backup
was performed, so to allow the user to identify the database that
he/she wants to restore.
ü
Compact - compacts the database;
- this operation is intended to
recover the disk space lost as result of database usage and it can help improving
the database performance.
ü Empty – deletes all the information and records stored in the database, excepting the information regarding the users.
– this allows to limit the database growing and by that ensures an
optimal usage and faster response during usage, from the
application.
User
Administration – provides the following
functionalities, depending on the type of the user logged in into the
application
ü Regular User – for a regular user it allows to view the
various properties or characteristics for the user currently logged in and
using the application;
The User Admin form for a Regular User
The
only property available to be changed is the password of the user.This
operation can be performed using the “Password change” form.
§
Application Administration User – Add user
When a new user is added there are certain attributes
need to be defined or selected before the user will be saved and become a valid
user for the application:
o User Name – the name of the new user
o User Is Application Admin – the option will be checked if the
user to be created will be Application Adminstartion user type, having all the
privileges for this type of user
o Password – allows establishing the password for the new user
o Password Expiry Date – a date on which the user password will
expire and the user will not be allowed to log in into the application using
this password
o Pasword never expires – eliminates the need for the user to
change is password after it expired based on the value of Password Expiry Date
field
The Password expiry date will be automatically set to
o Passwor change at login – having this option checked the new
user will have to enter a new password after a succcesful login using the
password defined here.
o User Begin Date and User End Date – allow to define a period
of time for which the user is a valid user for the application and can log in
into the application using the combination user name and password defined for
the user
o User never expires – will make the user permanently available
for the application
User end
date will be automatically set to 31-12-9998 and will not allow to be edited
Allows to be edit any of the attributes of an already
defined application user
Database – provides the application administration user with the options
for application database administration, as it follows:
ü
Backup – allows the backup of the database that
supports the application
– the
application administration user will be prompted with a screen in which he is
notified that connections to the database will be closed and that he must save
any current work before proceeding. He can choose to cancel the backup
operation or continue.
- database backupps are placed
in a specific application folder defined in application configuration file
ü
Restore – allows the
restore of a previous backuped database
– the
application administration user will be prompted with a screen wich provides
the date and time when the database backup
was performed, so to allow the user to identify the database that
he/she wants to restore.
ü
Compact - compacts the database;
- this operation is intended to
recover the disk space lost as result of database usage and it can help improving
the database performance.
ü Empty – deletes all the information and records stored in the database, excepting the information regarding the users.
– this allows to limit the database growing and by that ensures an
optimal usage and faster response during usage, from the
application.
The
application offers the possibility of importing data as a way of loading the
database with data needed for the Custom Declarations to be printed
Data
is imported based on a Standard Input File (SIF) that reflects the
application’s database physical model
SIF
is an XML file having a corresponding XML schema file (XSD) against which is
validated to ensure that data in the SIF file conforms to the application’s
database constraint and data types.
The user has the option of selecting the SIF file
that will be used for import as well as the XSD file that will be used for
validating the SIF file. New Topic. (Press Shift-Enter to
insert a line break. Press Enter to add a paragraph return.)
Other options presented for the Import Data process
are:
·
Save XML and XSD path
into the configuration file – this allows saving the path for the SIF (XML)
file and its corresponding XSD file into the configuration file so they will be
provided as default options when the Import feature is activated;
·
Include Users for Import – By selecting this option, the user informs
the application that Import Data will process/import the users supplied in the
SIF file.
If the option
is not selected the application will ignore at import the users’ data even if
the data is present into the SIF file.
The process of importing the data consists in
a few steps, as it follows:
1. SIF (XML) validation;
2. Existing data delete from the database, the
database being emptied and being prepared for import;
3. Data import.
The
user is informed of the completion of each step and the completion status
(success or error).
Allows an application user to access application functionalities
related to printing Custom Declaration forms, forms which are country
specific.
In order to be able to print the Custom forms for a flight
passengers, application user will need to make a selection for certain mandatory
fields :
ü
Country - the Country
for which the Custom form is printed
ü
Airport - the destination airport for the
flight
ü Flights – permits the selction of the flight number, so the that Custom declaration will be printed for the passengers of a specific flight
A number of other optional selections are provided to ensure the …
ü Print Seat No – it will print the airplane seat number on the Custom declaration so to ease the distribution of the printed Custom Decalaration among the flight passengers
ü
Print Persons on separate pages – it will print a person per Custom
Declaration; option available only if the country selected is
Using the Passenger List the
user can verify the list of passengers scheduled for boarding.
The user can filter the flight that want to verify the list for, through a series of conditions.
Once the Passenger List is showed, the user can perform a series of operations:
ü Update List – allows the user to uncheck if an user did not actually board.
ü
Filter
– which allows user to search through the passenger list based on information
like First Name, Last Name, Seat No, Checked (if boarded).
These filter criteria can be combined in a group using AND or the search can be performed based of any of the filter criteria using OR.
ü Sorting - the passenger list can be sorted ascending or descending, by clicking on each of the items in the header of the list.
Custom Declaration Printing is offered for a trial period of 30 days.
In order to be able to use
it beyond this trial period the evaluation period can be extended or the product
can be purchased.
For this you need to make a request for a product activation key using Request product Key form.
ü
The information needed to
be provided are detailed below:
ü
License Requester – the
name of the company or person who requests a product activation
ley
ü
License Type – the period
for which you want to register or license the
product
ü
License Start Date –
starting date od the product registration or product
usage
ü
Windows to be licensed –
the serial number for the Windows operating system that will be licensed.This
information is automatically collected for and from the PC where the request is
sent
ü
Email – email that will
receive the product activation key and/or email for
contact
In case more licenses are
required an email should be sent to office@columnasoft.com, email having an attachement with the above mentioned
information containing the serial numbers for Windows machines that need to be
licensed.
Once the product activation
key is received, the product will be licensed/registered using the Product
Registration form.
For product registration,
the product key received will be entered and then Register Product will be
clicked.
The Exit menu allows the
application user to leave the application in two ways:
ü
Exit – the user will exit
the application and the application will be
closed
ü
Logout- the user logs off
form the application but the application remains available and another user or
the same user can log back in at any time using the Login
menu
Custom Declaration
Printing requires the presence of other Microsoft products and components, as it
follows:
ü
Microsoft .NET Framework
ü
Microsoft Report Viewer
ü
Microsoft SQL Server Compact Edition
The additional
products and components are required to be installed before the installation of
Custom Declaration Printing.
For the installation
and setup of Custom Declaration Printing there
will be provided installer programs as below:
- Custom Declaration Printing - Full Installer –
contains all the products and components required. No additional downloads and
installs are required.
- Custom Declaration Printing - Simple Installer – contains Custom Declaration Printing application and Microsoft report Viewer. Any other product or component required will need to be downloaded and installed separately, before the installation of Custom Declaration Printing.
If the application is installed in one of the Windows special or
predefined folders , make sure the Windows user which will execute the
application has, at minimum, the Write permissions for the folder on which the
application was installed.
A
definition of Windows special or predefined folders can be found here: http://msdn.microsoft.com/en-us/library/s2esdf4x.aspx
Disk space required for installer: 10 MB
Disk space required for application: 15 MB
Double-click or click Enter for
CDP_Setup_Simple.exe
If you are asked to allow the program to
make changes on your computer click
<Yes>
When the following screen shows, click Next
Choose the installation folder in this screen and click Next
The following screens will present with options of creating in the Start Menu and on Desktop
Once the Install button is hit, the installation begins
At the end of the installation the user has the option to start the application
Disk space required for installer: 62 MB
Disk space required for application and Microsoft products and components: 350 MB
Double-click or click Enter for CDP_Setup_Full.exe
If you are asked to allow the program to make changes on your computer click Yes
When the following screen shows, click Next
Choose the installation folder in this screen and click Next
The following screens will present with options of creating in the Start Menu and on Desktop
The user can review the options chosen before the installation
During the installation, additional products and components are also installed
At the end of the installation the user has the option to start the application
TABLE_NAME: Addresses |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
AddressId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
CityId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
StreetNumber |
NULL |
YES |
smallint |
NULL |
NULL |
NULL |
NULL |
StreetPreDirection |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
StreetName |
NULL |
NO |
nvarchar |
50 |
100 |
NULL |
NULL |
StreetType |
NULL |
YES |
nvarchar |
15 |
30 |
NULL |
NULL |
StreetPostDirection |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
UnitType |
NULL |
YES |
nvarchar |
10 |
20 |
NULL |
NULL |
UnitNumber |
NULL |
YES |
smallint |
NULL |
NULL |
NULL |
NULL |
TABLE_NAME: AdministrativeRegions |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
AdministrativeRegionId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
AdministrativeRegionCode |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
AdministrativeRegion |
NULL |
YES |
nvarchar |
35 |
70 |
NULL |
NULL |
AdministrativeRegionCode1 |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
AdministrativeRegion1 |
NULL |
YES |
nvarchar |
35 |
70 |
NULL |
NULL |
AdministrativeRegionCode2 |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
AdministrativeRegion2 |
NULL |
YES |
nvarchar |
35 |
70 |
NULL |
NULL |
AdministrativeRegionCode3 |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
AdministrativeRegion3 |
NULL |
YES |
nvarchar |
35 |
70 |
NULL |
NULL |
AdministrativeRegionCode4 |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
AdministrativeRegion4 |
NULL |
YES |
nvarchar |
35 |
70 |
NULL |
NULL |
CountryId |
('') |
NO |
int |
NULL |
NULL |
NULL |
NULL |
TABLE_NAME: Airlines |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
AirlineId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
OrganizationId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
AirlineCode |
NULL |
YES |
nvarchar |
10 |
20 |
NULL |
NULL |
IATACode |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
ICAOCode |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
AirlineInfo |
NULL |
YES |
nvarchar |
150 |
300 |
NULL |
NULL |
TABLE_NAME: Airports |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
AirportCode |
NULL |
NO |
nchar |
3 |
6 |
NULL |
NULL |
AirportName |
NULL |
YES |
nvarchar |
150 |
300 |
NULL |
NULL |
CountryId |
NULL |
YES |
int |
NULL |
NULL |
NULL |
NULL |
rowguid |
NULL |
NO |
uniqueidentifier |
NULL |
NULL |
NULL |
NULL |
TABLE_NAME: Cities |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
CityId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
City |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
CountryId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
AdministrativeRegionId |
NULL |
YES |
int |
NULL |
NULL |
NULL |
NULL |
Latitude |
NULL |
YES |
float |
NULL |
NULL |
NULL |
NULL |
Longitude |
NULL |
YES |
float |
NULL |
NULL |
NULL |
NULL |
TimeZone |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
UTC |
NULL |
YES |
nvarchar |
10 |
20 |
NULL |
NULL |
TABLE_NAME: CivilStatus |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
CivilStatusId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
CivilStatusCode |
NULL |
NO |
nvarchar |
2 |
4 |
NULL |
NULL |
CivilStatus |
NULL |
YES |
nvarchar |
25 |
50 |
NULL |
NULL |
CivilStatusDescription |
NULL |
YES |
nvarchar |
255 |
510 |
NULL |
NULL |
TABLE_NAME: Countries |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
CountryId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
CountryCodeA2 |
NULL |
YES |
nchar |
2 |
4 |
NULL |
NULL |
CountryCodeA3 |
NULL |
YES |
nchar |
3 |
6 |
NULL |
NULL |
CountryName |
NULL |
NO |
nvarchar |
100 |
200 |
NULL |
NULL |
rowguid |
NULL |
NO |
uniqueidentifier |
NULL |
NULL |
NULL |
NULL |
TABLE_NAME: Flights |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
FlightId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
AirportCodeDeparture |
NULL |
NO |
nchar |
3 |
6 |
NULL |
NULL |
AirportCodeArrival |
NULL |
NO |
nchar |
3 |
6 |
NULL |
NULL |
DepartureTime |
NULL |
NO |
datetime |
NULL |
NULL |
3 |
3 |
ArrivalTime |
NULL |
NO |
datetime |
NULL |
NULL |
3 |
3 |
DepartureDelay |
NULL |
YES |
smallint |
NULL |
NULL |
NULL |
NULL |
ArrivalDelay |
NULL |
YES |
smallint |
NULL |
NULL |
NULL |
NULL |
TravelClassId |
NULL |
YES |
int |
NULL |
NULL |
NULL |
NULL |
rowguid |
NULL |
NO |
uniqueidentifier |
NULL |
NULL |
NULL |
NULL |
FlightNo |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
FlighCode |
NULL |
YES |
nvarchar |
8 |
16 |
NULL |
NULL |
SeatNo |
NULL |
YES |
nvarchar |
3 |
6 |
NULL |
NULL |
AirlineId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
FlightInfromation |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
TABLE_NAME: Gender |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
GenderId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
GenderCode |
NULL |
NO |
nvarchar |
1 |
2 |
NULL |
NULL |
Gender |
NULL |
YES |
nvarchar |
25 |
50 |
NULL |
NULL |
TABLE_NAME: Groups |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
GroupId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
GroupName |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
IsAppAdmin |
((0)) |
NO |
bit |
NULL |
NULL |
0 |
NULL |
BeginDate |
(getdate()) |
NO |
datetime |
NULL |
NULL |
3 |
3 |
EndDate |
NULL |
YES |
datetime |
NULL |
NULL |
3 |
3 |
TABLE_NAME: Passports |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
PassportId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
PersonId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
PassportNo |
NULL |
NO |
nvarchar |
50 |
100 |
NULL |
NULL |
PassportIssuedDate |
NULL |
NO |
datetime |
NULL |
NULL |
3 |
3 |
PassportExpiryDate |
NULL |
NO |
datetime |
NULL |
NULL |
3 |
3 |
PassportIssueAuthority |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
CountryId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
TABLE_NAME: Persons |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
rowguid |
NULL |
NO |
uniqueidentifier |
NULL |
NULL |
NULL |
NULL |
PersonId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
ReferencedPersonId |
NULL |
YES |
int |
NULL |
NULL |
NULL |
NULL |
Salutation |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
Title |
NULL |
YES |
nvarchar |
4 |
8 |
NULL |
NULL |
FirstName |
NULL |
NO |
nvarchar |
50 |
100 |
NULL |
NULL |
MiddleName |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
LastName |
NULL |
NO |
nvarchar |
50 |
100 |
NULL |
NULL |
Suffix |
NULL |
YES |
nvarchar |
5 |
10 |
NULL |
NULL |
DateofBirth |
NULL |
NO |
datetime |
NULL |
NULL |
3 |
3 |
CivilStatusId |
NULL |
YES |
int |
NULL |
NULL |
NULL |
NULL |
GenderId |
NULL |
YES |
int |
NULL |
NULL |
NULL |
NULL |
Citizenship |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
AddressId |
NULL |
YES |
int |
NULL |
NULL |
NULL |
NULL |
TABLE_NAME: Persons_Flights |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
PersonsToFlightsId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
PersonId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
FlightId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
SeatNo |
NULL |
YES |
nvarchar |
3 |
6 |
NULL |
NULL |
Checked |
1 |
YES |
bit |
NULL |
NULL |
0 |
NULL |
TABLE_NAME: PostalCodes |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
PostalCodeId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
CityId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
PostalCode |
NULL |
NO |
nvarchar |
10 |
20 |
NULL |
NULL |
PostalBarCode |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
TABLE_NAME: TravelClasses |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
TravelClassId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
Category |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
TravelClassCode |
NULL |
NO |
nchar |
1 |
2 |
NULL |
NULL |
TravelClassDescription |
NULL |
YES |
nvarchar |
50 |
100 |
NULL |
NULL |
TestSSIS |
NULL |
YES |
nvarchar |
100 |
200 |
NULL |
NULL |
TABLE_NAME: Users |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
UserId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
UserName |
NULL |
NO |
nvarchar |
50 |
100 |
NULL |
NULL |
UserPwd |
NULL |
NO |
nvarchar |
50 |
100 |
NULL |
NULL |
PwdExpiryDate |
NULL |
YES |
datetime |
NULL |
NULL |
3 |
3 |
PwdChangeAtLogin |
NULL |
YES |
bit |
NULL |
NULL |
0 |
NULL |
IsAppAdmin |
((0)) |
NO |
bit |
NULL |
NULL |
0 |
NULL |
BeginDate |
(getdate()) |
NO |
datetime |
NULL |
NULL |
3 |
3 |
EndDate |
NULL |
YES |
datetime |
NULL |
NULL |
3 |
3 |
TABLE_NAME: Users_Groups |
|||||||
COLUMN_NAME |
COLUMN_DEFAULT |
IS_NULLABLE |
DATA_TYPE |
CHARACTER_MAXIMUM_LENGTH |
NUMERIC_PRECISION |
NUMERIC_SCALE |
DATETIME_PRECISION |
GroupId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
UserId |
NULL |
NO |
int |
NULL |
NULL |
NULL |
NULL |
BeginDate |
(getdate()) |
NO |
datetime |
NULL |
NULL |
3 |
3 |
EndDate |
NULL |
YES |
datetime |
NULL |
NULL |
3 |
3 |