Sage EasyPay Data Model

Entity Venue

Description of Entity Venue

A venue represents a location under an organisation.
Example: A training centre by a training provider

The training centre may have a different address from the training provider's main office. This can be stored as a venue record. A venue code needs to be linked to an Organisation Code. An example would be the different training locations available under a training centre.

List of all Dependencies of the Entity Venue

Relation_274439

Reference

Relation_404365

Reference

Relation_244180

Reference

List of Attributes of the Entity Venue

Entity Attribute Organisation Code of the Entity Venue

Card of Attribute Organisation Code of the Entity Venue

Name	Organisation Code
Code	OrganisationCode
Data Type	char(20)
Mandatory	No

Description of Attribute Organisation Code of the Entity Venue

Shows the organisation code. This code is the same as the reference number. It is also the primary key for the Organisation table.

Entity Attribute Venue Code of the Entity Venue

Card of Attribute Venue Code of the Entity Venue

Name	Venue Code
Code	VenueCode
Data Type	char(20)
Mandatory	Yes

Name	Description
Code	VenueDesc
Data Type	char(100)
Mandatory	No

Name	Address
Code	Address1
Data Type	char(40)
Mandatory	No

Name	Address2
Code	Address2
Data Type	char(40)
Mandatory	No

Name	Address3
Code	Address3
Data Type	char(40)
Mandatory	No

Name	Venue URL
Code	VenueURL
Data Type	char(100)
Mandatory	No

Name	Contact 1
Code	ContactNo1
Data Type	char(20)
Mandatory	No

Name	Contact 2
Code	ContactNo2
Data Type	char(20)
Mandatory	No

Name	Contact Fax
Code	ContactFax
Data Type	char(20)
Mandatory	No

Name	For Training
Code	ForTraining
Data Type	smallint
Mandatory	No

Name	For Event
Code	ForEvent
Data Type	smallint
Mandatory	No

Name	For Project
Code	ForProject
Data Type	smallint
Mandatory	No

Description of Attribute For Project of the Entity Venue

Indicates if the venue is for a project, in a form of a checkbox.

Home