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

Parameter	Value	Data type	Explanation
attribute	TSTimesheetTable/(resolvedAttributes)/RecId	attribute

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"1.1"	string	semantic version number of the entity

is.application.releaseVersion

Parameter	Value	Data type	Explanation
releaseVersion	"10.0.13.0"	string	semantic version number of the application introducing this entity

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Timesheets	entity	a 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

Name	Value
isPrimaryKey	true
dataFormat	int64
isReadOnly	true

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

Parameter	Value	Data type	Explanation
attribute	TSTimesheetTable/(resolvedAttributes)/RecId	attribute

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

ApprovalStatus

First included in: Main/TSTimesheetTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	int64
isReadOnly	true

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

Name	Value
dataFormat	string
isReadOnly	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
displayName	Test Header Real
dataFormat	decimal
isReadOnly	true
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Test Header Real	entity	a 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

Name	Value
dataFormat	string
isReadOnly	true

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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjPeriodTable.cdm.json/ProjPeriodTable RecId	entity	a 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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjPeriodTimesheetWeek.cdm.json/ProjPeriodTimesheetWeek RecId	entity	a 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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionHeader/SourceDocumentHeader.cdm.json/SourceDocumentHeader RecId	entity	a 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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Miscellaneous/ResResourceIdentifier.cdm.json/ResResourceIdentifier RecId	entity	a 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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfo RecId	entity	a reference to the constant entity holding the list of entity references

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