DOC_TOL_EXCPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	DOC_TOL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Document Tolerance Document Type: could be Purchase Order or Voucher P=Purchase Order V=Voucher
4	DOC_ID	Character(50)	VARCHAR2(50) NOT NULL	ID
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
7	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
8	MATCH_RULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule ID
9	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
10	DISTRIB_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Distributed amount
11	TOL_VAR_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Document Tolerance User Defined Telerance Percentage
12	TOL_VAR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Document Tolerance User Defined Telerance Amount
13	TOL_PCT_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Calculated document amount based on Document Tolerance Percentage
14	TOL_AMT_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Calculated document amount based on Document Tolerance amount
15	PRED_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Document Tolerance Precedessor Business Unit
16	PRED_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Document Tolerance Predecessor Document ID, could be REQ_ID or VOUCHER_ID
17	PRED_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Document Tolerance Predecessor line number
18	PRED_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Document Tolerance Predecessor schedule number
19	PRED_DIST_LN_NUM	Number(5,0)	INTEGER NOT NULL	Document Tolerance Predecessor distribution line number
20	PRED_DOC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Document Tolerance Predecessor Document merchandise Amount
21	LIQUIDATED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Document Tolerance Life to Date document liquidated amount
22	PRED_GL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Document Tolerance Predecessor GL Business Unit base Currency Code
23	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
24	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
25	OVERRIDE_RULE	Character(1)	VARCHAR2(1) NOT NULL	Override Match Rule Y/N Table Edit Default Value: N
26	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
27	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp