RB_PUB_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	ORIG_SYSTEM	Character(30)	VARCHAR2(30) NOT NULL	CDH INTERFACE TABLE FIELD - ORIG_SYSTEM
5	BATCH_ID	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - BATCH_ID
6	PARTY_ORIG_SYSTEM	Character(30)	VARCHAR2(30) NOT NULL	CDH INTERFACE TABLE FIELD - PARTY_ORIG_SYSTEM
7	NUMROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
8	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
10	SOURCE_IND	Character(4)	VARCHAR2(4) NOT NULL	EIP Source Indicator CRM=CRM EBS=EBIZ Suite EXT=External HRMS=HCM SCM=SCM
11	CREATE_DATE_FROM	Date(10)	DATE	From date used in a range search.
12	CREATE_DATE_TO	Date(10)	DATE	Date created, used in date range
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
14	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
15	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
16	SETID_CUR	Character(5)	VARCHAR2(5) NOT NULL	SetID
17	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
18	BATCH_ID_PURGE	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - BATCH_ID
19	COMPANY_NAME	Character(70)	VARCHAR2(70) NOT NULL	Company Name
20	COMPANYID_FROM	Character(15)	VARCHAR2(15) NOT NULL	Unique identifier for the From Company ID
21	COMPANYID_TO	Character(15)	VARCHAR2(15) NOT NULL	Unique identifier for the From Company ID
22	SITE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Site Name
23	SITE_ID_FROM	Character(15)	VARCHAR2(15) NOT NULL	SITE_ID_FROM - Unique identifier for from Site ID
24	SITE_ID_TO	Character(15)	VARCHAR2(15) NOT NULL	SITE_ID_FROM - Unique identifier for from Site ID
25	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
26	PERSON_ID_FROM	Character(15)	VARCHAR2(15) NOT NULL	PERSON_ID_FROM - Unique identifier for from Person ID
27	PERSON_ID_TO	Character(15)	VARCHAR2(15) NOT NULL	PERSON_ID_TO - Unique identifier for To Person ID
28	EXTENSION_ID	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - EXTENSION_ID
29	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
30	ATTR_GROUP_NBR	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_NBR
31	ATTR_GROUP_BC	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_BC
32	ATTR_GROUP_BILL_TO	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_BILL_TO
33	ATTR_GROUP_SHIP_TO	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_SHIP_TO
34	ATTR_GROUP_SOLD_TO	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_SOLD_TO
35	ATTR_GROUP_TAX_EXM	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_TAX_EXM
36	ATTR_GROUP_C_TEAM	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_C_TEAM
37	ATTR_GROUP_C_GROUP	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_C_GROUP
38	ATTR_GROUP_CONTACT	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - ATTR_GROUP_CONTACT
39	PARTY_USG_ASIGN_ID	Number(15,0)	DECIMAL(15) NOT NULL	CDH INTERFACE TABLE FIELD - PARTY_USG_ASSIGNMENT_ID
40	PARTY_USAGE_CODE	Character(30)	VARCHAR2(30) NOT NULL	CDH INTERFACE TABLE FIELD - PARTY_USAGE_CODE
41	FLEX_CONTEXT_CODE	Character(30)	VARCHAR2(30) NOT NULL	CDH INTERFACE TABLE FIELD - DESCRIPTIVE_FLEX_CONTEXT_CODE
42	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
43	KEY1	Character(65)	VARCHAR2(65) NOT NULL	First Key
44	KEY2	Character(65)	VARCHAR2(65) NOT NULL	Second Key
45	IMP_MERGE_BATCH	Character(1)	VARCHAR2(1) NOT NULL	CDH INTERFACE TABLE FIELD - IMP_MERGE_ BATCH
46	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance