BCT_C_PO_RC_EVW

(SQL View)
 Index Back

BCT Control PO Message View

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

SELECT A.EIP_TRANS_SRC , A.EIP_TRANS_SRC_REF , B.EIP_TRANS_SRC_SEQ , A.OPRID , A.DEVICE_ID , A.DEVICE_DTTIME , A.DEVICE_LAST_SEQ , B.SHIPTO_SETID , B.SHIPTO_ID , B.VENDOR_ID , B.CARRIER_ID , B.BILL_OF_LADING , B.RECEIVER_ID , A.BUSINESS_UNIT , B.END_TRANS_FLG FROM PS_BCT_CTL A , PS_BCT_DTL B WHERE %Join(COMMON_KEYS, BCT_CTL A, BCT_DTL B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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 :-)
2 EIP_TRANS_SRC_REF Character(30) VARCHAR2(30) NOT NULL Source Reference
3 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 DEVICE_ID Character(10) VARCHAR2(10) NOT NULL Device ID
6 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
7 DEVICE_LAST_SEQ Number(5,0) INTEGER NOT NULL Device Last Sequence Number
8 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
9 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
11 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
12 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
13 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

15 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag