| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Parent Item |
nVarChar |
50 |
OITM |
|
|
|
| TreeType |
BOM Type |
VarChar |
1 |
- |
P |
A |
Assembly |
| |
|
|
|
|
|
S |
Sales |
| |
|
|
|
|
|
P |
Production |
| |
|
|
|
|
|
T |
Template |
| PriceList |
Price List |
Int |
6 |
OPLN |
0 |
|
|
| Qauntity |
No. of Units |
Num |
19.6 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| Transfered |
Postponed to Next Year |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DataSource |
Data source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| SCNCounter |
SCN Counter |
Int |
6 |
- |
|
|
|
| DispCurr |
Display Currency |
nVarChar |
3 |
- |
|
|
|
| ToWH |
Whse for Finished Product |
nVarChar |
8 |
- |
|
|
|
| Object |
Object Type |
nVarChar |
20 |
- |
66 |
|
|
| LogInstac |
Log Instance - History |
Int |
11 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
11 |
OUSR |
|
|
|
| OcrCode |
Distribution Rule |
nVarChar |
8 |
OOCR |
|
|
|
| HideComp |
Hide Components in Printing |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OcrCode2 |
Distribution Rule2 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode3 |
Distribution Rule3 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode4 |
Distribution Rule4 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode5 |
Distribution Rule5 |
nVarChar |
8 |
OOCR |
|
|
|
| UpdateTime |
Time of Update |
Int |
11 |
- |
|
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| PlAvgSize |
Planned Average Production Size |
Num |
19.6 |
- |
1 |
|
|
| Name |
Product Description |
nVarChar |
200 |
- |
|
|
|
| CreateTS |
Create Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| Attachment |
Attachments |
Text |
16 |
- |
|
|
|