biuan SAP® BUSINESS ONE SDK
API RSC6
RSC6 - Resources - Daily Capacities Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ResCode KEY UNIQUEInternal Resource IDnVarChar
20ORSC
Resources
PRIMARYYes
WeekDayWeekday No.Int
1) First Day of Week
2) Second Day of Week
3) Third Day of Week
4) Fourth Day of Week
5) Fifth Day of Week
6) Sixth Day of Week
7) Seventh Day of Week
11
CapFactor1Day 1 Capacity Factor 1Num
20
CapFactor2Day 1 Capacity Factor 2Num
20
CapFactor3Day 1 Capacity Factor 3Num
20
CapFactor4Day 1 Capacity Factor 4Num
20
CapTotalTotal Daily CapacityNum
20
RemarksRemarksnVarChar
100
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT RSC6.ResCode AS 'Internal Resource ID', RSC6.WeekDay AS 'Weekday No.', RSC6.CapFactor1 AS 'Day 1 Capacity Factor 1', RSC6.CapFactor2 AS 'Day 1 Capacity Factor 2', RSC6.CapFactor3 AS 'Day 1 Capacity Factor 3', RSC6.CapFactor4 AS 'Day 1 Capacity Factor 4', RSC6.CapTotal AS 'Total Daily Capacity', RSC6.Remarks AS 'Remarks', RSC6.LogInstanc AS 'Log Instance' FROM RSC6 AS RSC6

Related information


Resources ORSC 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