📚 SAP Business One SDK Help

Table Name: OTNL

Table Description: CCD Log

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
TrNtAbsEnt Tracking Note Internal Number Int 11 OTCN      
TrNtLineNo Tracking Note Row Number Int 11 TCN1      
Quantity Quantity Num 19.6 -      
WhsCode Warehouse Code nVarChar 8 -      
DocEntry Doc Abs Entry Int 11 -      
DocNum Doc Number Int 11 -      
DocType Transaction Type Int 11 - -1    
DocLineNum Doc Line Number Int 11 -      
BaseAbsEnt Base Abs Entry Int 11 - -1    
BaseType Base Document Type Int 11 -      
BaseLnNum Base Document Line No. Int 11 -      
ActionType Action Type Int 11 - 5 0 TRANSACTION_UNKNOWN
            1 TRANSACTION_IN
            2 TRANSACTION_OUT
            3 TRANSACTION_SET
            4 TRANSACTION_COMPLETE
            5 EMPTY_TRANSACTION
            6 TRANSACTION_REVALUATION
            7 TRANSACTION_REVALUATION_INCREASE
            8 TRANSACTION_REVALUATION_DECREASE
            9 TRANSACTION_CLOSE_IN
            10 TRANSACTION_CLOSE_OUT
            11 TRANSACTION_NEGATIVE_REVALUATION
            12 TRANSACTION_NULLIFY
            13 TRANSACTION_RESERVE_CI_IN
            14 TRANSACTION_RESERVE_CI_OUT
            15 TRANSACTION_RESERVE_CI_REVAL_INC
            16 TRANSACTION_RESERVE_CI_REVAL_DEC
            17 TRANSACTION_REVAL_PRICE_CHANGE_INCREASE
            18 TRANSACTION_REVAL_PRICE_CHANGE_DECREASE
CCDNum CCD Number nVarChar 40 -      
ItemCode Item Code nVarChar 50 -      
DirectImp Direct Import VarChar 1 - N Y Yes
            N No
CntrOrigin Country/Region of Origin nVarChar 3 -      
AccQty Quantity-In Accumulator Num 19.6 -      
AccNegQ Quantity-Out Accumulator Num 19.6 -      
AccRelQty Reallocation Quantity Accumulator Num 19.6 -      
CCDQty CCD Quantity Num 19.6 -      
CreateDate Creation Date Date 8 -      
CreateTime Generation Time Int 6 -      
OnHandQty Warehouse On Hand Quantity Num 19.6 -      
OILMEntry OILM Abs Entry Int 11 OILM      
Key Unique Field
PRIMARY Yes AbsEntry