Vendor settlement for 1099s in Worksheet(Tax1099Summary)

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	Tax1099Summary/(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 Vendor settlement for 1099s	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		Worksheet/Tax1099Summary
InventTransId		Worksheet/Tax1099Summary
IRSReportable		Worksheet/Tax1099Summary
PurchInternalInvoiceId		Worksheet/Tax1099Summary
SettleTax1099Amount		Worksheet/Tax1099Summary
SettleTax1099StateAmount		Worksheet/Tax1099Summary
Tax1099AddressOrLegalDesc		Worksheet/Tax1099Summary
Tax1099BuyersTax		Worksheet/Tax1099Summary
Tax1099CountryRegion		Worksheet/Tax1099Summary
Tax1099DateOfClosing		Worksheet/Tax1099Summary
Tax1099Fields		Worksheet/Tax1099Summary
Tax1099PropertyOrServices		Worksheet/Tax1099Summary
Tax1099State		Worksheet/Tax1099Summary
Tax1099StateTaxID		Worksheet/Tax1099Summary
Tax1099StateTaxWithheld		Worksheet/Tax1099Summary
Tax1099TaxYear		Worksheet/Tax1099Summary
Tax1099TradeOrBusiness		Worksheet/Tax1099Summary
TransDate		Worksheet/Tax1099Summary
VendAccount		Worksheet/Tax1099Summary
VendInvoiceId		Worksheet/Tax1099Summary
Voucher		Worksheet/Tax1099Summary
DataAreaId		Worksheet/Tax1099Summary
Relationship_InventTransOriginRelationshipId		Worksheet/Tax1099Summary
Relationship_LogisticsAddressCountryRegionRelationshipId		Worksheet/Tax1099Summary
Relationship_LogisticsAddressStateRelationshipId		Worksheet/Tax1099Summary
Relationship_Tax1099FieldsRelationshipId		Worksheet/Tax1099Summary
Relationship_VendorRelationshipId		Worksheet/Tax1099Summary
Relationship_CompanyRelationshipId		Worksheet/Tax1099Summary

RecId

First included in: Worksheet/Tax1099Summary (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	Tax1099Summary/(resolvedAttributes)/RecId	attribute

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

InventTransId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

IRSReportable

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
displayName	IRS reportable
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en IRS reportable	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

PurchInternalInvoiceId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

SettleTax1099Amount

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

SettleTax1099StateAmount

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

Tax1099AddressOrLegalDesc

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Tax1099BuyersTax

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the Tax1099BuyersTax attribute are listed below.

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

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

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

Tax1099CountryRegion

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

Tax1099DateOfClosing

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the Tax1099DateOfClosing attribute are listed below.

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

is.dataFormat.date

Tax1099Fields

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

Tax1099PropertyOrServices

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Tax1099PropertyOrServices attribute are listed below.

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

is.dataFormat.integer

Tax1099State

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

Tax1099StateTaxID

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
displayName	G-10b state identification number
dataFormat	string
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en G-10b state identification number	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Tax1099StateTaxWithheld

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
displayName	G-11 state income tax withheld
dataFormat	decimal
isNullable	true

Traits

List of traits for the Tax1099StateTaxWithheld attribute are listed below.

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

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 G-11 state income tax withheld	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

Tax1099TaxYear

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Tax1099TaxYear attribute are listed below.

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

is.dataFormat.integer

Tax1099TradeOrBusiness

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Tax1099TradeOrBusiness attribute are listed below.

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

is.dataFormat.integer

TransDate

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

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

VendAccount

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

VendInvoiceId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

Voucher

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

DataAreaId

First included in: Worksheet/Tax1099Summary (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_InventTransOriginRelationshipId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventTransOriginRelationshipId 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/SupplyChain/Inventory/Transaction/InventTransOrigin.cdm.json/InventTransOrigin RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_LogisticsAddressCountryRegionRelationshipId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LogisticsAddressCountryRegionRelationshipId 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/Common/GAB/Group/LogisticsAddressCountryRegion.cdm.json/LogisticsAddressCountryRegion RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_LogisticsAddressStateRelationshipId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LogisticsAddressStateRelationshipId 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/Common/GAB/Group/LogisticsAddressState.cdm.json/LogisticsAddressState RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_Tax1099FieldsRelationshipId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_Tax1099FieldsRelationshipId 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/AccountsPayable/Group/Tax1099Fields.cdm.json/Tax1099Fields RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_VendorRelationshipId

First included in: Worksheet/Tax1099Summary (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendorRelationshipId 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/SupplyChain/Vendor/Main/VendTable.cdm.json/VendTable 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: Worksheet/Tax1099Summary (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