Foundation1 / Development Guide / Core Server / Base Server Dev / Model / Base-serv-mod-ref / Entity Syntax / Keywords / Keywords Itd / This page

Attribute

Attribute definition

...

Syntax:

AttributeType Name Datatype [ Format ] AttributeFlags ( PropertySet | ;)

entityname Movie;
component  APPS8;
validity   DateInterval{
   FromColumn "FROM_COLUMN";
   ToColumn   "TOCOLUMN";
};

codegenproperties {
   DbReferenceImplementation "view";
}

attributes {
   key        MovieId        NUMBER(10)         KMI-L;
   public     Title          TEXT(100)          AMIUL;
   public     ReleaseDate    DATE               A-IUL;
   public     Genre          ENUMERATION(Genre) AMIUL;
   public     CountryCode    TEXT(2)            A-IUL;
}

searchDomains {
   domain Movie;
}

associations {
   parent                               IsoCountry     IsoCountry( CountryCode)/CASCADE{   }
   reference                            ItemIdRef      MovieItem( MovieId)/NOCHECK{   }
   reference                            TypeElementRef MovieTypeElement( CountryCode, MovieId)/CUSTOM=(Check_Reference_Pfe__,){   }
   reference                            LibraryIdRef   MovieLibrary( MovieId)/CUSTOMLIST=(Check_Remove,Do_Remove){   }
}

states {
   startstate {
      always transitionTo Planned;
   }
   state Planned {
      on GoAhead [HasFunds AND HasProducer] transitionTo PreProduction;
   }
   superstate Production {
      onEntry  do CreateBudget;
      on Cancel transitionTo Cancelled;
      onExit  [FilmCompleted] do CalculateProfitTarget;
      substate PreProduction {
         on Film transitionTo Filming;
      }
      substate Filming {
         on PostProduce transitionTo PostProduction;
      }
      substate PostProduction {
         on Release transitionTo Released;
      }
   }
   endstate Released {
   }
   endstate Cancelled {
   }
}

AttributeType

Name

Name of the attribute

Syntax:

<Identifier>

Restrictions:

The name must start with an uppercase letter and can only contain letters and numbers
All attributes and associations must have unique names
The name can not be more than 26 characters long when converted to db casing

Datatype

Datatype for the attribute

Syntax:

#Datatype

Alpha - Alphanumeric text
Binary - Binary array of data
Boolean - Flag that can be either true or false
Date - Date without time information
Enumeration - Enumeration, which specifies values at design time
Lookup - Similar to Enumeration but values are looked up from another Entity in the database at runtime (e.g. Country)
Identity - Generated unique identification number
Integer - Integer
LongText - Long text
Number - Number
Text - Text
Time - Time of day
Timestamp - Date and time

Format

Optional datatype format

Syntax:

/<UppercaseIdentifier>

AttributeFlags

Flags for the attribute

Attribute flags are an abbreviated description of the most important attribute properties.

The flags are position based and their meanings are as follows:

Attribute Type	Mandatory	Insert Allowed	Update Allowed	List of Value (LOV)
P = Parent Key	M = Mandatory	I = Insert Allowed	U = Update Allowed	L = Attribute included in LOV
K = Key	- = Not Mandatory	- = Insert Not Allowed	N = Update Allowed if value is null	- = Attribute not included in LOV
A = Attribute, Public or Private			- = Update Not Allowed

Optionally add /DERIVED if the attribute is not stored in the database.

Note: Derived attributes must also have the DbSqlImplementation property set.

This page is generated from IFS Developer Studio at 2021-08-13 08:40.