INV_TXN_CONTEXT_GT
This is a global temp table that is used to store the context of the demand during execution of the rules engine.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LINE_ID | NUMBER | Yes | Unique ID of context line | ||
| TXN_SOURCE_ID | NUMBER | Unique ID representing source demand record. | |||
| TXN_SOURCE_LINE_ID | NUMBER | Unique ID representing source demand line record. | |||
| TXN_SOURCE_NAME | VARCHAR2 | 30 | Name associated with source deman. | ||
| TXN_SOURCE_LINE_DETAIL | NUMBER | Unique ID representing source line detail. | |||
| FREIGHT_CARRIER_CODE | VARCHAR2 | 30 | Code representing freight carrier. | ||
| CUSTOMER_ID | NUMBER | Unique ID of customer. | |||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | ||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | ||
| ITEM_GRADE_CODE | VARCHAR2 | 150 | This indicates the material grade for the item. | ||
| ITEM_EXPIRATION_DATE | DATE | This is the date of expiration for the item. | |||
| INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality. | ||
| INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality. | ||
| INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information. | ||
| INV_USER_DEF_ATTRIBUTE_NUMBER1 | NUMBER | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_NUMBER2 | NUMBER | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_NUMBER3 | NUMBER | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_NUMBER4 | NUMBER | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_NUMBER5 | NUMBER | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_DATE1 | DATE | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_DATE2 | DATE | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_DATE3 | DATE | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_DATE4 | DATE | Reserved for user-definable Inventory striping information. | |||
| INV_USER_DEF_ATTRIBUTE_DATE5 | DATE | Reserved for user-definable Inventory striping information. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| INV_TXN_CONTEXT_GT_U1 | Unique | LINE_ID |