BCT_SHM2_INV_VW

(SQL View)
Index Back

BCT TSE Misc Shipping View

This view is used to edit the BCT DTL table for Misc Shipping transactions 621 and 625 (Associate and Deassociate Shipping Cntr using pick batch)

SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , LAST_DTTIME , BCT_DET_STATUS , INV_LOT_ID , INV_ITEM_ID , SERIAL_ID , UNIT_OF_MEASURE , QTY , PICK_BATCH_ID , PICKLIST_LINE_NO , SHIP_CNTR_ID , 0 , 0 , 0 FROM PS_BCT_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
5 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp
6 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
7 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
10 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: INV_SHIP_UOM_VW

11 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
12 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
13 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
14 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
15 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
16 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
17 LLS_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table.