biuan SAP® BUSINESS ONE SDK
API OAT3
OAT3 - Item Details: Activity Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AgrNo KEY UNIQUEAgreement No.Int
11OOAT
Blanket Agreement
PRIMARYYes
AgrLnNumAgreement Line NumberInt
11
AgrEfctNumLine NumberInt
11
ActivityIDActivity IDInt
11OCLG
Activities
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT OAT3.AgrNo AS 'Agreement No.', OAT3.AgrLnNum AS 'Agreement Line Number', OAT3.AgrEfctNum AS 'Line Number', OAT3.ActivityID AS 'Activity ID', OAT3.LogInstanc AS 'Log Instance' FROM OAT3 AS OAT3

Related information


Activities OCLG SQL Table

Blanket Agreement OOAT 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