biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Blanket Agreement / Blanket Agreement
DTW Blanket Agreement
API Blanket Agreements Service / Blanket Agreement
OOAT - Blanket Agreement Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsID KEY UNIQUEAgreement No.Int
11
PRIMARYYes
BpCodeBP CodenVarChar
15OCRD
Business Partner
BpNameBP NamenVarChar
100
CntctCodeContact Person CodeInt
11OCPR
Contact Persons
StartDateStart DateDate
8
EndDateEnd DateDate
8
TermDateTermination DateDate
8
DescriptDescriptionnVarChar
127
TypeAgreement TypeVarChar
G) General
S) Specific
1
G
StatusAgreement StatusVarChar
A) Approved
F) On Hold
D) Draft
T) Terminated
C) Canceled
1
D
OwnerOwnerInt
11OHEM
Employees
RenewalRenewalVarChar
Y) Yes
N) No
1
N
UseDiscntUse BP Special PriceVarChar
Y) Yes
N) No
1
Y
RemindValReminder TimeInt
6
RemindUnitRemind UnitVarChar
D) Day(s)
W) Week(s)
M) Month(s)
1
D
RemarksRemarksText
16
AtchEntryAttachment EntryInt
11OATC
Attachments
LogInstancLog InstanceInt
11
0
UserSignUser SignatureInt
6OUSR
Users
UserSign2User Signature 2Int
6OUSR
Users
UpdtDateUpdate DateDate
8
CreateDateCreate DateDate
8
CancelledCanceledVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Summary
D) Restore Wizard
P) Partner Implementation
T) Year of Transfer
1
N
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
RemindFlgReminder SentVarChar
Y) Yes
N) No
1
N
FulfilledFulfilledVarChar
Y) Fulfilled
N) Not Fulfilled
1
N
AttachmentAttachmentsText
16
SettleProbProbability that customer paysNum
20
UpdtTimeUpdate TimeInt
11
MethodAgreement MethodVarChar
I) Items Method
M) Monetary Method
1
I
GroupNumPayment Terms CodeInt
6OCTG
Payment Terms
ListNumPrice List No.Int
6OPLN
Price Lists
SignDateSigning DateDate
8
AmendedToAmendment ToInt
11
SeriesSeriesInt
6NNM1
Documents Numbering - Series
Number KEY UNIQUENumberInt
11
NUMYes
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		1250000025
HandwrttenManual NumberingVarChar
1
N
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator		' '
BpTypeBP TypeVarChar
C) Customer
S) Vendor
1
C
InstanceInstanceInt
6
0
PayMethodPayment MethodnVarChar
15OPYM
Payment Methods for Payment Wizard

Table relationship map

SELECT statement

SELECT OOAT.AbsID AS 'Agreement No.', OOAT.BpCode AS 'BP Code', OOAT.BpName AS 'BP Name', OOAT.CntctCode AS 'Contact Person Code', OOAT.StartDate AS 'Start Date', OOAT.EndDate AS 'End Date', OOAT.TermDate AS 'Termination Date', OOAT.Descript AS 'Description', OOAT.Type AS 'Agreement Type', OOAT.Status AS 'Agreement Status', OOAT.Owner AS 'Owner', OOAT.Renewal AS 'Renewal', OOAT.UseDiscnt AS 'Use BP Special Price', OOAT.RemindVal AS 'Reminder Time', OOAT.RemindUnit AS 'Remind Unit', OOAT.Remarks AS 'Remarks', OOAT.AtchEntry AS 'Attachment Entry', OOAT.LogInstanc AS 'Log Instance', OOAT.UserSign AS 'User Signature', OOAT.UserSign2 AS 'User Signature 2', OOAT.UpdtDate AS 'Update Date', OOAT.CreateDate AS 'Create Date', OOAT.Cancelled AS 'Canceled', OOAT.DataSource AS 'Data Source', OOAT.Transfered AS 'Year Transfer', OOAT.RemindFlg AS 'Reminder Sent', OOAT.Fulfilled AS 'Fulfilled', OOAT.Attachment AS 'Attachments', OOAT.SettleProb AS 'Probability that customer pays', OOAT.UpdtTime AS 'Update Time', OOAT.Method AS 'Agreement Method', OOAT.GroupNum AS 'Payment Terms Code', OOAT.ListNum AS 'Price List No.', OOAT.SignDate AS 'Signing Date', OOAT.AmendedTo AS 'Amendment To', OOAT.Series AS 'Series', OOAT.Number AS 'Number', OOAT.ObjType AS 'Object Type', OOAT.Handwrtten AS 'Manual Numbering', OOAT.PIndicator AS 'Period Indicator', OOAT.BpType AS 'BP Type', OOAT.Instance AS 'Instance', OOAT.PayMethod AS 'Payment Method' FROM OOAT AS OOAT

Related information


Blanket Agreement BlanketAgreement Object· Table: OOAT
A blanket agreement is a longer-term arrangement between a purchasing organization and a vendor, or a sales organization and a customer, for the supply of items or provision of services over a period of time based on predefined terms and...
   Parent: Blanket Agreements Service BlanketAgreementsService Service· Table: OOAT

Blanket Agreements Service BlanketAgreementsService Service· Table: OOAT
The BlanketAgreementsService service enables you to add, look up, cancel, and update blanket agreements. Source table: OOAT.

OOAT SQL Table

Attachments OATC SQL Table

Contact Persons OCPR SQL Table

Payment Terms OCTG SQL Table

Price Lists OPLN SQL Table

Object Settings - History ADP1 SQL Table

Employees OHEM SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Period Indicator OPID SQL Table

Documents Numbering - Series NNM1 SQL Table

Users OUSR SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates