BCT_D_PO_RC_EVW(SQL View) |
Index Back |
---|---|
BCTP Detail PO MessageBar-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 |