|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Item Count Alert
Table Name: ITW1
Table Description: Item Count Alert
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| CycleCode | Cycle Code | Int | 6 | OCYC | Â | Â | Â |
| Alert | Alert | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| NextDate | Next Counting Date | Date | 8 | - | Â | Â | Â |
| Time | Alert Time | Int | 6 | - | Â | Â | Â |
| DestUser | Destination User | Int | 6 | OUSR | Â | Â | Â |
| Alerted | Alerted | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BinAbs | Bin Internal Number | Int | 11 | OBIN | -1 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ItemCode |
| Â | Â | WhsCode |
| Â | Â | BinAbs |