SERVICE_PRODUCT_FULFILLMENT_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
ServiceActualCompletionDate	MISMODate	DATE	NO	The actual date of completion of the product/service being fulfilled.
ServiceActualPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The actual price of the product/service being fulfilled.
ServiceCancellationPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The price that the service provider charged for the cancellation of the order.
ServiceEstimatedCompletionDate	MISMODate	DATE	NO	The estimated date of completion of the product/service being fulfilled.
ServiceEstimatedOffHoldDate	MISMODate	DATE	NO	The estimated date that resolution to the current issue/problem will be resolved.
ServiceEstimatedPriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The estimated price of the product/service being fulfilled.
VendorOrderIdentifier	MISMOIdentifier	VARCHAR(0)	NO	A string that uniquely identifies a specific order for a vendor set by the vendor.
VendorTransactionIdentifier	MISMOIdentifier	VARCHAR(0)	NO	A string that uniquely identifies a specific transaction/file for a vendor set by the vendor.

SERVICE_PRODUCT_FULFILLMENT_DETAIL Keys

Key Name

Key Type

Keys

SERVICE_PRODUCT_FULFILLMENT_DETAIL Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
SERVICE_PRODUCT_FULFILLMENT	Identifying	One to Zero or One					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

SERVICE_PRODUCT_FULFILLMENT_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

SERVICE_PRODUCT_FULFILLMENT_DETAIL Bound Attachments

Name	Current Value

SERVICE_PRODUCT_FULFILLMENT_DETAIL User-Defined Mappings

Model

Name

Description

SERVICE_PRODUCT_FULFILLMENT_DETAIL Data Movement Rules

Name

Type

Rule Text/Value