JRNL_UP_ADJ_VW

(SQL View)
Index Back

Adjustment Entry View in WC

Adjustment Entry View in GL Workcenter unposting.

SELECT FIELDVALUE ,EFFDT ,XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = 'ADJUSTING_ENTRY' AND FIELDVALUE IN ('N','Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ADJUSTING_ENTRY Character(1) VARCHAR2(1) NOT NULL Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry
2 EFFDT Date(10) DATE Effective Date
3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name