BookingByDay

Booking by day [BookingByDay] objects give a day-by-day representation of bookings.

—	XML	SOAP	REST	Database table
Object	`BookingByDay`	`oaBookingByDay`	—	`booking_by_day`
Supported Commands	`Read`	`read()`	—	—

—

XML

SOAP

REST

Database table

Object

BookingByDay

oaBookingByDay

—

booking_by_day

Supported Commands

Read

read()

—

The BookingByDay object has the following properties:

XML / SOAP	XML / SOAP	Description
`booking_id`	`booking_id`	[Read-only] The ID of the associated booking.
`booking_type_id`	`booking_type_id`	[Read-only] The ID of the associated booking type.
`created`	`created`	[Read-only] Time the record was created. See Date Fields
`customer_id`	`customer_id`	[Read-only] The ID of the associated customer.
`date`	`date`	[Read-only] The date of the booking. See Date Fields
`hours`	`hours`	[Read-only] The number of booked hours on this date for this customer/project/user/booking type. High precision to reduce effect of rounding.
`id`	`id`	[Read-only] Unique ID. Automatically assigned by SuiteProjects Pro. Important: Entries in the `booking_by_day` table associated with a booking are deleted and added again with different IDs every time that booking is saved. This happens even if no changes were made to the booking. Changes to work schedules and schedule exceptions can also cause `booking_by_day` records to be deleted and added again with different IDs. In addition, the `booking_by_day` table can reach large sizes, and may be regenerated from time to time for performance and data management reasons, which causes new IDs to be assigned for each entry. The `booking_by_day` ID [`id`] should not be used as a reference to a specific `booking_by_day` entry over time. To read a `booking_by_day` entry associated with a specific booking for a specific date, for example, you can use the `equal to` read method and specify the `booking_id` and `date` in your query object instead of `id`.
`job_code_id`	`job_code_id`	[Read-only] The ID of the associated job code.
`project_id`	`project_id`	[Read-only] The ID of the associated project.
`project_task_id`	`project_task_id`	[Read-only] The ID of the task within the associated project.
`updated`	`updated`	[Read-only] Time the record was last modified. See Date Fields
`userid`	`user_id`	[Read-only] The ID of the associated user.

XML / SOAP

Description

booking_id

[Read-only] The ID of the associated booking.

booking_type_id

[Read-only] The ID of the associated booking type.

created

[Read-only] Time the record was created.

See Date Fields

customer_id

[Read-only] The ID of the associated customer.

date

[Read-only] The date of the booking.

See Date Fields

hours

[Read-only] The number of booked hours on this date for this customer/project/user/booking type. High precision to reduce effect of rounding.

id

[Read-only] Unique ID. Automatically assigned by SuiteProjects Pro.

Important:

Entries in the booking_by_day table associated with a booking are deleted and added again with different IDs every time that booking is saved. This happens even if no changes were made to the booking. Changes to work schedules and schedule exceptions can also cause booking_by_day records to be deleted and added again with different IDs. In addition, the booking_by_day table can reach large sizes, and may be regenerated from time to time for performance and data management reasons, which causes new IDs to be assigned for each entry.

The booking_by_day ID [id] should not be used as a reference to a specific booking_by_day entry over time. To read a booking_by_day entry associated with a specific booking for a specific date, for example, you can use the equal to read method and specify the booking_id and date in your query object instead of id.

job_code_id

[Read-only] The ID of the associated job code.

project_id

[Read-only] The ID of the associated project.

project_task_id

[Read-only] The ID of the task within the associated project.

updated

[Read-only] Time the record was last modified.

See Date Fields

userid

user_id

[Read-only] The ID of the associated user.