📚 SAP Business One SDK Help

Table Name: OIQR

Table Description: Inventory Posting

Field Description Type Size Related Default Value Constraints
DocEntry Document Internal ID Int 11 -      
CreateDate Creation Date Date 8 -      
DocTime Generation Time Int 6 -      
IOffIncAcc Inventory Offset - Increase Ac nVarChar 15 OACT      
DOffDecAcc Inventory Offset Decrease Acct nVarChar 15 OACT      
DocDate Posting Date Date 8 -      
Reference Reference nVarChar 11 -      
Comments Remarks nVarChar 254 -      
DocDueDate Due Date Date 8 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
VersionNum Version Number nVarChar 13 -      
JdtNum Journal Number Int 11 OJDT      
Reference2 Reference 2 nVarChar 11 -      
ObjType Object Type nVarChar 20 - 10000071    
DocNum Document Number Int 11 -      
Series Series Int 11 NNM1      
PriceSrc Price Source Int 11 - 3 1 By Price List
            2 Last Evaluated Price
            3 Item Cost
PriceList Price List Int 11 -      
JrnlMemo Journal Remarks nVarChar 254 -      
Status Status VarChar 1 - O O Open
            C Close
LogIns Log Instance - History Int 11 -      
UserSign2 Updating User - History Int 6 OUSR      
UpdateDate Date of Update - History Date 8 -      
CountDate Date of Counting Date 8 -      
CountTime Time of Counting Int 11 -      
WddStatus Authorization Status VarChar 1 - - - Without
            W Pending
            Y Approved
            N Rejected
            P Generated
            A Generated by Authorizer
            C Canceled
DraftKey Draft Document Internal ID Int 11 OIPD -1    
Printed Printed VarChar 1 - N    
DocTotal Document Total Num 19.6 -      
BPLId Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
UpdateTS Update Full Time Int 11 -      
CopyOption DI Copy from Option VarChar 1 - 0 0 No Counters Diff.
            1 Individual 1
            2 Individual 2
            3 Individual 3
            4 Individual 4
            5 Individual 5
            6 Team Counted Quantity
BaseEntry Base Counting Doc. Entry Int 11 -      
PIndicator Period Indicator nVarChar 10 OPID ' '    
FinncPriod Posting Period Int 11 OFPR      
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
YearEndDt End of Fiscal Year Date 8 -      
Key Unique Field
PRIMARY Yes DocEntry
DOC_DATE No DocDate
CREATEDATE No CreateDate
    DocTime