[Home] [Help] [Dependency Information]
Object Name: | OP_SLSR_MST |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.OP_SLSR_MST |
Subobject Name: | |
Status: | VALID |
Sales representative master table is updated through a data synchronization program invoked in OPM. Sales reps are maintained in Oracle Receivables and the data synchronization program updates the OPM table with the required sales rep information.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OP_SLSR_MST_PK | NORMAL | UNIQUE | APPS_TS_SEED | SLSREP_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SLSREP_CODE | VARCHAR2 | (8) | Yes | Unique identifier of a sales representative |
SLSREP_NAME | VARCHAR2 | (40) | Yes | Sales rep name |
ADDR_ID | NUMBER | (10) | Pointer to sy_addr_mst which contains address for the sales rep | |
PRICESLSREP_CODE | VARCHAR2 | (8) | Sales rep code for use with pricing; must be valid salesrep_code. Not currently used. | |
SLSREP_TYPE | NUMBER | (5) | Yes | Type of sales rep; defined by user. |
SLSREP_CLASS | VARCHAR2 | (8) | Class or grouping to which this sales rep belongs. | |
MGRSLSREP_CODE | VARCHAR2 | (8) | The manager of the sales rep; must be a valid, existing salesrep_code | |
SLSREP_TERRITORY | VARCHAR2 | (8) | Unvalidated field which designates the sales rep territory | |
COMMISSION_CODE | VARCHAR2 | (8) | Primary commission code for this sales rep. | |
SLSREP_PHONE1 | VARCHAR2 | (20) | Phone number for the sales rep | |
SLSREP_PHONE2 | VARCHAR2 | (20) | Second phone number for the sales rep. | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
CO_CODE | VARCHAR2 | (4) | Company for which a sales rep code is defined. A NULL value indicates the sales rep is defined for all companies. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
REQUEST_ID | NUMBER | (15) | Concurrent who column |
Cut, paste (and edit) the following text to query this object:
SELECT SLSREP_CODE
, SLSREP_NAME
, ADDR_ID
, PRICESLSREP_CODE
, SLSREP_TYPE
, SLSREP_CLASS
, MGRSLSREP_CODE
, SLSREP_TERRITORY
, COMMISSION_CODE
, SLSREP_PHONE1
, SLSREP_PHONE2
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TRANS_CNT
, DELETE_MARK
, TEXT_CODE
, CO_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM GML.OP_SLSR_MST;
GML.OP_SLSR_MST does not reference any database object
GML.OP_SLSR_MST is referenced by following:
|
|
|