Channel Claims

The Channel Claims view object contains claim header information about customer or supplier claims. Customer claims provide information about the customer dispute. Supplier claims represent a claim for promotional accruals from a supplier.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ClaimHeaderExtractPVO

Primary Keys : ClaimId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AcctdAmount	Indicates the claimed amount in functional currency.
AcctdAmountAdjusted	Indicates the split claim amount in functional currency.
AcctdAmountRemaining	Indicates the claim amount remaining in functional currency.
AcctdAmountSettled	Indicates the claim amount settled in functional currency.
Amount	Indicates the amount claimed in claim currency.
AmountAdjusted	Indicates the split claim amount in claim currency.
AmountApplied	Amount applied on the receipt application line while creating the claim in Receivables.
AmountIncludesTaxFlag	Indicates whether the tax is included in the claim amount. Contains one of the following values: Yes or Null. If Yes, then the tax is included in the claim amount. The default value is Null.
AmountRemaining	Indicates the claim amount remaining in claim currency.
AmountSettled	Indicates the claim amount settled in claim currency.
AppliedPaymentScheduleId	Value that uniquely identifies the payment schedule of the payment applied on the Receivables receipt line.
AttributeCategory	Context name for the Supplier Claim Header descriptive flexfield.
AttributeChar1	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar10	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar11	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar12	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar13	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar14	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar15	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar16	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar17	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar18	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar19	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar2	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar20	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar3	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar4	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar5	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar6	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar7	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar8	Segment for the Supplier Claim Header descriptive flexfield.
AttributeChar9	Segment for the Supplier Claim Header descriptive flexfield.
AttributeDate1	Date segment for the Supplier Claim Header descriptive flexfield.
AttributeDate2	Date segment for the Supplier Claim Header descriptive flexfield.
AttributeDate3	Date segment for the Supplier Claim Header descriptive flexfield.
AttributeDate4	Date segment for the Supplier Claim Header descriptive flexfield.
AttributeDate5	Date segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber1	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber10	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber2	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber3	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber4	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber5	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber6	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber7	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber8	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeNumber9	Number segment for the Supplier Claim Header descriptive flexfield.
AttributeTimestamp1	Date and time segment for the Supplier Claim Header descriptive flexfield.
AttributeTimestamp2	Date and time segment for the Supplier Claim Header descriptive flexfield.
AttributeTimestamp3	Date and time segment for the Supplier Claim Header descriptive flexfield.
AttributeTimestamp4	Date and time segment for the Supplier Claim Header descriptive flexfield.
AttributeTimestamp5	Date and time segment for the Supplier Claim Header descriptive flexfield.
BillToAddressId	Value that uniquely identifies the bill-to customer account site for the selected customer account.
BillToContactId	Value that uniquely identifies the bill-to customer account contact.
BillToCustomerId	Value that uniquely identifies the bill-to customer account for the claim.
BillToSiteUseId	Value that uniquely identifies the bill-to site use for the customer account site.
BuId	Value that uniquely identifies the business unit of the claim.
ClaimClassCode	Code that identifies the claim class. A list of accepted values is defined in the lookup type ORA_CJM_CLAIM_CLASS.
ClaimComments	Claim header level comments.
ClaimDate	Date when a claim is created.
ClaimForCode	Code that indicates whether the claim is created for a customer or supplier. A list of accepted values is defined in the lookup type ORA_CJM_CLAIM_FOR.
ClaimId	Value that uniquely identifies the claim . This is the primary key of the Channel Claims view object.
ClaimNumber	Number that identifies the claim.
ClaimSourceCode	Code that identifies the source of claim. A list of accepted values is defined in the lookup type ORA_CJM_CLAIM_SOURCE.
ClaimTypeId	Value that uniquely identifies the claim type. This is a foreign key to the Channel Claim Types view object.
CreatedBy	User who created the claim .
CreationDate	Date and time when the claim was created.
CurrencyCode	Code that identifies the claim currency.
CustomerAttributeCategory	Context name for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar1	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar10	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar11	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar12	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar13	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar14	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar15	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar16	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar17	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar18	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar19	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar2	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar20	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar3	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar4	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar5	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar6	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar7	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar8	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeChar9	Segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeDate1	Date segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeDate2	Date segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeDate3	Date segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeDate4	Date segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeDate5	Date segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber1	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber10	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber2	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber3	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber4	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber5	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber6	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber7	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber8	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeNumber9	Number segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeTimestamp1	Date and time segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeTimestamp2	Date and time segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeTimestamp3	Date and time segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeTimestamp4	Date and time segment for the Customer Claim Header descriptive flexfield.
CustomerAttributeTimestamp5	Date and time segment for the Customer Claim Header descriptive flexfield.
CustomerReason	Indicates the reason provided by the customer for the claim.
CustomerRefDate	Reference document date provided by the customer.
CustomerRefNumber	Reference number provided by the customer in support of claim.
ExchangeRate	Value that identifies exchange rate from transaction to accounting currency.
ExchangeRateDate	Date used when converting the amount from the claim currency to the ledger currency.
ExchangeRateType	Rate type used to convert the claim amount from the claim currency to the ledger currency.
GlDate	Date on which the claim settlement amount is posted to General Ledger.
GroupClaimId	Value that uniquely identifies the group claim created through mass settlement.
InvoiceBuId	Value that uniquely identifies the Business unit of the Receivables invoice.
JobDefinitionName	Name of the process that created the claim.
LastUpdateDate	Date and time when the claim was last updated.
LastUpdateLogin	Session login associated with the user who last updated the claim.
LastUpdatedBy	User who last updated the earning association row.
LegalEntityId	Value that uniquely identifies the legal entity of the claim.
MassSettlementNumber	Unique number for mass settlement of claims.
ObjectVersionNumber	Number of times the claim has been updated.
OriginalClaimDate	Indicates the claim date of the root claim.
OwnerId	Value that uniquely identifies the owner of the claim.
PrimaryResourceSalesrepId	Value that uniquely identifies the primary sales person.
ProgramHeaderId	Value that uniquely identifies the channel program associated with the claim. This is a foreign key to the Channel Programs view object.
ReasonCodeId	Value that uniquely identifies the claim reason. This is a foreign key to the Channel Claim Reasons view object.
ReceiptBuId	Value that uniquely identifies the Business unit of the Receivables receipt.
ReceiptId	Value that uniquely identifies the Receivables receipt.
ReceiptNumber	Number that identifies the receipt associated with the claim in Receivables.
ReceivableApplicationId	Value that uniquely identifies the Receivables application of the claim investigation line.
ReceivablesTrxId	Value that uniquely identifies the Receivables activity identifier associated with the non-invoice deduction or overpayment.
RequestId	Value that uniquely identifies the process that created the earning association.
ResolvedDate	Indicates the date when the claim is resolved and submitted for approval.
RootClaimId	Value that uniquely identifies the claim that initiated the transaction.
SettledBy	User who settled the claim .
SettledDate	Date when the claim was settled.
ShipToPartyAddressId	Value that uniquely identifies the ship-to party site, which stores the address associated with the party.
ShipToPartyContactId	Value that uniquely identifies the ship-to party contact.
ShipToPartyId	Value that uniquely identifies the ship-to party created.
ShipToPartySiteUseId	Value that uniquely identifies the party site use of the ship-to party site address.
SourceMapId	Value that uniquely identifies the source map assigned to the claim.
SourceObjectClass	Indicates the source object class used during the claim creation.
SourceObjectDate	Indicates the date of the source object.
SourceObjectId	Indicates the source object type identifier used during the claim creation.
SourceObjectNumber	Indicates the source object number used during the claim creation.
SourceObjectTypeId	Value that uniquely identifies the Indicates source object type.
SplitDate	Date when the split claim was created.
SplitFromClaimId	Value that uniquely identifies the parent claim.
StatusCode	Code that identifies the claim status.
TaxAmount	Indicates the tax amount applied to the claim.
UserStatusId	Value that identifies the user status of the claim.
VendorId	Value that uniquely identifies the Supplier. This value is available when the claim is created for a supplier.
VendorSiteId	Value that uniquely identifies the supplier site. This value is available when the claim is created for a supplier.
WoReceivablesActivityId	Value that uniquely identifies the Receivables activity or the write-off activity.
WriteOffFlag	Indicates whether the deduction is under the threshold and eligible for write-off. Contains one of the following values: Yes or Null. If Yes, then the deduction is under the threshold and eligible for write-off.