📚 SAP Business One SDK Help

Table Name: ORTL

Table Description: Resource Transaction Log

Field Description Type Size Related Default Value Constraints
LogEntry Log Entry ID Int 11 -      
ResCode Resource Code nVarChar 50 ORSC      
DocType Transact. Type Int 11 -      
DocEntry Document Internal ID Int 11 -      
DocLine Doc. Row Number Int 11 -      
BaseType Base Document Type Int 11 -      
BaseEntry Base Document Internal ID Int 11 -      
BaseLine Base Document Row Number Int 11 -      
ActionType Action Type Int 11 - 0 0 RESOURCE_TRANSACTION_UNKNOWN
            1 RESOURCE_TRANSACTION_IN
            2 RESOURCE_TRANSACTION_OUT
LocType Location Type Int 6 -      
LocCode Location Code nVarChar 8 -      
VersionNum Version Number nVarChar 13 -      
PostDate Posting Date Date 8 -      
CreateDate Creation Date Date 8 -      
CreateTime Creation Time Int 6 -      
DocQty Doc. Quantity Num 19.6 -      
Price Price Num 19.6 -      
LineTotal Row Total Num 19.6 -      
OpenQty Open Quantity Num 19.6 -      
DocNum Document Number nVarChar 11 -      
BaseDocNum Base Document Number nVarChar 11 -      
StgSeqNum Stage Sequence Number Int 11 -      
StgEntry Stage Entry Int 11 -      
StgDesc Stage Description nVarChar 100 -      
Key Unique Field
PRIMARY Yes LogEntry