SETIDCUST_IDPRODUCT_IDPrompt Table: %EDITTABLE2
PRODUCT_ALIASPrompt Table: CP_CFGCD_CST_VW
PROD_CUST_ALIAS(SQL Table) |
Index Back |
|---|---|
Customer Product AliasThis record hold the cross reference between Order Management Product ID and Customer Part Number. Use of this record is optional. This table is checked during Quote and Order entry when a Product ID is entered. If an entry exists for the Product ID, the Customer Part Number is automatically defaulted to the field on the quote or order. |
| # | 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. |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: %EDITTABLE2 |
| 4 | PRODUCT_ALIAS |
Character(18) | VARCHAR2(18) NOT NULL | Product Alias |
| 5 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table: CP_CFGCD_CST_VW |
| 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. |