1.0
Disk 1
Transaktionen.csv
Kassenbelege
Kassenbelege
2
,
branch_id
branch_name
transaction_id
purchased_date
YYY-MM-DD
purchase_time
client_id
client_first_name
client_last_name
client_source
purchase_voucher_discount_percentage
2
.
purchase_online_deposit
2
.
purchase_online_discount_amount
2
.
item_type
staff_id
staff_first_name
staff_last_name
staff_category_id
staff_category_name
description
quantity
discount_type
discount_value
2
.
service_id
service_name
service_category_id
service_category_name
package_id
package_name
special_offer_id
special_offer_name
product_id
product_name
product_brand_id
product_brand_name
product_category_id
product_category_name
product_barcode
product_code
course_id
course_name
client_course_name
voucher_serial
service_reward_id
service_reward_name
product_reward_id
product_reward_name
outstanding_balance_pmt
2
.
open_sale
open_sale_type
purchase_type
unit_price
2
.
service_cost
2
.
service_cost_type
online_booking
item_online_deposit
item_online_discount
original_price
2
.
loyalty_points_awarded
tax_rate
2
.
total_amount
2
.
total_amount_pre_vouch_disc
2
.
net_total_amount
2
.
gross_total_amount
2
.
net_price
2
.
gross_price
2
.
discount_amount
2
.
tax_amount
2
.
staff_tips
payment_type
department_id
department_name
is_requested_staff
session_net_amount
2
.
session_gross_amount
2
.
appointment_date
appointment_created
product_cost_price
2
.
internet_category_ids
internet_category_names
payment_type_ids
payment_type_amounts
payment_type_codes
payment_type_names
payment_type_voucher_serials
fixed_discount_id
fixed_discount_name
client_birthday
YYY-MM-DD
client_gender
client_email
client_first_visit
YYY-MM-DD
creating_user
payment_type_prepaid_tax_amounts
void
voided_transaction_id
void_reason
appt_client_id
appt_client_first_name
appt_client_last_name
appt_client_birthday
YYY-MM-DD
appt_client_gender
appt_client_email
appt_client_first_visit
YYY-MM-DD
primary_staff_id
deal
appointment_rating
branch_product_id
preferred_staff_id
preferred_staff_name
SonstigeBuchungen.csv
Barkassenbelege
Barkassenbelege
2
,
BRANCH_ID
BRANCH_NAME
ID
DATE
YYY-MM-DD
TIME
NAME
NOTES
WITHDRAWAL
AMOUNT
2
.
TAX_RATE
2
.