VENDOR_WTHD_VW4

(SQL View)
 Index Back

Supplier Withholding Informati

Record on Supplier Withholding Information

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.EFFDT , A.WTHD_ENTITY , A.ADDRESS_SEQ_NUM , %subrec(WTHD_FIELDS_SBR, A) , A.CUSIP_NBR , A.STATE_INCOME , A.AP_TIN_STATUS_CD , A.AP_TIN_MATCH_CD , A.AP_TIN_MATCH_DATE , A.AP_TIN_TRACK_CD , A.AP_TIN_MANUAL FROM PS_VENDOR_WTHD A WHERE EXISTS ( SELECT 'X' FROM PS_VENDOR_ADDR B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND B.EFF_STATUS = 'A')

# 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 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Default Value: VENDOR_LOC.VNDR_LOC

4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: VENDOR_LOC.EFFDT

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

Prompt Table: WTHD_ENTITY_DFN

6 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: VENDOR_ADDR_VW2

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

Prompt Table: STATE_TBL

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

39 REPORT_BOND_PREM Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium on Treasury Obligations
40 CUSIP_NBR Character(13) VARCHAR2(13) NOT NULL CUSIP ID - Used on Security
41 STATE_INCOME Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 State Income
42 AP_TIN_STATUS_CD Character(1) VARCHAR2(1) NOT NULL TIN Status Matching process
E=Error
F=Format Error
M=Matched
N=New
P=Pending

Default Value: N

43 AP_TIN_MATCH_CD Character(2) VARCHAR2(2) NOT NULL IRS TIN Match Return Code
0=Name/TIN Matches
1=Missing TIN or not 9digit num
2=TIN not currently issued
3=Name/TIN NOT Match
4=Invalid Request
5=Duplicate Request
6=TIN Match found only on SSN
7=TIN Match found only on EIN
8=TIN Match found both
44 AP_TIN_MATCH_DATE Date(10) DATE Match Date
45 AP_TIN_TRACK_CD Character(12) VARCHAR2(12) NOT NULL IRS TIN Matching Tracking Code
46 AP_TIN_MANUAL Character(1) VARCHAR2(1) NOT NULL AP Tin Manual Matching

Y/N Table Edit

Default Value: N