|
|
DTW Administration / Setup / Inventory / Inventory Cycles
API OCYC / Inventory Cycles
OCYC - Cycle Table
Inventory Cycles InventoryCycles Object· Table: OCYC
OCYC SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Cycle Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Cycle Name | nVarChar | 20 | NAME | Yes | |||
| Frequency | Frequency | VarChar | 0 1) Weekly 2) Every Four Weeks 3) Monthly 4) Quarterly 5) Semiannually 6) Annually 7) None 8) Every "X" Days: | 1 | ||||
| Day | Day | Int | 11 | |||||
| Hour | Hour | Int | 11 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| NextDate | Next Counting Date | Date | 8 | |||||
| Type | Cycle Type | VarChar | C) Cycle M) MRP | 1 | C | |||
| SubOption | Suboption | VarChar | 1) Option 1 2) Option 2 | 1 | 1 | |||
| Interval | Interval | Int | 11 | 1 | ||||
| EndType | Recurrence End Type | VarChar | N) No End Date C) By Counter D) By Date | 1 | N | |||
| MaxOccur | Max. Occurrences | Int | 11 | |||||
| SeEndDat | Series End Date | Date | 8 | |||||
| Sunday | Sunday | VarChar | N) No Y) Yes | 1 | N | |||
| Monday | Monday | VarChar | N) No Y) Yes | 1 | N | |||
| Tuesday | Tuesday | VarChar | N) No Y) Yes | 1 | N | |||
| Wednesday | Wednesday | VarChar | N) No Y) Yes | 1 | N | |||
| Thursday | Thursday | VarChar | N) No Y) Yes | 1 | N | |||
| Friday | Friday | VarChar | N) No Y) Yes | 1 | N | |||
| Saturday | Saturday | VarChar | N) No Y) Yes | 1 | N | |||
| DayInMonth | Repeat Day in Month | Int | 11 | |||||
| Week | Repeat Week in Month | Int | 1) First 2) Second 3) Third 4) Fourth 5) Last | 11 | ||||
| DayOfWeek | Repeat Day of Week | Int | 8) Day 9) Weekday 0 1) Sunday 2) Monday 3) Tuesday 4) Wednesday 5) Thursday 6) Friday 7) Saturday | 11 | ||||
| Month | Repeat Month | Int | 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
InventoryCycles
Enumeration
Method
Property
CycleCode
DTW DB
CycleName
DTW DB
Day
DTW DB
Frequency
DTW DB
Friday
DB
Hour
DTW DB
Monday
DB
NextCountingDate
DTW DB
Saturday
DB
Sunday
DB
Thursday
DB
Tuesday
DB
Wednesday
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
