Fortress Parameter |
Type & Size |
AudienceView Unlimited 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) |
EventDetails>name |
nvarchar(100) |
String(30) |
PassDetails>name |
nvarchar(100) |
|
StadiumCode |
String(6) |
EventDetails>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) |
