CS_CT_AJR_OB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Subscribing Node
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
4	CNTRCT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Buying Agreement Line Nbr
5	EFFDT	Date(10)	DATE	Effective Date
6	PRICE_ADJUST_SEQ	Number(3,0)	SMALLINT NOT NULL	Price Adjustment Sequence Default Value: 1
7	VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Contract Version number
8	ADJUST_ON_GENERAL	Character(1)	VARCHAR2(1) NOT NULL	General Adjustment N=No Y=Yes Y/N Table Edit Default Value: N
9	ADJUST_ON_UOM	Character(1)	VARCHAR2(1) NOT NULL	Adjust When UOM Matches N=No Y=Yes Y/N Table Edit Default Value: N
10	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
11	ADJUST_ON_SHIPTO	Character(1)	VARCHAR2(1) NOT NULL	Adjust on Shipto N=No Y=Yes Y/N Table Edit Default Value: N
12	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID Prompt Table: %EDITTABLE3
13	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: %EDITTABLE4
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CNTRCT_HDR.CURRENCY_CD Prompt Table: %EDITTABLE
15	FINAL_PRICE	Character(1)	VARCHAR2(1) NOT NULL	Stop Price Calculation Here N=No Y=Yes Y/N Table Edit Default Value: N
16	HARD_PRICE	Character(1)	VARCHAR2(1) NOT NULL	Hard Price N=No Y=Yes Y/N Table Edit Default Value: N
17	IGNORE_IF_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Ignore If Other Adjustments N=No Y=Yes Y/N Table Edit Default Value: N
18	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: %EDITTABLE8
19	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance