[Home] [Help] [Dependency Information]
Object Name: | OTFV_FINANCE_HEADERS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_FINANCE_HEADERS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows generic financial information about dealings you have with particular customer or supplier.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | (9) | ||
HEADER_SUPERSEDES | NUMBER | (9) | ||
FINANCE_HEADER_COMMENTS | VARCHAR2 | (2000) | Free Text Comments | |
DATE_RAISED | DATE | |||
HEADER_TYPE | VARCHAR2 | (4000) | ||
HEADER_SUB_TYPE | VARCHAR2 | (30) | ||
CANCELLED_FLAG | VARCHAR2 | (4000) | An indication of whether has been cancelled | |
CURRENCY | VARCHAR2 | (4000) | ||
ADMINISTRATOR | NUMBER | |||
HEADER_CANCELLED | VARCHAR2 | (4000) | ||
HEADER_PAID | VARCHAR2 | (4000) | ||
TRANSFER_STATUS | VARCHAR2 | (4000) | ||
TRANSFER_DATE | DATE | |||
EXTERNAL_REFERENCE | VARCHAR2 | (30) | ||
TRANSFER_MESSAGE | VARCHAR2 | (240) | ||
PAYING_COST_CENTER | VARCHAR2 | (800) | ||
RECEIVING_COST_CENTER | VARCHAR2 | (800) | ||
INVOICE_CONTACT | VARCHAR2 | (240) | ||
INVOICE_ADDRESS | VARCHAR2 | (2000) | ||
INVOICE_FULL_AMOUNT | VARCHAR2 | (4000) | ||
SUPPLIER_NAME | VARCHAR2 | (240) | ||
CONTACT_NAME | VARCHAR2 | (301) | ||
AUTHORIZED_BY | VARCHAR2 | (100) | ||
CUSTOMER_NAME | VARCHAR2 | (50) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
ADDRESS_LINE1 | VARCHAR2 | (240) | ||
ADDRESS_LINE2 | VARCHAR2 | (240) | ||
ADDRESS_LINE3 | VARCHAR2 | (240) | ||
ADDRESS_LINE4 | VARCHAR2 | (560) | ||
CITY | VARCHAR2 | (60) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
PROVINCE | VARCHAR2 | (60) | ||
COUNTY | VARCHAR2 | (60) | ||
SET_OF_BOOKS_FROM | VARCHAR2 | (30) | ||
SET_OF_BOOKS_TO | VARCHAR2 | (30) | ||
_KF:CODE_COMBINATIONS:FROM | CHAR | (17) | ||
_KF:CODE_COMBINATIONS:TO | CHAR | (18) | ||
_DF | CHAR | (31) | ||
TRANSFER_FROM_SET_OF_BOOKS_ID | NUMBER | (15) | ||
TRANSFER_TO_SET_OF_BOOKS_ID | NUMBER | (15) | ||
TRANSFER_FROM_CC_ID | NUMBER | (15) | ||
TRANSFER_TO_CC_ID | NUMBER | (15) | ||
ADDRESS_ID | NUMBER | |||
APPROVED_BY_ID | NUMBER | (10) | ||
CONTACT_ID | NUMBER | (15) | ||
SUPPLIER_ID | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, HEADER_SUPERSEDES
, FINANCE_HEADER_COMMENTS
, DATE_RAISED
, HEADER_TYPE
, HEADER_SUB_TYPE
, CANCELLED_FLAG
, CURRENCY
, ADMINISTRATOR
, HEADER_CANCELLED
, HEADER_PAID
, TRANSFER_STATUS
, TRANSFER_DATE
, EXTERNAL_REFERENCE
, TRANSFER_MESSAGE
, PAYING_COST_CENTER
, RECEIVING_COST_CENTER
, INVOICE_CONTACT
, INVOICE_ADDRESS
, INVOICE_FULL_AMOUNT
, SUPPLIER_NAME
, CONTACT_NAME
, AUTHORIZED_BY
, CUSTOMER_NAME
, ORGANIZATION_NAME
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ADDRESS_LINE4
, CITY
, POSTAL_CODE
, PROVINCE
, COUNTY
, SET_OF_BOOKS_FROM
, SET_OF_BOOKS_TO
, _KF:CODE_COMBINATIONS:FROM
, _KF:CODE_COMBINATIONS:TO
, _DF
, TRANSFER_FROM_SET_OF_BOOKS_ID
, TRANSFER_TO_SET_OF_BOOKS_ID
, TRANSFER_FROM_CC_ID
, TRANSFER_TO_CC_ID
, ADDRESS_ID
, APPROVED_BY_ID
, CONTACT_ID
, SUPPLIER_ID
, CUSTOMER_ID
, ORGANIZATION_ID
FROM APPS.OTFV_FINANCE_HEADERS;
APPS.OTFV_FINANCE_HEADERS is not referenced by any database object
|
|
|