PeopleSoft 9 Account Payables |
Table Name | WTHD_CNTL_PAYER |
Table Description |
WTHD_CNTL_PAYER |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | VARCHAR(5) | Yes | Yes |
WTHD_CNTL_ID | VARCHAR(10) | Yes | Yes |
PAYER_TIN | VARCHAR(20) | Yes | No |
WTHD_CONTROL_NAME | VARCHAR(4) | No | No |
PAYER_NAME1 | VARCHAR(40) | No | No |
PAYER_NAME2 | VARCHAR(40) | No | No |
PAYER_ADDRESS1 | VARCHAR(35) | No | No |
PAYER_ADDRESS2 | VARCHAR(35) | No | No |
PAYER_ADDRESS3 | VARCHAR(35) | No | No |
PAYER_CITY | VARCHAR(30) | No | No |
PAYER_STATE | VARCHAR(6) | No | No |
PAYER_POSTAL | VARCHAR(12) | No | No |
PAYER_COUNTRY | VARCHAR(3) | No | No |
COUNTRY_CODE | VARCHAR(3) | No | No |
PHONE | VARCHAR(24) | No | No |
EXTENSION | VARCHAR(6) | No | No |
FAX | VARCHAR(24) | No | No |
ALL_VENDORS_FLG | VARCHAR(1) | No | No |
LAST_FILE_FLG | VARCHAR(1) | No | No |
COMBINED_FED_STATE | VARCHAR(1) | No | No |
DIRECT_SALES | VARCHAR(1) | No | No |
GBR_ACCTS_OFC_NBR | VARCHAR(13) | No | No |
GBR_EMPL_REF_NBR | VARCHAR(10) | No | No |
GBR_HMRC_NBR | SMALLINT | No | No |
Index |
Name | Type | Unique | Member |
PS_WTHD_CNTL_PAYER | PK | Yes |
![]() |
Member(s) of "PS_WTHD_CNTL_PAYER" Index |
SETID |
WTHD_CNTL_ID |
PAYER_TIN |
Published June 06, 2007 |