[Home] [Help]
[Dependency Information]
[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:
APPS
FII_AP_INV_DIST_F
POA_API_BS_J_MV
POA_IDL_BS_J_MV
POA_MID_BS_J_MV
|
|
|
|