Channel Claim Settlement Methods

The Channel Claim Settlement Methods view object contains information about the claim integration with Financials cloud such as settlement method, credit memo transaction type, credit memo reason, invoice transaction type, settlement amount, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ClaimPaymentExtractPVO

Primary Keys : ClaimPaymentId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
BuId Value that uniquely identifies the business unit of the claim.
ClaimId Value that uniquely identifies the claim. This is a foreign key to the Channel Claims view object
ClaimPaymentId Value that uniquely identifies the settlement methods associated with the claim. This is the primary key of the Channel Claim Settlement Methods view object.
CreatedBy User who created the settlement method.
CreationDate Date and time when the settlement method was created.
LastUpdateDate Date and time when the settlement method row was last updated.
LastUpdateLogin Session login associated with the user who last updated the settlement method.
LastUpdatedBy User who last updated the settlement method row.
ObjectVersionNumber Number of times the settlement method row has been updated.
PaymentAmount Indicates the payment amount in the currency of the claim.
PaymentCurrencyCode Code that identifies the currency of the payment.
PaymentEffectiveDate Effective date of the payment.
PaymentMethodCode Indicates the claim settlement method. A list of accepted values is defined in the lookup type ORA_CJM_PAYMENT_METHOD.
PaymentReferenceDate Date of the payment reference instrument.
PaymentReferenceId Value that uniquely identifies the payment reference created or passed to the integrated system, which is populated during claim settlement. Values are from the payment instrument's identifier in Payables or Receivables.
PaymentReferenceNumber Identifier for the payment reference number. This number is available when the claim is settled. Values are from the payment instrument's number in Payables or Receivables.
PaymentStatusCode Status of the payment. Contains one of the following values for supplier claims: PENDING, INTERFACED, or PAID.
RaCustTrxTypeSeqId Value that uniquely identifies the Receivables transaction type sequence identifier.
ReceivablesReasonCode Code that identifies the credit memo or adjustment reason code defined in Receivables. For credit memos, a list of accepted values is defined in the lookup type CREDIT_MEMO_REASON. For adjustments, a list of accepted values is defined in the lookup type ADJUST_REASON.
WoReceivablesTrxId Value that uniquely identifies Receivables activity for Write Off settlement method.