AudienceView Unlimited 7 Release Notes

ts_order_admission

Added:

•orderadmission_exchange_orderadmission_id (for future use)

•orderadmission_exchange_performance_id (for future use)

•orderadmission_exchange_price_type_id (for future use)

•orderadmission_exchange_amount_delta (for future use)

•orderadmission_exchange_amount_delta_currency (for future use)

•orderadmission_exchange_net_delta (for future use)

•orderadmission_exchange_net_delta_currency (for future use)

•orderadmission_exchange_total_delta (for future use)

•orderadmission_exchange_total_delta_currency (for future use)

•FK_ts_order_admission_ts_price_type_exchange (for future use)

•FK_ts_order_admission_ts_performance_exchange (for future use)

ts_order_payment

Added:

•orderpayment_order_payment_plan_id (uniqueidentifier - FK constraint to ts_payment_plan)

ts_order_payment_plan

Added:

•orderpaymentplan_id (uniqueidentifier - Not Null - PK)

•orderpaymentplan_order_id (uniqueidentifier - Not Null - FK constraint ts_order)

•orderpaymentplan_customer_id (uniqueidentifier - FK constraint ts_customer)

•orderpaymentplan_customer_payment_id (uniqueidentifier - FK constraint ts_customer_payment)

•orderpaymentplan_payment_plan_id (uniqueidentifier - FK constraint to ts_payment_plan)

•orderpaymentplan_total_amount (bigint)

•orderpaymentplan_total_currenty (nvarchar 10)

•orderpaymentplan_outstanding_amount (bigint)

•orderpaymentplan_outstanding_currency (nvarchar 10)

•orderpaymentplan_first_payment_amount (bigint)

•orderpaymentplan_first_payment_currency (nvarchar 10)

•orderpaymentplan_start_date (datetime)

•orderpaymentplan_end_date (datetime)

ts_payment_plan

Added:

•paymentplan_id (uniqueidentifier - Not Null - PK)

•paymentplan_name (nvarchar 100 - Not Null)

•paymentplan_description (nvarchar 512)

•paymentplan_payment_due_date (nvarchar 50)

•paymentplan_minimum_total_amount (bigint)

•paymentplan_minimum_total_currency (nvarchar 10)

•paymentplan_minimum_first_payment_amount (bigint)

•paymentplan_minimum_first_payment_currency (nvarchar 10)

•paymentplan_minimum_first_payment_type (tinyint)

•paymentplan_frequency (tinyint - Not Null)

•paymentplan_process_day_of_month (tinyint)

•paymentplan_process_day_of_week (tinyint)

•paymentplan_terms_conditions (nvarchar 2000)

•paymentplan_data1 (nvarchar 50)

•paymentplan_data2 (nvarchar 50)

•paymentplan_data3 (nvarchar 50)

•paymentplan_data4 (nvarchar 50)

ts_payment_plan_calendar

Added:

•paymentplancalendar_id (uniqueIdentifier - Not Null - PK)

•paymentplancalendar_plan_id (uniqueIdentifier - Not Null - FK constraint ts_payment_plan)

•paymentplancalendar_date_start (dateTime)

•paymentplancalendar_date_end (dateTime)

ts_service_charge

Added:

•servicecharge_pricing_type (for future use)