L_PVCHR_WTHD

(SQL Table)
Index Back

  • Parent record: PYMNT_VCHR_XREF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    3 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
    4 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
    5 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
    6 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction
    7 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
    8 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
    9 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
    10 WTHD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Amount
    11 ORG_WTHD_BASIS_ENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Original withholding amount calculated by the withholding calculation ae.
    12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    13 POSTING_DATE Date(10) DATE Posting Date
    14 POST_STATUS_WTHD Character(1) VARCHAR2(1) NOT NULL Post Withholding Status
    N=Not Postable
    P=Posted
    U=Unposted
    X=Cancelled Withholding
    15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    16 CREATE_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Create Withholding Payment
    17 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. "
    18 WTHD_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount Base
    19 WTHD_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Amount Base
    20 WTHD_DECL_DATE Date(10) DATE withholding declaration date
    21 WTHD_AMT_ENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withhold Amount (Entity Curr)
    22 ENT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Entity Currency Code
    23 ENT_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Rate Type for Wthd Entity
    24 ENT_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL TE Rate Multiplier
    25 ENT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL TE Rate Divisor
    26 WTHD_BASIS_AMT_ENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
    27 BU_REGIST_ID Character(20) VARCHAR2(20) NOT NULL BU Tax Identification Number
    28 VNDR_REGIST_ID Character(20) VARCHAR2(20) NOT NULL Supplier Tax ID
    29 APPL_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Wthd Applicable Supplier Setid
    30 APPL_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Wthd Applicable Supplier ID
    31 APPL_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Wthd Applicable Supplier Loc
    32 APPL_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Wthd applic Address Seq Num
    33 WTHD_PYMNT_CNT Number(5,0) INTEGER NOT NULL Wthd Payment Count

    Default Value: 0

    34 WTHD_SURCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withhold Surcharge Amount