SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
CATALOG_NBREFFDTDefault Value: %date
E=Exclusive
I=Inclusive
Default Value: I
A=Active
I=Inactive
Default Value: A
PRODCTLG_TBL(SQL Table) |
Index Back |
|---|---|
Product Catalog TableThis 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_RB.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 | INCL_EXCL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Include/Exclude Type
E=Exclusive I=Inclusive Default Value: I |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |
| 8 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |