WTHD_RPT_IDLINE_NOWTHD_ENTITYVENDOR_SETIDPrompt Table: SP_SETVND_NONVW
VENDOR_IDPrompt Table: VNDR_WTHDRPT_VW
VNDR_LOCPrompt Table: VNDR_LOC_VW1
ADDRESS_SEQ_NUMBUSINESS_UNITPrompt Table: SP_BU_AP_NONVW
WTHD_RPTLOG1_LC(SQL Table) |
Index Back |
|---|---|
Report Log - Supplier level |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WTHD_RPT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 2 | LINE_NO |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 3 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 4 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETVND_NONVW |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VNDR_WTHDRPT_VW |
| 6 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: VNDR_LOC_VW1 |
| 7 | ADDRESS_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 8 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |