JDBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

ChannelSupplierManualAdjustments

Manages manual adjustments for channel supplier programs, including adjustment amounts, types, reasons, and approval details.

Columns

Name Type SupportedFinders Description
ManualAdjustmentId [KEY] Long PrimaryKey The unique identifier for the supplier manual adjustment.
ManualAdjustmentNumber String The unique number assigned to the manual adjustment.
BusinessUnit String The name of the business unit.
BusinessUnitId Long The unique identifier for the business unit.
ProgramCode String The code that uniquely identifies the supplier program.
ProgramId Long The unique identifier for the supplier program.
ProgramName String The name of the supplier program.
ProgramType String The name of the program type on which the channel program is based.
ProgramTypeId String The unique identifier for the program type on which the channel program is based.
ItemId Long The unique identifier for the item in the inventory.
Item String The name of the item in the inventory.
ItemDescription String A description of the item in the inventory.
Supplier String The name of the supplier.
SupplierId Long The unique identifier for the supplier.
SupplierNumber String The number that identifies the supplier.
SupplierSite String The name of the supplier site.
SupplierSiteId Long The unique identifier for the supplier site.
AdjustmentAmount Decimal The amount for which the manual adjustment is created.
AdjustmentCurrency String The name of the adjustment currency.
AdjustmentCurrencyCode String The abbreviation that identifies the adjustment currency.
AdjustmentDate Date The date when the user performed the manual adjustment. This date can be a system date or any past date.
RequestedAccountingDate Date The date when the adjustment should be accounted. This date can be a system date or any past date.
ConversionDate Date The date when the amount is converted.
TransactionInvoiceDate Date The date when the invoice was created for the transaction.
TransactionInvoiceLine Decimal The invoice line number used in the transaction.
TransactionInvoiceNumber String The number that identifies the invoice used in the transaction.
TransactionPurchaseOrder String The number that identifies the purchase order used in the transaction.
TransactionPurchaseOrderDate Date The date when the purchase order was created for the transaction.
TransactionReceipt String The number that identifies the receipt used in the transaction.
PredefinedAdjustmentTypeCode String The abbreviation that identifies the predefined adjustment type. The list of values are INCREASE_EARNED and DECREASE_EARNED.
AdjustmentType String The name of the user-created adjustment type.
AdjustmentTypeId Long The unique identifier for the user-created adjustment type.
AdjustmentReason String The name of the user-created adjustment reason.
AdjustmentReasonId Long The unique identifier for the user-created adjustment reason.
CommentsForApprovers String The comments submitted to provide additional information to the approvers.
Owner String The name of the person who owns the adjustment. Defaults to the name of the person who creates the adjustment.
OwnerPersonId Long The unique identifier for the person who owns the adjustment.
OwnerPersonNumber String The unique person number of the person who owns the adjustment.
Status String The status of the adjustment.
StatusCode String The abbreviation that identifies the status of the adjustment.
ApprovedBy String The name of the user who approved the adjustment.
ApprovedDate Date The date when the adjustment was approved.
CreatedBy String The user who created the record.
CreationDate Datetime The date and time when the user created the record.
LastUpdatedBy String The user who most recently updated the record.
LastUpdateDate Datetime The date and time when the user most recently updated the record.
Finder String The name of the finder method used to search and filter supplier manual adjustment records.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770