AIT5 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Inventory and Production /

Asset Item Projects - History

API AIT5

AIT5 - Asset Item Projects - History Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
ItemCode ^KEY ^UNIQUE	Item No.	nVarChar	20	OITM Items		PRIMARY	Yes
LineNum	Line Number	Int	11
ValidFrom	Valid From	Date	8
ValidTo	Valid To	Date	8
Project	Project	nVarChar	20	OPRJ Project Codes
LogInstanc	Log Instance	Int	11		0
ObjType	Object	nVarChar	20	ADP1 Object Settings - History	4

Table relationship map

SELECT statement

SELECT
   AIT5.ItemCode AS 'Item No.', 
   AIT5.LineNum AS 'Line Number', 
   AIT5.ValidFrom AS 'Valid From', 
   AIT5.ValidTo AS 'Valid To', 
   AIT5.Project AS 'Project', 
   AIT5.LogInstanc AS 'Log Instance', 
   AIT5.ObjType AS 'Object'
FROM AIT5 AS AIT5

Related information

OITM SQL Table

ADP1 SQL Table

OPRJ SQL Table

biuan SAP® BUSINESS ONE

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