SETIDPrompt Table: SETID_TBL
Y/N Table Edit
Default Value: Y
Default Value: 10
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Default Value: INSTALLATION.COUNTRY
Prompt Table: COUNTRY_TBL
AP_VENDOR_CNTRL(SQL Table) |
Index Back |
|---|---|
Controls for a set of VendorsControls for a set of Vendors. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | VENDOR_NUM_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Use Auto-Numbering
Y/N Table Edit Default Value: Y |
| 3 | VNDR_ID_PREFIX | Character(2) | VARCHAR2(2) NOT NULL | HRMS Vendor ID Prefix |
| 4 | VNDR_ID_LAST_ASSGN | Number(8,0) | INTEGER NOT NULL | Last Vendor ID Assigned |
| 5 | PRENOTE_WAIT_DAYS | Number(3,0) | SMALLINT NOT NULL |
Prenote Wait Days (U.S.)
Default Value: 10 |
| 6 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Display Withholding Flag
Y/N Table Edit Default Value: N |
| 7 | VAT_SW | Character(1) | VARCHAR2(1) NOT NULL |
VAT flag.
Y/N Table Edit Default Value: N |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: INSTALLATION.COUNTRY Prompt Table: COUNTRY_TBL |