AR_FIELDNAM2_LG

(SQL View)
 Index Back

Item Selection Field List


SELECT DISTINCT F.FIELDNAME , N.LANGUAGE_CD , N.LONGNAME , N.SHORTNAME FROM PSRECFIELDDB F , PSDBFLDLABL L , PSDBFLDLABLLANG N WHERE F.RECNAME = 'ITEM' AND F.FIELDNAME = L.FIELDNAME AND (L.DEFAULT_LABEL = 1 AND F.FIELDNAME IN ('AR_SPECIALIST', 'BILL_OF_LADING', 'BROKER_ID', 'BAL_AMT', 'CARRIER_ID', 'CLAIM_NO', 'CLASS_OF_TRADE', 'COLLECTOR', 'CONTRACT_NUM', 'CR_ANALYST', 'DIVISION', 'DOCUMENT', 'INV_PROD_FAM_CD', 'INVOICE', 'ITEM', 'MAJOR_CLASS', 'ORDER_NO', 'PO_REF', 'PROOF_OF_DELIVERY', 'SALES_PERSON', 'SALES_PERSON2', 'USER1', 'USER2', 'USER3', 'USER4', 'USER5', 'USER6', 'USER7', 'USER8', 'USER9', 'USER10')) AND L.FIELDNAME = N.FIELDNAME AND L.LABEL_ID = N.LABEL_ID

  • Related Language Record for AR_FIELDNAM2_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name