[Home] [Help] [Dependency Information]
Object Name: | IC_TRAN_CMP |
---|---|
Object Type: | TABLE |
Owner: | GMI |
FND Design Data: | GMI.IC_TRAN_CMP |
Subobject Name: | |
Status: | VALID |
Completed inventory transactions. Transactions created on the
Inventory Quantities form and through Physical Inventory are stored
here. Also, completed transactions associated with closed documents
can be purged from ic_tran_pnd into this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IC_TRAN_CMP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANS_ID |
IC_TRAN_CMPI1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ITEM_ID
LOT_ID WHSE_CODE LOCATION |
IC_TRAN_CMPI2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DOC_TYPE
DOC_ID LINE_ID |
IC_TRAN_CMPI3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANS_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANS_ID | NUMBER | (10) | Yes | Unique key for the transaction. |
ITEM_ID | NUMBER | (10) | Yes | Surrogate key for the item. |
LINE_ID | NUMBER | (10) | Yes | Surrogate key for the document line that produced the transaction. |
CO_CODE | VARCHAR2 | (4) | Yes | Company affected by the transaction (company which owns the organization which created the transaction). |
ORGN_CODE | VARCHAR2 | (4) | Yes | Organization which created the transaction. |
WHSE_CODE | VARCHAR2 | (4) | Warehouse affected by the transaction. | |
LOT_ID | NUMBER | (10) | Yes | Surrogate key of the lot. |
LOCATION | VARCHAR2 | (16) | Location affected by the transaction. | |
DOC_ID | NUMBER | (10) | Yes | Surrogate key of the document that created the transaction. |
DOC_TYPE | VARCHAR2 | (4) | Yes | Type of document which created the transaction. |
DOC_LINE | NUMBER | (10) | Yes | Not currently used. |
LINE_TYPE | NUMBER | (5) | Yes | Line type. |
REASON_CODE | VARCHAR2 | (4) | Reason code associated with the transaction. | |
CREATION_DATE | DATE | Yes | Standard who column | |
TRANS_DATE | DATE | Yes | Transaction date. | |
TRANS_QTY | NUMBER | Quantity of the transaction in the primary UOM of an item. | ||
TRANS_QTY2 | NUMBER | Quantity of the transaction in the secodary UOM of an item, if dual UOM controlled. | ||
QC_GRADE | VARCHAR2 | (4) | Grade associated with the transaction. | |
LOT_STATUS | VARCHAR2 | (4) | Lot status associated with the transaction. | |
TRANS_STAT | VARCHAR2 | (4) | Not currently used. | |
TRANS_UM | VARCHAR2 | (4) | UOM in which trans_qty is expressed. | |
TRANS_UM2 | VARCHAR2 | (4) | UOM in which trans_qty2 is expressed. | |
OP_CODE | NUMBER | (15) | Yes | Operator who created the transaction. |
GL_POSTED_IND | NUMBER | (10) | Yes | GL posted indicator. 0=Not posted to GL, 1=Posted to GL. |
EVENT_ID | NUMBER | (10) | Yes | Event ID. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
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 | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
REQUEST_ID | NUMBER | (15) | Concurrent who column | |
MOVEMENT_ID | NUMBER | Movement ID | ||
MVT_STAT_STATUS | VARCHAR2 | (30) | Movement statistics status | |
LINE_DETAIL_ID | NUMBER | Reference to wsh_delivery_details for OMSO doc type | ||
INVOICED_FLAG | VARCHAR2 | (1) | Intercompany Invoice Indicator.This column will be marked as Y once inventory transaction is processed to create inter company AR invoice. | |
STAGED_IND | NUMBER | (5) | Staged Indicator | |
INTORDER_POSTED_IND | NUMBER | (5) | Internal Order Intransit GL Posted Indicator. 0 = Not Processed; 1 = Posted; 2 = No Intransit | |
LOT_COSTED_IND | NUMBER | (5) | Identifies if transaction was processed by Lot Actual Cost. 0 = Not Processed; Null = Processed |
Cut, paste (and edit) the following text to query this object:
SELECT TRANS_ID
, ITEM_ID
, LINE_ID
, CO_CODE
, ORGN_CODE
, WHSE_CODE
, LOT_ID
, LOCATION
, DOC_ID
, DOC_TYPE
, DOC_LINE
, LINE_TYPE
, REASON_CODE
, CREATION_DATE
, TRANS_DATE
, TRANS_QTY
, TRANS_QTY2
, QC_GRADE
, LOT_STATUS
, TRANS_STAT
, TRANS_UM
, TRANS_UM2
, OP_CODE
, GL_POSTED_IND
, EVENT_ID
, TEXT_CODE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, MOVEMENT_ID
, MVT_STAT_STATUS
, LINE_DETAIL_ID
, INVOICED_FLAG
, STAGED_IND
, INTORDER_POSTED_IND
, LOT_COSTED_IND
FROM GMI.IC_TRAN_CMP;
GMI.IC_TRAN_CMP does not reference any database object
GMI.IC_TRAN_CMP is referenced by following:
|
|
|