Table Description
Product Delivery Frequency History: A historical delivery frequency for a product.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Products::Entity Objects::ProductDeliveryFrequencyHistory::ProductDeliveryFrequencyHist
Controlling File: core\model\Packages\Products\ProductDeliveryFrequencyHistory_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
prodDeliveryFreqHistoryIDkeynoUnique ID to identify the delivery frequency history record for the productPRODUCT_DELIVERY_FREQUENCY_HISTORY_ID SVR_INT64
productIDdetailsnoForeign Key to the Product entityPRODUCT_ID SVR_INT64
startDatedetails Date on which this delivery frequency pattern was set for the productCURAM_DATE SVR_DATE
endDatedetails Date the delivery frequency ended being the default frequency for the productCURAM_DATE SVR_DATE
deliveryFrequencydetails The delivery frequency pattern value that is to associated with the product by defaultFREQUENCY_PATTERN SVR_STRING<9>
Foreign Keys (1)
ChildParent
ProductDeliveryFrequencyHist.productIDProduct.productID
Indices (1)
Index NameAttributes
ProdDelivFreqHIdxproductID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProductIDreadmulti To retrieve all ProductDeliveryFrequencyHist records for a specified ProductID. 
readCurrentFrequencyns Method to return the current delivery frequency history record for a product using the product's unique identifierSQL
readByDateAndProductIDns Returns the delivery frequency history record for a product on a given date.SQL
getCurrentFrequency  @superseded - replaced by readCurrentFrequency 
Related Pages (0)