FND Design Data [Home] [Help]

Table: JTF_RS_SALESREPS

Product: JTF - CRM Foundation
Description: This table stores information about salesreps. Salesrep_id is the primary key. If resource category is 'OTHERS' then salesrep_number and org_id are unique.
Implementation/DBA Data: TableJTF.JTF_RS_SALESREPS
Primary Key: JTF_RS_SALESREPS_PK
  1. ColumnSALESREP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_RS_SALESREPS FK Joins to TableJTF_RS_RESOURCE_EXTNS JTF_RS_SALESREPS.RESOURCE_ID
TableFII_AR_SALES_CREDITS FK Joins to JTF_RS_SALESREPS FII_AR_SALES_CREDITS.SALESREP_ID
TableJTF_RS_SRP_TERRITORIES FK Joins to JTF_RS_SALESREPS JTF_RS_SRP_TERRITORIES.SALESREP_ID