| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | Code | Parent Item | nvarchar | 20 | 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 | UseFthrWhs | Issue from Parent Warehouse | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 6 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 7 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 8 | Transfered | Postponed to Next Year | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 9 | 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? |
| 10 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 11 | SCNCounter | SCN Counter | int | 6 | 0 | | | | Allow NULL? |
| 12 | DispCurr | Display Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | ToWH | Whse for Finished Product | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | Object | Object Type | nvarchar | 20 | 0 | | 66 | | Allow NULL? |
| 15 | LogInstac | Log Instance - History | int | 11 | 0 | | | | Allow NULL? |
| 16 | UserSign2 | Updating User | int | 11 | 0 | OUSR | | | Allow NULL? |
| 17 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 18 | HideComp | Hide Components in Printing | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 19 | OcrCode2 | Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 20 | OcrCode3 | Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 21 | OcrCode4 | Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 22 | OcrCode5 | Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 23 | UpdateTime | Time of Update | int | 11 | 0 | | | | Allow NULL? |
| 24 | Project | Project Code | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |