PO_REQRCON_AET (SQL Table)	Index Back
PO Req Recon Cache Rec

PO_REQRCON_AET

(SQL Table)

PO Req Recon Cache Rec

# 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 RUN_DT Date(10) DATE Run Date

5 PO_POST_RUN_IND Character(1) VARCHAR2(1) NOT NULL /* 615584 05/05/2005 - Added a new label for RTV Recon Process */
A=All BUs
B=1 Bus Unit
D=1 Document

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

7 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

9 CLOSE_DELAY_DAYS Signed Number(6,0) DECIMAL(5) NOT NULL Close Processing Delay Days

10 CANCEL_DELAY_DAYS Signed Number(6,0) DECIMAL(5) NOT NULL Cancel Days

11 PO_CLOSE_DATE Date(10) DATE PO Close Date

12 PO_CANCEL_DATE Date(10) DATE PO Cancel Date

13 COMMITMENT_CNTL_PO Character(1) VARCHAR2(1) NOT NULL Commitment Control on PO

14 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause

15 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause

16 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID

17 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

18 BATCH_LOCATION Character(1) VARCHAR2(1) NOT NULL Batch Location
R=Run Control Page
W=WorkBench Page

19 DESCRLONG Long Character CLOB Long Description

20 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

21 BUDGET_DT_SW Character(1) VARCHAR2(1) NOT NULL Show Budget Date

22 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	RUN_DT	Date(10)	DATE	Run Date
5	PO_POST_RUN_IND	Character(1)	VARCHAR2(1) NOT NULL	/* 615584 05/05/2005 - Added a new label for RTV Recon Process */ A=All BUs B=1 Bus Unit D=1 Document
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
8	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
9	CLOSE_DELAY_DAYS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Close Processing Delay Days
10	CANCEL_DELAY_DAYS	Signed Number(6,0)	DECIMAL(5) NOT NULL	Cancel Days
11	PO_CLOSE_DATE	Date(10)	DATE	PO Close Date
12	PO_CANCEL_DATE	Date(10)	DATE	PO Cancel Date
13	COMMITMENT_CNTL_PO	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control on PO
14	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
15	WHERE_CLAUSE2	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
16	WORKBENCH_ID	Character(10)	VARCHAR2(10) NOT NULL	WorkBench ID
17	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
18	BATCH_LOCATION	Character(1)	VARCHAR2(1) NOT NULL	Batch Location R=Run Control Page W=WorkBench Page
19	DESCRLONG	Long Character	CLOB	Long Description
20	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
21	BUDGET_DT_SW	Character(1)	VARCHAR2(1) NOT NULL	Show Budget Date
22	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.