OMPB_ADJDRG_OUT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	OMPB_BOOK_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Customer Price Book Definition ID
5	OMPB_BOOK_ID	Character(30)	VARCHAR2(30) NOT NULL	Customer Price Book ID
6	OMPB_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	price book instance
7	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
8	PRODUCT_UOM	Character(3)	VARCHAR2(3) NOT NULL	Product Unit of Measure
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	EOEP_RANGE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Range ID
11	EOEP_DATE_NAME	Character(15)	VARCHAR2(15) NOT NULL	Date Name
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	DATE_BEGIN	Date(10)	DATE	Start Date
14	DATE_END	Date(10)	DATE	End Date
15	OMPB_ACTIVE_ROW	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if the row in the extract table is avtive/valid data. This is not really the same as effective date/status related. 1=Active Row 2=Inactive Row
16	OMPB_ACTIVE_ROWX	Character(30)	VARCHAR2(30) NOT NULL	field to hold the translated xlat values for OMPB_ACTIVE_ROW
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	PROCESS_NAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
19	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
20	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values