DIC_TRAY_TYPE
Dictionary which lists tray types (cardboard or wooden box etc.) in the NDGC tray store.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(8) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(250) |
|
| 3 |
TRANSLATION |
Varchar(50) |
|
| 4 |
STATUS |
Char(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 7 of 7)
| CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| drawer |
cabinet drawer |
tray store |
I |
31-AUG-04 |
|
| redfib |
red fibre board |
tray store |
I |
31-AUG-04 |
|
| wooden |
wooden |
tray store |
I |
31-AUG-04 |
|
| plastic |
plastic tray |
tray store |
I |
01-SEP-04 |
|
| cardbrd |
cardboard box |
tray store |
I |
01-SEP-04 |
|
| ! |
information not available |
can't find what type it is |
I |
01-SEP-04 |
|
| ? |
Not entered |
Not databased yet |
I |
01-SEP-04 |
|
