biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Counting Draft
API OICD
OICD - Inventory Counting Draft Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNumDocument NumberInt
11
SeriesSeriesInt
6NNM1
Documents Numbering - Series
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
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) Approved
A) Generated by Authorizer
C) Canceled
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
10
' '
FinncPriodPosting PeriodInt
11
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 OICD.DocEntry AS 'Internal Number', OICD.DocNum AS 'Document Number', OICD.Series AS 'Series', OICD.CountDate AS 'Date of Counting', OICD.Time AS 'Time of Counting', OICD.CountType AS 'Counting Type', OICD.Taker1Type AS 'Type of Counter', OICD.Taker1Id AS 'Counter ID', OICD.Taker2Type AS '', OICD.Taker2Id AS '', OICD.Status AS 'Status', OICD.Ref2 AS 'Reference 2', OICD.Remarks AS 'Remarks', OICD.LogIns AS 'Log Instance - History', OICD.UserSign AS 'User Creating - History', OICD.UserSign2 AS 'Updating User - History', OICD.UpdateDate AS 'Date of Update - History', OICD.CreateDate AS 'Create Date - History', OICD.ObjType AS 'Object Type', OICD.WddStatus AS 'Authorization Status', OICD.DraftKey AS 'Draft Document Internal ID', OICD.Printed AS 'Printed', OICD.BPLId AS 'Branch', OICD.BPLName AS 'Branch Name', OICD.TeamCount AS 'Count of Team Counters', OICD.IndvCount AS 'Count of Individual Counters', OICD.DiffQty AS 'Total Difference', OICD.DiffPercen AS 'Total Difference (%)', OICD.UpdateTS AS 'Update Full Time', OICD.CreateTime AS 'Generation Time', OICD.PIndicator AS 'Period Indicator', OICD.FinncPriod AS 'Posting Period', OICD.PostDate AS 'Posting Date', OICD.VersionNum AS 'Version Number', OICD.DataSource AS 'Data Source' FROM OICD AS OICD

Related information


Inventory Counting Draft OICD SQL Table

Business Place OBPL 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