Table Description
Supplier Return Line Item:
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::Case::Entity Objects::SupplierReturnLineItem::SupplierReturnLineItem
Controlling File: core\model\Packages\Case\Supplier Return Line Item_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
lineItemIDkeynoUniqueID to identify line itemSUPPLIER_RET_LINE_ITEM_ID SVR_INT64
supplierReturnIDdetailsnoReturn IDSUPPLIER_RETURN_ID SVR_INT64
clientIDdetailsno CONCERN_ROLE_ID SVR_INT64
statusCodedetails Code value to denote the status of the Supplier Return Line Item.SUPPLIER_RET_LINE_ITEM_STATUS_CODESupplierRetLineItemStatusSVR_STRING<10>
recordStatusdetails Code value to denote the status of the Supplier Return Line Item record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
caseIDdetails The ID of the case to which evidence was added because of this line item. (Only populated after the line item has been processed.)CASE_ID SVR_INT64
costdetails  CURAM_AMOUNT SVR_MONEY
serviceTypeCodedetails  SERVICE_TYPE_CODEServiceTypeSVR_STRING<10>
dateOfServicedetails  CURAM_DATE SVR_DATE
evidenceIDdetails  EVIDENCE_ID SVR_INT64
Foreign Keys (2)
ChildParent
SupplierReturnLineItem.clientIDConcernRole.concernRoleID
SupplierReturnLineItem.supplierReturnIDSupplierReturnHeader.supplierReturnID
Indices (3)
Index NameAttributes
SupRetLnItemIdxclientID
SRLIEvidIDIndexevidenceID
SRLIReturnIDStatusIdxsupplierReturnID, recordStatus
Operations (5)
OperationStereotypeOptionsDescriptionSQL
searchBySupplierReturnIDStatusreadmulti Search Supplier Return Line Items by Supplier Return ID Status. 
readread Standard Operation 
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchBySupplierReturnIDreadmulti readmulti to read all records for the specified supplierReturn regardless of status. 
Related Pages (7)