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

TABLE: FII.FII_AP_INV_STG

Object Details
Object Name: FII_AP_INV_STG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AP_INV_STG
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15)
No longer used
ACCOUNT_DATE DATE

Accounting Date of invoice distribution
INV_CURRENCY_CODE VARCHAR2 (15)
Accounting Currency Code
INVOICE_ID NUMBER (15)
Invoice ID for the Inv. Distribution
PO_MATCHED_FLAG VARCHAR2 (1)
Flag if invoice is PO matched or not
COST_CENTER_ORG_ID NUMBER (15)
No longer used
CHART_OF_ACCOUNTS_ID NUMBER (15)
Chart of Accounts ID
ORG_ID NUMBER (15)
Organization identifier
AMOUNT_T NUMBER

Amount in transaction currency
AMOUNT_B NUMBER

Amount in base currency
SOURCE VARCHAR2 (25)
Source of Invoice
INV_DIST_CREATED_BY NUMBER (15)
Who created the Inv. 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
DIST_COUNT NUMBER (15)
Count of Unique Inv. Distributions
INVOICE_TYPE VARCHAR2 (25)
Type of invoice
PRIM_CONVERSION_RATE NUMBER

Primary Currency Conversion Rate
SEC_CONVERSION_RATE NUMBER

Secondary Currency Conversion Rate
POSTED_FLAG VARCHAR2 (1)
Flag indicating if invoice distribution is posted
APPROVED_FLAG VARCHAR2 (1)
Flag indicating if invoice distribution is approved
TASK_ID NUMBER (15)
Task Identifier
PROJECT_ID NUMBER (15)
Project oject Identifier
QUANTITY_INVOICED NUMBER

Quantity Invoiced
PO_DISTRIBUTION_ID NUMBER (15)
Purchase Order Distribution Identifier
DIST_CCID NUMBER (15)
General Ledger Code Combination Identifier
INVOICE_DISTRIBUTION_ID NUMBER (15)
Invoice Distribution Identifier
EMPLOYEE_ID NUMBER (15)
Employee Identifier
INVOICE_NUM VARCHAR2 (50)
Invoice Number
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
COMPANY_ID NUMBER (15)
Company Identifier
COST_CENTER_ID NUMBER (15)
Cost Center Identifier
LINE_TYPE_LOOKUP_CODE VARCHAR2 (25)
Line type lookup code
DISCRETIONARY_EXPENSE_FLAG VARCHAR2 (1)
Discretionary Expense Flag
USER_DIM1_ID NUMBER (15)
User Defined Dimension 1 Identifier
USER_DIM2_ID NUMBER (15)
User Defined Dimension 2 Identifier
TRANS_CURRENCY_CODE VARCHAR2 (15)
Currency code of invoice
INVOICE_DATE DATE

Invoice date
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Distribution line number
EXP_REPORT_HEADER_ID NUMBER

Expense report header identifier
PO_HEADER_ID NUMBER

Document header unique identifier
PO_RELEASE_ID NUMBER

Release unique identifier
PO_NUM VARCHAR2 (20)
Document number
LEDGER_ID NUMBER (15)
Ledger Identifier
AE_HEADER_ID NUMBER (15)
Subledger journal entry identifier
REF_AE_HEADER_ID NUMBER (15)
Reversed subledger journal entry header identifier
TEMP_LINE_NUM NUMBER (15)
Temporary line number generated by SLA
GL_SL_LINK_ID NUMBER (15)
Audit trail to General Ledger
GL_SL_LINK_TABLE VARCHAR2 (30)
Subledger link table name
INVENTORY_ITEM_ID NUMBER (15)
Inventory item identifier
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
PURCHASING_CATEGORY_ID NUMBER (15)
Purchasing category identifier
Query Text

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


SELECT SET_OF_BOOKS_ID
,      ACCOUNT_DATE
,      INV_CURRENCY_CODE
,      INVOICE_ID
,      PO_MATCHED_FLAG
,      COST_CENTER_ORG_ID
,      CHART_OF_ACCOUNTS_ID
,      ORG_ID
,      AMOUNT_T
,      AMOUNT_B
,      SOURCE
,      INV_DIST_CREATED_BY
,      INV_DIST_CREATION_DATE
,      SUPPLIER_SITE_ID
,      SUPPLIER_ID
,      DIST_COUNT
,      INVOICE_TYPE
,      PRIM_CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      POSTED_FLAG
,      APPROVED_FLAG
,      TASK_ID
,      PROJECT_ID
,      QUANTITY_INVOICED
,      PO_DISTRIBUTION_ID
,      DIST_CCID
,      INVOICE_DISTRIBUTION_ID
,      EMPLOYEE_ID
,      INVOICE_NUM
,      FIN_CATEGORY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      LINE_TYPE_LOOKUP_CODE
,      DISCRETIONARY_EXPENSE_FLAG
,      USER_DIM1_ID
,      USER_DIM2_ID
,      TRANS_CURRENCY_CODE
,      INVOICE_DATE
,      DISTRIBUTION_LINE_NUMBER
,      EXP_REPORT_HEADER_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_NUM
,      LEDGER_ID
,      AE_HEADER_ID
,      REF_AE_HEADER_ID
,      TEMP_LINE_NUM
,      GL_SL_LINK_ID
,      GL_SL_LINK_TABLE
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      PURCHASING_CATEGORY_ID
FROM FII.FII_AP_INV_STG;

Dependencies

[top of page]

FII.FII_AP_INV_STG does not reference any database object

FII.FII_AP_INV_STG is referenced by following:

SchemaAPPS
SynonymFII_AP_INV_STG