WTHD_CNTL_PAYER

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 WTHD_CNTL_ID Character(10) VARCHAR2(10) NOT NULL Control ID
3 WTHD_CONTROL_NAME Character(4) VARCHAR2(4) NOT NULL Withholding Control Name
4 PAYER_TIN Character(20) VARCHAR2(20) NOT NULL Payer Taxpayer Identification
5 PAYER_NAME1 Character(40) VARCHAR2(40) NOT NULL Payer Name 1
6 PAYER_NAME2 Character(40) VARCHAR2(40) NOT NULL Payer Name 2
7 PAYER_ADDRESS1 Character(40) VARCHAR2(40) NOT NULL Payer Address Line 1
8 PAYER_ADDRESS2 Character(40) VARCHAR2(40) NOT NULL Payer Address Line 2
9 PAYER_ADDRESS3 Character(40) VARCHAR2(40) NOT NULL Payer Address Line 3
10 PAYER_CITY Character(30) VARCHAR2(30) NOT NULL Payer City
11 PAYER_STATE Character(6) VARCHAR2(6) NOT NULL Payer State

Prompt Table: STATE_TBL

12 PAYER_POSTAL Character(12) VARCHAR2(12) NOT NULL Payer Postal
13 PAYER_COUNTRY Character(3) VARCHAR2(3) NOT NULL Payer Country

Prompt Table: COUNTRY_TBL

14 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
15 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
16 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
17 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
18 ALL_VENDORS_FLG Character(1) VARCHAR2(1) NOT NULL All Suppliers

Default Value: N

19 LAST_FILE_FLG Character(1) VARCHAR2(1) NOT NULL Last Filing
20 COMBINED_FED_STATE Character(1) VARCHAR2(1) NOT NULL Combined Federal State Filing
21 DIRECT_SALES Character(1) VARCHAR2(1) NOT NULL Direct Sales of $5000 or More
22 GBR_ACCTS_OFC_NBR Character(13) VARCHAR2(13) NOT NULL Accounts Office Reference Number
23 GBR_EMPL_REF_NBR Character(10) VARCHAR2(10) NOT NULL Employer's Reference Number
24 GBR_HMRC_NBR Number(3,0) SMALLINT NOT NULL HMRC Office Number