ODBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

InboundFiscalDocumentHolds

Returns holds placed on inbound fiscal documents, including exception type, hold code, and release details.

Columns

Name Type SupportedFinders Description
FiscalDocumentHoldId [KEY] Long PrimaryKey The value that uniquely identifies the fiscal document hold.
DocumentHeaderId Long The value that uniquely identifies the fiscal document for which a hold exists.
DocumentLineId Long The value that uniquely identifies the fiscal document line for which a hold exists.
LineNumber Decimal The number that identifies the fiscal document line.
DocumentScheduleId Long The value that uniquely identifies the fiscal document line schedule for which a hold exists.
ScheduleNumber Long The number that identifies the fiscal document line schedule.
ExceptionTypeCode String The code of the exception hold on the fiscal document.
ExceptionType String The meaning of the exception hold type on the fiscal document.
HoldCode String The code for the hold on the fiscal document.
HoldDescription String The description of the hold on the fiscal document.
Hold String The reason for the hold on the fiscal document.
HeldBy String The user who placed the hold on the fiscal document.
ReleaseTypeCode String The reason type code used for releasing the hold.
ReleaseType String The meaning of the hold release type.
ReleaseReasonCode String The reason code for removing the fiscal document hold.
ReleaseReason String The detailed reason for removing the fiscal document hold.
ReleaseDate Datetime The date on which the fiscal document hold was released.
ReleasedBy String The user who released the hold on the fiscal document.
ToleranceRuleId Long The Id of the fiscal document tolerance rule used for placing the fiscal document hold.
CreatedBy String The user who created the hold.
CreationDate Datetime The date and time when the hold was created.
LastUpdateDate Datetime The date and time of the last update to the record.
LastUpdatedBy String The user who last updated the record.
ItemId Long The value that uniquely identifies the item.
ItemNumber String The number that identifies the item.
ScheduleAllocatedQuantityinLinesUOM Decimal The allocated quantity for the fiscal document line schedule, in the unit of measure of the line.
ScheduleAmountOnHold Decimal The amount on hold for the fiscal document line schedule.
HeaderItemLineAmount Decimal The amount of the item line on the fiscal document header.
Finder String The name of the finder method used to search and filter records.

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