📚 SAP Business One SDK Help

Table Name: ORCJ

Table Description: Resource Capacity Log

Field Description Type Size Related Default Value Constraints
Id Primary Key Int 11 -      
ResCode Internal Resource ID nVarChar 50 ORSC      
WhsCode Warehouse Code nVarChar 8 OWHS      
CapDate Capacity Date Date 8 -      
CapType Type of Capacity Entry VarChar 1 - I I Internal
            O Ordered
            C Committed
            U Consumed
Capacity Capacity Num 19.6 -      
SrcObjType Source Object Type Int 11 - -1 -1  
            202 Production Order
            60 Issue for Production
            59 Receipt from Production
            17 Sales Order
            15 Delivery
            13 A/R Invoice
            -13 A/R Reserve Invoice
            14 A/R Credit Memo
            165 A/R Correction Invoice
            166 A/R Correction Invoice Reversal
            16 Returns
            22 Purchase Order
            20 Goods Receipt PO
            18 A/P Invoice
            -18 A/P Reserve Invoice
            19 A/P Credit Memo
            163 A/P Correction Invoice
            164 A/P Correction Invoice Reversal
            21 Goods Return
SrcAbsEnt Source Absolute Entry Int 11 -      
SrcLine Source Line Number Int 11 -      
BaseObjTyp Base Object Type Int 11 - -1 -1  
            202 Production Order
BaseAbsEnt Base Absolute Entry Int 11 -      
BaseLine Base Line Number Int 11 -      
ActionType Action Type Int 6 - -1 -1  
            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
            9 Sales Order - Create
            10 Sales Order - Close
            11 Sales Order - Cancel
            12 Sales Order - Add Line
            13 Sales Order - Delete Line
            14 Sales Order - Update Line
            15 Delivery - Create
            16 Delivery - Close
            17 Delivery - Cancel
            18 A/R Invoice - Create
            19 A/R Invoice - Cancel
            20 A/R Credit Memo - Create
            21 A/R Credit Memo - Cancel
            22 Correction A/R Invoice - Create
            23 Correction A/R Invoice Reversal - Create
            24 Returns - Create
            25 Returns - Cancel
            26 Returns - Close
            27 Purchase Order - Create
            28 Purchase Order - Close
            29 Purchase Order - Cancel
            30 Purchase Order - Add Line
            31 Purchase Order - Delete Line
            32 Purchase Order - Update Line
            33 Goods Receipt PO - Create
            34 Goods Receipt PO - Close
            35 Goods Receipt PO - Cancel
            36 A/P Invoice - Create
            37 A/P Invoice - Cancel
            38 A/P Credit Memo - Create
            39 A/P Credit Memo - Cancel
            40 Correction A/P Invoice - Create
            41 Correction A/P Invoice Reversal - Create
            42 Goods Return - Create
            43 Goods Return - Cancel
            44 Goods Return - Close
            45 A/R Invoice - Update
            46 A/P Invoice - Update
            47 A/R Reserve Invoice - Create
            48 A/R Reserve Invoice - Update
            49 A/R Reserve Invoice - Cancel
            50 A/P Reserve Invoice - Create
            51 A/P Reserve Invoice - Update
            52 A/P Reserve Invoice - Cancel
OwnObjTyp Owning Doc. Object Type Int 11 - -1 -1  
            202 Production Order
            60 Issue for Production
            59 Receipt from Production
            17 Sales Order
            15 Delivery
            13 A/R Invoice
            -13 A/R Reserve Invoice
            14 A/R Credit Memo
            165 A/R Correction Invoice
            166 A/R Correction Invoice Reversal
            16 Returns
            22 Purchase Order
            20 Goods Receipt PO
            18 A/P Invoice
            -18 A/P Reserve Invoice
            19 A/P Credit Memo
            163 A/P Correction Invoice
            164 A/P Correction Invoice Reversal
            21 Goods Return
OwnAbsEnt Owning Doc. Absolute Entry Int 11 -      
OwnLine Owning Doc. Line Number Int 11 -      
RevdObjTyp Reverted Object Type Int 11 - -1 -1  
            60 Issue for Production
RevdAbsEnt Reverted Absolute Entry Int 11 -      
RevdLine Reverted Line Number Int 11 -      
MemoSrc Memo Source VarChar 1 - - -  
            C Resource Capacity Form
            S Set Daily Internal Capacities Form
Memo Memo Text 16 -      
SngRunCap Single Run Capacity Num 19.6 -      
MemoSrcSng Memo Source of Single Run Capacity VarChar 1 - - -  
            C Resource Capacity Form
            S Set Daily Internal Capacities Form
MemoSng Memo of Single Run Capacity Text 16 -      
Key Unique Field
PRIMARY Yes Id
RWDT No ResCode
    WhsCode
    CapDate
    CapType
BASE_DOC No BaseObjTyp
    BaseAbsEnt
    BaseLine
OWNING_DOC No OwnObjTyp
    OwnAbsEnt
    OwnLine