WTHD_TRXN3_TMP

(SQL Table)
Index Back

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

Default Value: 0

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

Prompt Table: SP_BU_AP_NONVW

4 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

Prompt Table: WTHD_ENTITY_VW4

5 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type

Prompt Table: WTHD_ENTITY_VW

6 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction

Prompt Table: WTHD_ENTITY_VW1

7 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class

Prompt Table: WTHD_ENTITY_VW2

8 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule

Prompt Table: WTHD_ENTITY_VW3

9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
11 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
12 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
13 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
14 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
15 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
16 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number
17 WTHD_DECL_DATE Date(10) DATE withholding declaration date
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
20 ORG_WTHD_BASIS_ENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Original withholding amount calculated by the withholding calculation ae.
21 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
22 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
23 WTHD_SURCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withhold Surcharge Amount
24 ADDL_SRCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Additional Surcharge Amount
25 WTHD_CESS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to hold the amount value for Wihtholding Cess amount
26 MINIMUM_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Amount to Report