AUC_CNT_ADJ_SET

(SQL View)
Index Back

Contract Price Adjust Sets


SELECT SETID , CNTRCT_ID , CNTRCT_LINE_NBR , ADJ_ITEM_TYPE , EFFDT , EFF_STATUS , ADJ_SET_TYPE FROM PS_CNTRCT_ADJ_SET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
4 ADJ_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Adjust Item Type
C=Category Specific Adjustment
L=Line Specific Adjustment Set
O=Open Item Adjustment Set
T=Template Adjustment

Default Value: L

5 EFFDT Date(10) DATE NOT NULL Effective Date
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

7 ADJ_SET_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Set Type
INC=Increment Adjustments
SUM=Sum All Adjustments

Default Value: SUM