SPB_VMS_INFO_BU

(SQL Table)
 Index Back

VMS Supplier info Fee by BU

effective dated table to store the VMS Supplier and fees information by business unit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SPB_VMS_BY_BU
Set Control Field: BUSINESS_UNIT

2 VMS_SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL VMS Supplier ID

Prompt Table: SPF_VMSBUSUP_VW
Set Control Field: BUSINESS_UNIT

3 VMS_LOCATION Character(10) VARCHAR2(10) NOT NULL VMS Location - This is the Vendor Managed Service Supplier's office location

Prompt Table: SPF_VMSSUPLOC_V
Set Control Field: BUSINESS_UNIT

4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
7 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID

Prompt Table: SPB_VMS_TMID_VW
Set Control Field: BUSINESS_UNIT

8 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator

Prompt Table: SPB_VMS_SC_SPLR