[Home] [Help] [Dependency Information]
Object Name: | IC_ADJS_JNL |
---|---|
Object Type: | TABLE |
Owner: | GMI |
FND Design Data: | GMI.IC_ADJS_JNL |
Subobject Name: | |
Status: | VALID |
Inventory adjustment detail table. Contains the document details for
actions performed on the Inventory Quantities form, such as inventory
adjustments, moves, status and grade changes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IC_ADJS_JNL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRANS_TYPE
TRANS_FLAG DOC_ID DOC_LINE |
IC_ADJS_JNLI1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
JOURNAL_ID
DOC_LINE |
IC_ADJS_JNLI2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DOC_ID
LINE_ID |
IC_ADJS_JNLI3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ITEM_ID
LOT_ID WHSE_CODE LOCATION |
IC_ADJS_JNL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANS_TYPE | VARCHAR2 | (4) | Yes | Transaction type, for example, CREI, ADJI. |
TRANS_FLAG | NUMBER | (10) | Yes | 0 or session_no if selected or updated. |
DOC_ID | NUMBER | (10) | Yes | Surrogate key to the adjustment document (joins to ic_tran_cmp). |
DOC_LINE | NUMBER | (10) | Yes | Line number of the adjustment. Moves and grade and status changes create two rows with different values for doc_line, but the same value for line_id. |
JOURNAL_ID | NUMBER | (10) | Yes | Surrogate key to the journal (joins to ic_jrnl_mst). |
COMPLETED_IND | NUMBER | (5) | Yes | 0=Pending; 1=Updated to inventory. |
WHSE_CODE | VARCHAR2 | (4) | The warehouse in which the adjustment took place. | |
REASON_CODE | VARCHAR2 | (4) | Yes | Reason code for the adjusment. |
DOC_DATE | DATE | Yes | Date of the adjustment. | |
ITEM_ID | NUMBER | (10) | Yes | Surrogate key for the item adjusted. |
ITEM_UM | VARCHAR2 | (4) | Yes | Primary unit of measure of item. |
ITEM_UM2 | VARCHAR2 | (4) | Secondary unit of measure of item, for dual UOM items. | |
LOT_ID | NUMBER | (10) | Surrogate key to the lot that was adjusted. | |
LOCATION | VARCHAR2 | (16) | Location in which the adjustment took place. | |
QTY | NUMBER | Quantity of the adjustment in the item_um. | ||
QTY2 | NUMBER | Quantity of the adjustment in the item_um2. | ||
QC_GRADE | VARCHAR2 | (4) | The grade of the lot. | |
LOT_STATUS | VARCHAR2 | (4) | The status of the lot. | |
LINE_TYPE | NUMBER | (5) | Yes | Line type. 0=Adjustment, -1=From line (for moves and grade and status changes), 1=To line (for moves and grade and status changes). |
LINE_ID | NUMBER | (10) | Yes | Surrogate key for the adjustment "line". The two lines created by moves, and grade and status changes share the same line_id, but have different values for doc_line. |
CO_CODE | VARCHAR2 | (4) | The company of which the adjustment organization is a part. | |
ORGN_CODE | VARCHAR2 | (4) | Yes | The organization for which the adjustment is made. |
NO_INV | NUMBER | (5) | Yes | Not currently used. |
NO_TRANS | NUMBER | (5) | Not currently used. | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | 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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ACCTG_UNIT_ID | NUMBER | Accounting unit ID | ||
ACCT_ID | NUMBER | Account ID | ||
TEXT_CODE | NUMBER | (10) | Stores text code for text attached to record. |
Cut, paste (and edit) the following text to query this object:
SELECT TRANS_TYPE
, TRANS_FLAG
, DOC_ID
, DOC_LINE
, JOURNAL_ID
, COMPLETED_IND
, WHSE_CODE
, REASON_CODE
, DOC_DATE
, ITEM_ID
, ITEM_UM
, ITEM_UM2
, LOT_ID
, LOCATION
, QTY
, QTY2
, QC_GRADE
, LOT_STATUS
, LINE_TYPE
, LINE_ID
, CO_CODE
, ORGN_CODE
, NO_INV
, NO_TRANS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, TRANS_CNT
, LAST_UPDATED_BY
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LAST_UPDATE_LOGIN
, ACCTG_UNIT_ID
, ACCT_ID
, TEXT_CODE
FROM GMI.IC_ADJS_JNL;
GMI.IC_ADJS_JNL does not reference any database object
GMI.IC_ADJS_JNL is referenced by following:
|
|
|