📚 SAP Business One SDK Help

Table Name: OMRL

Table Description: Advanced Inventory Revaluation

Field Description Type Size Related Default Value Constraints
DocEntry Internal Number Int 11 -      
DocNum Document Number Int 11 -      
Series Series Int 11 - 0    
DocDate Posting Date Date 8 -      
RevalType Inventory Valuation Type VarChar 1 - P P Price Change
            M Inventory Debit/Credit
Handwrtten Manual Numbering VarChar 1 - N    
Printed Printed VarChar 1 - N Y Copy
            N Original
Transfered Year Transfer VarChar 1 - N Y Yes
            N No
DocCur Document Currency nVarChar 3 -      
DocRate Document Rate Num 19.6 -      
Ref2 Reference 2 nVarChar 11 -      
Comments Remarks nVarChar 254 -      
JrnlMemo Journal Remarks nVarChar 50 -      
TransId Transaction Number Int 11 OJDT      
DocTime Generation Time Int 6 -      
Confirmed Confirmed VarChar 1 - Y Y Yes
            N No
Instance Instance Int 6 - 0    
UpdateDate Date of Update Date 8 -      
CreateDate Creation Date Date 8 -      
TaxDate Document Date Date 8 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Upgrade
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
StampNum Stamp No. nVarChar 16 -      
FinncPriod Posting Period Int 11 OFPR      
UserSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
LogInstanc Log Instance Int 11 - 0    
StationID Workstation ID Int 11 CSTN      
Rounding Rounding VarChar 1 - N Y Yes
            N No
Segment Segment Int 6 - 0    
ReqDate Required Date Date 8 -      
CancelDate Cancelation Date Date 8 -      
Project Project Code nVarChar 20 OPRJ      
Key Unique Field
PRIMARY Yes DocEntry
NUM Yes DocNum
    Instance
    Segment
SERIES No Series