[Home] [Help] [Dependency Information]
Object Name: | OP_GNRC_ITM |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.OP_GNRC_ITM |
Subobject Name: | |
Status: | VALID |
This table maintains alternate names for items. These alternate names are used only in OPM Order Fulfillment. An alternate name may be a generic name, used by many customers in a specific industry. In this case, the alternate (generic) name is cross-referenced to an OPM item, and the CUST_ID on the record is null. An alternate name may be customer-specific and in that case, the CUST_ID for the customer item will not be null and will equal the id for the customer to whom the alternate name belongs. Generic/customer names may be entered instead of item numbers on an order and the OPM item number is then referenced.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OP_GNRC_ITM_PK | NORMAL | UNIQUE | APPS_TS_SEED | GENERIC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GENERIC_ID | NUMBER | (10) | Yes | Surrogate key to table |
GENERIC_ITEM | VARCHAR2 | (32) | Yes | The generic or customer item number. This is the number that the customer uses or is generally used throughout the industry (generic item). This number can be entered in order entry in place of an item number. |
GENERIC_DESC | VARCHAR2 | (70) | Yes | Description associated with the generic/customer item. |
USE_ONORDER | NUMBER | (5) | Yes | Indicates if the generic_desc should be used in place of the item description. Value of 0 means that even if the generic/customer/vendor item is entered, the description from ic_item_mst defaults as the item description. A value of 1 mea |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
CUST_ID | NUMBER | (15) | Customer who uses this item reference. If cust_id is NULL then the generic item is generic. If cust_id is not null, then the generic item is a customer item. Fk to op_cust_ms | |
VENDOR_ID | NUMBER | (10) | Column used in previous versions of software; not currently supported. | |
ITEM_ID | NUMBER | (10) | Yes | Item that this generic or customer item references. Fk to ic_item_mst. |
OPM_CUST_ID | NUMBER | (10) | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. | |
CO_CODE | VARCHAR2 | (4) | Company Code |
Cut, paste (and edit) the following text to query this object:
SELECT GENERIC_ID
, GENERIC_ITEM
, GENERIC_DESC
, USE_ONORDER
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRANS_CNT
, DELETE_MARK
, TEXT_CODE
, CUST_ID
, VENDOR_ID
, ITEM_ID
, OPM_CUST_ID
, CO_CODE
FROM GML.OP_GNRC_ITM;
GML.OP_GNRC_ITM does not reference any database object
GML.OP_GNRC_ITM is referenced by following:
|
|
|