PYCYCL_VNDR_TAO(SQL Table) |
Index Back |
|---|---|
Run Control AP SuppliersRun Control AP Suppliers |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 3 | PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Default Value: PYCYCL_PNL_WK5.PAY_CYCLE Prompt Table: SP_PYRSRT_NONVW |
| 4 | PAY_CYCLE_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL |
Pay Cycle Sequence Number
Default Value: PYCYCL_PNL_WK5.PAY_CYCLE_SEQ_NUM Prompt Table: PYCYCL_RSTRT_VW |
| 5 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 6 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: PYCYCL_VNDR_VW |
| 7 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: PYCYCL_VNDR_VW |
| 8 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |