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

TABLE: AX.AX_VARIANCES_EFC

Object Details
Object Name: AX_VARIANCES_EFC
Object Type: TABLE
Owner: AX
Subobject Name:
Status: VALID


Temparary table created to stores the information needed to adjust the inventory values
at the end of each accounting period during Euro as Functional Currency conversion. 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:
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 nventory item identifier
ACCOUNTING_PERIOD_ID NUMBER
Yes Accounting period identifier
VARIANCE_TYPE NUMBER
Yes Variance type (1 - PPV, 2 - IPV, 3 - EPV)
CODE_COMBINATION_ID NUMBER
Yes Code combination identifier
VARIANCE_AMOUNT NUMBER

Variance amount
ONHAND_AMOUNT NUMBER

Variance amount * onhand quantity / received quantity
ISSUED_AMOUNT NUMBER

Variance amount - onhand amount
PREVIOUS_VARIANCE NUMBER

Accounting period identifier of the last active period for this variance; 0 if no previous activity exists
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SET_OF_BOOKS_ID NUMBER (15)
Set of books identifier
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
,      CODE_COMBINATION_ID
,      VARIANCE_AMOUNT
,      ONHAND_AMOUNT
,      ISSUED_AMOUNT
,      PREVIOUS_VARIANCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SET_OF_BOOKS_ID
FROM AX.AX_VARIANCES_EFC;

Dependencies

[top of page]

AX.AX_VARIANCES_EFC does not reference any database object

AX.AX_VARIANCES_EFC is referenced by following:

SchemaAPPS
SynonymAX_VARIANCES_EFC