Importing Data from Marina Focus

Berth Categories:

• Name
• Marina Focus ID

Berths (Sites):

• Name
• Berth Category ID
• Berth Size ID

Booking Sources:

• Marina Focus ID
• Name

Inventory Items: 

• Marina Focus ID
• Name
• Description
• Amount
• Charge Interval
• Charge Interval Multiplier
• GST
• GL Account ID

Booking Groups: 

• Marina Focus Agreement ID as Booking Groups ID
• Booking Groups Name
• Period From
• Period To
• Booked When Date
• Source ID

Tariffs Quoted (Not Raising Charge): 

• Stay Date
• Booking ID
• Account ID
• Calculated Amount

 

Berth Size (Slab Size):

• Berth Size ID
• Berth Size Name
• Berth Width (in meters)
• Berth Length (in meters)
• Berth Height (in meters)

Guests:

• Marina Focus ID
• Title
• First & Last Name
• Gender
• Date of Birth
• Address Details
• Contact Details (Phone, Mobile, Email, Fax)

GL Accounts:

• GL Account Code
• NoteDate (if possible)

Users:

• Username
• Default NewBook Password

Bookings:

• Booked When Date
• Period From
• Period To
• Source ID
• Berth
• Guest ID
• Marina Focus Agreement ID Stored as Reference ID

Repeat Charges (Not Raising Charges):

• Booking ID
• Inventory Item ID
• Account ID
• Description
• Amount
• GST
• Charge Interval
• Charge Interval Multiplier
• Period From
• Period To
• GL Account ID