CS_CT_AJR_IB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	SUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Subscribing Node
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
5	CNTRCT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Buying Agreement Line Nbr
6	EFFDT	Date(10)	DATE	Effective Date
7	PRICE_ADJUST_SEQ	Number(3,0)	SMALLINT NOT NULL	Price Adjustment Sequence Default Value: 1
8	VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Contract Version number Default Value: 1
9	ADJUST_ON_GENERAL	Character(1)	VARCHAR2(1) NOT NULL	General Adjustment N=No Y=Yes Y/N Table Edit Default Value: N
10	ADJUST_ON_UOM	Character(1)	VARCHAR2(1) NOT NULL	Adjust When UOM Matches N=No Y=Yes Y/N Table Edit Default Value: N
11	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDITTABLE2
12	ADJUST_ON_SHIPTO	Character(1)	VARCHAR2(1) NOT NULL	Adjust on Shipto N=No Y=Yes Y/N Table Edit Default Value: N
13	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID Prompt Table: %EDITTABLE3
14	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: %EDITTABLE4
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CNTRCT_HDR.CURRENCY_CD Prompt Table: %EDITTABLE
16	FINAL_PRICE	Character(1)	VARCHAR2(1) NOT NULL	Stop Price Calculation Here N=No Y=Yes Y/N Table Edit Default Value: N
17	HARD_PRICE	Character(1)	VARCHAR2(1) NOT NULL	Hard Price N=No Y=Yes Y/N Table Edit Default Value: N
18	IGNORE_IF_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Ignore If Other Adjustments N=No Y=Yes Y/N Table Edit Default Value: N
19	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: %EDITTABLE8