Available Dates for Extraction

The Available Dates for Extraction view object collects the available days in a schedule.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.AvailableDateExtractPVO

Primary Keys : AvlDateId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AvlDateId	Value that uniquely identifies an available date for a schedule. This is the primary key of the Available Dates view object.
CalendarDate	Value that identifies a calendar date in the schedule.
CreatedBy	User who created the row.
CreationDate	Date and time of the creation of the row.
LastUpdateDate	Date and time of the last update of the row.
LastUpdateLogin	Session login associated to the user who last updated the row.
LastUpdatedBy	User who last updated the row.
NextDate	Value that identifies the next working date.
NextSeqNum	Value that identifies the next working date by its sequence number.
ObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PriorDate	Value that identifies the prior working date.
PriorSeqNum	Value that identifies the sequence number for the prior working date.
RequestId	Request ID of the job that created or last updated the row.
ScheduleId	Value that uniquely identifies the schedule that the available date is for. This is a foreign key to the Schedules view object.
SeqNum	Value that starts from 0 and increases by 1 for every available date in the schedule.