WTHD_AP_AET

(SQL Table)
Index Back

# 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 WTHD_POST_OPT Character(1) VARCHAR2(1) NOT NULL Withholding Post Option
A=Post All Transactions
B=Post by Business Unit
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
8 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
9 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
10 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
11 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
12 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
13 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
14 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
16 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
17 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
18 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
19 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
20 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
21 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
22 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
23 BU_REGIST_ID Character(20) VARCHAR2(20) NOT NULL BU Tax Identification Number
24 VNDR_REGIST_ID Character(20) VARCHAR2(20) NOT NULL Supplier Tax ID
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: WTHD_ENTITY_HDR.CURRENCY_CD

26 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Default Value: WTHD_ENTITY_HDR.CUR_RT_TYPE

27 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

Default Value: 1

28 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

Default Value: 1

29 PYMNT_DT Date(10) DATE Payment Date

Default Value: %Date

30 POST_DT Date(10) DATE The Date a transaction was Posted.

Default Value: %Date

31 WTHD_DECL_DATE Date(10) DATE withholding declaration date

Default Value: %Date

32 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
33 ORG_WTHD_BASIS_ENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Original withholding amount calculated by the withholding calculation ae.
34 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
35 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
36 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
37 WTHD_SURCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withhold Surcharge Amount
38 ADDL_SRCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Additional Surcharge Amount
39 WTHD_CESS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to hold the amount value for Wihtholding Cess amount
40 THRU_DATE Date(10) DATE Through Date
41 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups