FROM	ORDER	Data Type	Nullable?
	{{Id}}	INT	NOT NULL,
	{{MemberId}}	INT	NOT NULL,
	{{OrderStatus}}	VARCHAR (20)	NOT NULL,
	{{OrderDateTime}}	DATETIME	NOT NULL,
	{{ShippingMethodCode}}	VARCHAR (10)	NOT NULL,
	{{ShippingMethodName}}	VARCHAR (100)	NOT NULL,
	{{Email}}	VARCHAR (100)	NOT NULL,
	{{Name}}	VARCHAR (200)	NOT NULL,
	{{CompanyName}}	VARCHAR (200)	NULL,
	{{Address}}	VARCHAR (300)	NOT NULL,
	{{City}}	VARCHAR (100)	NOT NULL,
	{{State}}	VARCHAR (20)	NULL,
	{{TaxRegion}}	VARCHAR (10)	NOT NULL,
	{{PostalCode}}	VARCHAR (20)	NOT NULL,
	{{PhoneNumber}}	VARCHAR (20)	NOT NULL,
	{{AltPhoneNumber}}	VARCHAR (20)	NULL,
	{{Subtotal}}	CALCULATED ITEM COST * QTY
	{{ShippingCost}}	MONEY	NOT NULL,
	{{HandlingCost}}	MONEY	NOT NULL,
	{{TotalCost}}	MONEY	NOT NULL,
	{{DiscountCost}}	MONEY	NOT NULL,
	{{OrderNote}}	VARCHAR (300)	NULL,
	{{RequestUpgrade}}	BIT	NULL,
	{{TotalTaxes}}	MONEY	NULL,
	{{ReferralName}}	VARCHAR (50)	NULL,
	{{Tracking}}	VARCHAR (100)	NULL,
	{{TrackingUrl}}	VARCHAR (300)	NULL,
	{{ShipDate}}	DATETIME	NULL,
	{{AvailableDate}}	DATETIME	NULL,
	{{RiskStatus}}	VARCHAR (10)	NULL,
	{{RiskComment}}	VARCHAR (200)	NULL,
	{{RiskStatusDate}}	DATETIME	NULL,
	{{TicketFilesCount}}	INT	NULL,
	{{ShippingMethodId}}	INT	NULL,
	{{CouponCode}}	VARCHAR (50)	NULL,
	{{ServiceFee}}	MONEY	NULL,
	{{OrderCurrency}}	VARCHAR (10)	NULL,
FROM	Order Item	Data Type	Nullable?
	{{Item_Id}}	INT	NOT NULL,
	{{Item_OrderId}}	INT	NOT NULL,
	{{Item_TicketGroupId}}	INT	NOT NULL,
	{{Item_EventName}}	VARCHAR (200)	NOT NULL,
	{{Item_VenueName}}	VARCHAR (200)	NOT NULL,
	{{Item_EventDateTime}}	DATETIME	NOT NULL,
	{{DisplayEventDate}}	DATE FORMATED WITH T.B.A.
	{{Item_Quantity}}	INT	NOT NULL,
	{{Item_Section}}	VARCHAR (100)	NOT NULL,
	{{Item_Row}}	VARCHAR (100)	NOT NULL,
	{{Item_StartingSeat}}	INT	NULL,
	{{Item_EndingSeat}}	INT	NULL,
	{{Item_IsOddEvent}}	BIT	NOT NULL,
	{{Item_Price}}	MONEY	NOT NULL,
	{{Item_Cost}}	MONEY	NOT NULL,
	{{Item_ShortNote}}	VARCHAR (200)	NULL,
FROM	Order Payment	Data Type	Nulllable?
	{{Pmt_Id}}	INT	NOT NULL,
	{{Pmt_OrderId}}	INT	NOT NULL,
	{{Pmt_PaymentAmount}}	MONEY	NOT NULL,
	{{Pmt_BalanceAmount}}	MONEY	NULL,
	{{Pmt_PaymentNumber}}	VARCHAR (50)	NOT NULL,
	{{Pmt_PaymentAuthorization}}	VARCHAR (50)	NULL,
	{{Pmt_PaymentApproval}}	VARCHAR (50)	NULL,
	{{Pmt_ApprovalGateway}}	VARCHAR (50)	NULL,
	{{Pmt_PaymentExpDate}}	VARCHAR (5)	NULL,
	{{Pmt_PaymentType}}	VARCHAR (2)	NULL,
OTHER TAGS
	{{OrderXML}}	Complete Order Details in XML Format for AP
	{{RiskifiedXML}}	Riskified Approval/Reject  Details in XML Format For AP
	{{New Account Section}}	Conditional section to be included in Incentive
	{{End New Account Section}}	emails when a new account is created
	{{DiscountAmount}}	Discount for Incentives
	{{IncentiveCode}}	Incentive Code for Incentive Notification
	{{ResetPasswordUrl}}	Url to reset password of newly created account