1099_RPT_TMP

(SQL Table)
 Index Back

Wthd amounts by report line no

Temp table used by 1099_RPT_PST application engine to store withholding basis amounts by report US_REPORT line numbers.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 WTHD_ENTITY Character(5) VARCHAR2(5) NOT NULL Withholding Entity
3 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type

Default Value: 1099

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

Prompt Table: STATE_TBL

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: COUNTRY_TBL

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

Prompt Table: %EDIT_STATE

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

Y/N Table Edit

75 MINIMUM_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Minimum Amount to Report