|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Blanket Agreement - Details
Table Name: OAT2
Table Description: Blanket Agreement - Details
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AgrNo | Agreement No. | Int | 11 | OOAT | Â | Â | Â |
| AgrLnNum | Agreement Item Row Number | Int | 11 | - | Â | Â | Â |
| AgrEfctNum | Agreement Effective Row No. | Int | 11 | - | Â | Â | Â |
| DatePeriod | Frequency | VarChar | 1 | - | M | D | Daily |
| Â | Â | Â | Â | Â | Â | W | Weekly |
| Â | Â | Â | Â | Â | Â | M | Monthly |
| Â | Â | Â | Â | Â | Â | Q | Quarterly |
| Â | Â | Â | Â | Â | Â | S | Semi-Annually |
| Â | Â | Â | Â | Â | Â | A | Annually |
| Â | Â | Â | Â | Â | Â | O | One Time |
| FromDate | From Date | Date | 8 | - | Â | Â | Â |
| ToDate | To Date | Date | 8 | - | Â | Â | Â |
| CallUp | Release Information | nVarChar | 100 | - | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | -1 | Â | Â |
| Quantity | Item Quantity | Num | 19.6 | - | Â | Â | Â |
| ConsumeFCT | Consumer Sales Forecast | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FreeTxt | Free Text | nVarChar | 100 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| AmountLC | Planned Amount (LC) | Num | 19.6 | - | Â | Â | Â |
| AmountFC | Planned Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AgrNo |
| Â | Â | AgrLnNum |
| Â | Â | AgrEfctNum |