DOC_TOL_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	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	DOC_TOL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Tolerance Document Type: could be Purchase Order or Voucher P=Purchase Order V=Voucher
7	DOC_TOL_RUN_PO	Character(1)	VARCHAR2(1) NOT NULL	Run Options for PO for Document Tolerance Checking A=All Business Units B=Business Unit P=Purchase Order
8	DOC_TOL_RUN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Tolerance Run Type B=Batch O=Online
9	DOC_TOL_RUN_VCH	Character(1)	VARCHAR2(1) NOT NULL	Voucher Run Option for Document Tolerance Checking A=All Business Units B=Business Unit V=Voucher
10	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
11	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
12	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
13	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
14	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
15	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
16	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
17	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
18	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
19	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
20	VCHR_COUNT	Number(6,0)	INTEGER NOT NULL	Count of Vouchers
21	COUNTER1	Number(16,2)	DECIMAL(15,2) NOT NULL	Counter 1
22	ERROR_COUNT	Number(9,0)	DECIMAL(9) NOT NULL	Error Count
23	MATCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Match FLag
24	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
25	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
26	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
27	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN).
28	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN).
29	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow
30	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name
31	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
32	DECIMALPOS1	Number(4,0)	SMALLINT NOT NULL	Decimal Positions1
33	DECIMALPOS2	Number(5,0)	INTEGER NOT NULL	Decimal Positions2
34	DECIMALPOS3	Number(8,0)	INTEGER NOT NULL	Decimal Positions3
35	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
36	DOC_APPRV_REQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Document Approval Required
37	BUSINESS_UNIT_WRK	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
38	BUSINESS_UNIT_REQ	Character(5)	VARCHAR2(5) NOT NULL	Requesting Business Unit
39	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
40	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
41	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
42	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
43	DOC_TOL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Enable Document Tolerance
44	PO_ID_TMP	Character(10)	VARCHAR2(10) NOT NULL	Temporary Purchase Order ID
45	VOUCHER_ID_TMP	Character(8)	VARCHAR2(8) NOT NULL	Temporary Voucher ID
46	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status