Categories, Currencies, and Lookup Tables
Many of the standard object definitions have a category table associated with them - for example, WH_CONTACT_CATEGORIES. These tables are documented together with the other tables related to the object definition.
Similarly, the design categories that are applicable to a specific custom object definition are found in table WH_PROJECT_CATEGORIES, documented with the other Project tables.
The category values that are actually assigned to specific records are found in table WH_CATEGEORIES, shown below. That table "flattens" the category tree structure by providing a single row containing up to 10 levels of nesting for a given category.
WH_CATEGORIES
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
OBJECT_PRIMARY_KEY |
NUMBER |
INT |
Object Primary Key |
|
OBJECT_ENTITY_CODE |
NVARCHAR2(10 CHAR) |
VARCHAR(4) |
Object Entity Code |
|
OBJECT_IS_EMBEDDED |
NVARCHAR2(5 CHAR) |
VARCHAR(5) |
Object Is Embedded |
|
OBJECT_UNIQUE_CODE |
NVARCHAR2(10 CHAR) |
VARCHAR(4) |
Object Unique Code |
|
OBJECT_TITLE |
NVARCHAR2(250 CHAR) |
VARCHAR(250) |
Object Title |
|
CATEGORY_PRIMARY_KEY |
NUMBER |
INT |
Category Primary Key |
|
CATEGORY_NAME |
VARCHAR2(4000 CHAR) |
VARCHAR(50) |
Category Name |
|
CATEGORY_DISPLAY_ORDER |
NUMBER) |
INT |
Category Display Order |
|
CATEGORY_TREE_POSITION |
NVARCHAR2(250 CHAR) |
VARCHAR(250) |
Category Tree Position |
|
CATEGORY_IS_ACTIVE |
NUMBER |
INT |
Category Is Active |
|
CATEGORY_FULL_NAME |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Full Name |
|
CATEGORY_LEVEL_01 |
VARCHAR2(4000) | VARCHAR(4000) |
Category Level 01 |
|
CATEGORY_LEVEL_02 |
VARCHAR2(4000) | VARCHAR(4000) |
Category Level 02 |
|
CATEGORY_LEVEL_03 |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Level 03 |
|
CATEGORY_LEVEL_04 |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Level 04 |
|
CATEGORY_LEVEL_05 |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Level 05 |
|
CATEGORY_LEVEL_06 |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Level 06 |
|
CATEGORY_LEVEL_07 |
VARCHAR2(4000) |
VARCHAR(50) |
Category Level 07 |
|
CATEGORY_LEVEL_08 |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Level 08 |
|
CATEGORY_LEVEL_09 |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Level 09 |
|
CATEGORY_LEVEL_10 |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Level 10 |
| LOCALE | VARCHAR2(5) | VARCHAR(5) | Locale |
| OVERALL_DISPLAY_ORDER | NUMBER | INT | Overall Display Order |
| CATEGORY_PARENT_PK | NUMBER | INT | Category Parent Primary Key |
WH_CATEGORIES_TEMP
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
OBJECT_PRIMARY_KEY |
NUMBER |
INT |
Object Primary Key |
|
OBJECT_ENTITY_CODE |
VARCHAR2(10) |
VARCHAR(10) |
Object Entity Code |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(10) |
VARCHAR(10) |
Object Unique Code |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Object Title |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
Object Is Embedded |
|
CATEGORY_PRIMARY_KEY |
NUMBER |
INT |
Category Primary Key |
|
CATEGORY_DISPLAY_ORDER |
NUMBER |
INT |
Category Display Order |
|
CATEGORY_NAME |
VARCHAR2(4000) |
VARCHAR(4000) |
Category Name |
|
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Category Tree Position |
|
CATEGORY_IS_ACTIVE |
NUMBER |
INT |
Category Is Active |
|
LOCALE |
NVARCHAR2(5) |
VARCHAR(5) |
Locale |
|
CATEGORY_PK_C |
VARCHAR2(20) |
VARCHAR(20) |
Category Primary Key |
|
CATEGORY_PARENT_PK_C |
VARCHAR2(20) |
VARCHAR(20) |
Category Parent Primaey Key |
WH_CURRENCIES
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
CURRENCY_CODE |
NVARCHAR2(3 CHAR) |
VARCHAR(3) |
Currency Code |
|
CURRENCY_EXCHANGE_RATE |
NUMBER |
INT |
Currency Exchange Rate |
|
CURRENCY_NAME |
NVARCHAR2(50 CHAR) |
VARCHAR(50) |
Currency Name |
|
CURRENCY_SYMBOL |
NVARCHAR2(3 CHAR) |
VARCHAR(2) |
Currency Symbol |
|
LAST_MODIFIED_ON |
DATE |
DATETIME |
Last Modified On |
| LOCALE | VARCHAR2(5) | VARCHAR(5) | Locale |
WH_LOOKUP_TABLE_ITEMS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
TABLE_PRIMARY_KEY |
NUMBER |
INT |
Table Primary Key |
|
TABLE_NAME |
NVARCHAR2(50 CHAR) |
VARCHAR(50) |
Table Name |
|
TABLE_UNIQUE_CODE |
NVARCHAR2(4 CHAR) |
VARCHAR(4) |
Table Unique Code |
|
TABLE_VERSION |
NUMBER |
INT |
Table Version |
|
ITEM_PRIMARY_KEY |
NUMBER |
INT |
Item Primary Key |
|
ITEM_NAME |
VARCHAR2(4000 CHAR) |
VARCHAR(50) |
Item Name |
|
ITEM_DISPLAY_ORDER |
NUMBER |
INT |
Item Display Order |
|
ITEM_TREE_POSITION |
NVARCHAR2(250 CHAR) |
VARCHAR(250) |
Item Tree Position |
|
ITEM_IS_ACTIVE |
NVARCHAR2(10 CHAR) |
VARCHAR(10) |
Item Is Active |
|
ITEM_PARENT_PRIMARY_KEY |
NUMBER |
INT |
Item Parent Primary Key |
|
ITEM_NAME_FULL |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Name Full |
|
ITEM_LEVEL_01 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 01 |
|
ITEM_LEVEL_02 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 02 |
|
ITEM_LEVEL_03 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 03 |
|
ITEM_LEVEL_04 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 04 |
|
ITEM_LEVEL_05 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 05 |
|
ITEM_LEVEL_06 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 06 |
|
ITEM_LEVEL_07 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 07 |
|
ITEM_LEVEL_08 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 08 |
|
ITEM_LEVEL_09 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 09 |
|
ITEM_LEVEL_10 |
VARCHAR2(4000) |
VARCHAR(4000) |
Item Level 10 |
| LOCALE | VARCHAR2(5) | VARCHAR(5) | Locale |
| OVERALL_DISPLAY_ORDER | VARCHAR2(250) | VARCHAR(250) | Overall Display Order |
WH_LOOKUP_TABLE_ITEMS_TEMP
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
ITEM_PRIMARY_KEY |
NUMBER |
INT |
Item Primary Key |
|
LOCALE |
VARCHAR2(5) |
VARCHAR(5) |
Locale |
|
TABLE_PRIMARY_KEY |
NUMBER |
INT |
Table Primary Key |
|
TABLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Table Name |
|
TABLE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Table Unique Code |
|
TABLE_VERSION |
NUMBER |
INT |
Table Version |
|
ITEM_DISPLAY_ORDER |
NUMBER |
INT |
Item Display Order |
|
ITEM_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Item Tree Position |
|
ITEM_IS_ACTIVE |
VARCHAR2(10) |
VARCHAR(10) |
Item Is Active |
|
ITEM_PARENT_PRIMARY_KEY |
NUMBER |
INT |
Item Parent Primary Key |
|
ITEM_NAME |
VARCHAR2(4000) |
VARCHAR2(4000) |
Item Name |
|
ITEM_PK_C |
VARCHAR2(20) |
VARCHAR2(20) |
Item Primary Key |
|
ITEM_PARENT_PK_C |
VARCHAR2(20) |
VARCHAR2(20) |
Item Parent Primary Key |