DP_INTFA_SEQ_VW

(SQL View)
Index Back

Amend Stage, DP_SEQNUMBER

Prompt Table for DP_SEQNUMBER, Forecast Adjustments.

SELECT DISTINCT DP_CONFIGVIEW ,DP_SEQNUMBER FROM PS_DP_INT_ADJDATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
2 DP_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.