biuan SAP® BUSINESS ONE SDK
API AOA1
AOA1 - Blanket Agreement - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AgrNo KEY UNIQUEAgreement No.Int
11AOAT
Blanket Agreement
PRIMARYYes
AgrLineNumAgreement Row NumberInt
11
ItemCodeItem No.nVarChar
20OITM
Items
ItemNameItem DescriptionnVarChar
100
ItemGroupItem GroupInt
6OITB
Item Groups
PlanQtyPlanned QuantityNum
20
UnitPriceUnit PriceNum
20
CurrencyPrice CurrencynVarChar
3
CumQtyCumulative QuantityNum
20
CumAmntFCCumulative Amount in FCNum
20
CumAmntLCCumulative Amount in LCNum
20
FreeTxtFree TextnVarChar
100
InvntryUomInventory UoMnVarChar
100
LogInstancLog InstanceInt
11
0
VisOrderVisual OrderInt
11
RetPortionGoods Return ProbabilityNum
20
WrrtyEndDate When Goods ExpireDate
8
LineStatusRow StatusVarChar
O) Open
C) Closed
1
O
PlanAmtLCPlanned Amount (LC)Num
20
PlanAmtFCPlanned Amount (FC)Num
20
DiscountLine DiscountNum
20
UomEntryUoM EntryInt
11OUOM
UoM Master Data
UomCodeUoM CodenVarChar
20
NumPerMsrUoM ValueNum
20
0

Table relationship map

SELECT statement

SELECT AOA1.AgrNo AS 'Agreement No.', AOA1.AgrLineNum AS 'Agreement Row Number', AOA1.ItemCode AS 'Item No.', AOA1.ItemName AS 'Item Description', AOA1.ItemGroup AS 'Item Group', AOA1.PlanQty AS 'Planned Quantity', AOA1.UnitPrice AS 'Unit Price', AOA1.Currency AS 'Price Currency', AOA1.CumQty AS 'Cumulative Quantity', AOA1.CumAmntFC AS 'Cumulative Amount in FC', AOA1.CumAmntLC AS 'Cumulative Amount in LC', AOA1.FreeTxt AS 'Free Text', AOA1.InvntryUom AS 'Inventory UoM', AOA1.LogInstanc AS 'Log Instance', AOA1.VisOrder AS 'Visual Order', AOA1.RetPortion AS 'Goods Return Probability', AOA1.WrrtyEnd AS 'Date When Goods Expire', AOA1.LineStatus AS 'Row Status', AOA1.PlanAmtLC AS 'Planned Amount (LC)', AOA1.PlanAmtFC AS 'Planned Amount (FC)', AOA1.Discount AS 'Line Discount', AOA1.UomEntry AS 'UoM Entry', AOA1.UomCode AS 'UoM Code', AOA1.NumPerMsr AS 'UoM Value' FROM AOA1 AS AOA1

Related information


Blanket Agreement AOAT SQL Table

Items OITM SQL Table

Item Groups OITB SQL Table

UoM Master Data OUOM 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