Contract Line DMO

Represents a line item within a contract.

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

• 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.

• 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

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

• 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.

• 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.

• 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.

• 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.

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

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

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

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

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

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

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

• 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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.

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

• 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.

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

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

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

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

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

• 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.

• 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.

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

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