SAP Business One SDK 10.0 - Database Tables Reference
-
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 |