SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
COMPETITOR_CDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
COMPETITOR_CD(SQL Table) |
Index Back |
|---|---|
Competitor TableThis table is for users who wish to track competitive product information. The table allows users to set up competitor codes and then associate these codes with their own products in case they wish to record who their competition is for business. In addition, users may record on Quotations and Orders if they won or lost business to competitors. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | COMPETITOR_CD |
Character(6) | VARCHAR2(6) NOT NULL | Competitor Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |