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: FII.FII_AP_INV_DIST_T

Object Details

Object Name:	FII_AP_INV_DIST_T
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AP_INV_DIST_T
Subobject Name:
Status:	VALID

This table is used for internal processing only. It holds data in Oracle Payables not posted to SLA.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_DATE	DATE		Yes	Accounting date of invoice distribution
INV_CURRENCY_CODE	VARCHAR2	(15)	Yes	Accounting currency code
INVOICE_ID	NUMBER	(15)	Yes	Invoice ID for the invoice distribution
PO_MATCHED_FLAG	VARCHAR2	(1)	Yes	Indicates if invoice is PO matched
ORG_ID	NUMBER	(15)	Yes	Organization identifier
AMOUNT_B	NUMBER			Amount in base currency
SOURCE	VARCHAR2	(25)		Source of invoice
INV_DIST_CREATED_BY	NUMBER	(15)		Who created the invoice distribution
INV_DIST_CREATION_DATE	DATE			Creation date of invoice distribution
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier site identifier
SUPPLIER_ID	NUMBER	(15)		Supplier identifier
INVOICE_TYPE	VARCHAR2	(25)		Type of invoice
PRIM_CONVERSION_RATE	NUMBER			Rate to convert from base currency to primary currency
SEC_CONVERSION_RATE	NUMBER			Rate to convert from base currency to secondary currency
POSTED_FLAG	VARCHAR2	(1)		Indicates if invoice distribution is posted
APPROVED_FLAG	VARCHAR2	(1)		Indicates if invoice distribution is approved
PO_DISTRIBUTION_ID	NUMBER	(15)		PO distribution identifier
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice distribution identifier
COMPANY_ID	NUMBER	(15)		Company identifier
COST_CENTER_ID	NUMBER	(15)		Cost center identifier
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Name of line type
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory item identifier
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
PURCHASING_CATEGORY_ID	NUMBER	(15)		Purchasing category identifierN

Query Text

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


SELECT ACCOUNT_DATE
,      INV_CURRENCY_CODE
,      INVOICE_ID
,      PO_MATCHED_FLAG
,      ORG_ID
,      AMOUNT_B
,      SOURCE
,      INV_DIST_CREATED_BY
,      INV_DIST_CREATION_DATE
,      SUPPLIER_SITE_ID
,      SUPPLIER_ID
,      INVOICE_TYPE
,      PRIM_CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      POSTED_FLAG
,      APPROVED_FLAG
,      PO_DISTRIBUTION_ID
,      INVOICE_DISTRIBUTION_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      LINE_TYPE_LOOKUP_CODE
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      PURCHASING_CATEGORY_ID
FROM FII.FII_AP_INV_DIST_T;

Dependencies

[top of page]

FII.FII_AP_INV_DIST_T does not reference any database object

FII.FII_AP_INV_DIST_T is referenced by following:

APPS: FII_AP_INV_DIST_T