Channel Adjustments

The Channel Adjustments view object contains information about manual accrual adjustments that represent adjustments to existing accruals, or represent lump sum accrual adjustments to a program and item.

Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ManualAdjustmentExtractPVO

Primary Keys : ManualAdjustmentId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AccrualReversalFlag	Indicates whether the adjustment is a reversal of an existing accrual. Contains one of the following values: Y, N, or null. If Y, then the adjustment is a reversal of an existing accrual. If N or null, then adjustment isn't a reversal of an existing accrual.
AccrualTypeCode	Code that identifies whether the accrual is for a supplier or customer. A list of accepted values is defined in the lookup ORA_CJM_ACCRUAL_TYPES.
AdjustmentAmount	Amount that identifies the positive value of the adjustment. The adjustment type indicates whether the adjustment will increase or decrease the amount.
AdjustmentCurrencyCode	Code that identifies the currency of the source transaction. If a supplier ship and debit adjustment from the direct integration to sales orders, then this is the sales order currency.
AdjustmentDate	User enterable date for the adjustment. Defaulted to system date if not set by user.
AdjustmentReasonId	Value that uniquely identifies the adjustment reason. This is the foreign key to the Channel Adjustment Reasons view object.
AdjustmentTypeCode	Alternate code that uniquely identifies the adjustment reason. This is an alternate foreign key to the Channel Adjustment Reasons view object.
AdjustmentTypeId	Value that uniquely identifies the adjustment type. This is the foreign key to the Channel Adjustment Types view object.
ApprovedBy	User who approved the adjustment.
ApprovedDate	Date when the adjustment was approved.
BillToCustomerId	Value that uniquely identifies the bill-to customer account of the adjustment applicable for supplier ship and debit adjustments.
BillToLocationId	Value that uniquely identifies the purchase order bill-to location of the adjustment. This is a foreign key to HR_LOCATIONS_ALL.LOCATION_ID.
CreatedBy	User who created the adjustment row.
CreationDate	Date and time when the adjustment row was created.
CustomerTrxLineId	Value that uniquely identifies the sales invoice line from the sales order line of the source transaction. This is a foreign key to the Sales Orders view object.
ExchangeRateDate	Date used when the adjustment amount in the adjustment currency is converted to the ledger currency if adjustment and ledger currency are different.
ExchangeRateType	Value that indicates the type of exchange rate used when the adjustment amount in the adjustment currency is converted to the ledger currency if adjustment and ledger currency are different.
ExpectedReceiptDate	Date when shipment is expected to arrive.
InvoiceDate	Date of the sales invoice for a supplier ship and debit adjustment.
InvoiceId	Value that uniquely identifies the sales invoice referenced for a supplier ship and debit adjustment. This is a foreign key to the Transaction Header view object. This is mandatory for supplier ship and debit adjustments.
InvoiceLineNumber	Value that identifies the sales invoice line number used for a supplier ship and debit adjustment.
InvoiceNumber	Value that identifies the sales invoice number used for a supplier ship and debit adjustment.
InvoiceSourceApplication	Value that identifies the source application for either supplier invoices or sales invoices. Applicable for supplier rebate adjustments and supplier ship and debit adjustments respectively. Contains one of the following values: AP or AR. Value is AR for supplier ship and debit adjustments. Value is AP for supplier rebate adjustments.
InvoiceSourceCode	Code that identifies the application name of the sales invoice. This is applicable to supplier ship and debit adjustments only. Contains the value Distributed Order Orchestration.
ItemId	Value that uniquely identifies the item to be adjusted. This is a foreign key to the Items view object.
ItemLevelCode	Code that identifies the item level in the adjustment. Contains the value ITEM.
LastUpdateDate	Date and time when the adjustment row was last updated.
LastUpdateLogin	Session login associated with the user who last updated the adjustment.
LastUpdatedBy	User who last updated the adjustment row.
ManualAdjustmentId	Value that uniquely identifies the manual adjustment. This is the primary key to the Channel Adjustments view object.
ManualAdjustmentNumber	Alternate value that uniquely identifies the manual adjustment. This is an alternate primary key to the Channel Adjustments view object.
ObjectId	Value that uniquely identifies the source transaction header of the adjustment when the object type is provided. If object type is DOCUMENT, then the value is the foreign key to the CJM_DOCUMENT_HEADERS_ALL table used for supplier rebate adjustments. If object type is ORDER, then the value is the foreign key to the Sales Order Headers view object used for supplier ship and debit adjustments. This attribute is blank and not applicable for supplier annual programs.
ObjectLineId	Value that uniquely identifies the source transaction line of the adjustment when the object type is provided. If the object type is DOCUMENT, then the value is the foreign key to the CJM_DOCUMENT_LINES_ALL table used for supplier rebate adjustments. If the object type is ORDER, then the value is the foreign key to the Sales Order Lines view object used for supplier ship and debit adjustments. Alternate key that identifies the Order Charges and Order Charge Components view objects.
ObjectType	Code that identifies the view object or table where the source transaction is stored for an adjustment. The ObjectTypeCode, ObjectId, and ObjectLineId combine to uniquely identify a source transaction. Contains one of the following values: ORDER, DOCUMENT. If ORDER, then indicates the source transaction is stored in the Sales Order Headers view object for supplier ship and debit adjustments. If DOCUMENT, then indicates the source transaction is stored in the CJM_DOCUMENT_HEADERS_ALL table for supplier rebates adjustments. This attribute is blank and not applicable for supplier annual program adjustments.
ObjectVersionNumber	Number of times the object line row of the source transaction has been updated.
OrigObjectLineNum	Value that identifies the original document line number of the source transaction used for adjustments to an existing accrual. This is denormalized from the CJM_DOCUMENT_LINES_ALL table.
OrigObjectNumber	Value that identifies the original document number of the source transaction used for adjustments to an existing accrual. This is denormalized from the CJM_DOCUMENT_HEADERS_ALL table.
OwnerId	Value that uniquely identifies the user who created the adjustment.
PoDate	Date of the purchase order referenced in the adjustment.
PoHeaderId	Value that uniquely identifies the purchase order referenced in the adjustment.
PoNumber	Value that identifies the purchase order number referenced in the adjustment.
ProgramHeaderId	Value that uniquely identifies the program referenced in the adjustment. This is the foreign key to the Channel Programs view object.
ProgramLineId	Value that uniquely identifies the program product rule. This is the foreign key to the Channel Program Product Rules view object.
ReceiptId	Value that uniquely identifies the receiving receipt referenced in a supplier rebate adjustment. This is the foreign key to the Receiving Receipt Transactions view object.
ReceiptNumber	Value that identifies the receiving receipt number of a supplier rebate adjustment.
RequestedGlDate	User-enterable date when accrual accounting is requested.
ShipToLocationId	Value that uniquely identifies the purchase order ship to location. This is a foreign key to HR_LOCATIONS_ALL.LOCATION_ID.
SourceUtilizationId	Value that uniquely identifies the accrual that's being adjusted, otherwise the value is blank if it's a lump sum adjustment to a program and item. This is a foreign key to the Channel Supplier Accruals view object.
StatusCode	Code that uniquely identifies the status of the adjustment. This is a foreign key to the Channel User Statuses view object.
TpItemId	Value that uniquely identifies the supplier item if provided during adjustment creation or in the product rule. This is a foreign key to the Trading Partner Items view object.
TransactionDate	Date on which the receiving transaction occurred, which is referenced in the adjustment applicable for supplier rebate adjustments.
TransactionId	Value that uniquely identifies the receiving transaction applicable for supplier rebate adjustments. The foreign key to the Receiving Receipt Transactions view object.
VendorId	Value that uniquely identifies the supplier for supplier program adjustments. This is the foreign key to the Supplier Details view object.
VendorSiteId	Value that uniquely identifies the supplier site for supplier program adjustments. This is the foreign key to the Supplier Site Details view object.