FIELDNAMEFIELDVALUEI=Internal
P=Public
Default Value: I
N=Do Not Display
Y=Allow User Entry
Default Value: N
SUP_INFOCD_VW(SQL View) |
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. |
| SELECT c.fieldname , c.fieldvalue , x.xlatlongname ,c.sup_user_type , c.sup_data_entry_opt , c.sup_nb_attribute , c.sup_rb_attribute ,c.sup_ns_attribute , c.sup_rs_attribute , c.mpa FROM PS_SUP_INFO_CD_DFN c , psxlatitem x WHERE c.fieldname = x.fieldname AND c.fieldvalue = x.fieldvalue AND x.eff_status = 'A' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SUP_USER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
User Type
I=Internal P=Public Default Value: I |
| 5 | SUP_DATA_ENTRY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Data Entry Option
N=Do Not Display Y=Allow User Entry Default Value: N |
| 6 | SUP_NB_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL | New Bidder |
| 7 | SUP_RB_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL | Request Change Bidder |
| 8 | SUP_NS_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL | New Supplier |
| 9 | SUP_RS_ATTRIBUTE | Character(1) | VARCHAR2(1) NOT NULL | Request Change Supplier |
| 10 | MPA | Character(1) | VARCHAR2(1) NOT NULL | eSettlements |