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 | SetID |
2 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
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 | Last Maintained By Operator ID |