ODBC Driver for SugarCRM

Build 23.0.8839

BusinessCenters

The BusinessCenters table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String False

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Modified_User_Id String True

User who last modified record

Modified_By_Name String True

Created_By String True

User who created record

Created_By_Name String True

Description String False

Full text of the note

Deleted Bool False

Record deletion indicator

Timezone String False

Time Zone in which this Business Center operates

Address_Street String False

Address of this Business Center

Address_City String False

City of this Business Center

Address_State String False

State of this Business Center

Address_Postalcode String False

Postal Code of this Business Center

Address_Country String False

Country of this Business Center

Geocode_Status String True

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Tag String False

Commentlog String True

Locked_Fields String True

Sync_Key String True

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Team_Id String False

Team ID for the account

Team_Set_Id String False

Acl_Team_Set_Id String False

Team_Count String False

Team_Name String False

Acl_Team_Names String True

Is_Open_Sunday Bool False

Explicit marker for if this business center is open 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

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

Is_Open_Monday Bool False

Explicit marker for if this business center is open 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

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

Is_Open_Tuesday Bool False

Explicit marker for if this business center is open 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

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

Is_Open_Wednesday Bool False

Explicit marker for if this business center is open 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

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

Is_Open_Thursday Bool False

Explicit marker for if this business center is open 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

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

Is_Open_Friday Bool False

Explicit marker for if this business center is open 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

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

Is_Open_Saturday Bool False

Explicit marker for if this business center is open 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

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

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