Muokkaa

Jaa


Grant in Main(ProjGrant)

Latest version of the JSON entity definition is available on GitHub.

Traits

Traits for this entity are listed below.

is.identifiedBy
names a specifc identity attribute to use with an entity

ParameterValueData typeExplanation
attributeProjGrant/(resolvedAttributes)/RecIdattribute

is.CDM.entityVersion

ParameterValueData typeExplanation
versionNumber"1.1"stringsemantic version number of the entity

is.application.releaseVersion

ParameterValueData typeExplanation
releaseVersion"10.0.13.0"stringsemantic version number of the application introducing this entity

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enGrant
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Main/ProjGrant
ActualAwardDate Main/ProjGrant
ActualExpirationDate Main/ProjGrant
ActualStartDate Main/ProjGrant
ApplicationDueDate Main/ProjGrant
ApplicationSubmittedDate Main/ProjGrant
AwardedAmount Main/ProjGrant
BoardApprovalDate Main/ProjGrant
CFDAId Main/ProjGrant
CustAccount Main/ProjGrant
EstimatedAwardDate Main/ProjGrant
FederalMandate Main/ProjGrant
GrantApplicationId Main/ProjGrant
GrantDescription Main/ProjGrant
GrantId Main/ProjGrant
GrantManagerWorker Main/ProjGrant
GrantMatchingComments Main/ProjGrant
GrantName Main/ProjGrant
GrantParentId Main/ProjGrant
GrantPurpose Main/ProjGrant
GrantStatus Main/ProjGrant
MatchingAmount Main/ProjGrant
MatchingPercentage Main/ProjGrant
OrganizationUnitId Main/ProjGrant
PassThrough Main/ProjGrant
ProjGrantMatching Main/ProjGrant
ProjGrantorType Main/ProjGrant
ProjGrantType Main/ProjGrant
ProjLocalTrackingId Main/ProjGrant
RejectionNotification Main/ProjGrant
RenewalActionDate Main/ProjGrant
RequestedAmount Main/ProjGrant
StateMandate Main/ProjGrant
SubGrantor Main/ProjGrant
WorkerContact Main/ProjGrant
CFDA Main/ProjGrant
GrantorAgency Main/ProjGrant
DataAreaId Main/ProjGrant
Relationship_CustTableRelationshipId Main/ProjGrant
Relationship_OMOperatingUnitRelationshipId Main/ProjGrant
Relationship_ProjGrantMatchingRelationshipId Main/ProjGrant
Relationship_ProjGrantorTypeRelationshipId Main/ProjGrant
Relationship_ProjGrantTypeRelationshipId Main/ProjGrant
Relationship_ProjCFDANumberRelationshipId Main/ProjGrant
Relationship_GrantorAgencyRelationshipId Main/ProjGrant
Relationship_CompanyRelationshipId Main/ProjGrant

RecId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
isPrimaryKeytrue
dataFormatint64
isReadOnlytrue

Traits

List of traits for the RecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.identifiedBy
names a specifc identity attribute to use with an entity

ParameterValueData typeExplanation
attributeProjGrant/(resolvedAttributes)/RecIdattribute

is.readOnly
is.dataFormat.integer
is.dataFormat.big

ActualAwardDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ActualAwardDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ActualExpirationDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ActualExpirationDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ActualStartDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ActualStartDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ApplicationDueDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ApplicationDueDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ApplicationSubmittedDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ApplicationSubmittedDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

AwardedAmount

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

List of traits for the AwardedAmount attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

is.nullable
The attribute value may be set to NULL.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

BoardApprovalDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the BoardApprovalDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

CFDAId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the CFDAId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

CustAccount

First included in: Main/ProjGrant (this entity)

Properties

NameValue
displayNameGrant customer
dataFormatstring
isNullabletrue

Traits

List of traits for the CustAccount attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enGrant customer
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

EstimatedAwardDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the EstimatedAwardDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

FederalMandate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the FederalMandate attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

GrantApplicationId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the GrantApplicationId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

GrantDescription

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the GrantDescription attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

GrantId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the GrantId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.character
is.dataFormat.array

GrantManagerWorker

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

List of traits for the GrantManagerWorker attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer
is.dataFormat.big

GrantMatchingComments

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the GrantMatchingComments attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

GrantName

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the GrantName attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.character
is.dataFormat.array

GrantParentId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the GrantParentId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

GrantPurpose

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the GrantPurpose attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

GrantStatus

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the GrantStatus attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

MatchingAmount

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

List of traits for the MatchingAmount attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

is.nullable
The attribute value may be set to NULL.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

MatchingPercentage

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

List of traits for the MatchingPercentage attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

is.nullable
The attribute value may be set to NULL.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

OrganizationUnitId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the OrganizationUnitId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

PassThrough

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PassThrough attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

ProjGrantMatching

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

List of traits for the ProjGrantMatching attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer
is.dataFormat.big

ProjGrantorType

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

List of traits for the ProjGrantorType attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer
is.dataFormat.big

ProjGrantType

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint64

Traits

List of traits for the ProjGrantType attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.dataFormat.integer
is.dataFormat.big

ProjLocalTrackingId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the ProjLocalTrackingId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

RejectionNotification

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the RejectionNotification attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

RenewalActionDate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the RenewalActionDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

RequestedAmount

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

List of traits for the RequestedAmount attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

is.nullable
The attribute value may be set to NULL.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

StateMandate

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the StateMandate attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

SubGrantor

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the SubGrantor attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

WorkerContact

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

List of traits for the WorkerContact attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer
is.dataFormat.big

CFDA

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the CFDA attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

GrantorAgency

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the GrantorAgency attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

DataAreaId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the DataAreaId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.dataFormat.character
is.dataFormat.array

Relationship_CustTableRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CustTableRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTableRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_OMOperatingUnitRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_OMOperatingUnitRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/GAB/Main/OMOperatingUnit.cdm.json/OMOperatingUnitRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_ProjGrantMatchingRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjGrantMatchingRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjGrantMatching.cdm.json/ProjGrantMatchingRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_ProjGrantorTypeRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjGrantorTypeRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjGrantorType.cdm.json/ProjGrantorTypeRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_ProjGrantTypeRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjGrantTypeRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjGrantType.cdm.json/ProjGrantTypeRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_ProjCFDANumberRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjCFDANumberRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Miscellaneous/ProjCFDANumber.cdm.json/ProjCFDANumberRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_GrantorAgencyRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_GrantorAgencyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTableRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_CompanyRelationshipId

First included in: Main/ProjGrant (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array