BCT_D_PO_RC_EVW

(SQL View)
Index Back

BCTP Detail PO Message

Bar-code transaction detail view for PO ASN Reciept of total shipment. (0101).

SELECT A.EIP_TRANS_SRC_SEQ , A.TRANSACTION_CODE , B.OPRID , B.DEVICE_ID , A.DEVICE_DTTIME , A.INV_LOT_ID , A.INV_ITEM_ID , A.SERIAL_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.UNIT_OF_MEASURE , A.RECEIVER_ID , A.RECV_LN_NBR , A.QTY , A.SCHED_LINE_NBR , A.SHIPMENT_NO , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.BUSINESS_UNIT_IN , A.VENDOR_LOT_ID , A.TAG_NUMBER , A.SF_KANBAN_ID , A.CONTAINER_ID FROM PS_BCT_DTL A , PS_BCT_CTL B WHERE %Join(COMMON_KEYS, BCT_DTL A, BCT_CTL B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
2 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 DEVICE_ID Character(10) VARCHAR2(10) NOT NULL Device ID
5 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
6 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE9

8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
9 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: RECV_STOR_A1_VW

10 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: RECV_STOR_L1_VW

11 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: RECV_STOR_L2_VW

12 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: RECV_STOR_L3_VW

13 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: RECV_STOR_L4_VW

14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: %EDITTABLE10

15 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
16 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
17 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
18 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
19 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
20 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

Prompt Table: %EDIT_BU_PO

21 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: %EDITTABLE6

22 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Prompt Table: %EDITTABLE7

23 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: %EDIT_BU_IN

24 VENDOR_LOT_ID Character(15) VARCHAR2(15) NOT NULL Vendor Lot
25 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
26 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
27 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID