OMBCK_PPRC_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ADJUSTMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Amount
3	ADJUSTMENT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Adjustment Percent
4	BREAK_ID	Number(10,0)	DECIMAL(10) NOT NULL	Price Break ID
5	BREAK_QTY_HIGH	Number(15,4)	DECIMAL(14,4) NOT NULL	Upper Quantity/Amount
6	BREAK_QTY_LOW	Number(15,4)	DECIMAL(14,4) NOT NULL	Low Quantity/Amount
7	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
8	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID
9	COMMODITY_CD	Character(10)	VARCHAR2(10) NOT NULL	Commodity Code
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
12	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
13	DATE_BEGIN	Date(10)	DATE	Start Date
14	DATE_END	Date(10)	DATE	End Date
15	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
16	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
17	EFF_STATUS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Effective Status Flag N=No Effective Status Y=Effective Status Exists
18	EFFDT	Date(10)	DATE	Effective Date
19	EOEP_ADJUST_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Adjustment Type Bill-Back or Off-Invoice AC=Bill Back AMT=Amount OI=Off-Invoice OVR=Price Override PCT=Percent
20	EOEP_ARB_ID	Character(10)	VARCHAR2(10) NOT NULL	Arbitration Plan
21	EOEP_KEY_CD	Character(50)	VARCHAR2(50) NOT NULL	Price Rule Key Code
22	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
23	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
24	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code
25	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
26	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
27	OM_ADJST_AMT	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	Order Adjustment Amount
28	ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Total Order Flag
29	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
30	PPRC_FREEBIE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Pricing giveaway type. LINE=Per Line ORD=Per Order
31	PPRC_KEY_VALUE1	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 1
32	PPRC_KEY_VALUE2	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 2
33	PPRC_KEY_VALUE3	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 3
34	PPRC_KEY_VALUE4	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 4
35	PPRC_KEY_VALUE5	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 5
36	PPRC_KEY_VALUE6	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 6
37	PPRC_KEY_VALUE7	Character(60)	VARCHAR2(60) NOT NULL	Price Key value 7
38	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
39	PPRC_LOAD_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Weight/Volume Only Pricing
40	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
41	PRICE_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Price List ID
42	PRICE_PROGRAM	Character(10)	VARCHAR2(10) NOT NULL	Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
43	PRICE_PROTECTED	Character(1)	VARCHAR2(1) NOT NULL	Price Protected
44	PRICE_SET_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Price Set Type 99=Standard Discount A=Price Override F=Cascading S=Summed Adjustments Z=Giveaway
45	PRICE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Price Type P=Extended Price Q=Quantity V=Volume W=Weight
46	PRICEPGM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exclusive Pricing Only N=No Y=Yes
47	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
48	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
49	PRODUCT_ID_PROMO	Character(18)	VARCHAR2(18) NOT NULL	Promotional Product ID
50	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
51	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
52	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
53	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
54	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
55	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
56	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
57	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method
58	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
59	START_DT	Date(10)	DATE	Start Date
60	STOP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Stop Search Here
61	TAKE_ADJUSTMENT	Character(1)	VARCHAR2(1) NOT NULL	Take Adjustment
62	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
63	UOM_PROMO	Character(4)	VARCHAR2(4) NOT NULL	Unit of Measure (promo prod)