eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_MC_INVOICE_DISTS

Object Details

Object Name:	AP_MC_INVOICE_DISTS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_MC_INVOICE_DISTS
Subobject Name:
Status:	VALID

AP_MC_INVOICE_DISTS is a Multiple Reporting Currencies table that
stores reporting currency information for each invoice distribution in
Oracle Payables. There is an optional one to many relationship
between AP_INVOICE_DISTRIBUTIONS_ALL and this table. For each
invoice distribution in AP_INVOICE_DISTRIBUTIONS_ALL, there can be
several invoice distributions in the AP_MC_INVOICE_DISTS table with
the same value for INVOICE_ID and DISTRIBUTION_LINE_NUMBER, but
different values for SET_OF_BOOKS_ID. The number of invoice
distributions stored in the AP_MC_INVOICE_DISTS table having the same
INVOICE_ID and DISTRIBUTION_LINE_NUMBER will correspond with the
number of Reporting Sets of Books that have been defined.
There is a mandatory one to many relationship between
the AP_MC_INVOICES table and the AP_MC_INVOICE_DISTS table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_MC_INVOICE_DISTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID DISTRIBUTION_LINE_NUMBER SET_OF_BOOKS_ID
AP_MC_INVOICE_DISTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID SET_OF_BOOKS_ID
AP_MC_INVOICE_DISTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIST_CODE_COMBINATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Invoice distribution identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes	Invoice distribution line number
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
DIST_CODE_COMBINATION_ID	NUMBER	(15)	Yes	Accounting flexfield identifier for expense account associated with a distribution line
AMOUNT	NUMBER			Distribution amount in entered currency
BASE_AMOUNT	NUMBER			Distribution amount in functional currency, only used for foreign currency invoices
BASE_INVOICE_PRICE_VARIANCE	NUMBER			Price variance amount in functional currency for invoice distribution line matched to purchase order
EXCHANGE_RATE_VARIANCE	NUMBER			Amount of exchange rate variance for invoice distribution line matched to a purchase order
RATE_VAR_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for exchange rate variance account for distribution line
EXCHANGE_DATE	DATE			Date which determines currency conversion rate to convert transaction currency amounts into reporting currency amounts
EXCHANGE_RATE	NUMBER			Currency conversion rate used to convert the transactional currency amount to reporting currency amount
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency conversion rate type to convert transaction currency amounts into reporting currency amounts
RECEIPT_CONVERSION_RATE	NUMBER			Exchange rate of the receipt
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	Name of line type
QUANTITY_INVOICED	NUMBER			Quantity billed for purchase order or receipt matched invoice distributions
AMOUNT_TO_POST	NUMBER			No longer used in 11i but in data model upgrade
BASE_AMOUNT_TO_POST	NUMBER			No longer used in 11i but in data model upgrade
UPGRADE_POSTED_AMT	NUMBER			This column is only used during the upgrade to create accounting entries for Cash basis accounting
UPGRADE_BASE_POSTED_AMT	NUMBER			This column is only used during the upgrade to create accounting entries for Cash basis accounting
POSTED_AMOUNT	NUMBER			No longer used in 11i but in data model upgrade
POSTED_BASE_AMOUNT	NUMBER			No longer used in 11i but in data model upgrade

Query Text

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


SELECT INVOICE_DISTRIBUTION_ID
,      INVOICE_ID
,      DISTRIBUTION_LINE_NUMBER
,      SET_OF_BOOKS_ID
,      DIST_CODE_COMBINATION_ID
,      AMOUNT
,      BASE_AMOUNT
,      BASE_INVOICE_PRICE_VARIANCE
,      EXCHANGE_RATE_VARIANCE
,      RATE_VAR_CODE_COMBINATION_ID
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      RECEIPT_CONVERSION_RATE
,      LINE_TYPE_LOOKUP_CODE
,      QUANTITY_INVOICED
,      AMOUNT_TO_POST
,      BASE_AMOUNT_TO_POST
,      UPGRADE_POSTED_AMT
,      UPGRADE_BASE_POSTED_AMT
,      POSTED_AMOUNT
,      POSTED_BASE_AMOUNT
FROM AP.AP_MC_INVOICE_DISTS;

Dependencies

[top of page]

AP.AP_MC_INVOICE_DISTS does not reference any database object

AP.AP_MC_INVOICE_DISTS is referenced by following:

APPS: AP_MC_INVOICE_DISTS