DBA Data[Home] [Help] [Dependency Information]

TABLE: AX.AX_VARIANCES

Object Details
Object Name: AX_VARIANCES
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.AX_VARIANCES
Subobject Name:
Status: VALID


This table stores the information needed to adjust the inventory
values at the end of each accounting period. It contains a row for
each Inventory organization, subinventory, inventory item, accounting period,
variance type, primary cost method, and account.
Each row includes quantities and amounts used to calculate
adjustment.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_VARIANCES_PK
  1. ColumnORGANIZATION_ID
  2. ColumnSECONDARY_INVENTORY_NAME
  3. ColumnINVENTORY_ITEM_ID
  4. ColumnACCOUNTING_PERIOD_ID
  5. ColumnVARIANCE_TYPE
  6. ColumnCODE_COMBINATION_ID
Indexes
Index Type Uniqueness Tablespace Column
AX_VARIANCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSECONDARY_INVENTORY_NAME
ColumnINVENTORY_ITEM_ID
ColumnACCOUNTING_PERIOD_ID
ColumnVARIANCE_TYPE
ColumnCODE_COMBINATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Inventory organization identifier
SECONDARY_INVENTORY_NAME VARCHAR2 (10) Yes Secondary inventory name
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ACCOUNTING_PERIOD_ID NUMBER
Yes Accounting period identifier
VARIANCE_TYPE NUMBER
Yes Variance type (1 - PPV, 2 - IPV, 3 - EPV)
PRIMARY_COST_METHOD NUMBER

Primary cost method (1 - average cost, 2 - standard cost)
ONHAND_QUANTITY NUMBER

Onhand quantity as of the last day of the accounting period
RECEIVED_QUANTITY NUMBER

Received quantity since the most recent between the latest absorbtion date and the year opening date
VARIANCE_AMOUNT NUMBER

Variance amount
ONHAND_AMOUNT NUMBER

Variance amount * onhand quantity / received quantity
ISSUED_AMOUNT NUMBER

Variance amount - onhand amount
ONHAND_AMOUNT_FLAG NUMBER

Onhand amount adjusted flag (1 - not processed, 2 - adjusted, 3 - offset)
ISSUED_AMOUNT_FLAG NUMBER

Issued amount absorbed flag (1 - not absorbed, 2 - absorbed)
PREVIOUS_VARIANCE NUMBER

Accounting period identifier of the last active period for this variance; 0 if no previous activity exists
CODE_COMBINATION_ID NUMBER
Yes Code combination identifier
LAST_UPDATE_DATE DATE

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      SECONDARY_INVENTORY_NAME
,      INVENTORY_ITEM_ID
,      ACCOUNTING_PERIOD_ID
,      VARIANCE_TYPE
,      PRIMARY_COST_METHOD
,      ONHAND_QUANTITY
,      RECEIVED_QUANTITY
,      VARIANCE_AMOUNT
,      ONHAND_AMOUNT
,      ISSUED_AMOUNT
,      ONHAND_AMOUNT_FLAG
,      ISSUED_AMOUNT_FLAG
,      PREVIOUS_VARIANCE
,      CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM AX.AX_VARIANCES;

Dependencies

[top of page]

AX.AX_VARIANCES does not reference any database object

AX.AX_VARIANCES is referenced by following:

SchemaAPPS
SynonymAX_VARIANCES