UA_VNDRWTHD_TMP

(SQL Table)
 Index Back

Supplier Withholding Informati

  • Parent record: VENDOR_LOC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: VENDOR_LOC.SETID

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Default Value: VENDOR_LOC.VENDOR_ID

    3 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity

    Prompt Table: WTHD_ENTITY_DFN

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: VENDOR_LOC.EFFDT

    5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Default Value: VENDOR_LOC.VNDR_LOC

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Default Value: 1

    Prompt Table: VENDOR_ADDR_VW

    8 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    9 BIRTHDATE Date(10) DATE Date of Birth
    10 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

    Prompt Table: STATE_TBL

    11 NUM_CHILDREN Number(3,0) SMALLINT NOT NULL Number of children
    12 COMPANY_FLG Character(1) VARCHAR2(1) NOT NULL Company

    Y/N Table Edit

    Default Value: N

    13 TAX_DIST_REF Character(13) VARCHAR2(13) NOT NULL Tax District Reference
    14 CERTIFICATE_TYPE Character(1) VARCHAR2(1) NOT NULL Certificate type
    15 CERTIFICATE_NUM Character(15) VARCHAR2(15) NOT NULL Certificate Number
    16 CERTIFICATE_EXP_DT Date(10) DATE Certificate Expiration
    17 DIRECT_SALES Character(1) VARCHAR2(1) NOT NULL Direct Sales of $5000 or More

    Y/N Table Edit

    Default Value: N

    18 SECOND_TIN Character(1) VARCHAR2(1) NOT NULL IRS Notified Twice of Invalid

    Y/N Table Edit

    Default Value: N

    19 STATE_TAX_WH Number(16,2) DECIMAL(15,2) NOT NULL State Income Tax Withheld
    20 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL TIN Type
    F=Federal Employer ID Number
    S=Social Security Number
    21 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number
    22 WTHD_CONTROL_NAME Character(4) VARCHAR2(4) NOT NULL Withholding Control Name
    23 PROFESSION Character(30) VARCHAR2(30) NOT NULL Profession
    24 WTHD_PAN_NUM Character(15) VARCHAR2(15) NOT NULL PAN No.
    25 WTHD_PAN_WARD Character(30) VARCHAR2(30) NOT NULL PAN Ward
    26 TRADE_BUS_INC Character(1) VARCHAR2(1) NOT NULL Trade or Business Income Ind

    Y/N Table Edit

    27 COUNTRY_PAID Character(40) VARCHAR2(40) NOT NULL Country Paid
    28 FOREIGN_TAX_PAID Number(16,2) DECIMAL(15,2) NOT NULL Foreign Tax Paid
    29 GBR_VENDOR_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates a Corporation or Individual
    C=Corporation
    I=Individual
    30 GBR_REG_NO Character(9) VARCHAR2(9) NOT NULL Registration/National Insurance number
    31 GBR_VERIFY Character(1) VARCHAR2(1) NOT NULL Verification Complete or Not

    Y/N Table Edit

    Default Value: N

    32 GBR_VERIFY_NBR Character(13) VARCHAR2(13) NOT NULL Sub Contractor Verification Number
    33 GBR_VERIFY_DATE Date(10) DATE Sub Contractor Verification Number
    34 BOND_PREMIUM Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium
    35 MARKET_DISCOUNT Number(13,2) DECIMAL(12,2) NOT NULL Market Discount
    36 PRIVATE_BOND_INT Number(13,2) DECIMAL(12,2) NOT NULL Private Activity Bond Interest
    37 TAX_EXMPT_INTEREST Number(13,2) DECIMAL(12,2) NOT NULL Tax-exempt Interest
    38 BOND_PREMIUM_TAXEX Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium on Tax Exempt Bond
    39 FATCA_INDICATOR Character(1) VARCHAR2(1) NOT NULL FATCA Filiing Requirement Indicator

    Y/N Table Edit

    Default Value: N

    40 REPORT_BOND_PREM Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium on Treasury Obligations
    41 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    42 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    43 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    44 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    45 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    46 CITY Character(30) VARCHAR2(30) NOT NULL City
    47 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    48 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    49 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    50 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    51 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    52 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    53 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    54 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    55 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    56 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    57 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    58 WTHD_IND Character(1) VARCHAR2(1) NOT NULL Withhold Rule Indicator
    D=Default from Entity Definition
    S=Specify at this Level
    59 PRCNT_WTHHLD Number(6,2) DECIMAL(5,2) NOT NULL Percent Withheld
    60 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    61 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    62 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
    N=No
    Y=Yes