SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.8963

CycleCountSequenceDetails

The Cycle Count Sequence Details resource manages details for the cycle count sequences.

Columns

Name Type Description
CycleCountEntryId [KEY] Long Value that uniquely identifies the cycle count sequence.
CycleCountHeaderId [KEY] Long Value that uniquely identifies the cycle count.
CycleCountName String Name of the cycle count.
OrganizationId [KEY] Long Value that uniquely identifies the inventory organization.
OrganizationCode String Value that identifies the inventory organization.
OrganizationName String Name of the inventory organization.
CountTypeCode String Value that identifies the type of count. A list of accepted values is defined in the lookup type INV_CC_COUNT_TYPES.
CountType String Type of count. A list of accepted values is defined in the lookup type INV_CC_COUNT_TYPES.
InventoryItemId Long Value that uniquely identifies the inventory item.
ItemNumber String Name of the inventory item.
ItemDescription String Description of the inventory item.
ItemPrimaryImageURL String ItemPrimaryImageURL of CycleCountSequenceDetails
Subinventory String Name of the subinventory.
LocatorId Long Value that uniquely identifies the locator.
Locator String Name of the locator.
LotNumber String Number that identifies an item or group of items.
SerialNumber String Serial number to count.
Revision String Revision of the item.
CountSequence Long Number of the cycle count sequence.
CountQuantity Decimal Count quantity for the count sequence.
CountUOMCode String Value that identifies the unit of measure for the current count.
CountUOM String Unit of measure for the current count.
SecondaryCountQuantity Decimal Quantity of the current count in the secondary unit of measure that the item uses.
SecondaryCountUOMCode String Value that identifies the secondary unit of measure that the current count uses.
SecondaryCountUOM String Secondary unit of measure that the current count uses.
OwningType String Contains one of the following values: 1 or 2. If 1, then the item is consigned. If 2, then the item is owned.
OwningEntityId Long Value that uniquely identifies the owning entity. If the item is consigned, then this attribute contains the vendor site identifier. If the item is owned, then this attribute contains the owning organization identifier.
OwningPartySite String Name of the owning party site.
OwningParty String Name of the owning party.
Reason String Reason for the adjustment transaction.
Comments String Comments that describe the current count.
CountedByEmployeeId Long Value that uniquely identifies the employee who performed the current count.
CountedBy String Name of the employee who performed the current count.
CountDate Date Date when the warehouse counted this sequence.
ReviewedByEmployeeId Long Value that uniquely identifies the employee who approved the adjustment.
ReviewedBy String Name of the employee who approved the adjustment.
ReviewDate Date Date when the employee approved the adjustment.
CountSequenceStatusCode String Value that indicates the current status of the count sequence.
CountSequenceStatus String Current status of the count sequence. A list of accepted values is defined in the lookup type INV_CC_ENTRY_STATUSES.
ExportCode Long Value that determines whether to export the count sequence to the interface.
Exported String Indicates whether the warehouse exported the count sequence to the interface.
ItemLotControlCode String Identifies all the lot control items for a cycle count definition.
ItemSerialControlCode String Identifies all the serial control items for a cycle count definition.
ReasonId Long Value that uniquely identifies the reason.
OwningTypeCode String Name that uniquely identifies the owning entity. If the item is consigned, then this attribute contains the vendor site identifier. If the item is owned, then this attribute contains the owning organization identifier.
ManualCountPrefix String ManualCountPrefix of CycleCountSequenceDetails
PrimarySuggestedQuantity Decimal PrimarySuggestedQuantity of CycleCountSequenceDetails
PrimaryAdjustmentQuantity Decimal PrimaryAdjustmentQuantity of CycleCountSequenceDetails
SecondarySuggestedQuantity Decimal SecondarySuggestedQuantity of CycleCountSequenceDetails
SecondaryAdjustmentQuantity Decimal SecondaryAdjustmentQuantity of CycleCountSequenceDetails
AdjustmentValue Decimal AdjustmentValue of CycleCountSequenceDetails
AdjustmentDate Date AdjustmentDate of CycleCountSequenceDetails
Recounts Long Recounts of CycleCountSequenceDetails
ItemUnitCost Decimal ItemUnitCost of CycleCountSequenceDetails
DeviationPercentage Decimal DeviationPercentage of CycleCountSequenceDetails
ProcessingFlag Bool Contains one of the following values: true or false. If true, then the request was processed. If false, then the request was not processed. The default value is false.
ProcurementBU String Business unit that manages and owns the purchasing document.
BindCycleCountName String BindCycleCountName of CycleCountSequenceDetails
BindOrganizationCode String BindOrganizationCode of CycleCountSequenceDetails
Finder String Finder of CycleCountSequenceDetails
FromSerialNumber String FromSerialNumber of CycleCountSequenceDetails
ToSerialNumber String ToSerialNumber of CycleCountSequenceDetails

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963