CNTRCT_ADJSET_W

(SQL Table)
Index Back

Contract Price Adjust Sets

Contract Price Adjust Sets

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
4 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
5 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
6 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
7 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
8 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: CNTRCT_HDR.CNTRCT_BEGIN_DT

9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

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

Default Value: SUM

11 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
12 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.