SAP Business One SDK 10.0 - Database Tables Reference

• Blanket Agreement - Rows

  • Tablelist
  • DI API
  • Service Layer

  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