WTHD_CALC_RPT

(SQL Table)
Index Back

Voucher Scheduled Payment

  • Parent record: VOUCHER
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_FS

    3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
    4 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
    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 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
    9 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
    10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    11 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    12 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    13 WTHD_DECL_DATE Date(10) DATE withholding declaration date
    14 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
    15 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 BASE_MIN Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Basis Amount
    18 WTHD_MIN Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Withhold Amount
    19 BU_REGIST_ID Character(20) VARCHAR2(20) NOT NULL BU Tax Identification Number
    20 BU_CATEGORY Character(5) VARCHAR2(5) NOT NULL Business Unit Category
    21 APPL_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Wthd Applicable Supplier Setid
    22 APPL_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Wthd Applicable Supplier ID

    Prompt Table: VENDOR_NAME_VW1

    23 APPL_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Wthd Applicable Supplier Loc
    24 ACCUM_BASIS Signed Number(28,3) DECIMAL(26,3) NOT NULL This accumulated basis field will be stored in the currency of the withholding entity.
    25 ACCUM_WTHD Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will store the accumulated withholdings in the currency of the withholding entity.
    26 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    28 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
    29 CALC_WTHD_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Calc wthd (txn cur)
    30 WTHD_BASIS_AMT_ENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
    31 CALC_WTHD_ENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Calc wthd (ent cur)
    32 ENT_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL TE Rate Multiplier
    33 ENT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL TE Rate Divisor
    34 VNDR_JUR_EFFDT Date(10) DATE Effective Date
    35 BU_JUR_EFFDT Date(10) DATE Effective Date
    36 ENTITY_HDR_EFFDT Date(10) DATE Effective Date
    37 WTHD_RULE_EFFDT Date(10) DATE Effective Date