PO_STAGED_DOCUMENT_LINES

PO_STAGED_DOCUMENT_LINES contains information of staged document lines used in process requisition.

Details

• Schema: FUSION

• Object owner: PO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
PO_STAGED_DOCUMENT_LINES_PK	STAGED_DOCUMENT_LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STAGED_DOCUMENT_LINE_ID	NUMBER		18	Yes	Unique number generated by system
STAGED_DOCUMENT_HEADER_ID	NUMBER		18	Yes	Stage header id
REQUISITION_LINE_ID	NUMBER		18	Yes	Requisition line id
SOURCE_DOCUMENT_HEADER_ID	NUMBER		18		Agreement header id
SOURCE_DOCUMENT_LINE_ID	NUMBER		18		Agreement line id
LINE_NUMBER	NUMBER				Line number of the purchase order
QUANTITY	NUMBER				Quantity ordered
UNIT_PRICE	NUMBER				Unit price in functional currency
AMOUNT	NUMBER				Amount on the req line
AUTO_STAGED_FLAG	VARCHAR2	1			Auto staged flag
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Tablespace	Columns
PO_STAGED_DOCUMENT_LINES_N1	Non Unique	Default	REQUISITION_LINE_ID
PO_STAGED_DOCUMENT_LINES_U1	Unique	Default	STAGED_DOCUMENT_LINE_ID