Channel Claim Lines

The Channel Claim Lines view object contains information about transaction line details to be interfaced to financials for a given settlement method of a claim. Claims and claim lines can be promotional or non-promotional. Promotional claim lines are grouped by program and item.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ClaimLineExtractPVO

Primary Keys : ClaimLineId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AcctdAmount	Accounted amount of the clam line.
ActivityId	Value that uniquely identifies the activity linked to the claim line.
ActivityTypeCode	The type of activity linked to the promotional claim line. A list of accepted values is defined in the lookup type ORA_CJM_LINE_SOURCE_TYPE
Amount	Amount of the claim line.
AssociationId	Value that uniquely identifies the accrual association record.
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
ClaimLineId	Value that uniquely identifies the claim line. This is the primary key of the claim lines view object.
CreatedBy	User who created the claim line.
CreationDate	Date when the claim line row was created.
CurrencyCode	Code that identifies the currency for the claim line.
Description	Name that identifies the description for a claim line.
EarningsAssociatedFlag	Indicates whether the earnings are associated with the claim line. Contains the following value: Y or N. If Y, then the earnings are associated with the claim line. If N, then the earnings aren't associated with the claim line.
ExchangeRate	Rate type used to convert the claim amount from the claim currency to the ledger currency.
ExchangeRateDate	Date used when converting the amount from the claim currency to the ledger currency.
ExchangeRateType	Value that identifies the type of the exchange rate.
ItemId	Value that uniquely identifies the inventory item for a claim line.
ItemLevelCode	The type of item level. A list of accepted values is defined in the lookup type ORA_CJM_ITEM_TYPE.
JobDefinitionName	Name of the process that created the claim line.
LastUpdateDate	Date when the claim line row was last updated.
LastUpdateLogin	Session login associated with the user who last updated the claim line.
LastUpdatedBy	User who last updated the claim line row.
LineComments	Comments for the claim line.
LineNumber	Number of the claim line.
LineSourceTypeCode	The type of claim line. A list of accepted values is defined in the lookup type ORA_CJM_CLAIM_LINE_TYPE
MemoLineSeqId	Value that uniquely identifies the receivables memo line.
ObjectVersionNumber	Number of times the claim line row has been updated.
Quantity	Quantity of the claim line item.
QuantityUomCode	Code that identifies the unit of measure for claim line item.
Rate	Rate of the item for the claim line.
RequestId	Value that uniquely identifies the process that created the claim line.
SettlementLineFlag	Indicates if the claim line is eligible to be interfaced to Payables or Receivables
SourceObjectLineId	Value that uniquely identifies the source object line, such as credit memo line, invoice line, or order fulfillment line.
SourceObjectTypeId	Value that uniquely identifies the Receivables customer transaction type sequence, which is populated only when a claim is created from Receivables.