📚 SAP Business One SDK Help

Table Name: OCYC

Table Description: Cycle

Field Description Type Size Related Default Value Constraints
Code Cycle Code Int 6 -      
Name Cycle Name nVarChar 20 -      
Frequency Frequency VarChar 1 -   0 Daily
            1 Weekly
            2 Every Four Weeks
            3 Monthly
            4 Quarterly
            5 Semiannually
            6 Annually
            7 None
            8 Every "X" Days:
Day Day Int 11 -      
Hour Hour Int 11 -      
UserSign User Signature Int 6 OUSR      
NextDate Next Counting Date Date 8 -      
Type Cycle Type VarChar 1 - C C Cycle
            M MRP
SubOption Suboption VarChar 1 - 1 1 Option 1
            2 Option 2
Interval Interval Int 11 - 1    
EndType Recurrence End Type VarChar 1 - N N No End Date
            C By Counter
            D By Date
MaxOccur Max. Occurrences Int 11 -      
SeEndDat Series End Date Date 8 -      
Sunday Sunday VarChar 1 - N N No
            Y Yes
Monday Monday VarChar 1 - N N No
            Y Yes
Tuesday Tuesday VarChar 1 - N N No
            Y Yes
Wednesday Wednesday VarChar 1 - N N No
            Y Yes
Thursday Thursday VarChar 1 - N N No
            Y Yes
Friday Friday VarChar 1 - N N No
            Y Yes
Saturday Saturday VarChar 1 - N N No
            Y Yes
DayInMonth Repeat Day in Month Int 11 -      
Week Repeat Week in Month Int 11 -   1 First
            2 Second
            3 Third
            4 Fourth
            5 Last
DayOfWeek Repeat Day of Week Int 11 -   8 Day
            9 Weekday
            0 Weekend Day
            1 Sunday
            2 Monday
            3 Tuesday
            4 Wednesday
            5 Thursday
            6 Friday
            7 Saturday
Month Repeat Month Int 11 -      
Key Unique Field
PRIMARY Yes Code
NAME Yes Name