Timesheets in Main(TSTimesheetTable)

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
attributeTSTimesheetTable/(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
enTimesheets
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Main/TSTimesheetTable
ApprovalStatus Main/TSTimesheetTable
IsWorkflowToBeResubmitted Main/TSTimesheetTable
PeriodFrom Main/TSTimesheetTable
PeriodTo Main/TSTimesheetTable
PostStatus Main/TSTimesheetTable
ProjPeriodId Main/TSTimesheetTable
ProjPeriodTimesheetWeek Main/TSTimesheetTable
SourceDocumentHeader Main/TSTimesheetTable
TimesheetNbr Main/TSTimesheetTable
Resource Main/TSTimesheetTable
Worker Main/TSTimesheetTable
TestHeaderReal Main/TSTimesheetTable
DataAreaId Main/TSTimesheetTable
Relationship_ProjPeriodTableRelationshipId Main/TSTimesheetTable
Relationship_ProjPeriodTimesheetWeekRelationshipId Main/TSTimesheetTable
Relationship_SourceDocumentRelationshipId Main/TSTimesheetTable
Relationship_ResourceTableRelationshipId Main/TSTimesheetTable
Relationship_CompanyRelationshipId Main/TSTimesheetTable

RecId

First included in: Main/TSTimesheetTable (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
attributeTSTimesheetTable/(resolvedAttributes)/RecIdattribute

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

ApprovalStatus

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ApprovalStatus attribute are listed below.

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

is.dataFormat.integer

IsWorkflowToBeResubmitted

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsWorkflowToBeResubmitted attribute are listed below.

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

is.dataFormat.integer

PeriodFrom

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the PeriodFrom attribute are listed below.

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

is.dataFormat.date

PeriodTo

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the PeriodTo attribute are listed below.

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

is.dataFormat.date

PostStatus

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PostStatus attribute are listed below.

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

is.dataFormat.integer

ProjPeriodId

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the ProjPeriodId 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

ProjPeriodTimesheetWeek

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ProjPeriodTimesheetWeek attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

SourceDocumentHeader

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue

Traits

List of traits for the SourceDocumentHeader attribute are listed below.

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

TimesheetNbr

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the TimesheetNbr attribute are listed below.

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

Resource

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

List of traits for the Resource 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

Worker

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

List of traits for the Worker 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

TestHeaderReal

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
displayNameTest Header Real
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

List of traits for the TestHeaderReal attribute are listed below.

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

is.readOnly
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
enTest Header Real
entitya reference to the constant entity holding the list of localized text

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

DataAreaId

First included in: Main/TSTimesheetTable (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_ProjPeriodTableRelationshipId

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjPeriodTableRelationshipId 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/ProjPeriodTable.cdm.json/ProjPeriodTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProjPeriodTimesheetWeekRelationshipId

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjPeriodTimesheetWeekRelationshipId 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/ProjPeriodTimesheetWeek.cdm.json/ProjPeriodTimesheetWeekRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SourceDocumentRelationshipId

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SourceDocumentRelationshipId 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/AccountingFoundation/TransactionHeader/SourceDocumentHeader.cdm.json/SourceDocumentHeaderRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ResourceTableRelationshipId

First included in: Main/TSTimesheetTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ResourceTableRelationshipId 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/ResResourceIdentifier.cdm.json/ResResourceIdentifierRecId
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/TSTimesheetTable (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