PO_RECON_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	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	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
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	PCT_UNDER_QTY	Signed Number(4,0)	DECIMAL(3) NOT NULL	Close PO Under Qty Pct Tol
15	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
16	BATCH_LOCATION	Character(1)	VARCHAR2(1) NOT NULL	Batch Location R=Run Control Page W=WorkBench Page Default Value: R
17	WORKBENCH_ID	Character(10)	VARCHAR2(10) NOT NULL	WorkBench ID
18	DESCRLONG	Long Character	CLOB	Long Description
19	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
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.
23	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer