IN_VMI_QOH_VW

(SQL View)
 Index Back

Qty On Hand

Used by VMI QOH message

SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , EIP_TRANS_SRC_SEQ , LAST_DTTIME , BCT_DET_STATUS , SHIP_TO_CUST_ID , STAGED_DATE , INV_LOT_ID , SERIAL_ID , PRODUCT_ID , INV_ITEM_ID , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , CONTAINER_ID , UNIT_OF_MEASURE , QTY 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 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
6 LAST_DTTIME DateTime(26) TIMESTAMP NOT NULL Last Date Time
7 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
8 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
9 STAGED_DATE Date(10) DATE Staged Date
10 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
11 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
12 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
15 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
16 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
17 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
18 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
19 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
21 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity