biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Inventory Cycles
API OCYC / Inventory Cycles
OCYC - Cycle Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECycle CodeInt
6
PRIMARYYes
Name KEY UNIQUECycle NamenVarChar
20
NAMEYes
FrequencyFrequencyVarChar
0
1) Weekly
2) Every Four Weeks
3) Monthly
4) Quarterly
5) Semiannually
6) Annually
7) None
8) Every "X" Days:
1
DayDayInt
11
HourHourInt
11
UserSignUser SignatureInt
6OUSR
Users
NextDateNext Counting DateDate
8
TypeCycle TypeVarChar
C) Cycle
M) MRP
1
C
SubOptionSuboptionVarChar
1) Option 1
2) Option 2
1
1
IntervalIntervalInt
11
1
EndTypeRecurrence End TypeVarChar
N) No End Date
C) By Counter
D) By Date
1
N
MaxOccurMax. OccurrencesInt
11
SeEndDatSeries End DateDate
8
SundaySundayVarChar
N) No
Y) Yes
1
N
MondayMondayVarChar
N) No
Y) Yes
1
N
TuesdayTuesdayVarChar
N) No
Y) Yes
1
N
WednesdayWednesdayVarChar
N) No
Y) Yes
1
N
ThursdayThursdayVarChar
N) No
Y) Yes
1
N
FridayFridayVarChar
N) No
Y) Yes
1
N
SaturdaySaturdayVarChar
N) No
Y) Yes
1
N
DayInMonthRepeat Day in MonthInt
11
WeekRepeat Week in MonthInt
1) First
2) Second
3) Third
4) Fourth
5) Last
11
DayOfWeekRepeat Day of WeekInt
8) Day
9) Weekday
0
1) Sunday
2) Monday
3) Tuesday
4) Wednesday
5) Thursday
6) Friday
7) Saturday
11
MonthRepeat MonthInt
11

Table relationship map

SELECT statement

SELECT OCYC.Code AS 'Cycle Code', OCYC.Name AS 'Cycle Name', OCYC.Frequency AS 'Frequency', OCYC.Day AS 'Day', OCYC.Hour AS 'Hour', OCYC.UserSign AS 'User Signature', OCYC.NextDate AS 'Next Counting Date', OCYC.Type AS 'Cycle Type', OCYC.SubOption AS 'Suboption', OCYC.Interval AS 'Interval', OCYC.EndType AS 'Recurrence End Type', OCYC.MaxOccur AS 'Max. Occurrences', OCYC.SeEndDat AS 'Series End Date', OCYC.Sunday AS 'Sunday', OCYC.Monday AS 'Monday', OCYC.Tuesday AS 'Tuesday', OCYC.Wednesday AS 'Wednesday', OCYC.Thursday AS 'Thursday', OCYC.Friday AS 'Friday', OCYC.Saturday AS 'Saturday', OCYC.DayInMonth AS 'Repeat Day in Month', OCYC.Week AS 'Repeat Week in Month', OCYC.DayOfWeek AS 'Repeat Day of Week', OCYC.Month AS 'Repeat Month' FROM OCYC AS OCYC

Related information


Inventory Cycles InventoryCycles Object· Table: OCYC
The InventoryCycles object enables to setup cycles of inventory counts and order intervals. Inventory cycles setup enables to track inventory counts by issuing an alert each time a count is due. It also is used for planning the order...

OCYC SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates