WS_FIELDNAME_VW

(SQL View)
 Index Back

Item Selection Fields List


SELECT F.FIELDNAME , L.LONGNAME , L.SHORTNAME FROM PSRECFIELD F , PSDBFLDLABL L WHERE F.RECNAME = 'WS_ITEM' AND F.FIELDNAME = L.FIELDNAME AND L.DEFAULT_LABEL = 1 AND F.FIELDNAME IN ('BILL_OF_LADING', 'BROKER_ID', 'CARRIER_ID', 'CLASS_OF_TRADE', 'CONTRACT_NUM', 'CR_ANALYST', 'CUST_DB_NUM', 'CLAIM_NO', 'DIVISION', 'DM_REASON', 'DOCUMENT', 'ENTRY_REASON', 'INVOICE', 'INV_PROD_FAM_CD', 'ITEM', 'MAJOR_CLASS', 'ORDER_NO', 'PAYMENT_ID', 'PO_REF', 'PROOF_OF_DELIVERY', 'SALES_PERSON', 'SALES_PERSON2', 'USER1', 'USER2', 'USER3', 'USER4', 'USER5', 'USER6', 'USER7', 'USER8', 'USER9', 'USER10')

# 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