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: PA.PA_INVOICE_FORMAT_DETAILS

Object Details

Object Name:	PA_INVOICE_FORMAT_DETAILS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_INVOICE_FORMAT_DETAILS
Subobject Name:
Status:	VALID

PA_INVOICE_FORMAT_DETAILS stores column values or free
text strings defined for an invoice format. Each column
value or free text string is placed between two specified
positions in the invoice line description.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	3
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_INVOICE_FORMAT_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_SEED	INVOICE_FORMAT_DETAIL_ID
PA_INVOICE_FORMAT_DETAILS_U2	NORMAL	UNIQUE	APPS_TS_SEED	INVOICE_FORMAT_ID START_POSITION
PA_INVOICE_FORMAT_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	INVOICE_FORMAT_ID INVOICE_GROUP_COLUMN_ID
PA_INVOICE_FORMAT_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	INVOICE_GROUP_COLUMN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_FORMAT_DETAIL_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the invoice format detail
INVOICE_FORMAT_ID	NUMBER	(15)	Yes	The identifier of the invoice format to which the invoice format detail line belongs
START_POSITION	NUMBER	(3)	Yes	The start position in which to display the column or text value in the invoice line description
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
END_POSITION	NUMBER	(3)	Yes	The end position in which to display the column or text value in the invoice line description
RIGHT_JUSTIFY_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the column value/text literal should be right justified in its position in the invoice line description
INVOICE_GROUP_COLUMN_ID	NUMBER	(15)		The identifier of the invoice group column whose value is to be displayed in the invoice line description between the two position coordinates
TEXT	VARCHAR2	(240)		The free text to be displayed as literal characters between the start and end positions in the invoice line description

Query Text

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


SELECT INVOICE_FORMAT_DETAIL_ID
,      INVOICE_FORMAT_ID
,      START_POSITION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      END_POSITION
,      RIGHT_JUSTIFY_FLAG
,      INVOICE_GROUP_COLUMN_ID
,      TEXT
FROM PA.PA_INVOICE_FORMAT_DETAILS;

Dependencies

[top of page]

PA.PA_INVOICE_FORMAT_DETAILS does not reference any database object

PA.PA_INVOICE_FORMAT_DETAILS is referenced by following:

APPS: PA_INVOICE_FORMAT_DETAILS