IN_VMI_QOH_EVW

(SQL View)
Index Back

Qty on Hand

Used by VMI QOH message

SELECT A.EIP_TRANS_SRC , A.EIP_TRANS_SRC_REF , B.EIP_TRANS_SRC_SEQ , A.OPRID , A.DEVICE_ID , B.DEVICE_DTTIME , B.BUSINESS_UNIT , B.VMI_OM_BU , B.SHIP_TO_CUST_ID , B.SOLD_TO_CUST_ID , B.STAGED_DATE , B.INV_LOT_ID , B.SERIAL_ID , B.PRODUCT_ID , B.INV_ITEM_ID , B.STORAGE_AREA , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 , B.CONTAINER_ID , B.UNIT_OF_MEASURE , B.QTY FROM PS_BCT_DTL B , PS_BCT_CTL A WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI
9 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
10 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
11 STAGED_DATE Date(10) DATE Staged Date
12 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
13 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
14 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
17 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
18 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
19 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
20 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
21 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
22 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
23 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity