WTHD_1099_3TMP (SQL Table)	Index Back
Temp table for APY1099 SQR

WTHD_1099_3TMP

(SQL Table)

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 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
Default Value: 1099

6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

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

11 LINE_NO Number(3,0) SMALLINT NOT NULL Line Number

12 PAYER_TIN Character(20) VARCHAR2(20) NOT NULL Payer Taxpayer Identification

13 DESCR Character(30) VARCHAR2(30) NOT NULL Description

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 WTHD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Basis Amount

16 WTHD_LIABILITY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Liability Amount

17 PAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Paid Amount

18 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

19 BIRTHDATE Date(10) DATE Date of Birth

20 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
Prompt Table: STATE_TBL

21 NUM_CHILDREN Number(3,0) SMALLINT NOT NULL Number of children

22 COMPANY_FLG Character(1) VARCHAR2(1) NOT NULL Company
Y/N Table Edit
Default Value: N

23 TAX_DIST_REF Character(13) VARCHAR2(13) NOT NULL Tax District Reference

24 CERTIFICATE_TYPE Character(1) VARCHAR2(1) NOT NULL Certificate type

25 CERTIFICATE_NUM Character(15) VARCHAR2(15) NOT NULL Certificate Number

26 CERTIFICATE_EXP_DT Date(10) DATE Certificate Expiration

27 DIRECT_SALES Character(1) VARCHAR2(1) NOT NULL Direct Sales of $5000 or More
Y/N Table Edit
Default Value: N

28 SECOND_TIN Character(1) VARCHAR2(1) NOT NULL IRS Notified Twice of Invalid
Y/N Table Edit
Default Value: N

29 STATE_TAX_WH Number(16,2) DECIMAL(15,2) NOT NULL State Income Tax Withheld

30 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL TIN Type
F=Federal Employer ID Number
S=Social Security Number

31 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number

32 WTHD_CONTROL_NAME Character(4) VARCHAR2(4) NOT NULL Withholding Control Name

33 PROFESSION Character(30) VARCHAR2(30) NOT NULL Profession

34 WTHD_PAN_NUM Character(15) VARCHAR2(15) NOT NULL PAN No.

35 WTHD_PAN_WARD Character(30) VARCHAR2(30) NOT NULL PAN Ward

36 TRADE_BUS_INC Character(1) VARCHAR2(1) NOT NULL Trade or Business Income Ind
Y/N Table Edit

37 COUNTRY_PAID Character(40) VARCHAR2(40) NOT NULL Country Paid

38 FOREIGN_TAX_PAID Number(16,2) DECIMAL(15,2) NOT NULL Foreign Tax Paid

39 GBR_VENDOR_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates a Corporation or Individual
C=Corporation
I=Individual

40 GBR_REG_NO Character(9) VARCHAR2(9) NOT NULL Registration/National Insurance number

41 GBR_VERIFY Character(1) VARCHAR2(1) NOT NULL Verification Complete or Not
Y/N Table Edit
Default Value: N

42 GBR_VERIFY_NBR Character(13) VARCHAR2(13) NOT NULL Sub Contractor Verification Number

43 GBR_VERIFY_DATE Date(10) DATE Sub Contractor Verification Number

44 BOND_PREMIUM Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium

45 MARKET_DISCOUNT Number(13,2) DECIMAL(12,2) NOT NULL Market Discount

46 PRIVATE_BOND_INT Number(13,2) DECIMAL(12,2) NOT NULL Private Activity Bond Interest

47 TAX_EXMPT_INTEREST Number(13,2) DECIMAL(12,2) NOT NULL Tax-exempt Interest

48 BOND_PREMIUM_TAXEX Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium on Tax Exempt Bond

49 FATCA_INDICATOR Character(1) VARCHAR2(1) NOT NULL FATCA Filiing Requirement Indicator
Y/N Table Edit
Default Value: N

50 REPORT_BOND_PREM Number(13,2) DECIMAL(12,2) NOT NULL Bond Premium on Treasury Obligations

51 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

52 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

53 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

54 PERIOD Number(3,0) SMALLINT NOT NULL Period

55 FROM_DT Date(10) DATE From Date

56 THRU_DATE Date(10) DATE Through Date

57 RPT_DT Date(10) DATE Report Date

58 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

59 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2

60 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

61 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

62 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

63 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

64 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

65 CITY Character(30) VARCHAR2(30) NOT NULL City

66 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

67 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

68 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

69 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

70 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

71 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

72 COUNTY Character(30) VARCHAR2(30) NOT NULL County

73 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

74 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

75 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

76 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

77 CUSIP_NBR Character(13) VARCHAR2(13) NOT NULL CUSIP ID - Used on Security

78 STATE_INCOME Signed Number(21,2) DECIMAL(19,2) NOT NULL 1099 State Income

#	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	WTHD_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Withholding Type Default Value: 1099
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
11	LINE_NO	Number(3,0)	SMALLINT NOT NULL	Line Number
12	PAYER_TIN	Character(20)	VARCHAR2(20) NOT NULL	Payer Taxpayer Identification
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	WTHD_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Basis Amount
16	WTHD_LIABILITY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Liability Amount
17	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
18	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
19	BIRTHDATE	Date(10)	DATE	Date of Birth
20	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location Prompt Table: STATE_TBL
21	NUM_CHILDREN	Number(3,0)	SMALLINT NOT NULL	Number of children
22	COMPANY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Company Y/N Table Edit Default Value: N
23	TAX_DIST_REF	Character(13)	VARCHAR2(13) NOT NULL	Tax District Reference
24	CERTIFICATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Certificate type
25	CERTIFICATE_NUM	Character(15)	VARCHAR2(15) NOT NULL	Certificate Number
26	CERTIFICATE_EXP_DT	Date(10)	DATE	Certificate Expiration
27	DIRECT_SALES	Character(1)	VARCHAR2(1) NOT NULL	Direct Sales of $5000 or More Y/N Table Edit Default Value: N
28	SECOND_TIN	Character(1)	VARCHAR2(1) NOT NULL	IRS Notified Twice of Invalid Y/N Table Edit Default Value: N
29	STATE_TAX_WH	Number(16,2)	DECIMAL(15,2) NOT NULL	State Income Tax Withheld
30	TIN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	TIN Type F=Federal Employer ID Number S=Social Security Number
31	TIN	Character(20)	VARCHAR2(20) NOT NULL	Taxpayer Identification Number
32	WTHD_CONTROL_NAME	Character(4)	VARCHAR2(4) NOT NULL	Withholding Control Name
33	PROFESSION	Character(30)	VARCHAR2(30) NOT NULL	Profession
34	WTHD_PAN_NUM	Character(15)	VARCHAR2(15) NOT NULL	PAN No.
35	WTHD_PAN_WARD	Character(30)	VARCHAR2(30) NOT NULL	PAN Ward
36	TRADE_BUS_INC	Character(1)	VARCHAR2(1) NOT NULL	Trade or Business Income Ind Y/N Table Edit
37	COUNTRY_PAID	Character(40)	VARCHAR2(40) NOT NULL	Country Paid
38	FOREIGN_TAX_PAID	Number(16,2)	DECIMAL(15,2) NOT NULL	Foreign Tax Paid
39	GBR_VENDOR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Indicates a Corporation or Individual C=Corporation I=Individual
40	GBR_REG_NO	Character(9)	VARCHAR2(9) NOT NULL	Registration/National Insurance number
41	GBR_VERIFY	Character(1)	VARCHAR2(1) NOT NULL	Verification Complete or Not Y/N Table Edit Default Value: N
42	GBR_VERIFY_NBR	Character(13)	VARCHAR2(13) NOT NULL	Sub Contractor Verification Number
43	GBR_VERIFY_DATE	Date(10)	DATE	Sub Contractor Verification Number
44	BOND_PREMIUM	Number(13,2)	DECIMAL(12,2) NOT NULL	Bond Premium
45	MARKET_DISCOUNT	Number(13,2)	DECIMAL(12,2) NOT NULL	Market Discount
46	PRIVATE_BOND_INT	Number(13,2)	DECIMAL(12,2) NOT NULL	Private Activity Bond Interest
47	TAX_EXMPT_INTEREST	Number(13,2)	DECIMAL(12,2) NOT NULL	Tax-exempt Interest
48	BOND_PREMIUM_TAXEX	Number(13,2)	DECIMAL(12,2) NOT NULL	Bond Premium on Tax Exempt Bond
49	FATCA_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	FATCA Filiing Requirement Indicator Y/N Table Edit Default Value: N
50	REPORT_BOND_PREM	Number(13,2)	DECIMAL(12,2) NOT NULL	Bond Premium on Treasury Obligations
51	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
52	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
53	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
54	PERIOD	Number(3,0)	SMALLINT NOT NULL	Period
55	FROM_DT	Date(10)	DATE	From Date
56	THRU_DATE	Date(10)	DATE	Through Date
57	RPT_DT	Date(10)	DATE	Report Date
58	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
59	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
60	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
61	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
62	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
63	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
64	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
65	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
66	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
67	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
68	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
69	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
70	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
71	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
72	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
73	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
74	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
75	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
76	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
77	CUSIP_NBR	Character(13)	VARCHAR2(13) NOT NULL	CUSIP ID - Used on Security
78	STATE_INCOME	Signed Number(21,2)	DECIMAL(19,2) NOT NULL	1099 State Income