RUN_OM_ADJWS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
6	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
7	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
8	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
9	CB_CONTRACT_ID	Character(25)	VARCHAR2(25) NOT NULL	Claimback Contract ID
10	CB_COST_ADJ	Number(28,4)	DECIMAL(27,4) NOT NULL	Unit Cost
11	CB_MARGIN	Character(1)	VARCHAR2(1) NOT NULL	Claimback Margin Impact B=Primary and Secondary Margin N=None P=Primary Margin S=Secondary Margin
12	CUST_NAME	Character(40)	VARCHAR2(40) NOT NULL	Name
13	PRICE_PROT_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks Y/N Table Edit Default Value: N
14	PRICE_PROTECTED	Character(1)	VARCHAR2(1) NOT NULL	Price Protected Y/N Table Edit Default Value: N
15	PROD_PRICE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pricing Option 0=Regular 1=KVI 2=NDP
16	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
17	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
18	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
19	NET_UNIT_PRICE_NEW	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks
20	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage