biuan SAP® BUSINESS ONE SDK
API OFIX
OFIX - Fixed Asset Transactions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
SrcObjType KEYSource Object TypenVarChar
20
SECONDARYNo
SrcObjAbsSource Object Internal IDInt
11
CanceledCanceledVarChar
Y) Yes
N) No
1
N
CancelDateCancellation DateDate
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



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