| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | Code | Parent Item | nvarchar | 50 | 0 | OITM | | | Allow NULL? |
| 2 | TreeType | BOM Type | char | 1 | 0 | | P | A=Assembly, P=Production, S=Sales, T=Template | Allow NULL? |
| 3 | PriceList | Price List | int | 6 | 0 | OPLN | 0 | | Allow NULL? |
| 4 | Qauntity | No. of Units | num | 19 | 6 | | | | Allow NULL? |
| 5 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 6 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 7 | Transfered | Postponed to Next Year | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 8 | DataSource | Data source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 9 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 10 | SCNCounter | SCN Counter | int | 6 | 0 | | | | Allow NULL? |
| 11 | DispCurr | Display Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | ToWH | Whse for Finished Product | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | Object | Object Type | nvarchar | 20 | 0 | | 66 | | Allow NULL? |
| 14 | LogInstac | Log Instance - History | int | 11 | 0 | | | | Allow NULL? |
| 15 | UserSign2 | Updating User | int | 11 | 0 | OUSR | | | Allow NULL? |
| 16 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 17 | HideComp | Hide Components in Printing | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 18 | OcrCode2 | Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 19 | OcrCode3 | Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 20 | OcrCode4 | Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 21 | OcrCode5 | Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 22 | UpdateTime | Time of Update | int | 11 | 0 | | | | Allow NULL? |
| 23 | Project | Project Code | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 24 | PlAvgSize | Planned Average Production Size | num | 19 | 6 | | 1 | | Allow NULL? |
| 25 | Name | Product Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 26 | CreateTS | Create Time - Incl. Secs | int | 11 | 0 | | | | Allow NULL? |
| 27 | UpdateTS | Update Full Time | int | 11 | 0 | | | | Allow NULL? |
