ORDERITEM
Repository name :   SampDB1
Repository location : C:\Versata_55\Samples\SampDB1
Analysis date :   Tue Sep 16 16:10:05 PDT 2003
Analysis run on machine : TYLER_DELL
Analysis run by user : Tyler
DataObject Name : ORDERITEM
Description : Line items for the order
Attributes Caption Nullability Persistent DataType Business Rule
PartNum Part# Required Persistent Long
QtyOrdered Qty Ordered Required Persistent Long Default(1)
Amount Amount Optional Persistent Currency Formula(PartPrice * QtyOrdered/* This rule states that Amount is the product of PartPrice and QtyOrdered -- QtyOrdered is manually entered -- PartPrice is derived - examine its Derivation Rule*/)
PartPrice Part Price Optional Persistent Currency ParentReplicate(Part(PART), Price, Not Maintained)
ShippedFlag Shipped Optional Persistent Boolean ParentReplicate(Order(ORDERS), ShippedFlag, Maintained)
Notes Notes Optional Persistent Memo
AutoBucksEarned Auto Bucks Earned Optional Derived Currency Formula(QtyOrdered * PartAutoBucks)
PartAutoBucks Parts' Auto Bucks Optional Persistent Currency ParentReplicate(Part(PART), AutoBucks, Not Maintained)
OrderNum Order# Required Persistent Long
Constraints When Constraint Error Message
Event Condition Action Condition Action
Parent Relationships Parent Child Enforced
Child Relationships Child Parent Enforced
ORDERS_JN_ORDERITEM ORDERITEM (OrderItems) ORDERS (Order) Enforced
PART_JN_ORDERITEM ORDERITEM (OrderItems) PART (Part) Enforced
Indexes
OIPK OrderNum || PartNum || Pimary Key
User Defined Methods Method Signature
addListeners public void SampDB1.ORDERITEMImpl.addListeners()
getNewObject public static SampDB1.ORDERITEMImpl SampDB1.ORDERITEMImpl.getNewObject(versata.vls.Session,boolean)
Used By Used In
ORDERS Sum Amount
ORDERS Sum AutoBucksEarned
PART Sum QtyOrdered
PART Sum QtyOrdered
OrderItemJoinPart QUERY
PartQuery QUERY
ORDERITEM FORM ShoppingCart:pORDERS
ORDERITEM FORM ShoppingCart:pORDERITEM
ORDERITEM FORM PDX_Basic_HTML:pEditOrder
ORDERITEM FORM PDX_Inclusion:pORDERITEM_Grid
ORDERITEM FORM SortCombo:pORDERITEM_Grid
ORDERITEM FORM SortCombo:pORDERITEM
ORDERITEM FORM Server_Event_Commit:fORDERS
ORDERITEM FORM Server_Extended_Rules_Mods:CUSTOMERS