UPDT_WTHD_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 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | PROCESS_WTHD_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Update Withholding Request Processing Options
A=Process Only Supplier Updates B=Process All Updates L=Process Only Voucher Lines |
| 4 | TMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Field for holding temp data |
| 5 | WTHD_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 6 | WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 7 | WTHD_JUR_CD | Character(5) | VARCHAR2(5) NOT NULL | Withholding Jurisdiction |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 10 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 11 | WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 12 | WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | Withholding Rule |
| 13 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 15 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 16 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 17 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 18 | BU_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Category |
| 19 | VENDOR_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Vendor Category |
| 20 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 21 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 22 | MERCH_AMT_ENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt |
| 23 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 24 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 25 | ORIG_PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Original Payment Count |
| 26 | WTHD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 27 | WTHD_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount Base |
| 28 | WTHD_BASIS_AMT_ENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Basis Amount |
| 29 | ORG_WTHD_BASIS_ENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Original withholding amount calculated by the withholding calculation ae. |
| 30 | WTHD_LIABILITY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Liability Amount |
| 31 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 32 | WTHD_SURCHRG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withhold Surcharge Amount |
| 33 | ADDL_SRCHRG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Additional Surcharge Amount |
| 34 | WTHD_CESS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Field to hold the amount value for Wihtholding Cess amount |
| 35 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 36 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 37 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 38 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 39 | 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 |
| 40 | APPL_VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Wthd Applicable Supplier Setid |
| 41 | APPL_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Wthd Applicable Supplier ID |
| 42 | APPL_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Wthd Applicable Supplier Loc |
| 43 | APPL_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Wthd applic Address Seq Num |
| 44 | WTHD_DECL_DATE | Date(10) | DATE | withholding declaration date |
| 45 | NEW_WTHD_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Withhold class |
| 46 | NEW_WTHD_JUR_CD | Character(5) | VARCHAR2(5) NOT NULL | New Withholding Jurisdiction |
| 47 | NEW_WTHD_RULE | Character(5) | VARCHAR2(5) NOT NULL | New withholding rule associated with the new withhold class |
| 48 | NEW_WTHD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | New Withhold Type |
| 49 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 50 | END_DATE | Date(10) | DATE | End Date |
| 51 | PYMNT_CNT2 | Number(5,0) | INTEGER NOT NULL | Payments |
| 52 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 53 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 54 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 55 | WTHD_BASIS_AMT1 | Signed Number(33,3) | DECIMAL(31,3) NOT NULL | WTHD_BASIS_AMT1 |
| 56 | ORG_WTH_BASIS_ENT1 | Signed Number(33,3) | DECIMAL(31,3) NOT NULL | ORG_WTH_BASIS_ENT1 |
| 57 | TMP_FLD1 | Character(1) | VARCHAR2(1) NOT NULL | TMP_FLD1 |
| 58 | DATE1 | Date(10) | DATE | Date |
| 59 | DATE2 | Date(10) | DATE | Date |