PROD_CSTALS_LNG(SQL Table) |
Index Back |
---|---|
Customer Prod. Alias Rel. LangThis 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |