JDBC Driver for SugarCRM

Build 24.0.9062

BusinessCenters

The BusinessCenters table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Address_City String False

City of this Business Center

Address_Country String False

Country of this Business Center

Address_Postalcode String False

Postal Code of this Business Center

Address_State String False

State of this Business Center

Address_Street String False

Address of this Business Center

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_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

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 Business Center 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