SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
OFFERING_CATEGORYPrompt Table: DST_CODE_UAR_VW
1=None
2=Duplicate
3=Too Long
Y/N Table Edit
UPG_CA_OFF_CAT(SQL Table) |
Index Back |
|---|---|
Contract Offering Categories |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | OFFERING_CATEGORY |
Character(20) | VARCHAR2(20) NOT NULL | Offering Category |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | DST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Distribution Code
Prompt Table: DST_CODE_UAR_VW |
| 6 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 7 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 8 | UPG_ISSUE | Character(1) | VARCHAR2(1) NOT NULL |
Issue
1=None 2=Duplicate 3=Too Long |
| 9 | UPG_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Upgrade?
Y/N Table Edit |
| 10 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |