AR_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 = 'ITEM' AND F.FIELDNAME = L.FIELDNAME AND L.DEFAULT_LABEL = 1 AND F.FIELDNAME NOT IN ('ITEM_LINE' , 'ENTRY_EVENT' , 'ITEM_LINE_ORG' , 'ITEM_SEQ_NUM' , 'RT_TYPE' , 'RATE_MULT' , 'RATE_DIV' , 'BAL_AMT_LAST' , 'ENTRY_AMT', 'VAT_DCLRTN_POINT', 'VAT_RECALC_FLAG', 'COUNTRY_VAT_BILLFR', 'COUNTRY_VAT_BILLTO', 'COUNTRY_SHIP_TO', 'COUNTRY_SHIP_FROM', 'VAT_TREATMENT_BAL', 'VAT_CALC_GROSS_NET', 'VAT_EXCPTN_TYPE', 'VAT_EXCPTN_CERTIF', 'VAT_RGSTRN_BUYER', 'VAT_ROUND_RULE', 'BUSINESS_UNIT_BI', 'BUSINESS_UNIT_OM', 'ADDRESS_SEQ_NUM', 'CONSOL_BUS_UNIT', 'PROCESS_INSTANCE', 'USER_AMT1', 'USER_AMT2', 'USER_AMT3', 'USER_AMT4', 'USER_AMT5', 'USER_AMT6', 'USER_AMT7', 'USER_AMT8', 'USER_DT1', 'USER_DT2', 'USER_DT3', 'USER_DT4')

# 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