biuan SAP® BUSINESS ONE SDK
API AIN1
AIN1 - Inventory Counting - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11OINC
Inventory Counting
PRIMARYYes
LineNumRow NumberInt
11
ItemCodeItem CodenVarChar
20OITM
Items
ItemDescItem DescriptionnVarChar
100
FreezeItem Freeze StatusVarChar
Y) Yes
N) No
1
N
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
InWhsQtyIn-Whse Qty on Count DateNum
20
CountedCountedVarChar
Y) Yes
N) No
1
N
CountQtyCounted QuantityNum
20
CountQtyT1Counter 1 - Counted QuantityNum
20
CountQtyT2Num
20
RemarkRemarksnVarChar
127
BarCodeBar CodenVarChar
127
InvUoMInventory UoMVarChar
Y) Yes
N) No
1
Y
DifferenceDifferenceNum
20
DiffPercenDifference %Num
20
CountDateCount DateDate
8
CountTimeCount TimeInt
11
TargetRefTarget Document ReferencenVarChar
16
TargetTypeTarget Document TypeInt
-1)
0
10000071) Inventory Posting
11
-1
TargetEntrTarget Document Internal IDInt
11
TargetLineTarget Document RowInt
11
ProjCodeProject CodenVarChar
20OPRJ
Project Codes
OcrCodeDistribution Rule CodenVarChar
8OOCR
Distribution Rule
LineStatusRow StatusVarChar
O) Open
C) Closed
1
O
BinEntryBin Location EntryInt
11OBIN
Bin Location
VisOrderVisual OrderInt
11
OcrCode2Distribution Rule 2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule 3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule 4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule 5nVarChar
8OOCR
Distribution Rule
FirmCodeManufacturerInt
6OMRC
Manufacturers
SuppCatNumMfr Catalog No.nVarChar
17
PrefVendorPreferred VendornVarChar
15OCRD
Business Partner
LogInsLog Instance - HistoryInt
11
UgpEntryUoM Group EntryInt
11OUGP
UoM Group
IUomEntryInventory UoM EntrynVarChar
20OUOM
UoM Master Data
CountDiffCounters' Diff.Num
20
CountDiffPCounters' Diff. (%)Num
20
UomCodeUoM Code for DInVarChar
20
UomQtyUoM Counted Qty for DINum
20

Table relationship map

SELECT statement

SELECT AIN1.DocEntry AS 'Internal Number', AIN1.LineNum AS 'Row Number', AIN1.ItemCode AS 'Item Code', AIN1.ItemDesc AS 'Item Description', AIN1.Freeze AS 'Item Freeze Status', AIN1.WhsCode AS 'Warehouse Code', AIN1.InWhsQty AS 'In-Whse Qty on Count Date', AIN1.Counted AS 'Counted', AIN1.CountQty AS 'Counted Quantity', AIN1.CountQtyT1 AS 'Counter 1 - Counted Quantity', AIN1.CountQtyT2 AS '', AIN1.Remark AS 'Remarks', AIN1.BarCode AS 'Bar Code', AIN1.InvUoM AS 'Inventory UoM', AIN1.Difference AS 'Difference', AIN1.DiffPercen AS 'Difference %', AIN1.CountDate AS 'Count Date', AIN1.CountTime AS 'Count Time', AIN1.TargetRef AS 'Target Document Reference', AIN1.TargetType AS 'Target Document Type', AIN1.TargetEntr AS 'Target Document Internal ID', AIN1.TargetLine AS 'Target Document Row', AIN1.ProjCode AS 'Project Code', AIN1.OcrCode AS 'Distribution Rule Code', AIN1.LineStatus AS 'Row Status', AIN1.BinEntry AS 'Bin Location Entry', AIN1.VisOrder AS 'Visual Order', AIN1.OcrCode2 AS 'Distribution Rule 2', AIN1.OcrCode3 AS 'Distribution Rule 3', AIN1.OcrCode4 AS 'Distribution Rule 4', AIN1.OcrCode5 AS 'Distribution Rule 5', AIN1.FirmCode AS 'Manufacturer', AIN1.SuppCatNum AS 'Mfr Catalog No.', AIN1.PrefVendor AS 'Preferred Vendor', AIN1.LogIns AS 'Log Instance - History', AIN1.UgpEntry AS 'UoM Group Entry', AIN1.IUomEntry AS 'Inventory UoM Entry', AIN1.CountDiff AS 'Counters' Diff.', AIN1.CountDiffP AS 'Counters' Diff. (%)', AIN1.UomCode AS 'UoM Code for DI', AIN1.UomQty AS 'UoM Counted Qty for DI' FROM AIN1 AS AIN1

Related information


Bin Location OBIN SQL Table

Inventory Counting OINC SQL Table

Manufacturers OMRC SQL Table

Items OITM SQL Table

UoM Master Data OUOM SQL Table

Distribution Rule OOCR SQL Table

Business Partner OCRD SQL Table

Project Codes OPRJ SQL Table

UoM Group OUGP 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates