biuan SAP® BUSINESS ONE SDK
DTW Inventory Posting
API Inventory Postings Service / Inventory Posting
OIQR - Inventory Posting Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11
PRIMARYYes
CreateDate KEYCreation DateDate
8
CREATEDATENo
DocTimeGeneration TimeInt
6
IOffIncAccInventory Offset - Increase AcnVarChar
15OACT
G/L Accounts
DOffDecAccInventory Offset Decrease AcctnVarChar
15OACT
G/L Accounts
DocDate KEYPosting DateDate
8
DOC_DATENo
ReferenceReferencenVarChar
11
CommentsRemarksnVarChar
127
DocDueDateDue DateDate
8
DataSourceData SourceVarChar
1
N
UserSignUser SignatureInt
6OUSR
Users
VersionNumVersion NumbernVarChar
11
JdtNumJournal NumberInt
11OJDT
Journal Entry
Reference2Reference 2nVarChar
11
ObjTypeObject TypenVarChar
20
10000071
DocNumDocument NumberInt
11
SeriesSeriesInt
6NNM1
Documents Numbering - Series
PriceSrcPrice SourceInt
1) By Price List
2) Last Evaluated Price
3) Item Cost
11
3
PriceListPrice ListInt
11
JrnlMemoJournal RemarksnVarChar
50
StatusStatusVarChar
O) Open
C) Close
1
O
LogInsLog Instance - HistoryInt
11
UserSign2Updating User - HistoryInt
6OUSR
Users
UpdateDateDate of Update - HistoryDate
8
CountDateDate of CountingDate
8
CountTimeTime of CountingInt
11
WddStatusAuthorization StatusVarChar
-) Without
W) Pending
Y) Approved
N) Rejected
P) Generated
A) Generated by Authorizer
C) Canceled
1
DraftKeyDraft Document Internal IDInt
11OIPD
Inventory Posting Draft
-1
PrintedPrintedVarChar
1
N
DocTotalDocument TotalNum
20
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
UpdateTSUpdate Full TimeInt
11
CopyOptionDI Copy from OptionVarChar
0
1) Individual 1
2) Individual 2
3) Individual 3
4) Individual 4
5) Individual 5
6) Team Counted Quantity
1
0
BaseEntryBase Counting Doc. EntryInt
11
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
' '
FinncPriodPosting PeriodInt
11OFPR
Posting Period

Table relationship map

SELECT statement

SELECT OIQR.DocEntry AS 'Document Internal ID', OIQR.CreateDate AS 'Creation Date', OIQR.DocTime AS 'Generation Time', OIQR.IOffIncAcc AS 'Inventory Offset - Increase Ac', OIQR.DOffDecAcc AS 'Inventory Offset Decrease Acct', OIQR.DocDate AS 'Posting Date', OIQR.Reference AS 'Reference', OIQR.Comments AS 'Remarks', OIQR.DocDueDate AS 'Due Date', OIQR.DataSource AS 'Data Source', OIQR.UserSign AS 'User Signature', OIQR.VersionNum AS 'Version Number', OIQR.JdtNum AS 'Journal Number', OIQR.Reference2 AS 'Reference 2', OIQR.ObjType AS 'Object Type', OIQR.DocNum AS 'Document Number', OIQR.Series AS 'Series', OIQR.PriceSrc AS 'Price Source', OIQR.PriceList AS 'Price List', OIQR.JrnlMemo AS 'Journal Remarks', OIQR.Status AS 'Status', OIQR.LogIns AS 'Log Instance - History', OIQR.UserSign2 AS 'Updating User - History', OIQR.UpdateDate AS 'Date of Update - History', OIQR.CountDate AS 'Date of Counting', OIQR.CountTime AS 'Time of Counting', OIQR.WddStatus AS 'Authorization Status', OIQR.DraftKey AS 'Draft Document Internal ID', OIQR.Printed AS 'Printed', OIQR.DocTotal AS 'Document Total', OIQR.BPLId AS 'Branch', OIQR.BPLName AS 'Branch Name', OIQR.UpdateTS AS 'Update Full Time', OIQR.CopyOption AS 'DI Copy from Option', OIQR.BaseEntry AS 'Base Counting Doc. Entry', OIQR.PIndicator AS 'Period Indicator', OIQR.FinncPriod AS 'Posting Period' FROM OIQR AS OIQR

Related information


Inventory Posting InventoryPosting Object· Table: OIQR
If there are differences between the inventory counting results and the item quantities recorded in SAP Business One, you may need to reconcile the quantities so as not to distort your inventory valuation results. For this purpose, use the...
   Parent: Inventory Postings Service InventoryPostingsService Service· Table: OIQR

Inventory Postings Service InventoryPostingsService Service· Table: OIQR
The InventoryPostingsService service enables you to add, look up, and update inventory posting transactions. Source table: OIQR.

Business Place OBPL SQL Table

G/L Accounts OACT SQL Table

Inventory Posting Draft OIPD SQL Table

Posting Period OFPR SQL Table

Journal Entry OJDT SQL Table

Period Indicator OPID SQL Table

Documents Numbering - Series NNM1 SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates