SAP Business One SDK 10.0 - Database Tables Reference
-
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 |