PROD_CSTALS_LNG

(SQL Table)
Index Back

Customer Prod. Alias Rel. Lang

This 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.

  • Related Language Record for PROD_CUST_ALIAS
  • # 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