VENDOR_M(SQL Table) |
Index Back |
|---|---|
Supplier Header Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
|
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier | |
| 3 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 4 | VNDR_NAME_SHRT_USR | Character(10) | VARCHAR2(10) NOT NULL | Short Vendor Name |
| 5 | VNDR_NAME_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 8 | VENDOR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Status
A=Approved D=Denied E=Unapproved I=Inactive X=To Be Archived |
| 9 | VENDOR_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Classification
A=Attorney E=Employee H=HCM R=Outside Party Default Value: R |
| 10 | VENDOR_PERSISTENCE | Character(1) | VARCHAR2(1) NOT NULL |
Persistence
O=One Time P=Permanent R=Regular S=Single Payment Supplier Default Value: R |
| 11 | ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered by |
| 12 | DEFAULT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Default Location |
| 13 | HRMS_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Human Resources Classification
D=General Deduction G=Garn Payee H=National Health Serv Provider I=Industrial Ins Board Provider M=Imp Partner Provider P=General Provider T=Tax Collector |