FIELDNAMEFIELDVALUEI=Internal
P=Public
Default Value: I
N=Do Not Display
Y=Allow User Entry
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
SUP_INFO_CD_DFN(SQL Table) |
Index Back |
|---|---|
Registration Attribute ConfigSupplier Template Attribute configuration. This table is a system table that controls the attributes displayed in the grid. All the xlat values for SUP_HDR_INFO_CD and SUP_LOC_INFO_CD should be in this table with the display details. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | FIELDVALUE |
Character(4) | VARCHAR2(4) NOT NULL | Field Value |
| 3 | SUP_USER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
User Type
I=Internal P=Public Default Value: I |
| 4 | SUP_DATA_ENTRY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Data Entry Option
N=Do Not Display Y=Allow User Entry |
| 5 | SUP_NB_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL |
New Bidder
Y/N Table Edit |
| 6 | SUP_RB_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL |
Request Change Bidder
Y/N Table Edit |
| 7 | SUP_NS_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL |
New Supplier
Y/N Table Edit |
| 8 | SUP_RS_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL |
Request Change Supplier
Y/N Table Edit |
| 9 | MPA | Character(1) | VARCHAR2(1) NOT NULL |
eSettlements
Y/N Table Edit |