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

SQL

Finance /

Depreciation Types - Rows - History

API ADT1

ADT1 - Depreciation Types - Rows - History Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
Code ^KEY ^UNIQUE	Code	nVarChar		15	ODTP Fixed Assets Depreciation Types		PRIMARY	Yes
Level	Level	Int		11
Base	Base	nVarChar	APC) Acquisition Value NBV) Net Book Value	3		APC
Years	Number of Years	Int		11
Percentage	Percentage	Num		20
LogInstanc	Log Instance	Int		11		0
Amount	Amount	Num		20
SnapshotId	Snapshot ID	Int		11		0

SELECT statement

SELECT
   ADT1.Code AS 'Code', 
   ADT1.Level AS 'Level', 
   ADT1.Base AS 'Base', 
   ADT1.Years AS 'Number of Years', 
   ADT1.Percentage AS 'Percentage', 
   ADT1.LogInstanc AS 'Log Instance', 
   ADT1.Amount AS 'Amount', 
   ADT1.SnapshotId AS 'Snapshot ID'
FROM ADT1 AS ADT1

Related information

ODTP 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