WTHD_ENTITY_DTL

(SQL Table)
Index Back

Withholding Entity Detail

  • Parent record: WTHD_ENTITY_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

    Default Value: WTHD_ENTITY_DFN.WTHD_ENTITY

    Prompt Table: WTHD_ENTITY_DFN

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: WTHD_ENTITY_HDR.EFFDT

    3 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type

    Default Value: WTHD_TYPE_TBL.WTHD_TYPE

    Prompt Table: WTHD_TYPE_TBL

    4 WTHD_JUR_CD Character(5) VARCHAR2(5) NOT NULL Withholding Jurisdiction

    Default Value: WTHD_JUR_TBL.WTHD_JUR_CD

    Prompt Table: WTHD_JUR_TBL

    5 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class

    Default Value: WTHD_CLASS_TBL.WTHD_CLASS

    Prompt Table: WTHD_CLASS_VW1

    6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    7 MINIMUM_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Amount to Report
    8 WTHD_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Apply VAT

    Default Value: N

    9 FREIGHT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Freight

    Default Value: N

    10 WTHD_SUT_APPL Character(1) VARCHAR2(1) NOT NULL Apply Sales/Use Tax

    Default Value: N

    11 WHTD_DSCNT_APPL Character(1) VARCHAR2(1) NOT NULL Apply Discount

    Default Value: N

    12 NETAMT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Net Amount

    Default Value: Y

    13 MISC_CHG_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Miscellaneous Charges

    Default Value: N

    14 EXCISE_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Apply Excise Tax

    Default Value: N

    15 APPLY_BALANCE Character(1) VARCHAR2(1) NOT NULL Specifies whether we apply withholding on the invoicing vendor or the remit_to vendor
    I=Invoicing Supplier
    R=Remit to Supplier

    Default Value: R