The Location Object

This item maps to the Location object in the FlexNet Manager Suite compliance database.

Database interaction

If an incoming Location is not matched by an existing record in the compliance database, a new record is created there.

If an incoming Location matches an existing record in the compliance database, details are updated (as allowed for individual properties described below).

Behavior in the Business Adapter Studio

When you create new objects in the Business Adapter Studio, the Location appears in the Enterprise Groups group in the right-click context menu.

Within the Business Adapter Studio, the default name suggested for the Output attribute of this Location object is Location_ID.

Properties

The Location object exposes the following properties in the data model for the Business Importer and the Business Adapter Studio.

Table 1. Data model properties for Location object (alphabetical listing)

Property

Details

Address - City

Type: varchar. Maximum: 200.

Maps to Location.address_city in the compliance database.

Address - Country

Type: varchar. Maximum: 100.

Maps to Location.address_country in the compliance database.

Address - State

Type: varchar. Maximum: 200.

Maps to Location.address_state in the compliance database.

Address - Street

Type: varchar. Maximum: 200.

Maps to Location.address_street in the compliance database.

Address - Zip

Type: varchar. Maximum: 20.

Maps to Location.address_zip in the compliance database.

Business Phone Number

Type: varchar. Maximum: 30.

Maps to Location.businessphonenumber in the compliance database.

Description

Type: ntext.

Maps to Location.comments in the compliance database.

Email Address

Type: varchar. Maximum: 200.

Maps to Location.email in the compliance database.

Fax Number

Type: varchar. Maximum: 30.

Maps to Location.faxphonenumber in the compliance database.

ID

Type: int.

For the ID property, the Business Adapter Studio offers a list of the output field names from previous objects in the adapter.

Maps to Location.groupexid in the compliance database.

It is used (perhaps in conjunction with other properties) as a key for matching existing records there. In the Business Adapter Studio, SQL-like expressions for pattern matching (contained in the MatchingMask attribute of the adapter's XML file) are supported for this property.

An exception is the case when the incoming ID is null. In these cases, the property is excluded from the matching process, which then relies on other properties of the Location object.

However, updates to the stored value of Location.groupexid are not permitted.

Name

Type: varchar. Maximum: 128. Mandatory: adapters must provide values for this column.

Individual groups in the path through the enterprise group hierarchy are separated with the / character.

Maps to Location.groupcn in the compliance database.

It is used (perhaps in conjunction with other properties) as a key for matching existing records there.

However, updates to the stored value of Location.groupcn are not permitted.

Data model version 13.2

2022 R1