BCT_C_PO_RCV_VW (SQL View)	Index Back
BCT Control PO ASN Recv View Bar-code transaction control log file view for PO ASN Receipt processes.

BCT_C_PO_RCV_VW

(SQL View)

BCT Control PO ASN Recv View

Bar-code transaction control log file view for PO ASN Receipt processes.

SELECT business_unit , eip_ctl_id , trans_program , transaction_code , dt_timestamp , bct_status , bct_source , process_instance , oprid , device_id , device_last_seq , device_dttime , eip_trans_src_ref , eip_trans_src , pubnode , chnlname , pubid FROM PS_BCT_CTL

# 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 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

3 TRANS_PROGRAM Character(3) VARCHAR2(3) NOT NULL Transaction Program

4 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
Prompt Table: BCT_XPO_RCV_VW

5 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

6 BCT_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction status in the stage table
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Confirmed

7 BCT_SOURCE Character(1) VARCHAR2(1) NOT NULL Indicates the source where the transaction was created
1=Msg Agent
2=Page
3=Batch
4=Auto Gen
5=Message

8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

10 DEVICE_ID Character(10) VARCHAR2(10) NOT NULL Device ID

11 DEVICE_LAST_SEQ Number(5,0) INTEGER NOT NULL Device Last Sequence Number

12 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time

13 EIP_TRANS_SRC_REF Character(30) VARCHAR2(30) NOT NULL Source Reference

14 EIP_TRANS_SRC Character(30) VARCHAR2(30) NOT NULL 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)

15 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

16 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).

17 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier

#	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	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	TRANS_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Transaction Program
4	TRANSACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code Prompt Table: BCT_XPO_RCV_VW
5	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
6	BCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction status in the stage table 0=New 1=Error 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Confirmed
7	BCT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Indicates the source where the transaction was created 1=Msg Agent 2=Page 3=Batch 4=Auto Gen 5=Message
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	DEVICE_ID	Character(10)	VARCHAR2(10) NOT NULL	Device ID
11	DEVICE_LAST_SEQ	Number(5,0)	INTEGER NOT NULL	Device Last Sequence Number
12	DEVICE_DTTIME	DateTime(26)	TIMESTAMP	Device Date Time
13	EIP_TRANS_SRC_REF	Character(30)	VARCHAR2(30) NOT NULL	Source Reference
14	EIP_TRANS_SRC	Character(30)	VARCHAR2(30) NOT NULL	08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
15	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
16	CHNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSCHNLDEFN).
17	PUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Publication Identifier