| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SUP_INSTALL_KEY |
Character(1) |
VARCHAR2(1) NOT NULL |
Bid Factor List Items
Default Value: 1
|
| 2 |
SUP_LOG_INVITE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Invitation Activity Log
Y/N Table Edit
|
| 3 |
SYS_GEN_USR_PWD |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generates User Password
Y/N Table Edit
|
| 4 |
REG_SUP_AS_BIDDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Registering Supplier as Bidder
Y/N Table Edit
|
| 5 |
REG_SUP_AS_NEWSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Register Supplier as New
Y/N Table Edit
|
| 6 |
SUP_NEW_USER_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
New User for Existing Supplier
Y/N Table Edit
|
| 7 |
MAINT_SUP_PROFILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain Supplier Profile
Y/N Table Edit
|
| 8 |
SUP_DPLCT_TIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Duplicate TIN
N=Do not Check
R=Reject
W=Warning
Default Value: N
|
| 9 |
REG_INSTRUCTION |
Long Character |
CLOB |
Registration Instructions
|
| 10 |
REG_USER_INSTRUCT |
Long Character |
CLOB |
User Registration Instructions
|
| 11 |
SCR_BIDDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Bidder Profile Change
Y/N Table Edit
|
| 12 |
SCR_SUPPLIER |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Supplier Profile Chg
Y/N Table Edit
Default Value: N
|
| 13 |
SCR_INSTRUCTION |
Long Character |
CLOB |
Change Request Instructions
|
| 14 |
REG_ID_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Identifying Information Instr
|
| 15 |
REG_ADDR_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Address Instructional Text
|
| 16 |
REG_CNTCT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Contact Instructional Test
|
| 17 |
REG_PYMT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Payment Instructional Text
|
| 18 |
REG_CAT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Category Instructional Text
|
| 19 |
SCR_ADDR_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Address Instructional Text
|
| 20 |
REG_SUBMIT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Submit Instructional Text
|
| 21 |
SCR_ID_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Company Profile Instructions
|
| 22 |
SCR_CNTCT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Contact Instructional Text
|
| 23 |
SCR_PYMT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Payment Instructional Text
|
| 24 |
SCR_CAT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Categorization Instructions
|
| 25 |
SCR_SUBMIT_INST |
Character(254) |
VARCHAR2(254) NOT NULL |
Submit Instructional Text
|
| 26 |
PASSCD_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Password Access
1=No Password Required
2=Supplier Specified Password
3=System Generated Password
Default Value: 1
|
| 27 |
WARNING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Issue Warning Flag
Y/N Table Edit
Default Value: Y
|
| 28 |
ALLOW_ED_FOR_SUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Registration Request
Y/N Table Edit
Default Value: N
|
| 29 |
ALLOW_ED_FOR_BIDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Bidder Registration Request
Y/N Table Edit
Default Value: N
|
| 30 |
ALLOW_ED_FOR_SCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Change Request
Y/N Table Edit
Default Value: N
|
| 31 |
SUP_EXT_LS_BR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup/Select for External Bidder Registration Template
Y/N Table Edit
Default Value: N
|
| 32 |
SUP_EXT_LS_RS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup/Select for External Supplier Change Request Template
Y/N Table Edit
Default Value: N
|
| 33 |
SUP_EXT_LS_SR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup/Select for External Supplier Registration Template
Y/N Table Edit
Default Value: N
|
| 34 |
SUP_INT_LS_BR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup/Select for Internal Bidder Registration Template
Y/N Table Edit
Default Value: N
|
| 35 |
SUP_INT_LS_RS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup/Select for Internal Supplier Change Request Template
Y/N Table Edit
Default Value: N
|
| 36 |
SUP_INT_LS_SR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup/Select for Internal Supplier Registration Template
Y/N Table Edit
Default Value: N
|
| 37 |
SUP_HISTORY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days History Deafult
Default Value: 30
|
| 38 |
SUP_OBSOLETE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days Obsolete Default
Default Value: 180
|