eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OTA.OTA_FINANCE_HEADERS

Object Details

Object Name:	OTA_FINANCE_HEADERS
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_FINANCE_HEADERS
Subobject Name:
Status:	VALID

A finance header holds generic financial information about the
dealings you have with a particular customer or supplier. For example,
the customer name, contact information and payment currency. Each
financial transaction you have with the supplier, customer or cost center
as a finance line. You can associate one or more finance lines with
each finance header.
There are three types of finance header:
1. Payable
2. Receivable
3. Cross Charges
4. Cancellation
You transfer the finance headers to your finance system to trigger the
creation of sales invoices or receipts.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_FINANCE_HEADERS_PK

FINANCE_HEADER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_FINANCE_HEADERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FINANCE_HEADER_ID
OTA_FINANCE_HEADERS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPERCEDING_HEADER_ID
OTA_FINANCE_HEADERS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
OTA_FINANCE_HEADERS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
OTA_FINANCE_HEADERS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_ID
OTA_FINANCE_HEADERS_N52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS_ID
OTA_FINANCE_HEADERS_N53	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OTA_FINANCE_HEADERS	OTA_FINANCE_HEADERS	OTA_FINANCE_HEADERS SUPERCEDING_HEADER_ID
OTA_FINANCE_HEADERS	OTA_FINANCE_HEADERS	OTA_FINANCE_HEADERS SUPERCEDING_HEADER_ID
OTA_FINANCE_LINES	OTA_FINANCE_HEADERS	OTA_FINANCE_LINES FINANCE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FINANCE_HEADER_ID	NUMBER	(9)	Yes	The Unique identifier of the Finance Header
SUPERCEDING_HEADER_ID	NUMBER	(9)		Foreign key to OTA_FINANCE_HEADERS
AUTHORIZER_PERSON_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F
ORGANIZATION_ID	NUMBER	(9)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS
ADMINISTRATOR	NUMBER		Yes	The person who raised the header (AOL User)
CANCELLED_FLAG	VARCHAR2	(30)	Yes	An indication of whether has been cancelled
CURRENCY_CODE	VARCHAR2	(30)	Yes	The currency in which all lines are defined
DATE_RAISED	DATE		Yes	The date this header was raised
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Version number for change control
PAYMENT_STATUS_FLAG	VARCHAR2	(30)	Yes	Describes if the invoice has been paid or not.
TRANSFER_STATUS	VARCHAR2	(30)	Yes	The Status of the header for external transfer
TYPE	VARCHAR2	(30)	Yes	The type of header: cancellation /payable / receivable
COMMENTS	VARCHAR2	(2000)		Free Text Comments
EXTERNAL_REFERENCE	VARCHAR2	(30)		The identification of what this header is in the external system
INVOICE_ADDRESS	VARCHAR2	(2000)		The address to which the invoice is to sent
INVOICE_CONTACT	VARCHAR2	(240)		The person to which this invoice is to be sent
PAYMENT_METHOD	VARCHAR2	(30)		The Method by which this header is to be paid
PYM_ATTRIBUTE1	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE10	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE11	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE12	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE13	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE14	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE15	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE16	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE17	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE18	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE19	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE2	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE20	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE3	VARCHAR2	(150)		Attribute for Payment Method FlexfieldAttribute for Payment Method Flexfield
PYM_ATTRIBUTE4	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE5	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE6	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE7	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE8	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_ATTRIBUTE9	VARCHAR2	(150)		Attribute for Payment Method Flexfield
PYM_INFORMATION_CATEGORY	VARCHAR2	(30)		The flexfield to hold Payment Method Details
RECEIVABLE_TYPE	VARCHAR2	(30)		The type of receivable header
TRANSFER_DATE	DATE			The date this header was transfered into an external system
TRANSFER_MESSAGE	VARCHAR2	(240)		A message to send to the external system with this header.
VENDOR_ID	NUMBER	(15)		Foreign key to PO_VENDORS.
CONTACT_ID	NUMBER	(15)		Foreign key to RA_CONTACTS.
ADDRESS_ID	NUMBER			Foreign key to RA_ADDRESSES.
CUSTOMER_ID	NUMBER	(15)		Foreign key to RA_CUSTOMERS.
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
TFH_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
TFH_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
TFH_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column
RECEIVING_COST_CENTER	VARCHAR2	(800)		Receiving cost center code for the resource charge cross transfer.
PAYING_COST_CENTER	VARCHAR2	(800)		Paying cost center code for the resource charge cross transfer.
TRANSFER_FROM_SET_OF_BOOKS_ID	NUMBER	(15)		Transfer from Set of book id
TRANSFER_TO_SET_OF_BOOKS_ID	NUMBER	(15)		Transfer to set of book id
FROM_SEGMENT1	VARCHAR2	(25)		GL segment column
FROM_SEGMENT2	VARCHAR2	(25)		GL segment column
FROM_SEGMENT3	VARCHAR2	(25)		GL segment column
FROM_SEGMENT4	VARCHAR2	(25)		GL segment column
FROM_SEGMENT5	VARCHAR2	(25)		GL segment column
FROM_SEGMENT6	VARCHAR2	(25)		GL segment column
FROM_SEGMENT7	VARCHAR2	(25)		GL segment column
FROM_SEGMENT8	VARCHAR2	(25)		GL segment column
FROM_SEGMENT9	VARCHAR2	(25)		GL segment column
FROM_SEGMENT10	VARCHAR2	(25)		GL segment column
FROM_SEGMENT11	VARCHAR2	(25)		GL segment column
FROM_SEGMENT12	VARCHAR2	(25)		GL segment column
FROM_SEGMENT13	VARCHAR2	(25)		GL segment column
FROM_SEGMENT14	VARCHAR2	(25)		GL segment column
FROM_SEGMENT15	VARCHAR2	(25)		GL segment column
FROM_SEGMENT16	VARCHAR2	(25)		GL segment column
FROM_SEGMENT17	VARCHAR2	(25)		GL segment column
FROM_SEGMENT18	VARCHAR2	(25)		GL segment column
FROM_SEGMENT19	VARCHAR2	(25)		GL segment column
FROM_SEGMENT20	VARCHAR2	(25)		GL segment column
FROM_SEGMENT21	VARCHAR2	(25)		GL segment column
FROM_SEGMENT22	VARCHAR2	(25)		GL segment column
FROM_SEGMENT23	VARCHAR2	(25)		GL segment column
FROM_SEGMENT24	VARCHAR2	(25)		GL segment column
FROM_SEGMENT25	VARCHAR2	(25)		GL segment column
FROM_SEGMENT26	VARCHAR2	(25)		GL segment column
FROM_SEGMENT27	VARCHAR2	(25)		GL segment column
FROM_SEGMENT28	VARCHAR2	(25)		GL segment column
FROM_SEGMENT29	VARCHAR2	(25)		GL segment column
FROM_SEGMENT30	VARCHAR2	(25)		GL segment column
TO_SEGMENT1	VARCHAR2	(25)		GL segment column
TO_SEGMENT2	VARCHAR2	(25)		GL segment column
TO_SEGMENT3	VARCHAR2	(25)		GL segment column
TO_SEGMENT4	VARCHAR2	(25)		GL segment column
TO_SEGMENT5	VARCHAR2	(25)		GL segment column
TO_SEGMENT6	VARCHAR2	(25)		GL segment column
TO_SEGMENT7	VARCHAR2	(25)		GL segment column
TO_SEGMENT8	VARCHAR2	(25)		GL segment column
TO_SEGMENT9	VARCHAR2	(25)		GL segment column
TO_SEGMENT10	VARCHAR2	(25)		GL segment column
TO_SEGMENT11	VARCHAR2	(25)		GL segment column
TO_SEGMENT12	VARCHAR2	(25)		GL segment column
TO_SEGMENT13	VARCHAR2	(25)		GL segment column
TO_SEGMENT14	VARCHAR2	(25)		GL segment column
TO_SEGMENT15	VARCHAR2	(25)		GL segment column
TO_SEGMENT16	VARCHAR2	(25)		GL segment column
TO_SEGMENT17	VARCHAR2	(25)		GL segment column
TO_SEGMENT18	VARCHAR2	(25)		GL segment column
TO_SEGMENT19	VARCHAR2	(25)		GL segment column
TO_SEGMENT20	VARCHAR2	(25)		GL segment column
TO_SEGMENT21	VARCHAR2	(25)		GL segment column
TO_SEGMENT22	VARCHAR2	(25)		GL segment column
TO_SEGMENT23	VARCHAR2	(25)		GL segment column
TO_SEGMENT24	VARCHAR2	(25)		GL segment column
TO_SEGMENT25	VARCHAR2	(25)		GL segment column
TO_SEGMENT26	VARCHAR2	(25)		GL segment column
TO_SEGMENT27	VARCHAR2	(25)		GL segment column
TO_SEGMENT28	VARCHAR2	(25)		GL segment column
TO_SEGMENT29	VARCHAR2	(25)		GL segment column
TO_SEGMENT30	VARCHAR2	(25)		GL segment column
TRANSFER_FROM_CC_ID	NUMBER	(15)		Transfer from GL Code Combination Id
TRANSFER_TO_CC_ID	NUMBER	(15)		Transfer to GL Code Combination Id

Query Text

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


SELECT FINANCE_HEADER_ID
,      SUPERCEDING_HEADER_ID
,      AUTHORIZER_PERSON_ID
,      ORGANIZATION_ID
,      ADMINISTRATOR
,      CANCELLED_FLAG
,      CURRENCY_CODE
,      DATE_RAISED
,      OBJECT_VERSION_NUMBER
,      PAYMENT_STATUS_FLAG
,      TRANSFER_STATUS
,      TYPE
,      COMMENTS
,      EXTERNAL_REFERENCE
,      INVOICE_ADDRESS
,      INVOICE_CONTACT
,      PAYMENT_METHOD
,      PYM_ATTRIBUTE1
,      PYM_ATTRIBUTE10
,      PYM_ATTRIBUTE11
,      PYM_ATTRIBUTE12
,      PYM_ATTRIBUTE13
,      PYM_ATTRIBUTE14
,      PYM_ATTRIBUTE15
,      PYM_ATTRIBUTE16
,      PYM_ATTRIBUTE17
,      PYM_ATTRIBUTE18
,      PYM_ATTRIBUTE19
,      PYM_ATTRIBUTE2
,      PYM_ATTRIBUTE20
,      PYM_ATTRIBUTE3
,      PYM_ATTRIBUTE4
,      PYM_ATTRIBUTE5
,      PYM_ATTRIBUTE6
,      PYM_ATTRIBUTE7
,      PYM_ATTRIBUTE8
,      PYM_ATTRIBUTE9
,      PYM_INFORMATION_CATEGORY
,      RECEIVABLE_TYPE
,      TRANSFER_DATE
,      TRANSFER_MESSAGE
,      VENDOR_ID
,      CONTACT_ID
,      ADDRESS_ID
,      CUSTOMER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TFH_INFORMATION_CATEGORY
,      TFH_INFORMATION1
,      TFH_INFORMATION2
,      TFH_INFORMATION3
,      TFH_INFORMATION4
,      TFH_INFORMATION5
,      TFH_INFORMATION6
,      TFH_INFORMATION7
,      TFH_INFORMATION8
,      TFH_INFORMATION9
,      TFH_INFORMATION10
,      TFH_INFORMATION11
,      TFH_INFORMATION12
,      TFH_INFORMATION13
,      TFH_INFORMATION14
,      TFH_INFORMATION15
,      TFH_INFORMATION16
,      TFH_INFORMATION17
,      TFH_INFORMATION18
,      TFH_INFORMATION19
,      TFH_INFORMATION20
,      RECEIVING_COST_CENTER
,      PAYING_COST_CENTER
,      TRANSFER_FROM_SET_OF_BOOKS_ID
,      TRANSFER_TO_SET_OF_BOOKS_ID
,      FROM_SEGMENT1
,      FROM_SEGMENT2
,      FROM_SEGMENT3
,      FROM_SEGMENT4
,      FROM_SEGMENT5
,      FROM_SEGMENT6
,      FROM_SEGMENT7
,      FROM_SEGMENT8
,      FROM_SEGMENT9
,      FROM_SEGMENT10
,      FROM_SEGMENT11
,      FROM_SEGMENT12
,      FROM_SEGMENT13
,      FROM_SEGMENT14
,      FROM_SEGMENT15
,      FROM_SEGMENT16
,      FROM_SEGMENT17
,      FROM_SEGMENT18
,      FROM_SEGMENT19
,      FROM_SEGMENT20
,      FROM_SEGMENT21
,      FROM_SEGMENT22
,      FROM_SEGMENT23
,      FROM_SEGMENT24
,      FROM_SEGMENT25
,      FROM_SEGMENT26
,      FROM_SEGMENT27
,      FROM_SEGMENT28
,      FROM_SEGMENT29
,      FROM_SEGMENT30
,      TO_SEGMENT1
,      TO_SEGMENT2
,      TO_SEGMENT3
,      TO_SEGMENT4
,      TO_SEGMENT5
,      TO_SEGMENT6
,      TO_SEGMENT7
,      TO_SEGMENT8
,      TO_SEGMENT9
,      TO_SEGMENT10
,      TO_SEGMENT11
,      TO_SEGMENT12
,      TO_SEGMENT13
,      TO_SEGMENT14
,      TO_SEGMENT15
,      TO_SEGMENT16
,      TO_SEGMENT17
,      TO_SEGMENT18
,      TO_SEGMENT19
,      TO_SEGMENT20
,      TO_SEGMENT21
,      TO_SEGMENT22
,      TO_SEGMENT23
,      TO_SEGMENT24
,      TO_SEGMENT25
,      TO_SEGMENT26
,      TO_SEGMENT27
,      TO_SEGMENT28
,      TO_SEGMENT29
,      TO_SEGMENT30
,      TRANSFER_FROM_CC_ID
,      TRANSFER_TO_CC_ID
FROM OTA.OTA_FINANCE_HEADERS;

Dependencies

[top of page]

OTA.OTA_FINANCE_HEADERS does not reference any database object

OTA.OTA_FINANCE_HEADERS is referenced by following:

APPS: OTA_FINANCE_HEADERS; OTA_FINANCE_HEADERS_WHO