SCH_PR_PO_DETAILS

Details

Schema: FUSION
Object owner: SCH
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
SCH_PR_PO_DETAILS_PK	PO_DETAIL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REPLACEMENT_ID	NUMBER		18	Yes	Unique Identifier for a replacement instance initiated for a combination of supplier, supplier site and item in a procurement business unit.
PO_DETAIL_ID	NUMBER		18	Yes	Unique identifier of the purchase order entity that undergoes mass replacement.
REPLACEMENT_DETAIL_ID	NUMBER		18	Yes	Replacement Details Unique Identifier.
REPLACEMENT_ACTION	VARCHAR2	30		Yes	Indicates whether the mass replacement is for Replace action or Reinstate action.
INLINE_REPLACEMENT_FLAG	VARCHAR2	1		Yes	Indicates if inline replacement must be done for this purchase order line.
PO_STATUS	VARCHAR2	30		Yes	Indicates if the Purchase order replacement is Not started or Cancelled or Interfaced or Replaced or Failed.
PO_HEADER_ID	NUMBER		18	Yes	Purchase order header unique identifier which is replaced.
PO_LINE_ID	NUMBER		18	Yes	Purchase order line unique identifier for the purchase order which is replaced.
PO_LINE_LOCATION_ID	NUMBER		18	Yes	Purchase order line location unique identifier for the purchase order which is replaced.
PO_DISTRIBUTION_ID	NUMBER		18	Yes	Purchase order distribution unique identifier for the purchase order which is replaced.
REP_PO_HEADER_ID	NUMBER		18		Purchase order header unique identifier which is created to replace the original purchase order.
REP_PO_LINE_ID	NUMBER		18		Purchase order line unique identifier for the purchase order which is created to replace the original purchase order line.
REP_PO_LINE_LOCATION_ID	NUMBER		18		Purchase order line location unique identifier for the purchase order which is created to replace the original purchase order line location.
REP_PO_DISTRIBUTION_ID	NUMBER		18		Purchase order distribution unique identifier for the purchase order which is created to replace the original purchase order distribution.
QUANTITY_DUE	NUMBER			Yes	Indicates the pending quantity in the purchase order line that needs replacement.
PRICE	NUMBER				Indicates the unit price of the replaced purchase order line.
NOTIFICATION_GROUP_ID	NUMBER		18		This column is used to send notifications based on the grouping of requester or requisition number.
CANCEL_CO_NUM	VARCHAR2	80			Internal identifier for a change order for cancelling the line or document.
CREATE_CO_NUM	VARCHAR2	80			Internal identifier for a change order for creating the line or document.
INTERFACE_HEADER_ID	NUMBER		18		Purchase Order Interface header unique identifier.
INTERFACE_LINE_ID	NUMBER		18		Purchase Order Interface line unique identifier.
INTERFACE_LINE_LOCATION_ID	NUMBER		18		Purchase Order Interface line location unique identifier.
INTERFACE_DISTRIBUTION_ID	NUMBER		18		Purchase Order Interface distribution unique identifier.
BATCH_ID	NUMBER		18		Unique Batch Identifier used for importing the Purchase Orders.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or 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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
SCH_PR_PO_DETAILS	SCH_PR_REPLACEMENTS	REPLACEMENT_ID
SCH_PR_PO_DETAILS	SCH_PR_REPLACEMENT_DETAILS	REPLACEMENT_DETAIL_ID

Indexes

Index	Uniqueness	Tablespace	Columns
SCH_PR_PO_DETAILS_N1	Non Unique	Default	REPLACEMENT_ID, REPLACEMENT_DETAIL_ID, PO_STATUS, REPLACEMENT_ACTION
SCH_PR_PO_DETAILS_N2	Non Unique	Default	REQUEST_ID, REPLACEMENT_ID, PO_STATUS
SCH_PR_PO_DETAILS_N3	Non Unique	Default	NOTIFICATION_GROUP_ID
SCH_PR_PO_DETAILS_N4	Non Unique	Default	PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID
SCH_PR_PO_DETAILS_U1	Unique	Default	PO_DETAIL_ID