[Home] [Help] [Dependency Information]
Object Name: | FII_AP_INV_DIST_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AP_INV_DIST_F |
Subobject Name: | |
Status: | VALID |
This table holds AP summary information for data not posted to SLA. It is used to support POA portlets.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_DATE | DATE | Accounting date of invoice distribution | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | Accounting currency code | |
INVOICE_ID | NUMBER | (15) | Invoice ID for the invoice distribution | |
AMOUNT_B | NUMBER | Amount in base currency | ||
PO_MATCHED_FLAG | VARCHAR2 | (1) | Indicates if invoice is PO matched | |
SOURCE | VARCHAR2 | (25) | Source of invoice | |
INV_DIST_CREATED_BY | NUMBER | (15) | Who created the invoice distribution | |
SUPPLIER_SITE_ID | NUMBER | Supplier site identifier | ||
INV_DIST_CREATION_DATE | DATE | Creation date of invoice distribution | ||
SUPPLIER_ID | NUMBER | (15) | Supplier identifier | |
DIST_COUNT | NUMBER | Count of unique invoice distributions | ||
INVOICE_TYPE | VARCHAR2 | (25) | Type of invoice | |
PRIM_AMOUNT_G | NUMBER | Amount in primary global currency | ||
SEC_AMOUNT_G | NUMBER | Amount in secondary global currency | ||
UPDATE_SEQUENCE | NUMBER | Sequence to identify deleted invoices | ||
POSTED_FLAG | VARCHAR2 | (1) | Indicates if invoice distribution is posted | |
APPROVED_FLAG | VARCHAR2 | (1) | Indicates if invoice distribution is approved | |
ORG_ID | NUMBER | (15) | Organization identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
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 identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_DATE
, INV_CURRENCY_CODE
, INVOICE_ID
, AMOUNT_B
, PO_MATCHED_FLAG
, SOURCE
, INV_DIST_CREATED_BY
, SUPPLIER_SITE_ID
, INV_DIST_CREATION_DATE
, SUPPLIER_ID
, DIST_COUNT
, INVOICE_TYPE
, PRIM_AMOUNT_G
, SEC_AMOUNT_G
, UPDATE_SEQUENCE
, POSTED_FLAG
, APPROVED_FLAG
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, 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_F;
FII.FII_AP_INV_DIST_F does not reference any database object
FII.FII_AP_INV_DIST_F is referenced by following:
|
|
|