SETIDCUST_IDPRODUCT_IDPrompt Table: %EDITTABLE2
PRODUCT_ALIASLANGUAGE_CDPROD_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 | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |