MOT_TERR_RULE_BNDRY_VALS

Details

Schema: FUSION
Object owner: MOT
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
MOT_TERR_RULE_BNDRY_VALS_PK_	LAST_UPDATE_DATE, LAST_UPDATED_BY, TERR_RULE_BNDRY_VALUE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TERR_RULE_BNDRY_VALUE_ID	NUMBER		18	Yes	Territory Rule Boundary Value Identifier
TERR_ACCT_DIM_INTG_ID	NUMBER		18		Foreign key to HZ_PARTIES.
TERR_PRTNR_DIM_INTG_ID	NUMBER		18		Refers to PARTY_ID of ZPM_PARTNER_PROFILES.
TERR_RULE_BOUNDARY_ID	NUMBER		18		Territory Rule Boundary Identifier
TERR_DIMENSION_CODE	VARCHAR2	5			Identifier of territory dimension.
TERR_DIM_INTG_ID	VARCHAR2	80			Foreign key to mot_terr_dim_members_b.
TERR_DIM_HIGH_INTG_ID	VARCHAR2	80			Foreign key to mot_terr_dim_members_b.
INCLUDE_HIERARCHY_FLAG	VARCHAR2	1			Identifies whether the customer or sales account is included in the territory coverage alons with its hierarchy.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			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.
CONFLICT_ID	NUMBER		18		Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
OBJECT_VERSION_NUMBER	NUMBER		9		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.
TERR_GEO_DIM_INTG_ID	NUMBER		18		Geography integration ID
TERR_GEO_DIM_HIGH_INTG_ID	NUMBER		18		Geography High integration Id
ADDRESS_COUNTRY	VARCHAR2	2			Country
ADDRESS_STATE	VARCHAR2	60			State
ADDRESS_PROVINCE	VARCHAR2	60			Province
ADDRESS_COUNTY	VARCHAR2	60			County
ADDRESS_CITY	VARCHAR2	60			City
ADDRESS_POSTAL_CODE	VARCHAR2	60			Postal Code
ADDRESS_HIGH_POSTAL_CODE	VARCHAR2	60			Postal Code
ADDR_ELEMENT_ATTRIBUTE1	VARCHAR2	150			Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE2	VARCHAR2	150			Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE3	VARCHAR2	150			Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE4	VARCHAR2	150			Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE5	VARCHAR2	150			Additional address element to support flexible address format
AUDIT_ACTION_TYPE_	VARCHAR2	10			Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_	VARCHAR2	1000			Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_	VARCHAR2	64			Original Impersonator User.

Indexes

Index	Uniqueness	Tablespace	Columns
MOT_TERR_RULE_BNDRY_VALSN1_	Non Unique	Default	TERR_RULE_BNDRY_VALUE_ID, LAST_UPDATE_DATE
MOT_TERR_RULE_BNDRY_VALSN2_	Non Unique	Default	TERR_RULE_BOUNDARY_ID, TERR_DIMENSION_CODE, TERR_DIM_INTG_ID
MOT_TERR_RULE_BNDRY_VALS_PK_	Unique	Default	LAST_UPDATE_DATE, LAST_UPDATED_BY, TERR_RULE_BNDRY_VALUE_ID
MOT_TERR_RULE_BNDRY_VALS_N3_	Non Unique	Default	LAST_UPDATE_DATE, LAST_UPDATED_BY, TERR_RULE_BOUNDARY_ID, TERR_DIMENSION_CODE, TERR_DIM_INTG_ID, TERR_DIM_HIGH_INTG_ID
MOT_TERR_RULE_BNDRY_VALS_N4_	Non Unique	Default	TERR_DIM_INTG_ID, LAST_UPDATE_DATE, AUDIT_ACTION_TYPE_