|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bill of Materials - Components
Table Name: ITT1
Table Description: Bill of Materials - Components
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Father | Parent Item | nVarChar | 50 | OITT | Â | Â | Â |
| ChildNum | Component Element Number | Int | 11 | - | Â | Â | Â |
| VisOrder | Visual Order | Int | 11 | - | Â | Â | Â |
| Code | Component Code | nVarChar | 50 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| Warehouse | Warehouse | nVarChar | 8 | OWHS | Â | Â | Â |
| Price | Price | Num | 19.6 | - | Â | Â | Â |
| Currency | Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| PriceList | Price List | Int | 6 | OPLN | 0 | Â | Â |
| OrigPrice | Original Price | Num | 19.6 | - | Â | Â | Â |
| OrigCurr | Original Currency | nVarChar | 3 | - | Â | Â | Â |
| IssueMthd | Issue Method | VarChar | 1 | - | Â | B | Backflush |
| Â | Â | Â | Â | Â | Â | M | Manual |
| Uom | Inventory UoM | nVarChar | 100 | - | Â | Â | Â |
| Comment | Comment | nVarChar | 254 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | Â | Â | Â |
| Object | Object | nVarChar | 20 | - | 66 | Â | Â |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR | Â | Â | Â |
| PrncpInput | Principal Input | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| Type | Component Type | Int | 11 | - | 4 | 4 | Item |
| Â | Â | Â | Â | Â | Â | 290 | Resource |
| Â | Â | Â | Â | Â | Â | -18 | Text |
| WipActCode | WIP Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| AddQuantit | Additional Quantity | Num | 19.6 | - | Â | Â | Â |
| LineText | Row Text | Text | 16 | - | Â | Â | Â |
| StageId | Stage ID | Int | 11 | - | Â | Â | Â |
| ItemName | Item Description | nVarChar | 200 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Father |
| Â | Â | ChildNum |
| VISORDER | Yes | Father |
| Â | Â | VisOrder |
| FATHER | No | Father |
| CHILD | No | Code |
| PRICE_LIST | No | PriceList |