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

SQL Finance / Fixed Asset Transactions

API OFIX

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11		PRIMARY	Yes
SrcObjType ^KEY	Source Object Type	nVarChar		20		SECONDARY	No
SrcObjAbs	Source Object Internal ID	Int		11
Canceled	Canceled	VarChar	Y) Yes N) No	1	N
CancelDate	Cancellation Date	Date		8

SELECT statement

SELECT
   OFIX.AbsEntry AS 'Internal Number', 
   OFIX.SrcObjType AS 'Source Object Type', 
   OFIX.SrcObjAbs AS 'Source Object Internal ID', 
   OFIX.Canceled AS 'Canceled', 
   OFIX.CancelDate AS 'Cancellation Date'
FROM OFIX AS OFIX

Related information

OFIX 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