...
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 { } }
Name of the attribute
Syntax:
<Identifier>
Restrictions:
Datatype for the attribute
Syntax:
#Datatype
Optional datatype format
Syntax:
/<UppercaseIdentifier>
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.