EN_BOM_MSG_REQ

(SQL Table)
Index Back

Request table-BOM messaging

# 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 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
N=Specific Business Unit
Y=All Business Units

Y/N Table Edit

Default Value: Y

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

5 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 ALL_EIP_CTL_ID Character(1) VARCHAR2(1) NOT NULL All EIP_CTL_IDs

Y/N Table Edit

Default Value: Y

8 EIP_CTL_ID_FROM Character(25) VARCHAR2(25) NOT NULL EIP control ID selection

Prompt Table: EN_BOMSYNC_VW

9 EIP_CTL_ID_TO Character(25) VARCHAR2(25) NOT NULL EIP control ID selection

Prompt Table: EN_BOMSYNC_VW

10 PROCESS_ERROR Character(1) VARCHAR2(1) NOT NULL Re-process any Errors in Range

Y/N Table Edit

Default Value: N

11 EIP_SOURCE Character(1) VARCHAR2(1) NOT NULL EIP Source
1=Msg Agent
2=Online
3=Batch
4=Auto Gen
5=Message
12 PURGE_OPTN Character(1) VARCHAR2(1) NOT NULL Purge History without Archive

Y/N Table Edit

Default Value: N

13 TRANSFER_OPT Character(1) VARCHAR2(1) NOT NULL Transfer Options
T=Validate and Transfer
V=Validate Only