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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AgrNo KEY UNIQUEAgreement No.Int
11AOAT
Blanket Agreement
PRIMARYYes
AgrLnNumAgreement Item Row NumberInt
11
AgrEfctNumAgreement Effective: Row No.Int
11
ActivityIDActivity IDInt
11OCLG
Activities
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT AOA3.AgrNo AS 'Agreement No.', AOA3.AgrLnNum AS 'Agreement Item Row Number', AOA3.AgrEfctNum AS 'Agreement Effective: Row No.', AOA3.ActivityID AS 'Activity ID', AOA3.LogInstanc AS 'Log Instance' FROM AOA3 AS AOA3

Related information


Activities OCLG SQL Table

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