MOT_TERR_AFFCT_BATCH_LNS
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 by serving as a placeholder for all the affected territories. In addition, the affected parent, sibling and child territories will also be listed in this table. The territories listed in this table are grouped under batches that are listed in the territory realignment batch s table. The respective work objects will use this table to identify which work object transactions will need to modify their territory assignments as a result of the territories that have been changed.
Details
-
Schema: FUSION
-
Object owner: MOT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MOT_TERR_AFFCT_BATCH_LNS_PK |
TERR_AFFCT_BATCH_LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TERR_AFFCT_BATCH_LINE_ID | NUMBER | 18 | Yes | Primary Key. | |
TERR_AFFCT_BATCH_ID | NUMBER | 18 | Yes | Foreign key to mot_terr_affct_batches | |
TERR_PROPOSAL_ID | NUMBER | 18 | Foreign key to mot_terr_proposals | ||
TERRITORY_ID | NUMBER | 18 | Yes | Territory Identifier | |
TERRITORY_VERSION_ID | NUMBER | 18 | Yes | Foreign key to mot_territories | |
REASON_CODE | VARCHAR2 | 30 | Yes | Reason Code. | |
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 |
MOT_TERR_AFFCT_BATCH_LNS | mot_terr_proposals | TERR_PROPOSAL_ID |
MOT_TERR_AFFCT_BATCH_LNS | mot_territories | TERRITORY_VERSION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MOT_TERR_AFFCT_BATCH_LNS_N1 | Non Unique | Default | TERR_AFFCT_BATCH_ID |
MOT_TERR_AFFCT_BATCH_LNS_PK | Unique | Default | TERR_AFFCT_BATCH_LINE_ID |