PO_VAL_ADJ_WK1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
5	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
6	ADJ_NBR	Number(3,0)	SMALLINT NOT NULL	Adjustment Sequence
7	ADJ_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Adjustment Type BAS=Base CNT=Contract FRT=Freight OTH=Other TAX=Tax TBL=Table Default Value: OTH
8	BASE_PRICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Base Price Type C=Contract I=Item Std R=RFQ U=User V=Supplier Std
9	ADJ_TBL_UOM_FLG	Character(1)	VARCHAR2(1) NOT NULL	UOM Adjustment N=No Y=Yes Y/N Table Edit Default Value: N
10	ADJ_TBL_SHIPTO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Adjust on Shipto Flag Y/N Table Edit Default Value: N
11	QTY_MIN	Number(16,4)	DECIMAL(15,4) NOT NULL	Minimum Quantity
12	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
13	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code Prompt Table: TAX_SU_HDR_VW
14	ADJ_TYPE_OTHER	Character(50)	VARCHAR2(50) NOT NULL	Other Adjustment Type
15	ADJ_METH	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Method A=Amount P=Percentage Default Value: A
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	ADJ_AMT	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Adjustment Amount
18	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
19	ADJ_AMT_BSE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Adjustment Amount - Base
20	ADJ_PCT	Signed Number(11,4)	DECIMAL(9,4) NOT NULL	Adjust Percentage
21	ADJ_PCT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Price To Base Percentage On INC=Calculated SUM=Base Default Value: SUM
22	APPLY_ADJ	Character(1)	VARCHAR2(1) NOT NULL	Apply Adjustment N=No Y=Yes Y/N Table Edit Default Value: Y
23	NOT_APPLY_REASON	Character(50)	VARCHAR2(50) NOT NULL	Why Adjustment Not Applied
24	ADJ_IMPACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Impacts P=Price S=Schedule Value Default Value: P
25	DECIMAL_POS	Number(2,0)	SMALLINT NOT NULL	Decimal Position
26	DECIMAL_POS_BSE	Number(2,0)	SMALLINT NOT NULL	Base Cur Decimal Positions