AP_ARC_PYM_WT_H

(SQL Table)
Index Back

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

    Default Value: 0

    36 WTHD_SURCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withhold Surcharge Amount
    37 ADDL_SRCHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Additional Surcharge Amount
    38 WTHD_CESS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to hold the amount value for Wihtholding Cess amount
    39 WTH_SRCHRG_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Withhold Surcharge Amount
    40 ADD_SRCHRG_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Additional Surcharge Amount
    41 WTHD_CESS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Field to hold the amount value for Wihtholding Cess amount