DOC_TOL_OVR_VW

(SQL View)
 Index Back

Document Tolerance Exceptions


SELECT BUSINESS_UNIT , DOC_TOL_TYPE , DOC_ID , LINE_NBR , SCHED_NBR , DISTRIB_LINE_NUM , MATCH_RULE_ID , MONETARY_AMOUNT , DISTRIB_AMT , TOL_VAR_PCT , TOL_VAR_AMT , TOL_PCT_AMT , TOL_AMT_AMT , PRED_BUSINESS_UNIT , PRED_DOC_ID , PRED_LINE_NBR , PRED_SCHED_NBR , PRED_DIST_LN_NUM , PRED_DOC_AMT , LIQUIDATED_AMT , PRED_GL_CURRENCY , TXN_CURRENCY_CD , DESCR254 , OVERRIDE_RULE , OPRID , DATETIME_STAMP FROM PS_DOC_TOL_EXCPT WHERE OVERRIDE_RULE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DOC_TOL_TYPE Character(1) VARCHAR2(1) NOT NULL Document Tolerance Document Type: could be Purchase Order or Voucher
P=Purchase Order
V=Voucher
3 DOC_ID Character(50) VARCHAR2(50) NOT NULL ID
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID
8 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.
9 DISTRIB_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Distributed amount
10 TOL_VAR_PCT Number(6,2) DECIMAL(5,2) NOT NULL Document Tolerance User Defined Telerance Percentage
11 TOL_VAR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Document Tolerance User Defined Telerance Amount
12 TOL_PCT_AMT Number(27,3) DECIMAL(26,3) NOT NULL Calculated document amount based on Document Tolerance Percentage
13 TOL_AMT_AMT Number(27,3) DECIMAL(26,3) NOT NULL Calculated document amount based on Document Tolerance amount
14 PRED_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Document Tolerance Precedessor Business Unit
15 PRED_DOC_ID Character(10) VARCHAR2(10) NOT NULL Document Tolerance Predecessor Document ID, could be REQ_ID or VOUCHER_ID
16 PRED_LINE_NBR Number(5,0) INTEGER NOT NULL Document Tolerance Predecessor line number
17 PRED_SCHED_NBR Number(3,0) SMALLINT NOT NULL Document Tolerance Predecessor schedule number
18 PRED_DIST_LN_NUM Number(5,0) INTEGER NOT NULL Document Tolerance Predecessor distribution line number
19 PRED_DOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Document Tolerance Predecessor Document merchandise Amount
20 LIQUIDATED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Document Tolerance Life to Date document liquidated amount
21 PRED_GL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Document Tolerance Predecessor GL Business Unit base Currency Code
22 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
23 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
24 OVERRIDE_RULE Character(1) VARCHAR2(1) NOT NULL Override Match Rule

Y/N Table Edit

Default Value: N

25 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
26 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp