SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CATALOG_NBREFFDTDefault Value: %date
LANGUAGE_CDPRODCTLG_TB_LNG(SQL Table) |
Index Back |
|---|---|
Product Catalog Related Lang.This record is the "header" of the Product Catalog. This record will have links to Products and Product Groups which will show the Products in an exclusive or inclusive catalog. |
| # | 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_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CATALOG_NBR |
Character(18) | VARCHAR2(18) NOT NULL | Catalog Number |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |