SCH_REC_EXPENSE_TXNS

This table stores the transaction details for recalled items that are delivered to expense locations

Details

• Schema: FUSION

• Object owner: SCH

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SCH_REC_EXPENSE_TXNS_PK	EXPENSE_TRACE_DETAIL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXPENSE_TRACE_DETAIL_ID	NUMBER		18	Yes	Unique identifier for product recall expense trace details.
PRODUCT_TRACE_LINE_ID	NUMBER		18	Yes	Unique identifier for product recall traceability details.
TRANSACTION_ID	NUMBER		18		Inventory transaction unique identifier that represents the material issue to expense locations or receiving transaction unique identifier that represents the material receipt to expense locations.
PRIMARY_TRANSACTION_QTY	NUMBER				Transaction quantity in primary unit of measure issued or received into expense locations.
TRANSACTION_DATE	TIMESTAMP				Date on which material is issued or received into expense location.
TRANSACTION_TYPE_ID	NUMBER		18		Transaction type unique identifier representing the inventory transactions used to issue the material to expense locations.
PURCHASE_ORDER	VARCHAR2	60			Purchase Order number against which material is received into expense location.
PO_LINE_NUMBER	NUMBER				Purchase Order number against which material is received into expense location.
REQUISITION_NUMBER	VARCHAR2	60			Requisition number against which material is received into expense location.
REQUISITION_LINE_NUMBER	NUMBER				Requisition Line number against which material is received into expense location.
TRANSFER_ORDER_NUMBER	VARCHAR2	200			Transfer Order Number against which material is issued to expense location.
TRANSFER_ORDER_LINE_NUMBER	NUMBER		9		Transfer Order Line Number against which material is issued to expense location.
TO_DISTRIBUTION_ID	NUMBER		18		Stores distribution_id of inv_transfer_order_distribs for a transfer order which is used to derive expense_account_id in sch_rec_trace_details.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID 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.
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.
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_REC_EXPENSE_TXNS	sch_rec_trace_details	PRODUCT_TRACE_LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
SCH_REC_EXPENSE_TXNS_N1	Non Unique	Default	PRODUCT_TRACE_LINE_ID
SCH_REC_EXPENSE_TXNS_N2	Non Unique	Default	TRANSACTION_TYPE_ID
SCH_REC_EXPENSE_TXNS_U1	Unique	Default	EXPENSE_TRACE_DETAIL_ID