SAC_INTG_APPCLS (SQL Table)	Index Back
Define ID Generator AppClass Repository to store ID Generator AppClass

SAC_INTG_APPCLS

(SQL Table)

Define ID Generator AppClass

Repository to store ID Generator AppClass

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INTG_DOC_TYPE Character(4) VARCHAR2(4) NOT NULL Integration Doc Type
PO=Purchase Order
PORQ=Purchasing Requisition

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 INTG_ID_APP_CLASS Character(254) VARCHAR2(254) NOT NULL ERP Integration ID Generator

4 INTG_OPT_APP_CLASS Character(254) VARCHAR2(254) NOT NULL Integration Option App Class

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INTG_DOC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Integration Doc Type PO=Purchase Order PORQ=Purchasing Requisition
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	INTG_ID_APP_CLASS	Character(254)	VARCHAR2(254) NOT NULL	ERP Integration ID Generator
4	INTG_OPT_APP_CLASS	Character(254)	VARCHAR2(254) NOT NULL	Integration Option App Class