The DUOS is composed of user-defined collections,
each of which can store several data objects. Each data object can
contain several properties and property values. The following table
shows the structure of the DUOS that contains two user-defined
collections (Customers and Items):
The Collection name is a string
specifying the user-defined collection where you’re storing the
data object. This name cannot exceed 30 characters. You can create
or specify the collection you want to work with using the global
DUOSObjectsGetmethod.
The Object ID is a unique value for
a data object within its collection. This ID cannot exceed 60
characters. You can specify the object ID using the Itemproperty
from the DUOSObjects collection.
The Property name is a string that
specifies the name of the property for the object. The property
name cannot exceed 30 characters. You can define several property
names for a data object. Each object in a collection may contain
different property names. You can specify the property name using
the Itemproperty
in the DUOSProperties collection.
A data object must have at least one
property name to remain persistent in the DUOS.
The Property value is a
string that specifies the value of the property. This value cannot
exceed 132 characters. The DUOS stores all property values as
strings. You can specify a property value using the Valueproperty
from the DUOSProperty object.
Microsoft Dynamics GP stores DUOS data objects in
a table named SY_User_Object_Store (SY90000.*). This table is
company-specific, so Microsoft Dynamics GP stores data objects you
create for each company in separate tables, located in separate
directories. The combination of the collection name, object ID,
property name and property value all make up a single record in
this table:
If two additional properties and property values
are added to the ITM001 data object, the accounting system adds two
records to this table:
Since Microsoft Dynamics GP stores DUOS data
objects in a table, you can use table maintenance windows to
perform routine table maintenance.