PeopleSoft 9
Account Payables

Table Name WTHD_1099_TBL

Table Description
WTHD_1099_TBL
Columns
Name Datatype Is PK Is FK
WTHD_SETID VARCHAR(5) Yes No
WTHD_CNTL_ID VARCHAR(10) Yes No
WTHD_ENTITY VARCHAR(5) Yes No
WTHD_TYPE VARCHAR(5) Yes No
VENDOR_SETID VARCHAR(5) Yes No
VENDOR_ID VARCHAR(10) Yes No
VNDR_LOC VARCHAR(10) Yes No
ADDRESS_SEQ_NUM INT Yes No
BUSINESS_UNIT VARCHAR(5) Yes No
LINE_NO SMALLINT Yes No
WTHD_RPT_ID VARCHAR(10) No No
DESCR VARCHAR(30) No No
CURRENCY_CD VARCHAR(3) No No
WTHD_BASIS_AMT decimal(26,3) No No
WTHD_LIABILITY_AMT decimal(26,3) No No
PAID_AMT decimal(26,3) No No
SEX VARCHAR(1) No No
BIRTHDATE PSDATE No No
BIRTHPLACE VARCHAR(30) No No
NUM_CHILDREN SMALLINT No No
COMPANY_FLG VARCHAR(1) No No
TAX_DIST_REF VARCHAR(13) No No
CERTIFICATE_TYPE VARCHAR(1) No No
CERTIFICATE_NUM VARCHAR(15) No No
CERTIFICATE_EXP_DT PSDATE No No
DIRECT_SALES VARCHAR(1) No No
SECOND_TIN VARCHAR(1) No No
STATE_TAX_WH decimal(15,2) No No
TIN_TYPE VARCHAR(1) No No
TIN VARCHAR(20) No No
WTHD_CONTROL_NAME VARCHAR(4) No No
PROFESSION VARCHAR(30) No No
WTHD_PAN_NUM VARCHAR(15) No No
WTHD_PAN_WARD VARCHAR(30) No No
TRADE_BUS_INC VARCHAR(1) No No
COUNTRY_PAID VARCHAR(40) No No
FOREIGN_TAX_PAID decimal(13) No No
GBR_VENDOR_TYPE VARCHAR(1) No No
GBR_REG_NO VARCHAR(9) No No
GBR_VERIFY VARCHAR(1) No No
GBR_VERIFY_NBR VARCHAR(13) No No
GBR_VERIFY_DATE datetime No No
CALENDAR_SETID VARCHAR(5) No No
CALENDAR_ID VARCHAR(2) No No
FISCAL_YEAR SMALLINT No No
PERIOD SMALLINT No No
FROM_DT PSDATE No No
THRU_DATE PSDATE No No
RPT_DT PSDATE No No
NAME1 VARCHAR(40) No No
NAME2 VARCHAR(40) No No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
PRCNT_WTHHLD decimal(5,2) No No
Index
Name Type Unique Member
PS_WTHD_1099_TBL PK Yes
Member(s) of "PS_WTHD_1099_TBL" Index
WTHD_SETID
WTHD_CNTL_ID
WTHD_ENTITY
WTHD_TYPE
VENDOR_SETID
VENDOR_ID
VNDR_LOC
ADDRESS_SEQ_NUM
BUSINESS_UNIT
LINE_NO

Published June 06, 2007