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:

Datatype

Datatype for the attribute

Syntax:

#Datatype

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.