ODBC Driver for SugarCRM

Build 24.0.9062

Shifts

The Shifts table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Commentlog String True

Created_By String True

User who created record

Created_By_Name String True

Date_End Date False

Date is which shift is scheduled to (or did) end

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Date_Start Date False

Date in which shift is schedule to (or did) start

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Following Bool False

Is user following this record

Friday_Close_Hour String False

The hour portion of the time this business center is closed on Friday

Friday_Close_Minutes String False

The minute portion of the time this business center is closed on Friday

Friday_Open_Hour String False

The hour portion of the time this business center is open on Friday

Friday_Open_Minutes String False

The minute portion of the time this business center is open on Friday

Id [KEY] String True

Unique identifier

Is_Open_Friday Bool False

Explicit marker for if this business center is open on Friday

Is_Open_Monday Bool False

Explicit marker for if this business center is open on Monday

Is_Open_Saturday Bool False

Explicit marker for if this business center is open on Saturday

Is_Open_Sunday Bool False

Explicit marker for if this business center is open on Sunday

Is_Open_Thursday Bool False

Explicit marker for if this business center is open on Thursday

Is_Open_Tuesday Bool False

Explicit marker for if this business center is open on Tuesday

Is_Open_Wednesday Bool False

Explicit marker for if this business center is open on Wednesday

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

Monday_Close_Hour String False

The hour portion of the time this business center is closed on Monday

Monday_Close_Minutes String False

The minute portion of the time this business center is closed on Monday

Monday_Open_Hour String False

The hour portion of the time this business center is open on Monday

Monday_Open_Minutes String False

The minute portion of the time this business center is open on Monday

My_Favorite Bool False

Favorite for the user

Name String False

Saturday_Close_Hour String False

The hour portion of the time this business center is closed on Saturday

Saturday_Close_Minutes String False

The minute portion of the time this business center is closed on Saturday

Saturday_Open_Hour String False

The hour portion of the time this business center is open on Saturday

Saturday_Open_Minutes String False

The minute portion of the time this business center is open on Saturday

Sunday_Close_Hour String False

The hour portion of the time this business center is closed on Sunday

Sunday_Close_Minutes String False

The minute portion of the time this business center is closed on Sunday

Sunday_Open_Hour String False

The hour portion of the time this business center is open on Sunday

Sunday_Open_Minutes String False

The minute portion of the time this business center is open on Sunday

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Thursday_Close_Hour String False

The hour portion of the time this business center is closed on Thursday

Thursday_Close_Minutes String False

The minute portion of the time this business center is closed on Thursday

Thursday_Open_Hour String False

The hour portion of the time this business center is open on Thursday

Thursday_Open_Minutes String False

The minute portion of the time this business center is open on Thursday

Timezone String False

Time Zone in which this Shift operates

Tuesday_Close_Hour String False

The hour portion of the time this business center is closed on Tuesday

Tuesday_Close_Minutes String False

The minute portion of the time this business center is closed on Tuesday

Tuesday_Open_Hour String False

The hour portion of the time this business center is open on Tuesday

Tuesday_Open_Minutes String False

The minute portion of the time this business center is open on Tuesday

Wednesday_Close_Hour String False

The hour portion of the time this business center is closed on Wednesday

Wednesday_Close_Minutes String False

The minute portion of the time this business center is closed on Wednesday

Wednesday_Open_Hour String False

The hour portion of the time this business center is open on Wednesday

Wednesday_Open_Minutes String False

The minute portion of the time this business center is open on Wednesday

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062