biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Counting / Inventory Counting
DTW Inventory Counting
API Inventory Countings Service / Inventory Counting
OINC - Inventory Counting Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNumDocument NumberInt
11
Series KEY UNIQUESeriesInt
6NNM1
Documents Numbering - Series		SERIESYes
CountDateDate of CountingDate
8
TimeTime of CountingInt
11
CountTypeCounting TypeVarChar
1) Single Counter
2) Multiple Counters
1
1
Taker1TypeType of CounterInt
12) User
171) Employee
11
12
Taker1IdCounter IDInt
11
Taker2TypeInt
12) User
171) Employee
11
12
Taker2IdInt
11
StatusStatusVarChar
O) Open
C) Closed
1
O
Ref2Reference 2nVarChar
11
RemarksRemarksText
16
LogInsLog Instance - HistoryInt
11
UserSignUser Creating - HistoryInt
6OUSR
Users
UserSign2Updating User - HistoryInt
6OUSR
Users
UpdateDateDate of Update - HistoryDate
8
CreateDateCreate Date - HistoryDate
8
ObjTypeObject TypenVarChar
20
1470000065
WddStatusAuthorization StatusVarChar
-) Without
W) Pending
Y) Approved
N) Rejected
P) Generated
A) Generated by Authorizer
C) Approved
1
DraftKeyDraft Document Internal IDInt
11OICD
Inventory Counting Draft		-1
PrintedPrintedVarChar
Y) Yes
N) No
1
N
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
TeamCountCount of Team CountersInt
11
0
IndvCountCount of Individual CountersInt
11
0
DiffQtyTotal DifferenceNum
20
DiffPercenTotal Difference (%)Num
20
UpdateTSUpdate Full TimeInt
11
CreateTimeGeneration TimeInt
6
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator		' '
FinncPriodPosting PeriodInt
11OFPR
Posting Period
PostDatePosting DateDate
8
VersionNumVersion NumbernVarChar
11
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Summary
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N

Table relationship map

SELECT statement

SELECT OINC.DocEntry AS 'Internal Number', OINC.DocNum AS 'Document Number', OINC.Series AS 'Series', OINC.CountDate AS 'Date of Counting', OINC.Time AS 'Time of Counting', OINC.CountType AS 'Counting Type', OINC.Taker1Type AS 'Type of Counter', OINC.Taker1Id AS 'Counter ID', OINC.Taker2Type AS '', OINC.Taker2Id AS '', OINC.Status AS 'Status', OINC.Ref2 AS 'Reference 2', OINC.Remarks AS 'Remarks', OINC.LogIns AS 'Log Instance - History', OINC.UserSign AS 'User Creating - History', OINC.UserSign2 AS 'Updating User - History', OINC.UpdateDate AS 'Date of Update - History', OINC.CreateDate AS 'Create Date - History', OINC.ObjType AS 'Object Type', OINC.WddStatus AS 'Authorization Status', OINC.DraftKey AS 'Draft Document Internal ID', OINC.Printed AS 'Printed', OINC.BPLId AS 'Branch', OINC.BPLName AS 'Branch Name', OINC.TeamCount AS 'Count of Team Counters', OINC.IndvCount AS 'Count of Individual Counters', OINC.DiffQty AS 'Total Difference', OINC.DiffPercen AS 'Total Difference (%)', OINC.UpdateTS AS 'Update Full Time', OINC.CreateTime AS 'Generation Time', OINC.PIndicator AS 'Period Indicator', OINC.FinncPriod AS 'Posting Period', OINC.PostDate AS 'Posting Date', OINC.VersionNum AS 'Version Number', OINC.DataSource AS 'Data Source' FROM OINC AS OINC

Related information


Inventory Counting InventoryCounting Object· Table: OINC
You can use this object to specify items for inventory counting and record the counting results. Source table: OINC.  
   Parent: Inventory Countings Service InventoryCountingsService Service· Table: OINC

Inventory Countings Service InventoryCountingsService Service· Table: OINC
The InventoryCountingsService service enables you to add, look up, update, and close inventory counting transactions. Source table: OINC.

OINC SQL Table

Business Place OBPL SQL Table

Inventory Counting Draft OICD SQL Table

Posting Period OFPR 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates