Earning statement lines inquiry in Payroll(PayrollEarningStatementLineInquiryEntity)

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

Traits

Traits for this entity are listed below.

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 Earning statement lines inquiry	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
Worker		Payroll/PayrollEarningStatementLineInquiryEntity
PersonnelNumber		Payroll/PayrollEarningStatementLineInquiryEntity
DocumentNumber		Payroll/PayrollEarningStatementLineInquiryEntity
PayCycleId		Payroll/PayrollEarningStatementLineInquiryEntity
PeriodStartDate		Payroll/PayrollEarningStatementLineInquiryEntity
PeriodEndDate		Payroll/PayrollEarningStatementLineInquiryEntity
PaymentStatus		Payroll/PayrollEarningStatementLineInquiryEntity
AccountingDate		Payroll/PayrollEarningStatementLineInquiryEntity
EarningDate		Payroll/PayrollEarningStatementLineInquiryEntity
EarningCode		Payroll/PayrollEarningStatementLineInquiryEntity
EarningCodeDescription		Payroll/PayrollEarningStatementLineInquiryEntity
QuantityUnit		Payroll/PayrollEarningStatementLineInquiryEntity
Quantity		Payroll/PayrollEarningStatementLineInquiryEntity
EarningRate		Payroll/PayrollEarningStatementLineInquiryEntity
AccountingCurrencyAmount		Payroll/PayrollEarningStatementLineInquiryEntity
RetroactivePriorRate		Payroll/PayrollEarningStatementLineInquiryEntity
PositionId		Payroll/PayrollEarningStatementLineInquiryEntity
TaxRegion		Payroll/PayrollEarningStatementLineInquiryEntity
WorkerGLIBenefitId		Payroll/PayrollEarningStatementLineInquiryEntity
WorkerCompensationBenefitId		Payroll/PayrollEarningStatementLineInquiryEntity
IsProductive		Payroll/PayrollEarningStatementLineInquiryEntity
FringeBenefitType		Payroll/PayrollEarningStatementLineInquiryEntity
PremiumCode		Payroll/PayrollEarningStatementLineInquiryEntity
GenerationSource		Payroll/PayrollEarningStatementLineInquiryEntity
Relationship_WorkerRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity
Relationship_EarningStatementRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity
Relationship_PremiumEarningCodeRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity
Relationship_PositionRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity
Relationship_TaxRegionRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity
Relationship_PayPeriodRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity
BackingTable_PayrollEarningStatementLineRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity
Relationship_PrimaryCompanyContextRelationshipId		Payroll/PayrollEarningStatementLineInquiryEntity

Worker

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PersonnelNumber

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DocumentNumber

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PayCycleId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PeriodStartDate

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PeriodEndDate

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PaymentStatus

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AccountingDate

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EarningDate

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EarningCode

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EarningCodeDescription

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

QuantityUnit

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Quantity

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EarningRate

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AccountingCurrencyAmount

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RetroactivePriorRate

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PositionId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxRegion

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

WorkerGLIBenefitId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

WorkerCompensationBenefitId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

IsProductive

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

FringeBenefitType

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PremiumCode

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

GenerationSource

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Relationship_WorkerRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WorkerRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

Relationship_EarningStatementRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_EarningStatementRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PremiumEarningCodeRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PremiumEarningCodeRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PositionRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PositionRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TaxRegionRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxRegionRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PayPeriodRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PayPeriodRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

BackingTable_PayrollEarningStatementLineRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the BackingTable_PayrollEarningStatementLineRelationshipId 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/HumanResources/Payroll/WorksheetLine/PayrollEarningStatementLine.cdm.json/PayrollEarningStatementLine RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PrimaryCompanyContextRelationshipId

First included in: Payroll/PayrollEarningStatementLineInquiryEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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