REQ_VAL_ADJ_P

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	ADJ_IMPACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Impacts P=Price S=Schedule Value Default Value: P
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: BAS Prompt Table: PO_ADJ_TYPE_VW
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_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition 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	MISC_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Prompt Table: CM_LC_COMPONENT
25	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
26	X_VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Supplier Set ID Prompt Table: SP_SETID_NONVW
27	X_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Third Party Supplier Prompt Table: VNDR_VNDSET_VW
28	X_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Third Party Supplier Location Prompt Table: VNDR_VNDSET_VW
29	LC_COMP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Y/N Table Edit Default Value: N
30	LC_ACCRUAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. Indicates whether this landed cost component is typically accrued upon receipt (i.e., included in inventory value) or whether it is expensed.
31	LC_COMP_CALC	Character(3)	VARCHAR2(3) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement FL=Flat Amt FR=Free FRT=Freight STX=Sales Tax UNT=Unit Amt UTX=Use Tax VAL=% Value VAT=VAT VOL=Volume WT=Weight
32	LC_COMP_ALLOC	Character(3)	VARCHAR2(3) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement MAT=Matl Value QTY=Quantity VOL=Volume WT=Weight
33	LC_COMP_ON_PO	Character(1)	VARCHAR2(1) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Indicates whether this Landed cost component is typically included on the Purchase order to the merchandise supplier Default Value: N
34	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price
35	FLAT_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
36	PCT_VALUE	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Percentage of Value
37	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
38	MISC_CHARGE_ORIGN	Character(1)	VARCHAR2(1) NOT NULL	Misc Charge Origin A=Allocated C=Calculated M=Entered
39	UNIT_PRICE_LC	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price -Landed Cost
40	SALETX_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Sales Tax
41	USETAX_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Use Tax
42	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Non-Recoverable VAT
43	VAT_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate VAT
44	FRGHT_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Freight Charges
45	MISC_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Miscellaneous Charge
46	ACTUAL_CHRG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Actual Charges Flag Y/N Table Edit
47	LC_RTV_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	Return to Vendor for Credit Y/N Table Edit Default Value: N
48	RATE_DATE	Date(10)	DATE	Exchange Rate Date
49	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
50	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier Default Value: 1
51	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1