[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
FII.FII_AP_INV_DIST_T does not reference any database object
FII.FII_AP_INV_DIST_T is referenced by following:
|
|
|