SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OOAT
Table Description: Blanket Agreement
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsID |
Agreement No. |
Int |
11 |
- |
|
|
|
| BpCode |
BP Code |
nVarChar |
15 |
OCRD |
|
|
|
| BpName |
BP Name |
nVarChar |
200 |
- |
|
|
|
| CntctCode |
Contact Person |
Int |
11 |
OCPR |
|
|
|
| StartDate |
Start Date |
Date |
8 |
- |
|
|
|
| EndDate |
End Date |
Date |
8 |
- |
|
|
|
| TermDate |
Termination Date |
Date |
8 |
- |
|
|
|
| Descript |
Description |
nVarChar |
254 |
- |
|
|
|
| Type |
Agreement Type |
VarChar |
1 |
- |
G |
G |
General |
| |
|
|
|
|
|
S |
Specific |
| Status |
Agreement Status |
VarChar |
1 |
- |
D |
A |
Approved |
| |
|
|
|
|
|
B |
To Be Approved |
| |
|
|
|
|
|
F |
On Hold |
| |
|
|
|
|
|
D |
Draft |
| |
|
|
|
|
|
T |
Terminated |
| |
|
|
|
|
|
C |
Canceled |
| |
|
|
|
|
|
X |
To Be Terminated |
| |
|
|
|
|
|
P |
To Be On Hold |
| Owner |
Owner |
Int |
11 |
OHEM |
|
|
|
| Renewal |
Renewal |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UseDiscnt |
Use BP Special Price |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RemindVal |
Reminder |
Int |
6 |
- |
|
|
|
| RemindUnit |
Reminder Unit |
VarChar |
1 |
- |
D |
D |
Day(s) |
| |
|
|
|
|
|
W |
Week(s) |
| |
|
|
|
|
|
M |
Month(s) |
| Remarks |
Remarks |
Text |
16 |
- |
|
|
|
| AtchEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| UserSign2 |
User Signature 2 |
Int |
6 |
OUSR |
|
|
|
| UpdtDate |
Update Date |
Date |
8 |
- |
|
|
|
| CreateDate |
Create Date |
Date |
8 |
- |
|
|
|
| Cancelled |
Canceled |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Upgrade |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Auto Summary |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year of Transfer |
| Transfered |
Year Transfer |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RemindFlg |
Reminder Sent |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Fulfilled |
Fulfilled |
VarChar |
1 |
- |
N |
Y |
Fulfilled |
| |
|
|
|
|
|
N |
Not Fulfilled |
| Attachment |
Attachments |
Text |
16 |
- |
|
|
|
| SettleProb |
Settlement Probability % |
Num |
19.6 |
- |
|
|
|
| UpdtTime |
Update Time |
Int |
11 |
- |
|
|
|
| Method |
Agreement Method |
VarChar |
1 |
- |
I |
I |
Items Method |
| |
|
|
|
|
|
M |
Monetary Method |
| GroupNum |
Payment Terms Code |
Int |
6 |
OCTG |
|
|
|
| ListNum |
Price List No. |
Int |
6 |
OPLN |
|
|
|
| SignDate |
Signing Date |
Date |
8 |
- |
|
|
|
| AmendedTo |
Amendment To |
Int |
11 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| Number |
Number |
Int |
11 |
- |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
1250000025 |
|
|
| Handwrtten |
Manual Numbering |
VarChar |
1 |
- |
N |
|
|
| PIndicator |
Period Indicator |
nVarChar |
10 |
OPID |
' ' |
|
|
| BpType |
BP Type |
VarChar |
1 |
- |
C |
C |
Customer |
| |
|
|
|
|
|
S |
Vendor |
| Instance |
Instance |
Int |
6 |
- |
0 |
|
|
| PayMethod |
Payment Method |
nVarChar |
15 |
OPYM |
|
|
|
| NumAtCard |
Customer/Vendor Ref. No. |
nVarChar |
200 |
- |
|
|
|
| BPCurr |
BP Currency |
nVarChar |
3 |
OCRN |
|
|
|
| FixedRate |
Exchange Rate |
Num |
19.6 |
- |
|
|
|
| TrnspCode |
Shipping Type |
Int |
6 |
OSHP |
|
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| PriceMode |
Price Mode |
VarChar |
1 |
- |
N |
N |
Net |
| |
|
|
|
|
|
G |
Gross |
| WddStatus |
Authorization Status |
VarChar |
1 |
- |
- |
- |
Without |
| |
|
|
|
|
|
W |
Pending |
| |
|
|
|
|
|
Y |
Approved |
| |
|
|
|
|
|
N |
Rejected |
| |
|
|
|
|
|
P |
Generated |
| |
|
|
|
|
|
A |
Generated by Authorizer |
| |
|
|
|
|
|
C |
Canceled |
| FromStat |
From Status |
VarChar |
1 |
- |
D |
F |
On Hold |
| |
|
|
|
|
|
D |
Draft |
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| SAPPassprt |
Extended SAP Passport |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
AbsID |
| NUM |
Yes |
Number |
| |
|
PIndicator |
| |
|
BpType |
| |
|
Instance |