MSC_HVGOP_ORG_UT

Table data used for testing organization.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_HVGOP_ORG_UT_PK	ORGANIZATION_ID, INSTANCE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ORGANIZATION_ID	NUMBER		18	Yes	Field is used to indicate the organization id	Active
SHIPPING_CALENDAR_ID	NUMBER		18		Field is used to indicate shipping calendar id of the organization	Active
RECEIVING_CALENDAR_ID	NUMBER		18		Field is used to indicate receiving calendar id of the organization	Active
PRODUCTION_CALENDAR_ID	NUMBER		18		Field is used to indicate production calendar id of the organization	Active
SNM_CUSTOMER_CODE	VARCHAR2	64			Field is used to indicate snm customer code	Active
IS_FIXED_DATE	VARCHAR2	1			Field is used to indicate its fixed date org	Active
IS_DROP_SHIP_VALIDATION_ORG	VARCHAR2	1			Field is used to indicate if org is drop ship validation org	Active
INSTANCE_ID	NUMBER			Yes	Field is used to indicate insatance id	Active
TIMEZONE_CODE	VARCHAR2	64			Field is used to indicate the timezone of the organization
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.
SALES_ORDER_COLL_START	DATE				Indicates the time when last sales order collection started. This column is populated by collection flow. If current order promising request time is between SALES_ORDER_COLL_START and SALES_ORDER_COLL_END then order promising will write these requests to MSC_HVGOP_LATEST_DEMANDS table. Null value indicates no need to store demands separately.
SALES_ORDER_COLL_END	DATE				Indicates the time when last sales order collection ended. This column is populated by collection flow. If current order promising request time is between SALES_ORDER_COLL_START and SALES_ORDER_COLL_END then order promising will write these requests to MSC_HVGOP_LATEST_DEMANDS table. If SALES_ORDER_COLL_START is Not Null and SALES_ORDER_COLL_END is Null it means the Collection has started but it's not finished yet, which means the processed demands still need to be stored in MSC_HVGOP_LATEST_DEMANDS

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_HVGOP_ORG_UT_U1	Unique	Default	ORGANIZATION_ID, INSTANCE_ID