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

SQL Inventory and Production / Asset Item Depreciation Params - History

API AIT7

AIT7 - Asset Item Depreciation Params - 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
PeriodCat	Period Category	nVarChar	10
DprArea	Depreciation Area	nVarChar	15	ODPA Fixed Asset Depreciation Areas
VisOrder	Visual Order	Int	11
DprStart	Depreciation Start Date	Date	8
DprEnd	Depreciation End Date	Date	8
UsefulLife	Useful Life	Int	11
RemainLife	Remaining Life	Num	20
DprType	Depreciation Type	nVarChar	15	ODTP Fixed Assets Depreciation Types
DprTypeC	Depr. Type Calculation	nVarChar	15	ODTP Fixed Assets Depreciation Types
UsefulLfeC	Useful Life Calculation	Int	11
LogInstanc	Log Instance	Int	11		0
ObjType	Object	nVarChar	20	ADP1 Object Settings - History	4
RemainDays	Remaining Life in Days	Num	20

Table relationship map

SELECT statement

SELECT
   AIT7.ItemCode AS 'Item No.', 
   AIT7.PeriodCat AS 'Period Category', 
   AIT7.DprArea AS 'Depreciation Area', 
   AIT7.VisOrder AS 'Visual Order', 
   AIT7.DprStart AS 'Depreciation Start Date', 
   AIT7.DprEnd AS 'Depreciation End Date', 
   AIT7.UsefulLife AS 'Useful Life', 
   AIT7.RemainLife AS 'Remaining Life', 
   AIT7.DprType AS 'Depreciation Type', 
   AIT7.DprTypeC AS 'Depr. Type Calculation', 
   AIT7.UsefulLfeC AS 'Useful Life Calculation', 
   AIT7.LogInstanc AS 'Log Instance', 
   AIT7.ObjType AS 'Object', 
   AIT7.RemainDays AS 'Remaining Life in Days'
FROM AIT7 AS AIT7

Related information

ODPA SQL Table

ODTP SQL Table

OITM SQL Table

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