biuan SAP® BUSINESS ONE SDK
API ORCJ
ORCJ - Resource Capacity Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Id KEY UNIQUEPrimary KeyInt
11
PRIMARYYes
ResCode KEYInternal Resource IDnVarChar
20ORSC
Resources
RWDTNo
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
CapDateCapacity DateDate
8
CapTypeType of Capacity EntryVarChar
I) Internal
O) Ordered
C) Committed
U) Consumed
1
CapacityCapacityNum
20
SrcObjTypeSource Object TypeInt
202) Production Order
60) Issue for Production
59) Receipt from Production
11
SrcAbsEntSource Absolute EntryInt
11
SrcLineSource Line NumberInt
11
BaseObjTyp KEYBase Object TypeInt
202) Production Order
11
BASE_DOCNo
BaseAbsEntBase Absolute EntryInt
11
BaseLineBase Line NumberInt
11
ActionTypeAction TypeInt
1) Production Order - Create
2) Production Order - Close
3) Production Order - Reschedule
4) Production Order - Add Line
5) Production Order - Delete Line
6) Production Order - Update Line
7) Issue for Production - Create
8) Receipt from Production - Create
6
OwnObjTyp KEYOwning Doc. Object TypeInt
202) Production Order
60) Issue for Production
59) Receipt from Production
11
OWNING_DOCNo
OwnAbsEntOwning Doc. Absolute EntryInt
11
OwnLineOwning Doc. Line NumberInt
11
RevdObjTypReverted Object TypeInt
60) Issue for Production
11
RevdAbsEntReverted Absolute EntryInt
11
RevdLineReverted Line NumberInt
11
MemoSrcMemo SourceVarChar
C) Resource Capacity Form
S) Set Daily Internal Capacities Form
1
MemoMemoText
16

Table relationship map

SELECT statement

SELECT ORCJ.Id AS 'Primary Key', ORCJ.ResCode AS 'Internal Resource ID', ORCJ.WhsCode AS 'Warehouse Code', ORCJ.CapDate AS 'Capacity Date', ORCJ.CapType AS 'Type of Capacity Entry', ORCJ.Capacity AS 'Capacity', ORCJ.SrcObjType AS 'Source Object Type', ORCJ.SrcAbsEnt AS 'Source Absolute Entry', ORCJ.SrcLine AS 'Source Line Number', ORCJ.BaseObjTyp AS 'Base Object Type', ORCJ.BaseAbsEnt AS 'Base Absolute Entry', ORCJ.BaseLine AS 'Base Line Number', ORCJ.ActionType AS 'Action Type', ORCJ.OwnObjTyp AS 'Owning Doc. Object Type', ORCJ.OwnAbsEnt AS 'Owning Doc. Absolute Entry', ORCJ.OwnLine AS 'Owning Doc. Line Number', ORCJ.RevdObjTyp AS 'Reverted Object Type', ORCJ.RevdAbsEnt AS 'Reverted Absolute Entry', ORCJ.RevdLine AS 'Reverted Line Number', ORCJ.MemoSrc AS 'Memo Source', ORCJ.Memo AS 'Memo' FROM ORCJ AS ORCJ

Related information


Resources ORSC SQL Table

Warehouses OWHS 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