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 |
|---|---|---|
|
OBJECT_PRIMARY_KEY |
NUMBER |
INT |
|
OBJECT_ENTITY_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
CATEGORY_PRIMARY_KEY |
NUMBER |
INT |
|
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_DISPLAY_ORDER |
NUMBER) |
INT |
|
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
|
CATEGORY_IS_ACTIVE |
NUMBER |
INT |
|
CATEGORY_FULL_NAME |
VARCHAR2(1000) |
VARCHAR(1000) |
|
CATEGORY_LEVEL_01 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_02 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_03 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_04 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_05 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_06 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_07 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_08 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_09 |
VARCHAR2(50) |
VARCHAR(50) |
|
CATEGORY_LEVEL_10 |
VARCHAR2(50) |
VARCHAR(50) |
WH_CURRENCIES
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
CURRENCY_CODE |
VARCHAR2(3) |
VARCHAR(3) |
|
CURRENCY_EXCHANGE_RATE |
NUMBER |
INT |
|
CURRENCY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CURRENCY_SYMBOL |
VARCHAR2(2) |
VARCHAR(2) |
|
LAST_MODIFIED_ON |
DATE |
DATETIME |
WH_LOOKUP_TABLE_ITEMS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
TABLE_PRIMARY_KEY |
NUMBER |
INT |
|
TABLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
TABLE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
TABLE_VERSION |
NUMBER |
INT |
|
ITEM_PRIMARY_KEY |
NUMBER |
INT |
|
ITEM_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_DISPLAY_ORDER |
NUMBER |
INT |
|
ITEM_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
|
ITEM_IS_ACTIVE |
VARCHAR2(10) |
VARCHAR(10) |
|
ITEM_PARENT_PRIMARY_KEY |
NUMBER |
INT |
|
ITEM_NAME_FULL |
VARCHAR2(700) |
VARCHAR(700) |
|
ITEM_LEVEL_01 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_02 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_03 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_04 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_05 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_06 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_07 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_08 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_09 |
VARCHAR2(50) |
VARCHAR(50) |
|
ITEM_LEVEL_10 |
VARCHAR2(50) |
VARCHAR(50) |