| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ResCode |
Internal Code |
nVarChar |
50 |
- |
|
|
|
| VisResCode |
Resource No. |
nVarChar |
50 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| Number |
Number |
Int |
11 |
- |
|
|
|
| CodeBars |
Bar Code |
nVarChar |
254 |
- |
|
|
|
| ResName |
Resource Description |
nVarChar |
200 |
- |
|
|
|
| FrgnName |
Description in Foreign Lang. |
nVarChar |
200 |
- |
|
|
|
| ResType |
Resource Type |
VarChar |
1 |
- |
M |
M |
Machine |
| |
|
|
|
|
|
L |
Labor |
| |
|
|
|
|
|
O |
Other |
| ResGrpCod |
Resource Group |
Int |
6 |
ORSB |
1 |
|
|
| UnitOfMsr |
Unit of Measure |
nVarChar |
100 |
- |
|
|
|
| PrchseRes |
Purchase Resource [Yes/No] |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SellRes |
Sales Resource [Yes/No] |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ProdRes |
Production Resource [Yes/No] |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CardCode |
Preferred Vendor |
nVarChar |
15 |
OCRD |
|
|
|
| NoDiscount |
No Discounts |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IssueMthd |
Issue Method |
VarChar |
1 |
- |
B |
B |
Backflush |
| |
|
|
|
|
|
M |
Manual |
| StdCost1 |
Resource Cost 1 |
Num |
19.6 |
- |
|
|
|
| StdCost2 |
Resource Cost 2 |
Num |
19.6 |
- |
|
|
|
| StdCost3 |
Resource Cost 3 |
Num |
19.6 |
- |
|
|
|
| StdCost4 |
Resource Cost 4 |
Num |
19.6 |
- |
|
|
|
| StdCost5 |
Resource Cost 5 |
Num |
19.6 |
- |
|
|
|
| StdCost6 |
Resource Cost 6 |
Num |
19.6 |
- |
|
|
|
| StdCost7 |
Resource Cost 7 |
Num |
19.6 |
- |
|
|
|
| StdCost8 |
Resource Cost 8 |
Num |
19.6 |
- |
|
|
|
| StdCost9 |
Resource Cost 9 |
Num |
19.6 |
- |
|
|
|
| StdCost10 |
Resource Cost 10 |
Num |
19.6 |
- |
|
|
|
| validFor |
Active |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| validFrom |
Active From |
Date |
8 |
- |
|
|
|
| validTo |
Active To |
Date |
8 |
- |
|
|
|
| frozenFor |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| frozenFrom |
Inactive From |
Date |
8 |
- |
|
|
|
| frozenTo |
Inactive To |
Date |
8 |
- |
|
|
|
| DfltWH |
Default Warehouse |
nVarChar |
8 |
- |
|
|
|
| QueryGroup |
Properties |
Int |
11 |
- |
0 |
|
|
| PicturName |
Picture |
nVarChar |
200 |
- |
|
|
|
| UserText |
Item Remarks |
Text |
16 |
- |
|
|
|
| QryGroup1 |
Property 1 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup2 |
Property 2 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup3 |
Property 3 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup4 |
Property 4 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup5 |
Property 5 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup6 |
Property 6 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup7 |
Property 7 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup8 |
Property 8 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup9 |
Property 9 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup10 |
Property 10 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup11 |
Property 11 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup12 |
Property 12 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup13 |
Property 13 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup14 |
Property 14 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup15 |
Property 15 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup16 |
Property 16 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup17 |
Property 17 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup18 |
Property 18 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup19 |
Property 19 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup20 |
Property 20 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup21 |
Property 21 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup22 |
Property 22 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup23 |
Property 23 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup24 |
Property 24 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup25 |
Property 25 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup26 |
Property 26 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup27 |
Property 27 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup28 |
Property 28 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup29 |
Property 29 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup30 |
Property 30 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup31 |
Property 31 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup32 |
Property 32 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup33 |
Property 33 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup34 |
Property 34 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup35 |
Property 35 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup36 |
Property 36 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup37 |
Property 37 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup38 |
Property 38 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup39 |
Property 39 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup40 |
Property 40 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup41 |
Property 41 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup42 |
Property 42 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup43 |
Property 43 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup44 |
Property 44 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup45 |
Property 45 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup46 |
Property 46 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup47 |
Property 47 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup48 |
Property 48 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup49 |
Property 49 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup50 |
Property 50 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup51 |
Property 51 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup52 |
Property 52 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup53 |
Property 53 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup54 |
Property 54 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup55 |
Property 55 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup56 |
Property 56 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup57 |
Property 57 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup58 |
Property 58 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup59 |
Property 59 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup60 |
Property 60 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup61 |
Property 61 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup62 |
Property 62 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup63 |
Property 63 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup64 |
Property 64 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CreateDate |
Date of Creation |
Date |
8 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| 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 |
| ValidComm |
Active Remarks |
nVarChar |
30 |
- |
|
|
|
| FrozenComm |
Inactive Remarks |
nVarChar |
30 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
- |
290 |
|
|
| Deleted |
Deleted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UserSign2 |
Updating User |
Int |
6 |
- |
|
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| LastPurPrc |
Last Purchase Price |
Num |
19.6 |
- |
|
|
|
| LastPurCur |
Last Purchase Currency |
nVarChar |
3 |
- |
|
|
|
| LastPurDat |
Last Purchase Date |
Date |
8 |
- |
|
|
|
| LstEvlPric |
Last Evaluated Price |
Num |
19.6 |
- |
|
|
|
| LstEvlDate |
Date of Last Reval. Price |
Date |
8 |
- |
|
|
|
| NumResUnit |
No. of Resource Units |
Int |
11 |
- |
1 |
|
|
| TimeResUn |
Time per Resource Units |
Int |
11 |
- |
|
|
|
| ResAlloc |
Resource Allocation |
VarChar |
1 |
- |
S |
S |
On Start Date |
| |
|
|
|
|
|
D |
On End Date |
| |
|
|
|
|
|
F |
Start Date Forwards |
| |
|
|
|
|
|
B |
End Date Backwards |
| LinkItm |
Linked Item |
nVarChar |
50 |
OITM |
|
|
|
| RelCap1 |
Relevant to single run capacity 1 |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RelCap2 |
Relevant to single run capacity 2 |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RelCap3 |
Relevant to single run capacity 3 |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RelCap4 |
Relevant to single run capacity 4 |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|