AudienceView Connect
 Product Guides   Knowledge Base   Discussions   Support   Annual Conference   Developer Guide Login   Developer Guides  
 

Fortress to AudienceView Configuration Mappings

Table of Contents | Previous

Fortress Parameter Type & Size AudienceView Parameter Type
Operator String(50) Order>User_id nvarchar(100)
MemberID String(18) Customer>customer_number bigint(8 bytes)
  String(18) CustomerPasses>number nvarchar(50)
Product Code String(30) PerformanceDetails>name nvarchar(100)
  String(30) PassDetails>name nvarchar(100)
StadiumCode String(6) PerformanceDetails>venue_name nvarchar(100)
StandCode String(6) SectionDetails>stand nvarchar(50)
AreaCode String(4) Admissions>section nvarchar(50)
Row String (4) Admissions>row nvarchar(50)
Seat String(4) Admissions>seat nvarchar(50)
PriceBandCode String(5) PriceTypes>name nvarchar(100)
TicketNumber Int Tickets>ticket_number nvarchar(50)
Title String(10) Contact>title nvarchar(40)
Forename String(20) Contact>first_name nvarchar(100)
Surname String(50) Contact>last_name nvarchar(100)
CompanyName String(50) Contact>company nvarchar(100)
AddressName String(50) Contact>first_name + “ “ +
Contact>last_name 		201 characters
AddressLine1 String(50) Address>street nvarchar(122)
AddressLine2 String(50) Address>city nvarchar(40)
AddressLine3 String(50) Address>state nvarchar(40)
AddressLine4 String(50) Address>country nvarchar(40)
PostCode1 String(50) Address>zip nvarchar(40)
EmailAddress String(50) Contact>email nvarchar(200)
MobilePhone String(20) Contact>phone_number3 nvarchar(50)
DateOfBirth String(30) Contact>birth_date datetime (8 bytes)
PrinterCode String(10) Printer>node_name  
CardNumber Int CustomerPasses>ticket_number nvarchar(50)
Tst1 String(4) SectionDetails>ingates (first gate) nvarchar(50)
Tst2 String(4) SectionDetails>ingates (second gate) nvarchar(50)
Tst3 String(4) SectionDetails>ingates (third gate) nvarchar(50)
Tst4 String(4) SectionDetails>ingates (fourth gate) nvarchar(50)
CancelComment String Order>cancel_reason nvarchar(256)