biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Items - Warehouse / Item Count Alert
DTW Inventory / Item Master Data / Item Count Alert
API Item Warehouse Info / Item Cycle Count
ITW1 - Item Count Alert Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items		PRIMARYYes
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
UserSignUser SignatureInt
6OUSR
Users
CycleCodeCycle CodeInt
6OCYC
Cycle
AlertAlertVarChar
N) No
Y) Yes
1
N
NextDateNext Counting DateDate
8
TimeAlert TimeInt
6
DestUserDestination UserInt
6OUSR
Users
AlertedAlertedVarChar
Y) Yes
N) No
1
N
BinAbsBin Internal NumberInt
11OBIN
Bin Location		-1

Table relationship map

SELECT statement

SELECT ITW1.ItemCode AS 'Item No.', ITW1.WhsCode AS 'Warehouse Code', ITW1.UserSign AS 'User Signature', ITW1.CycleCode AS 'Cycle Code', ITW1.Alert AS 'Alert', ITW1.NextDate AS 'Next Counting Date', ITW1.Time AS 'Alert Time', ITW1.DestUser AS 'Destination User', ITW1.Alerted AS 'Alerted', ITW1.BinAbs AS 'Bin Internal Number' FROM ITW1 AS ITW1

Related information


Item Cycle Count ItemCycleCount Object· Table: ITW1
ItemCycleCount object hold the information when an item will go through cycle counting. Each Item has a few Warehouses and each Warehouse has one ItemCycleCount. Source table: ITW1
   Parent: Item Warehouse Info ItemWarehouseInfo Object· Table: OITW
Bin Location OBIN SQL Table

Cycle OCYC SQL Table

Users OUSR SQL Table

Items OITM SQL Table

Warehouses OWHS 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