FA_INVENTORY

This table stores audit trail information for the asset physical inventory.

Details

• Schema: FUSION

• Object owner: FA

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
FA_INVENTORY_PK	INVENTORY_NAME

Columns

Name	Datatype	Length	Not-null	Comments
INVENTORY_NAME	VARCHAR2	240	Yes	User entered physical inventory name.
BOOK_TYPE_CODE	VARCHAR2	30	Yes	Name of the asset book for which physical inventory was taken.
START_DATE	DATE			The data on which the physical verification of the assets has started.
END_DATE	DATE			The data on which the physical verification of the assets has ended.
RUN_PURGE_FLAG	VARCHAR2	1		Indicates whether the physical inventory data is purged.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
FA_INVENTORY_U1	Unique	Default	INVENTORY_NAME