📚 SAP Business One SDK Help

Table Name: OAT1

Table Description: Blanket Agreement - Rows

Field Description Type Size Related Default Value Constraints
AgrNo Agreement No. Int 11 OOAT      
AgrLineNum Agreement Row Number Int 11 -      
ItemCode Item No. nVarChar 50 OITM      
ItemName Item Description nVarChar 200 -      
ItemGroup Item Group Int 6 OITB      
PlanQty Planned Quantity Num 19.6 -      
UnitPrice Unit Price Num 19.6 -      
Currency Price Currency nVarChar 3 -      
CumQty Cumulative Quantity Num 19.6 -      
CumAmntFC Cumulative Amount in FC Num 19.6 -      
CumAmntLC Cumulative Amount in LC Num 19.6 -      
FreeTxt Free Text nVarChar 100 -      
InvntryUom Inventory UoM nVarChar 100 -      
LogInstanc Log Instance Int 11 - 0    
VisOrder Visual Order Int 11 -      
RetPortion Goods Return Probability Num 19.6 -      
WrrtyEnd Date When Goods Expire Date 8 -      
LineStatus Row Status VarChar 1 - O O Open
            C Closed
PlanAmtLC Planned Amount (LC) Num 19.6 -      
PlanAmtFC Planned Amount (FC) Num 19.6 -      
Discount Line Discount Num 19.6 -      
UomEntry UoM Entry Int 11 OUOM      
UomCode UoM Code nVarChar 20 -      
NumPerMsr UoM Value Num 19.6 - 0    
UndlvQty Undeliverd Quantity Num 19.6 -      
UndlvAmntL Undeliverd Amount LC Num 19.6 -      
UndlvAmntF Undeliverd Amount FC Num 19.6 -      
TrnspCode Shipping Type Int 6 OSHP      
Project Project Code nVarChar 20 OPRJ      
TaxCode Tax Code nVarChar 8 -      
TAXRate TAX Rate Num 19.6 -      
PlVatAmtLC Planned VAT Amount (LC) Num 19.6 -      
PlVatAmtFC Planned VAT Amount (FC) Num 19.6 -      
CumVtAmtLC Cumulative VAT Amount (LC) Num 19.6 -      
CumVtAmtFC Cumulative VAT Amount (FC) Num 19.6 -      
EncryptIV Encrypt IV nVarChar 100 -      
UoMNum UoM Item Per Unit Numerator Num 19.6 -      
UoMDen UoM Item Per Unit Denominator Num 19.6 -      
Key Unique Field
PRIMARY Yes AgrNo
    AgrLineNum