AR_FIELDNAM3_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', 'CARRIER_ID', 'CLAIM_DT', 'CLAIM_NO', 'CLASS_OF_TRADE', 'COLLECTION_DT', 'COLLECTION_STATUS', 'COLLECTOR', 'CONTRACT_NUM', 'CR_ANALYST', 'DEDUCTION_DT', 'DEDUCTION_STATUS', 'DISPUTE_STATUS', 'DIVISION', 'DOCUMENT', 'DUE_DT', 'INV_PROD_FAM_CD', 'INVOICE', 'MAJOR_CLASS', 'MEMO_STATUS_CD', 'MERCH_TYPE', 'NET_REF_ID', 'NETTING_SW', 'ORDER_NO', 'PAYMENT_METHOD', 'PYMNT_TERMS_CD', 'REF_REASON', 'PO_REF', 'PPRC_PROMO_CD', 'PROOF_OF_DELIVERY', 'REVALUE_FLAG', 'SALES_PERSON', 'SALES_PERSON2', 'SHIP_TO_CUST_ID', 'SOLD_TO_CUST_ID')

# 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