BUS_UNIT_PV_INT (SQL Table)	Index Back
ePro Business Unit options ePro Business Unit Options

BUS_UNIT_PV_INT

(SQL Table)

ePro Business Unit options

ePro Business Unit Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 PV_INT_OPTION Character(3) VARCHAR2(3) NOT NULL BU Integration Options
000=None
001=Enterprise One Integration
002=SAP
003=Oracle
004=PeopleSoft 8.0
005=PeopleSoft 8.4
009=Other
100=PO ID - Default
101=PO ID By Installation
102=PO ID By Business Unit
109=PO ID - User Defined
CON=Do Not Consolidate Reqs.
DEL=No Deletion After Integration
DST=One Distribution per Schedule
INV=External Invoices
PMT=External Payments
PO=PeopleSoft PO ID Used
RCV=External Receiveing
SCH=One Schedule per Line

3 PV_INT_OPTION_VAL Character(100) VARCHAR2(100) NOT NULL BU Integration Options

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	PV_INT_OPTION	Character(3)	VARCHAR2(3) NOT NULL	BU Integration Options 000=None 001=Enterprise One Integration 002=SAP 003=Oracle 004=PeopleSoft 8.0 005=PeopleSoft 8.4 009=Other 100=PO ID - Default 101=PO ID By Installation 102=PO ID By Business Unit 109=PO ID - User Defined CON=Do Not Consolidate Reqs. DEL=No Deletion After Integration DST=One Distribution per Schedule INV=External Invoices PMT=External Payments PO=PeopleSoft PO ID Used RCV=External Receiveing SCH=One Schedule per Line
3	PV_INT_OPTION_VAL	Character(100)	VARCHAR2(100) NOT NULL	BU Integration Options