MSC_HVGOP_CUSTOMER_SRC_RULE_UT

Table data used for testing customer sourcing rules.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSC_HVGOP_CUST_SRC_RULE_PK	CUSTOMER_SOURCING_RULE_ID, SOURCE_ID1, SOURCE_ID2, SHIP_METHOD

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CUSTOMER_SOURCING_RULE_ID	NUMBER		18	Yes	Field is used to indicate sourcing rule id	Active
SOURCING_RULE_NAME	VARCHAR2	64			Field is used to indicate sourcing rule name	Active
SOURCE_ID1	NUMBER		18	Yes	Field is used to indicate source id1 of sourcing rule	Active
SOURCE_ID2	NUMBER		18	Yes	Field is used to indicate source id2 of sourcing rule	Active
SOURCE_SYSTEM_ID	NUMBER		18		Field is used to indicate source system id	Active
RANK	NUMBER		18		Field is used to indicate rank of sourcing rule	Active
SHIP_METHOD	VARCHAR2	64		Yes	Field is used to indicate ship method associated	Active
ENABLE_DATE	TIMESTAMP			Yes	Field is used to indicate the enable date of sourcing rule	Active
DISABLE_DATE	TIMESTAMP				Field is used to indicate disable date of sourcing rule	Active
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_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
EXCLUDE_ITEMS	VARCHAR2	256			Field is used to indicate items to be excluded from sourcing.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_HVGOP_CUST_SRC_RULE_UT_U1	Unique	Default	CUSTOMER_SOURCING_RULE_ID, SOURCE_ID1, SOURCE_ID2, SHIP_METHOD