[Home] [Help] [Dependency Information]
Object Name: | IC_TRAN_ARC |
---|---|
Object Type: | TABLE |
Owner: | GMI |
FND Design Data: | GMI.IC_TRAN_ARC |
Subobject Name: | |
Status: | VALID |
Inventory transaction archive table. Stores rows from ic_tran_cmp
after purge.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IC_TRAN_ARC_PK | NORMAL | UNIQUE | APPS_TS_ARCHIVE | TRANS_ID |
IC_TRAN_ARCI0 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
DOC_TYPE
DOC_ID |
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 | Yes | 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) | Yes | UOM in which trans_qty is expressed. |
TRANS_UM2 | VARCHAR2 | (4) | UOM in which trans_qty2 is expressed. | |
ARCHIVE_DATE | DATE | Yes | Date the transaction was archived. | |
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 |
PURGE_ID | NUMBER | (10) | Yes | Purge ID. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
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
, ARCHIVE_DATE
, OP_CODE
, GL_POSTED_IND
, EVENT_ID
, TEXT_CODE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, PURGE_ID
, LAST_UPDATE_LOGIN
, LINE_DETAIL_ID
, INVOICED_FLAG
, STAGED_IND
, INTORDER_POSTED_IND
, LOT_COSTED_IND
FROM GMI.IC_TRAN_ARC;
GMI.IC_TRAN_ARC does not reference any database object
GMI.IC_TRAN_ARC is referenced by following:
|
|
|