Table Description
Payment Cancellation Request: A request to cancel a payment instrument.
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::Financial::Entity Objects::PaymentCancellationRequest::PaymentCancellationRequest
Controlling File: core\model\Packages\Financial Manager Packages\PaymentCancellationRequest_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
pmtInstrumentIDdetailsyesPaymentInstrumentID of the PaymentInstrument to be canceled.PAYMENT_INSTRUMENT_ID SVR_INT64
creationDatedetails Date on which the request for Payment Instrument cancellation was registeredCURAM_DATE SVR_DATE
reasonTextdetails Free text describing the reason for the Payment Instrument Cancellation RequestREASON_TEXT SVR_STRING<200>
typeCodedetails Code value to denote the classification of the Payment Instrument cancellation Populated from the CancellationRequest code table.CANCELLATION_REQUEST_CODECancellationRequestSVR_STRING<10>
pmtCancellationIDkeynoUnique reference number assigned by the system to this PaymentCancellationRequestPAYMENT_CANC_REQUEST_ID SVR_INT64
Foreign Keys (1)
ChildParent
PaymentCancellationRequest.pmtInstrumentIDPaymentInstrument.pmtInstrumentID
Indices (1)
Index NameAttributes
PCPmtInstrumentIdxpmtInstrumentID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
searchByTypeCodeDateRangensmulti Returns payment cancellation request records based on the search criteria, typeCode, creationFromDate and creationToDate passed in.SQL
readByPmtInstrumentIDnsread Operation to read the paymentCancellationRequest entity on pmtInstrumentID. 
Related Pages (51)
Adjustment Instruction Details (ExternalParty_viewAdjustmentInstruction)
Financial Line Item Details (ExternalParty_viewLineItem)
Payment Instruction Details (ExternalParty_viewNonClientPaymentInstruction)
Payment Instruction Details (ExternalParty_viewPaymentInstruction)
Canceled Payment Details (Financial_cancelledPaymentInstruction)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Reissue with Applied Deduction (Financial_createAppliedFixedDeductionWizard)
Reissue with Un-applied Deduction (Financial_createUnappliedDeductionWizard)
Invalidate Payment (Financial_invalidatePayment)
Financial_paymentSearch
Confirm & Reissue (Financial_regenerateAppliedFixedDeduction)
Reissue with Un-applied Deduction (Financial_regenerateUnappliedDeduction)
Reversed Liability Details (Financial_reversedLiabilityInstruction)
Adjustment Instruction Details (Financial_viewAdjustmentInstruction)
Liability Instruction Details (Financial_viewLiabilityInstruction)
Liability Details (Financial_viewLiabilityInstruction1)
Liability Details (Financial_viewLiabilityInstructionDetailsTransaction)
Manual Payment Details (Financial_viewManualPaymentInstruction)
Payment Instruction Details (Financial_viewNonClientPaymentInstruction)
Payment Instruction Details (Financial_viewNonClientPaymentInstruction1)
Payment Details (Financial_viewPaymentInstruction)
Payment Details (Financial_viewPaymentInstruction1)
Payment Instruction Details (Financial_viewPaymentInstructionDetailsTransaction)
Financial_viewPaymentInstructionInline
Payment Details (Financial_viewPaymentInstructionModal)
- (Financial_viewPaymentInstrument)
Payment Instrument Details (Financial_viewPaymentInstrument1)
Payment Received Details (Financial_viewPaymentReceivedInstruction)
Payment Received (Financial_viewPaymentReceivedInstruction1)
Payment Received Details (Financial_viewPaymentReceivedInstructionDetailsTransaction)
Reversal Instruction Details (Financial_viewReversalInstruction)
Reversal Instruction Details (Financial_viewReversalInstructionDetailsTransaction)
Payment Details (Financial_viewUnderpmtPaymentInstruction)
Write Off Instruction Details (Financial_viewWriteOffInstruction)
Write Off (Financial_viewWriteOffInstruction1)
Adjustment Instruction Details (Participant_viewAdjustmentInstruction)
Liability Instruction Details (Participant_viewLiabilityInstruction)
Liability Instruction Details (Participant_viewLiabilityInstructionFromWriteOff)
Payment Instruction Details (Participant_viewNonClientPaymentInstruction)
Payment Details (Participant_viewPaymentInstruction)
- (Participant_viewPaymentInstrument)
Payment Received Details (Participant_viewPaymentReceivedInstruction)
Reversal Instruction Details (Participant_viewReversalInstruction)
Write Off Instruction Details (Participant_viewWriteOffInstruction)
Payment Details (ProductDelivery_viewDedPaymentInstruction)
Payment Instruction Details (ProviderManagement_viewBenefitUnderPaymentInstruction)
Liability Instruction Details (SocialEnterpriseFolder_viewFinancialLiabilityInstruction)
Payment Instruction Details: (SocialEnterpriseFolder_viewFinancialPaymentInstruction)
Payment Received Details (SocialEnterpriseFolder_viewFinancialPaymentReceivedInstruction)