VNDR_WTHD_JURVW

(SQL View)
 Index Back

Supplier Withold Jurisdiction


SELECT SETID , VENDOR_ID , VNDR_LOC , EFFDT , WTHD_ENTITY , WTHD_TYPE , WTHD_JUR_CD , WTHD_IND , WTHD_RULE , HOLD_PAY_IND , HOLD_PAY_FLG , WTHD_FLG , DEFAULT_JUR_FLG , DEFAULT_CLASS , VENDOR_CATEGORY , WTHD_CONDITION , CONDITION_PCT , CONDITION_UNTIL , REMIT_WTHD_TO_FLG , REMIT_VENDOR , REMIT_LOC , REMIT_ADDR_SEQ_NUM FROM %Table(VENDOR_WTHD_JUR)

  • Parent record: VENDOR_LOC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

    Prompt Table: WTHD_ENTITY_DFN

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

    Prompt Table: WTHD_TYPE_TBL

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

    Prompt Table: WTHD_JUR_TBL

    8 WTHD_IND Character(1) VARCHAR2(1) NOT NULL Withhold Rule Indicator
    D=Default from Entity Definition
    S=Specify at this Level
    9 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule

    Prompt Table: WTHD_RULE_HDR

    10 HOLD_PAY_IND Character(1) VARCHAR2(1) NOT NULL Hold Pay Indicator
    D=Default from Entity Definition
    S=Specify at this Level
    11 HOLD_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Hold Payment
    B=Hold wthd & regular payment
    N=Do Not Hold
    W=Hold Withholding only
    12 WTHD_FLG Character(1) VARCHAR2(1) NOT NULL Withhold if missing
    N=Don't withholding
    Y=Withholdeable
    13 DEFAULT_JUR_FLG Character(1) VARCHAR2(1) NOT NULL Default Jurisdiction
    N=Not Default Jur
    Y=Default Jur
    14 DEFAULT_CLASS Character(5) VARCHAR2(5) NOT NULL Default Withholding Class

    Prompt Table: WTHD_CLASS_TBL

    15 VENDOR_CATEGORY Character(5) VARCHAR2(5) NOT NULL Vendor Category

    Prompt Table: WTHD_VNDR_CAT

    16 WTHD_CONDITION Character(1) VARCHAR2(1) NOT NULL Withholding Condition
    E=Exonerate
    N=Not Applicable
    X=Exempt
    17 CONDITION_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Condition %
    18 CONDITION_UNTIL Date(10) DATE Condition Valid Until
    19 REMIT_WTHD_TO_FLG Character(1) VARCHAR2(1) NOT NULL Remit Withhold to Flag
    E=Entity
    V=Supplier
    20 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

    Prompt Table: VNDR_RETURN_VW

    21 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location

    Prompt Table: VNDR_REM_LOC_VW

    22 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location

    Prompt Table: VNDR_REMADDR_VW