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 |