1. Tables and Views for Sales, Fusion Service, and Field Service
  2. MOT_TERR_AFFCT_BATCHES

MOT_TERR_AFFCT_BATCHES

This table is used for improving the reassignment of sales territories to work objects after a territory realignment process occurs, or when stage data is propogated. Specifically this table will hold the batches of territories that are affected by realignment. Each realignment will cause a batch to be created and affected territories will be grouped under this batch.

Details

  • Schema: FUSION

  • Object owner: MOT

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MOT_TERR_AFFCT_BATCHES_PK

TERR_AFFCT_BATCH_ID

Columns

Name Datatype Length Precision Not-null Comments
TERR_AFFCT_BATCH_ID NUMBER 18 Yes Primary Key
TYPE_CODE VARCHAR2 30 Yes Identifies type of Batch
CREATED_ON_DATE TIMESTAMP Yes This indicates the date and time when the batch was inserted into the table.
CLOSED_ON_DATE TIMESTAMP This indicates the date and time when the batch status of the row was changed to "CLOSED".
STATUS_CODE VARCHAR2 30 Yes This column indicates the state of the batch row. A status 'OPEN' indicates that the batch record has just been created. A status 'CLOSED' indicates that the list of affected territories associated with this batch record has been written to territory reassignment table.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.
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.
CONFLICT_ID NUMBER 18 Yes 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).

Foreign Keys

Table Foreign Table Foreign Key Column
mot_terr_affct_batch_lns mot_terr_affct_batches TERR_AFFCT_BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
MOT_TERR_AFFCT_BATCHES_PK Unique Default TERR_AFFCT_BATCH_ID