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 |