Document references in WorksheetLine(DocuRef)

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

Attributes

Name Description First Included in Instance
RecId WorksheetLine/DocuRef
RefCompanyId WorksheetLine/DocuRef
ActualCompanyId WorksheetLine/DocuRef
Author WorksheetLine/DocuRef
InterCompanySkipUpdate WorksheetLine/DocuRef
Name WorksheetLine/DocuRef
Notes WorksheetLine/DocuRef
Party WorksheetLine/DocuRef
RefRecId WorksheetLine/DocuRef
RefTableId WorksheetLine/DocuRef
Restriction WorksheetLine/DocuRef
TypeId WorksheetLine/DocuRef
ValueRecId WorksheetLine/DocuRef
DocumentId WorksheetLine/DocuRef
DefaultAttachment WorksheetLine/DocuRef
ContactPersonId WorksheetLine/DocuRef
IsJustification WorksheetLine/DocuRef
smmEMailEntryID WorksheetLine/DocuRef
smmEMailStoreID WorksheetLine/DocuRef
smmTable WorksheetLine/DocuRef
EncyclopediaItemId WorksheetLine/DocuRef
EngChgEngineeringReferenceId WorksheetLine/DocuRef
EngChgEngineeringDocumentRecId WorksheetLine/DocuRef
Relationship_DocuTypeRelationshipId WorksheetLine/DocuRef
Relationship_DocuValueRelationshipId WorksheetLine/DocuRef
Relationship_DirPartyTable_FKRelationshipId WorksheetLine/DocuRef
Relationship_DirPersonRelationshipId WorksheetLine/DocuRef

RecId

First included in: WorksheetLine/DocuRef (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
attributeDocuRef/(resolvedAttributes)/RecIdattribute

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

RefCompanyId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
displayNameCompany account
dataFormatstring
isReadOnlytrue

Traits

List of traits for the RefCompanyId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.character
is.dataFormat.array

ActualCompanyId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
displayNameCompany accounts
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ActualCompanyId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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
enCompany accounts
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Author

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
displayNameAuthor
dataFormatint64
isNullabletrue

Traits

List of traits for the Author attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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
enAuthor
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

InterCompanySkipUpdate

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the InterCompanySkipUpdate attribute are listed below.

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

is.dataFormat.integer

Name

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Notes

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Party

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

RefRecId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
displayNameReference record ID
dataFormatint64
isReadOnlytrue

Traits

List of traits for the RefRecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.readOnly
is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enReference record ID
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

RefTableId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue

Traits

List of traits for the RefTableId attribute are listed below.

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

Restriction

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Restriction attribute are listed below.

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

is.dataFormat.integer

TypeId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the TypeId attribute are listed below.

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

ValueRecId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
displayNameDocument value record ID
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ValueRecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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
enDocument value record ID
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

DocumentId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatguid
isNullabletrue

Traits

List of traits for the DocumentId attribute are listed below.

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

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

DefaultAttachment

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the DefaultAttachment attribute are listed below.

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

is.dataFormat.integer

ContactPersonId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

IsJustification

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsJustification attribute are listed below.

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

is.dataFormat.integer

smmEMailEntryID

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

smmEMailStoreID

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

smmTable

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
displayNameSales and marketing table
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the smmTable attribute are listed below.

is.dataFormat.integer
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
enSales and marketing table
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

EncyclopediaItemId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

EngChgEngineeringReferenceId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

List of traits for the EngChgEngineeringReferenceId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

EngChgEngineeringDocumentRecId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

Relationship_DocuTypeRelationshipId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_DocuTypeRelationshipId 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/System/SystemAdministration/Group/DocuType.cdm.json/DocuTypeRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_DocuValueRelationshipId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_DocuValueRelationshipId 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/System/SystemAdministration/Transaction/DocuValue.cdm.json/DocuValueRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_DirPartyTable_FKRelationshipId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_DirPersonRelationshipId

First included in: WorksheetLine/DocuRef (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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