[Home] [Help] [Dependency Information]
Object Name: | FII_AP_INV_B |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AP_INV_B |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_AP_INV_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
EMPLOYEE_ID
ACCOUNT_DATE |
FII_AP_INV_B_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
COST_CENTER_ID
COMPANY_ID ACCOUNT_DATE |
FII_AP_INV_B_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | INVOICE_ID |
FII_AP_INV_B_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
SUPPLIER_SITE_ID
SUPPLIER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | No longer used | |
ACCOUNT_DATE | DATE | Accounting Date of invoice distribution | ||
ACCOUNT_DATE_ID | NUMBER | Accounting Date of invoice distribution converted to Julian date format | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | Accounting Currency Code | |
AMOUNT_T | NUMBER | Amount in transaction currency | ||
INVOICE_ID | NUMBER | (15) | Invoice ID for the Inv. Distribution | |
AMOUNT_B | NUMBER | Amount in base currency | ||
PO_MATCHED_FLAG | VARCHAR2 | (1) | Flag if invoice is PO matched or not | |
SOURCE | VARCHAR2 | (25) | Source of Invoice | |
INV_DIST_CREATED_BY | NUMBER | (15) | Who created the Inv. 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 Inv. Distributions | ||
INVOICE_TYPE | VARCHAR2 | (25) | Type of invoice | |
POSTED_FLAG | VARCHAR2 | (1) | Flag indicating if invoice distribution is posted | |
COST_CENTER_ORG_ID | NUMBER | (15) | No longer used - Cost center org id | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart of Accounts ID | |
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 | ||
APPROVED_FLAG | VARCHAR2 | (1) | Flag indicating if invoice distribution is approved | |
ORG_ID | NUMBER | (15) | Organization identifier | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
TASK_ID | NUMBER | (15) | Task Identifier | |
PROJECT_ID | NUMBER | (15) | Project 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 accounting engine in SLA temporary journal entries table | |
GL_SL_LINK_ID | NUMBER | (15) | Audit trail to General Ledger | |
GL_SL_LINK_TABLE | VARCHAR2 | (30) | Subledger link table name used to link GL journal lines with subledger journal entry lines | |
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 SET_OF_BOOKS_ID
, ACCOUNT_DATE
, ACCOUNT_DATE_ID
, INV_CURRENCY_CODE
, AMOUNT_T
, 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
, POSTED_FLAG
, COST_CENTER_ORG_ID
, CHART_OF_ACCOUNTS_ID
, PRIM_AMOUNT_G
, SEC_AMOUNT_G
, UPDATE_SEQUENCE
, APPROVED_FLAG
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, 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_B;
FII.FII_AP_INV_B does not reference any database object
FII.FII_AP_INV_B is referenced by following:
|
|
|