[Home] [Help] [Dependency Information]
Object Name: | CM_APCM_MST_EFC |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.CM_APCM_MST_EFC |
Subobject Name: | |
Status: | VALID |
Shadow table of CM_APCM_MST for EFC migration. Stores the original values of columns of CM_APCM_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_APCM_DTL and only the columns that are actually converted to the Euro currency.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_LINE_NO | NUMBER | Yes | Invoice line number | |
POLINE_ID | NUMBER | Yes | Surrogate identifying the PO line | |
AQUI_COST_ID | NUMBER | Yes | Acquisition cost surrogate | |
LINE_TYPE | NUMBER | Yes | Indicator for the line type; 0 - Item, 1 - Acquisition cost | |
INVOICE_NO | VARCHAR2 | (50) | Yes | Invoice number |
INVOICE_BASE_AMOUNT | NUMBER | Yes | Total invoice line amount in the base currency | |
PO_ID | NUMBER | Yes | Surrogate identifying the PO number | |
ITEM_ID | NUMBER | Yes | Surrogate of the item number on the PO | |
UNIT_BASE_PRICE | NUMBER | Yes | Unit price for the invoice line in the base currency | |
SET_OF_BOOKS_ID | NUMBER | Yes | Set of books identifier | |
BASE_CURRENCY | VARCHAR2 | (4) | Yes | Base currency for the invoice |
EXCHANGE_RATE | NUMBER | Yes | Exchange rate used for converting the invoice amount from the billing to the base currency |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_LINE_NO
, POLINE_ID
, AQUI_COST_ID
, LINE_TYPE
, INVOICE_NO
, INVOICE_BASE_AMOUNT
, PO_ID
, ITEM_ID
, UNIT_BASE_PRICE
, SET_OF_BOOKS_ID
, BASE_CURRENCY
, EXCHANGE_RATE
FROM GMF.CM_APCM_MST_EFC;
GMF.CM_APCM_MST_EFC does not reference any database object
GMF.CM_APCM_MST_EFC is referenced by following:
|
|
|