VENDOR_M(SQL Table) |
Index Back |
---|---|
Supplier Header Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
2 | VENDOR_ID | 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 |