VENDOR_SETIDA=Attorney
E=Employee
H=HRMS related
R=Outside Party
Default Value: R
SF_AP_VNDR_OPTN(SQL Table) |
Index Back |
|---|---|
AP Vendor OptionsVendor Options used during SF - AP Interface Vendor File creation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor Set ID |
| 2 | SF_AP_VNDR_PREFIX | Character(2) | VARCHAR2(2) NOT NULL | Vendor ID Prefix |
| 3 | NEXT_VENDOR_ID | Number(10,0) | DECIMAL(10) NOT NULL | Last Vendor ID |
| 4 | AP_ADDRESS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | AP Address Sequence Number |
| 5 | SF_AP_VNDR_PAYGRP | Character(2) | VARCHAR2(2) NOT NULL | Vendor Pay Group |
| 6 | VENDOR_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Classification
A=Attorney E=Employee H=HRMS related R=Outside Party Default Value: R |