RCS_QS_ORG_SPECS

This table contains the specification data used by Quick Setup to rapidly construct an Inventory Organization. This table information is accessed with the Quick Setup action available in the Facilities functional area when setting up Manufacturing and Supply Chain Materials Management.

Details

• Schema: FUSION

• Object owner: RCS

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
RCS_QS_ORG_SPECS_PK	QS_ORG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
QS_ORG_ID	NUMBER		18	Yes	Quick Setup Organization identifier.	Active
ORGANIZATION_CODE	VARCHAR2	18		Yes	Organization Code of the Organization	Active
NAME	VARCHAR2	240			The name of the inventory organization constructed by Quick Setup. The name must be unique, and will also be used to default the organization code as well.	Active
MASTER_ORGANIZATION_ID	NUMBER		18		Identifier of the Master Organization.	Active
BUSINESS_UNIT_ID	NUMBER		18		Identifier of the Business Unit with the Materials Management business function assigned. If only one exists, it will be set as the value.	Active
INVENTORY_FLAG	VARCHAR2	1		Yes	Inventory Flag	Active
MFG_FLAG	VARCHAR2	1			Manufacturing flag	Obsolete
ORGANIZATION_ID	NUMBER		18		Organization Identifier created by a Quick setup run	Active
LOCATION_ID	NUMBER		18		Location associated to the created inventory organization.	Active
RUN_ID	NUMBER		18	Yes	Quick setup Run Identifier.	Active
DELETE_FLAG	VARCHAR2	1			Delete Flag	Active
ORG_ADDL_USAGE	VARCHAR2	32			Additional usage of organization. Allows user to indicate if organization will also conduct manufacturing or maintenance activities. Default value is ??NONE?? for None.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
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.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
RCS_QS_ORG_SPECS_U1	Unique	FUSION_TS_TX_IDX	QS_ORG_ID	Active