[Home] [Help] [Dependency Information]
Object Name: | GL_SUBR_TST_VAR |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.GL_SUBR_TST_VAR |
Subobject Name: | |
Status: | VALID |
Table for storing all types of batch close variances calculated during test subledger run.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_SUBR_TST_VAR_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SUBLEDGER_VARIANCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUBLEDGER_VARIANCE_ID | NUMBER | (15) | Yes | Surrogate for Subleder Variance |
REFERENCE_NO | NUMBER | (15) | Yes | Reference Number for Sub-ledger run |
CO_CODE | VARCHAR2 | (4) | Yes | Copmany Code |
FISCAL_YEAR | NUMBER | (5) | Yes | Fiscal Year |
PERIOD | NUMBER | (5) | Yes | Fiscal Period |
DOC_TYPE | VARCHAR2 | (4) | Yes | Document Type |
DOC_ID | NUMBER | (15) | Yes | Document ID |
LINE_ID | NUMBER | (15) | Yes | Line ID |
ITEM_ID | NUMBER | (10) | Item ID | |
RESOURCES | VARCHAR2 | (16) | Resource | |
VARIANCE_TYPE | NUMBER | (5) | Yes | Type of Variance; 1 = scale formula to WIP planned quantity of primary product in batch, 2 = scale formula to actual quantity of primary product in batch, 3 = aggregate variance |
TRANS_SOURCE_TYPE | NUMBER | (5) | Yes | Source Type |
SUB_EVENT_TYPE | NUMBER | (10) | Yes | Sub Event Type |
ACCT_TTL_TYPE | NUMBER | (10) | Yes | Account Title Type |
AMOUNT_BASE | NUMBER | Yes | Base Amount | |
AMOUNT_TRANS | NUMBER | Yes | Transaction Amount | |
DEBIT_CREDIT_SIGN | NUMBER | (5) | Yes | Debit/Credit Sign; 1 = Debit, -1 = Credit |
QUANTITY | NUMBER | Quantity | ||
QUANTITY_UOM | VARCHAR2 | (4) | Quantity Unit of Measure | |
CREATED_BY | NUMBER | (15) | Yes | Standard who Column |
CREATION_DATE | DATE | Yes | Standard who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who Column | |
DELETE_MARK | NUMBER | (5) | Yes | Standard; 0 = Active Record (Default), 1 = Marked for (logical) Deletion |
Cut, paste (and edit) the following text to query this object:
SELECT SUBLEDGER_VARIANCE_ID
, REFERENCE_NO
, CO_CODE
, FISCAL_YEAR
, PERIOD
, DOC_TYPE
, DOC_ID
, LINE_ID
, ITEM_ID
, RESOURCES
, VARIANCE_TYPE
, TRANS_SOURCE_TYPE
, SUB_EVENT_TYPE
, ACCT_TTL_TYPE
, AMOUNT_BASE
, AMOUNT_TRANS
, DEBIT_CREDIT_SIGN
, QUANTITY
, QUANTITY_UOM
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DELETE_MARK
FROM GMF.GL_SUBR_TST_VAR;
GMF.GL_SUBR_TST_VAR does not reference any database object
GMF.GL_SUBR_TST_VAR is referenced by following:
|
|
|