AR_FIELDNAM2_VW

(SQL View)
 Index Back

Item Selection Field List


SELECT DISTINCT F.FIELDNAME , L.LONGNAME , L.SHORTNAME FROM PSRECFIELDDB F , PSDBFLDLABL L 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'))

  • Related Language Record: AR_FIELDNAM2_LG

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