Channel Claim Settlement Documents

The Channel Claim Settlement Documents view object contains information about the instruments that can be generated as part of the claim settlement process such as payables debit memo and payables invoice in case of supplier claims. For customer claims, the instruments that can be generated are receivable credit memo, invoice, write-off adjustments, and receipt write-off.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ClaimSettlementDocumentExtractPVO

Primary Keys : SettlementDocId

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.
ClaimPaymentId Value that uniquely identifies the settlement method associated with the claim.
CreatedBy User who created the settlement document.
CreationDate Date when the settlement document was created.
JobDefinitionName Name of the process that created the settlement document.
LastUpdateDate Date when the settlement document row was last updated.
LastUpdateLogin Session login associated with the user who last updated the settlement document.
LastUpdatedBy User who last updated the settlement document row.
ObjectVersionNumber Number of times the settlement document row has been updated.
PaymentMethodCode Code that identifies the settlement method.
RequestId Value that uniquely identifies the process that created the settlement document.
SettlementAcctdAmount Accounted amount of the settlement document.
SettlementAmount Amount of the settlement document.
SettlementCurrencyCode Code that identifies the currency for the settlement document.
SettlementDate Date when the settlement document was created in Receivables or Payables.
SettlementDocId Value that uniquely identifies the settlement document. This is the primary key of the claim settlement document view object.
SettlementDocTypeCode Code that identifies the settlement document line type. A list of accepted values is defined in the lookup type ORA_CJM_SETTLEMENT_DOC_TYPE.
SettlementId Value that uniquely identifies the settlement instrument. For example, check or invoice identifier in case of supplier claims and credit memo, invoice, write-off, or chargeback instrument identifier in case of customer claims.
SettlementNumber Number associated with settlement document.
SettlementTaxAmount Tax amount of the settlement document.
SettlementType Settlement type that identifies the transaction type of the settlement instrument that's created in receivables or payables as part of the claim settlement.
SettlementTypeId Value that uniquely identifies the transaction type of the settlement instrument that's created in receivables or payables as part of the claim settlement.
StatusCode Status of the settlement instrument created in Receivables or Payables.