RB_EIP_AE_PARM

(SQL Table)
Index Back

Inventory Integration Values

Contains Parameters for Inventory Integration

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Prompt Table: SP_SETID_NONVW

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE

5 INV_ITEM_ID_NEW Character(18) VARCHAR2(18) NOT NULL Item ID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE2

7 MFG_ITM_ID Character(20) VARCHAR2(20) NOT NULL Manufacturer's Item ID
8 MFG_ID Character(50) VARCHAR2(50) NOT NULL Key field to represent Manufacturer Identification number
9 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

Prompt Table: RB_EIP_MSG_ACTV

10 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
11 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
EN=Engineering
PR=Manufacturing

Default Value: PR

12 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
SV=Service

Default Value: PR

13 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
14 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

Prompt Table: %EDITTABLE3