WTHD_TX_DIAG_VW

(SQL View)
 Index Back

SELECT PROCESS_INSTANCE , BUSINESS_UNIT , WTHD_ENTITY , WTHD_TYPE , WTHD_JUR_CD , WTHD_CLASS , WTHD_RULE , VENDOR_SETID , VENDOR_ID , VNDR_LOC , ADDRESS_SEQ_NUM , BANK_SETID , BANK_CD , BANK_ACCT_KEY , PYMNT_ID , PYMNT_DT , POST_DT , WTHD_DECL_DATE , WTHD_BASIS_AMT , WTHD_LIABILITY_AMT , PAID_AMT , DESCR100 FROM PS_WTHD_TRXN_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

Default Value: 0

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

Prompt Table: SP_BU_AP_NONVW

3 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
4 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
5 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
6 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
7 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
12 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
13 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
14 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
15 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
16 PYMNT_DT Date(10) DATE Payment Date
17 POST_DT Date(10) DATE The Date a transaction was Posted.
18 WTHD_DECL_DATE Date(10) DATE withholding declaration date
19 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
20 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
21 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
22 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description