Contract Line DMO

Represents a line item within a contract.

Object Properties

Object API Name: ssot__ContractLine__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

Relationships

• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• ContractId has a FOREIGNKEY relationship with the Contract DMO Id field.
• AssetId has a FOREIGNKEY relationship with the Asset DMO Id field.
• PriceBookEntryId has a FOREIGNKEY relationship with the Price Book Entry DMO Id field.
• LocationId has a FOREIGNKEY relationship with the Location DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• ParentContractLineId has a FOREIGNKEY relationship with the Contract Line DMO Id field.
• RootContractLineId has a FOREIGNKEY relationship with the Contract Line DMO Id field.
• SupplierProductId has a FOREIGNKEY relationship with the Supplier DMO Id field.
• AssociatedLocationId has a FOREIGNKEY relationship with the Account Location DMO Id field.

Fields

• AssetId
• AssociatedLocationId
• cdp_sys_record_currency
• ContractId
• ContractLineStatus
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• Description
• DiscountPercent
• EndDateTime
• Id
• InternalOrganizationId
• KQ_AssetId
• KQ_ContractId
• KQ_CreatedById
• KQ_Id
• KQ_LastModifiedById
• KQ_LocationId
• KQ_ParentContractLineId
• KQ_PriceBookEntryId
• KQ_ProductId
• KQ_RootContractLineId
• LastModifiedById
• LastModifiedDate
• LineItemNumber
• LocationId
• Name
• ParentContractLineId
• PriceBookEntryId
• ProductId
• ProductPriceAmount
• ProductQuantity
• RootContractLineId
• StartDateTime
• SubtotalAmount
• SupplierProductId
• SystemModstamp
• TotalPriceAmount
• UnitPriceAmount

AssetId

• Field API Name: ssot__AssetId__c
• Data Type: TEXT
• Description: Reference to the asset related to a contract line.

AssociatedLocationId

• Field API Name: ssot__AssociatedLocationId__c
• Data Type: TEXT
• Description: The location where the contracted product is sourced from or delivered to. References an associated location record linked to the supplier's account.

cdp_sys_record_currency

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

ContractId

• Field API Name: ssot__ContractId__c
• Data Type: TEXT
• Description: Required. This is a One to One (1:1) relationship field. ContractProducts is the relationship name and Contract is the referenced object. Maximum size is 36 characters.

ContractLineStatus

• Field API Name: ssot__ContractLineStatus__c
• Data Type: TEXT
• Description: The status of one product or service within a larger contract, for example Draft, InApproval or Approved.

CreatedById

• Field API Name: ssot__CreatedById__c
• Data Type: TEXT
• Description: User who created the record.

CreatedDate

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: Date and time when this record was created.

DataSourceId

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

Description

• Field API Name: ssot__Description__c
• Data Type: TEXT
• Description: Description of a Contract Product.

DiscountPercent

• Field API Name: ssot__DiscountPercent__c
• Data Type: DOUBLE
• Description: Discount Percentage for the Contract line item.

EndDateTime

• Field API Name: ssot__EndDateTime__c
• Data Type: DATETIME
• Description: When the contract product ceases to be in effect.

Id

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this ContractLine record. Maximum size is 36 characters.

InternalOrganizationId

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

KQ_AssetId

• Field API Name: KQ_AssetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AssetId

KQ_ContractId

• Field API Name: KQ_ContractId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ContractId

KQ_CreatedById

• Field API Name: KQ_CreatedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for CreatedById

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_LastModifiedById

• Field API Name: KQ_LastModifiedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for LastModifiedById

KQ_LocationId

• Field API Name: KQ_LocationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocationId

KQ_ParentContractLineId

• Field API Name: KQ_ParentContractLineId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ParentContractLineId

KQ_PriceBookEntryId

• Field API Name: KQ_PriceBookEntryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PriceBookEntryId

KQ_ProductId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

KQ_RootContractLineId

• Field API Name: KQ_RootContractLineId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RootContractLineId

LastModifiedById

• Field API Name: ssot__LastModifiedById__c
• Data Type: TEXT
• Description: User who most recently changed the record.

LastModifiedDate

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: Date and time when a user last modified this record.

LineItemNumber

• Field API Name: ssot__LineItemNumber__c
• Data Type: TEXT
• Description: Line number of contract line item.

LocationId

• Field API Name: ssot__LocationId__c
• Data Type: TEXT
• Description: Where a contract product is physically located.

Name

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of the contract line item.

ParentContractLineId

• Field API Name: ssot__ParentContractLineId__c
• Data Type: TEXT
• Description: A contract line item may be grouped within another contract line item on the same contract.

PriceBookEntryId

• Field API Name: ssot__PriceBookEntryId__c
• Data Type: TEXT
• Description: A list of products and their prices.

ProductId

• Field API Name: ssot__ProductId__c
• Data Type: TEXT
• Description: What is intended to be sold. For example, goods, services, bundles, made to order products.

ProductPriceAmount

• Field API Name: ssot__ProductPriceAmount__c
• Data Type: DOUBLE
• Description: Product Quantity * Product List Price.

ProductQuantity

• Field API Name: ssot__ProductQuantity__c
• Data Type: DOUBLE
• Description: Product quantity associated with the line item.

RootContractLineId

• Field API Name: ssot__RootContractLineId__c
• Data Type: TEXT
• Description: Self reference to the root Contract line.

StartDateTime

• Field API Name: ssot__StartDateTime__c
• Data Type: DATETIME
• Description: When the contract product is in effect.

SubtotalAmount

• Field API Name: ssot__SubtotalAmount__c
• Data Type: DOUBLE
• Description: Product Price Amount: Adjustment Amount + Tax Amount.

SupplierProductId

• Field API Name: ssot__SupplierProductId__c
• Data Type: TEXT
• Description: The supplier product that this line item references. Identifies which supplier provides the product and enables supply chain risk analysis.

SystemModstamp

• Field API Name: ssot__SystemModstamp__c
• Data Type: DATETIME
• Description: Date and time when this record was last modified by a user or by an automated process.

TotalPriceAmount

• Field API Name: ssot__TotalPriceAmount__c
• Data Type: DOUBLE
• Description: Total price of the line item.

UnitPriceAmount

• Field API Name: ssot__UnitPriceAmount__c
• Data Type: DOUBLE
• Description: Unit price of the line item.