WTHD_1099_TMP3

(SQL Table)
 Index Back

Temp table for APY1099 SQR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID
2 WTHD_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Withholding Code
3 WTHD_CNTL_ID Character(10) VARCHAR2(10) NOT NULL Control ID
4 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
10 LINE_NO Number(3,0) SMALLINT NOT NULL Line Number
11 PAYER_TIN Character(20) VARCHAR2(20) NOT NULL Payer Taxpayer Identification
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount
15 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount
16 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount
17 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
18 BIRTHDATE Date(10) DATE Date of Birth
19 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

Prompt Table: STATE_TBL

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

Y/N Table Edit

Default Value: N

22 TAX_DIST_REF Character(13) VARCHAR2(13) NOT NULL Tax District Reference
23 CERTIFICATE_TYPE Character(1) VARCHAR2(1) NOT NULL Certificate type
24 CERTIFICATE_NUM Character(15) VARCHAR2(15) NOT NULL Certificate Number
25 CERTIFICATE_EXP_DT Date(10) DATE Certificate Expiration
26 DIRECT_SALES Character(1) VARCHAR2(1) NOT NULL Direct Sales of $5000 or More

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

28 STATE_TAX_WH Number(16,2) DECIMAL(15,2) NOT NULL State Income Tax Withheld
29 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL TIN Type
F=Federal Employer ID Number
S=Social Security Number
30 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number
31 WTHD_CONTROL_NAME Character(4) VARCHAR2(4) NOT NULL Withholding Control Name
32 PROFESSION Character(30) VARCHAR2(30) NOT NULL Profession
33 WTHD_PAN_NUM Character(15) VARCHAR2(15) NOT NULL PAN No.
34 WTHD_PAN_WARD Character(30) VARCHAR2(30) NOT NULL PAN Ward
35 TRADE_BUS_INC Character(1) VARCHAR2(1) NOT NULL Trade or Business Income Ind

Y/N Table Edit

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

Y/N Table Edit

Default Value: N

41 GBR_VERIFY_NBR Character(13) VARCHAR2(13) NOT NULL Sub Contractor Verification Number
42 GBR_VERIFY_DATE Date(10) DATE Sub Contractor Verification Number
43 BOND_PREMIUM Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium
44 MARKET_DISCOUNT Number(13,2) DECIMAL(12,2) NOT NULL Market Discount
45 PRIVATE_BOND_INT Number(13,2) DECIMAL(12,2) NOT NULL Private Activity Bond Interest
46 TAX_EXMPT_INTEREST Number(13,2) DECIMAL(12,2) NOT NULL Tax-exempt Interest
47 BOND_PREMIUM_TAXEX Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium on Tax Exempt Bond
48 FATCA_INDICATOR Character(1) VARCHAR2(1) NOT NULL FATCA Filiing Requirement Indicator

Y/N Table Edit

Default Value: N

49 REPORT_BOND_PREM Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium on Treasury Obligations
50 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
51 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
52 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
53 PERIOD Number(3,0) SMALLINT NOT NULL Period
54 FROM_DT Date(10) DATE From Date
55 THRU_DATE Date(10) DATE Through Date
56 RPT_DT Date(10) DATE Report Date
57 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
58 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
59 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

60 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
61 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
62 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
63 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
64 CITY Character(30) VARCHAR2(30) NOT NULL City
65 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
66 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
67 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
68 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
69 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
70 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
71 COUNTY Character(30) VARCHAR2(30) NOT NULL County
72 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

73 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
74 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
75 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit