SETIDDefault Value: OPR_DEF_TBL_FS.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 |
SetID
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 | 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 | Last Maintained By Operator ID |