Szerkesztés

Megosztás a következőn keresztül:


Service orders in WorksheetHeader(SMAServiceOrderTable)

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

Attributes

Name Description First Included in Instance
RecId WorksheetHeader/SMAServiceOrderTable
ActivityNumber WorksheetHeader/SMAServiceOrderTable
ActivityTypeId WorksheetHeader/SMAServiceOrderTable
AddressRefRecId WorksheetHeader/SMAServiceOrderTable
AddressRefTableId WorksheetHeader/SMAServiceOrderTable
AgreementId WorksheetHeader/SMAServiceOrderTable
CalendarConflict WorksheetHeader/SMAServiceOrderTable
CertifiedPayroll WorksheetHeader/SMAServiceOrderTable
Compliance WorksheetHeader/SMAServiceOrderTable
ContactPersonId WorksheetHeader/SMAServiceOrderTable
CustAccount WorksheetHeader/SMAServiceOrderTable
Description WorksheetHeader/SMAServiceOrderTable
IncomingWebOrder WorksheetHeader/SMAServiceOrderTable
Origin WorksheetHeader/SMAServiceOrderTable
Priority WorksheetHeader/SMAServiceOrderTable
Progress WorksheetHeader/SMAServiceOrderTable
ProjId WorksheetHeader/SMAServiceOrderTable
ServiceAddressName WorksheetHeader/SMAServiceOrderTable
ServiceDateTime WorksheetHeader/SMAServiceOrderTable
ServiceLevelAgreement WorksheetHeader/SMAServiceOrderTable
ServiceLevelAgreementStatus WorksheetHeader/SMAServiceOrderTable
ServiceOrderId WorksheetHeader/SMAServiceOrderTable
ServicePostalAddress WorksheetHeader/SMAServiceOrderTable
SignOff WorksheetHeader/SMAServiceOrderTable
SignOffDateTime WorksheetHeader/SMAServiceOrderTable
StageId WorksheetHeader/SMAServiceOrderTable
WorkerPreferredTechnician WorksheetHeader/SMAServiceOrderTable
WorkerResponsible WorksheetHeader/SMAServiceOrderTable
DataAreaId WorksheetHeader/SMAServiceOrderTable
Relationship_ContactPersonRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_CustTableRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_ProjTableRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_ServicePostalAddressRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_SMAAgreementTableRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_SMAServiceLevelAgreementTableRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_SMAServiceObjectRelationRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_SMAServiceTaskRelationRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_SMAStageTableRelationshipId WorksheetHeader/SMAServiceOrderTable
Relationship_CompanyRelationshipId WorksheetHeader/SMAServiceOrderTable

RecId

First included in: WorksheetHeader/SMAServiceOrderTable (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
attributeSMAServiceOrderTable/(resolvedAttributes)/RecIdattribute

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

ActivityNumber

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ActivityTypeId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
displayNameDefault line activity type
dataFormatstring
isNullabletrue

Traits

List of traits for the ActivityTypeId 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
enDefault line activity type
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

AddressRefRecId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

AddressRefTableId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AddressRefTableId attribute are listed below.

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

is.dataFormat.integer

AgreementId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CalendarConflict

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
displayNameCalendar conflict
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the CalendarConflict 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
enCalendar conflict
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

CertifiedPayroll

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
displayNameCertified payroll
dataFormatint32
isNullabletrue

Traits

List of traits for the CertifiedPayroll attribute are listed below.

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

is.dataFormat.integer

Compliance

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

List of traits for the Compliance 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.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ContactPersonId

First included in: WorksheetHeader/SMAServiceOrderTable (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

CustAccount

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
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.dataFormat.character
is.dataFormat.array

Description

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

IncomingWebOrder

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
displayNameIncoming
dataFormatint32
isNullabletrue

Traits

List of traits for the IncomingWebOrder attribute are listed below.

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

is.dataFormat.integer

Origin

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the Origin attribute are listed below.

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

is.dataFormat.integer

Priority

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Priority attribute are listed below.

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

is.dataFormat.integer

Progress

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the Progress attribute are listed below.

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

is.dataFormat.integer

ProjId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ServiceAddressName

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ServiceDateTime

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ServiceDateTime attribute are listed below.

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

is.dataFormat.date

ServiceLevelAgreement

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

ServiceLevelAgreementStatus

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ServiceLevelAgreementStatus attribute are listed below.

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

is.dataFormat.integer

ServiceOrderId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the ServiceOrderId attribute are listed below.

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

ServicePostalAddress

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

SignOff

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
displayNameSign off
dataFormatint32
isNullabletrue

Traits

List of traits for the SignOff attribute are listed below.

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

is.dataFormat.integer

SignOffDateTime

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatdate
isReadOnlytrue
isNullabletrue

Traits

List of traits for the SignOffDateTime attribute are listed below.

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

is.dataFormat.date

StageId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the StageId attribute are listed below.

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

WorkerPreferredTechnician

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

WorkerResponsible

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

DataAreaId

First included in: WorksheetHeader/SMAServiceOrderTable (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_ContactPersonRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ContactPersonRelationshipId 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/SupplyChain/SalesAndMarketing/Main/ContactPerson.cdm.json/ContactPersonRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CustTableRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (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_ProjTableRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjTableRelationshipId 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/Main/ProjTable.cdm.json/ProjTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ServicePostalAddressRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_SMAAgreementTableRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SMAAgreementTableRelationshipId 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/SupplyChain/ServiceManagement/WorksheetHeader/SMAAgreementTable.cdm.json/SMAAgreementTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SMAServiceLevelAgreementTableRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SMAServiceLevelAgreementTableRelationshipId 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/SupplyChain/ServiceManagement/Main/SMAServiceLevelAgreementTable.cdm.json/SMAServiceLevelAgreementTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SMAServiceObjectRelationRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SMAServiceObjectRelationRelationshipId 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/SupplyChain/ServiceManagement/Main/SMAServiceObjectRelation.cdm.json/SMAServiceObjectRelationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SMAServiceTaskRelationRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SMAServiceTaskRelationRelationshipId 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/SupplyChain/ServiceManagement/Main/SMAServiceTaskRelation.cdm.json/SMAServiceTaskRelationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SMAStageTableRelationshipId

First included in: WorksheetHeader/SMAServiceOrderTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SMAStageTableRelationshipId 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/SupplyChain/ServiceManagement/Group/SMAStageTable.cdm.json/SMAStageTableRecId
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: WorksheetHeader/SMAServiceOrderTable (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