Table Description
Supplier Return Header:
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::SupplierReturnHeader::SupplierReturnHeader
Controlling File: core\model\Packages\Case\Supplier Return Header_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
supplierReturnIDkeynoUnique ID to identify ReturnHeaderSUPPLIER_RETURN_ID SVR_INT64
supplierConcernRoleIDdetailsnoConcern Role ID of the supplier.CONCERN_ROLE_ID SVR_INT64
receiptDatedetails Date of receiptCURAM_DATE SVR_DATE
productIDdetailsnoProduct IDPRODUCT_ID SVR_INT64
numberOfItemsdetails Number of itemsNUMBER_OF_ITEMS SVR_INT32
totalAmountdetails Total amountCURAM_AMOUNT SVR_MONEY
docReferenceNumberdetails Document reference number (optional)DOCUMENT_REFERENCE_NUMBER SVR_STRING<16>
methodOfEntrydetails Method of entrySUPPLIER_RETURN_METHODOFENTRYSSReturnMethodOfEntrySVR_STRING<10>
contactNamedetails Denotes the contact name for the supplier return header.CONTACT_NAME SVR_STRING<131>
statusCodedetails Code value to denote the status of the Supplier Return Header.SUPPLIER_RETURN_STATUS_CODESupplierReturnStatusSVR_STRING<10>
recordStatusdetails Return statusRECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text about the supplier return header.COMMENTS SVR_STRING<300>
supplierInitialsdetails Initials of a service supplier, usually a doctor.PERSON_INITIALS SVR_STRING<10>
Foreign Keys (3)
ChildParent
SupplierReturnHeader.supplierConcernRoleIDConcernRole.concernRoleID
SupplierReturnLineItem.supplierReturnIDSupplierReturnHeader.supplierReturnID
WMInstanceData.supplierReturnIDSupplierReturnHeader.supplierReturnID
Indices (1)
Index NameAttributes
SupRetHeaderIdxsupplierConcernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
searchBySupplierConcernRoleIDreadmulti Search Supplier Return Header by Supplier Concern Role ID. 
readread Standard Operation 
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
countDuplicateSupplierReturnsns Count duplicate Supplier Returns for Supplier Return Header.SQL
Related Pages (9)