SPM_BU_SUPPLIER(SQL Table) |
Index Back |
|---|---|
Supplier Network by BU |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_SP_VW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_SP_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | SP_SEND_TO | Character(1) | VARCHAR2(1) NOT NULL |
SP_SEND_TO
C=Provider Contact L=Location |
| 6 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
SPM_SPLR_CNT_VW
|
| 7 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: SPB_LOC_VW1 |
| 8 | NOTIFY_BY | Character(4) | VARCHAR2(4) NOT NULL |
Notification Method
EM=Email and Worklist WL=WorkList Only Default Value: EM |
| 9 | SPM_SOURCETYPE | Character(4) | VARCHAR2(4) NOT NULL |
Supplier Network Source Type
0=Internal 1=Primary 2=Secondary 3=Tertiary |
| 10 | SUBMITAL_LIMIT | Number(2,0) | SMALLINT NOT NULL |
Submittal Limit
Default Value: 5 |
| 11 | SP_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Score |