Item_revisions
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| create_date |
TIMESTAMP |
|
|
|
|
|
Create date |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
| effective_date |
TIMESTAMP |
|
|
|
|
|
Effective date |
| externalid |
VARCHAR2 |
255 |
|
|
|
|
External ID |
| isinactive |
VARCHAR2 |
3 |
|
|
|
|
Is inactive |
| item_revision_id |
NUMBER |
|
39 |
0 |
|
|
Item revision ID |
| item_revision_item |
NUMBER |
|
39 |
0 |
|
|
Item revision item |
| item_revision_name |
VARCHAR2 |
100 |
|
|
|
|
Item revision name |
| memo |
VARCHAR2 |
255 |
|
|
|
|
Memo |
| obsolete_date |
TIMESTAMP |
|
|
|
|
|
Obsolete date |
Primary key
| PK Column Name |
| item_revision_id |